Page 1 of 1

Question about database connection failure

Posted: Mon Apr 14, 2008 6:30 pm
by shamerokka
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.

Re: Question about database connection failure

Posted: Tue Apr 15, 2008 1:19 am
by Christopher
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.