Question about database connection failure

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
shamerokka
Forum Newbie
Posts: 1
Joined: Mon Apr 14, 2008 6:16 pm

Question about database connection failure

Post 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.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: Question about database connection failure

Post 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.
(#10850)
Post Reply