Question about database connection failure
Posted: Mon Apr 14, 2008 6:30 pm
Hi.
I have a Media Temple account (grid service) running WordPress using PHP 4 and I received database connection errors when trying to access the site yesterday for about 1 hour.
PHPMyAdmin shows the database restarted and there are now values highlighted in red which I am not able to understand how to resolve.
Here are some of the values:
Connections Aborted1,294
30.41 per hour
Slow_queries 34
Select_range_check 30
Handler_read_rnd 493 M
Handler_read_rnd_next 3,163.93 M
Created_tmp_disk_tables 222 k
Table_locks_waited 7,564
The database has been functional as I have disabled all unnecessary plugins. It would appear i need to index tables but I do not know hot to do this. I would like to know how to go about fixing these issues and the implications of not doing so. Finally, my host offers an option to use PHP 5 by simply clicking a radio button, is this wise or should i remain using PHP 4, which was the default.
Thanks in advance for your attention.
I have a Media Temple account (grid service) running WordPress using PHP 4 and I received database connection errors when trying to access the site yesterday for about 1 hour.
PHPMyAdmin shows the database restarted and there are now values highlighted in red which I am not able to understand how to resolve.
Here are some of the values:
Connections Aborted1,294
30.41 per hour
Slow_queries 34
Select_range_check 30
Handler_read_rnd 493 M
Handler_read_rnd_next 3,163.93 M
Created_tmp_disk_tables 222 k
Table_locks_waited 7,564
The database has been functional as I have disabled all unnecessary plugins. It would appear i need to index tables but I do not know hot to do this. I would like to know how to go about fixing these issues and the implications of not doing so. Finally, my host offers an option to use PHP 5 by simply clicking a radio button, is this wise or should i remain using PHP 4, which was the default.
Thanks in advance for your attention.