Home » mysql

mysql


Starting MySQL… ERROR! The server quit without updating PID file

Starting MySQL… ERROR! The server quit without updating PID file Sometimes you may see this error in your server. But don’t panic, just rename or move away the /etc/my.cnf in your server, and try to restart the MySQLd again.   [[email protected]:~ ] $ service mysqld start Starting MySQL… ERROR! The server quit without updating PID …

Starting MySQL… ERROR! The server quit without updating PID file Read More »

Table does not support optimize, doing recreate + analyze instead

Everytime you do optimize MySQL, by using mysqlcheck -A -o or using ./mysql_optimize from here. You may see the output Table does not support optimize, doing recreate + analyze instead. It is because the table that you are using is InnoDB. You can optimize the InnoDB tables by using this. ALTER TABLE table.name ENGINE=’InnoDB’;

How to view MySql running resources

If your server’s mysql always in high resources or down, I suggest you use this command to trace out which database that eat up your MySql resource /usr/bin/mysqladmin proc stat /usr/bin/watch -n 5 ‘mysqladmin proc stat’ Every 5.0s: mysqladmin proc stat Sat Aug 28 02:05:06 2010 +——+———-+———–+—-+———+——+——-+——————+ |  Id  |   User   | Host …

How to view MySql running resources Read More »