hi,anyone.
i have a zabbix(zabbix-server-mysql-3.4.11 and mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1). yesterday, i want to optimization mysql. so i choose partition mysql.
i have backup my mysql, then i create a new sql, import backup files. according to https://www.zabbix.org/wiki/Docs/howto/mysql_partition to make mysql partition. it's ok. but at "
mysql> CALL partition_maintenance_all('zabbix'); it's wrong, like this "ERROR 1508 (HY000): Cannot remove all partitions, use DROP TABLE instead." sonmeone can help me .thanks.
i have a zabbix(zabbix-server-mysql-3.4.11 and mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1). yesterday, i want to optimization mysql. so i choose partition mysql.
i have backup my mysql, then i create a new sql, import backup files. according to https://www.zabbix.org/wiki/Docs/howto/mysql_partition to make mysql partition. it's ok. but at "
mysql> CALL partition_maintenance_all('zabbix'); it's wrong, like this "ERROR 1508 (HY000): Cannot remove all partitions, use DROP TABLE instead." sonmeone can help me .thanks.
Comment