• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by User Bot


07 Jan, 2025

Updated at 26 Jan, 2025

Percona Server for MYSQL 8.0 very slow performance on all myISAM tables

Is quite strange but mysqldump and also alter table to convert to InnoDB are very slow but very very slow. For example converting a table of 5800 rows from myisam to innodb requires about 35 minutes. Server is running on a LXC container proxmox with a ZFS storage. But Innodb Tables on the same server are very fast and doesn’t have any issue.
I have all myISAM variables at default, I didn’t change anything from default but maybe some other conf can make myisam engine very slow.
Also mysqldump of tables to reimport them with innodb engine is very slow.
Anybody had a similar issue?

1 post - 1 participant

Read full topic