WordPress.org

1. bschneider5
   Member
   Posted 4 years ago #

   I've been having trouble getting into the dashboard area, this is what Dreamhost support said. Can anyone help me with this?

   The problem was that the database instance for your blog db needed a restart - your own DB was holding it up with extremely long query times. The admin I showed the case to told me I should ask you not to run the OPTIMIZE TABLE command on a live table, please. I'm also passing your case to our mysql expert so he can take a look at your table to see if he can make sure this problem won't happen again.

2. MichaelH
   Volunteer
   Posted 4 years ago #

   WordPress doesn't do an Optimize Table, but the Akismet plugin does do an OPTIMIZE TABLE on the comments table.

3. bschneider5
   Member
   Posted 4 years ago #

   It seems I had to remove this from the akismet.php file

   $n = mt_rand(1, 5);

   if ( $n % 5 )

   $wpdb->query("OPTIMIZE TABLE $wpdb->comments");`

4. drmike
   Member
   Posted 4 years ago #

   Why do I get the feeling that you're not deleteing your akismet queue, the comment table is becoming huge, and running optimize on that huge table is the issue?

   Dreamhost worried about a single optimize command? Sounds like they're passing the buck if you ask me. I do webhosting and I drill that into the heads of my clients. I want them running that command.

   edit: I wonder if the person who added the 'anal' tag agrees with me. ;)

Topic Closed

This topic has been closed to new replies.