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.
Question about database connection failure
Moderator: General Moderators
-
shamerokka
- Forum Newbie
- Posts: 1
- Joined: Mon Apr 14, 2008 6:16 pm
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Question about database connection failure
If you are using PHPMyAdmin then go to the structure tab for table that is slow and click the little index icon next to the column you want to index. The index will then be listed below the list of column definitions.
(#10850)