LAMP server: Fedora Core release 6
Using phpMyAdmin, I have added a new field to a database table. The datatype is
int with a default of
This table has approx 5 million rows.
Since I submitted the phpMyAdmin form to add the field, Firefox waited for about 30mins then gave up saying the connection was reset. I submitted the form around an hour ago. If I try to access phpMyAdmin again, Firefox just loads forever.
There is a php/mysql web app running which works but is slow.
top command, I can see that the CPU usage for PHP and MySQL are around:
php 35% mysqld 20%
I suspect that MySQL is still in the process of adding the field, due to the huge amount of records and having to set
default=0 on each. Does that sound correct?
I was looking for some thoughts on what to do/what not to do in this scenario. Do I just wait it out or should I try rebooting the server? I'm concerned if I reboot, the table might crash and lose the data.
Edit: I can now access phpMyAdmin no problem and view the table, all looks fine, but the CPU usage is now:
php 60% mysqld 0.7%
Surely this is not normal CPU usage for php?