New answers tagged

0

InnoDB/MySQL can't allocate 1G for some reason. At the same time, free -h shows some free memory. That means that something inside mysql or outside of mysql allocating memory. The my.cnf above does not show any additional memory allocation, but you have this include: "!includedir /etc/mysql/conf.d/" Please check the content of this directory and see if there ...


0

For those who still having this issue, you can follow this way to do it, I found this answer in a website. It helps me a lot: shell> mysql -u username -p -e "SELECT concat('ALTER TABLE ', TABLE_NAME,' ENGINE=MYISAM;') FROM Information_schema.TABLES WHERE TABLE_SCHEMA = 'db_name' AND ENGINE = 'InnoDB' AND TABLE_TYPE = 'BASE TABLE'" | tail -n+2 >> ...


0

Your innodb buffer pool is too small. You need to increase it and like 4 other innodb parameters. Basically, you tell the innodb engine in the mysql config how much ram it gets. Presumably this is to keep horrible things from happening to your data if the machine runs out of ram. If you have a lot of innodb tables make the buffer pool really really large, ...



Top 50 recent answers are included