WordPress MU

About 15 minutes ago, I sat down at the press table at Peoria City Hall. I connected to the wireless network here, loaded up my site and prepared to liveblog.

My page loaded fine. I opened a post to answer a comment and got a database cannot connect message. The message persisted. I called mediatemple. After putting me on hold several times, after telling me it wasn't a problem because HE could see my website, the tech informed me that the problem was due to the following processes:

`Created 04:00 PM 07/22/2008

### 4 Queries
### Total time: 71, Average time: 17.75
### Taking 4 , 5 , 8 , 54 seconds to complete
### Rows analyzed 11086, 17647, 31044 and 31050
SELECT * FROM dbXXX_wpmu.wp_XXX_referer_visitLog;

SELECT * FROM db46537_wpmu.wp_170_referer_visitLog;

### 3 Queries
### Total time: 50, Average time: 16.6666666666667
### Taking 4 , 9 , 37 seconds to complete
### Rows analyzed 24093, 24093 and 24093
SELECT * FROM dbXXX_wpmu.wp_XXX_comments;

SELECT * FROM db46537_wpmu.wp_29_comments;'

[deleted comments that had nothing to do with the issue at hand]

Anyway, any advice for fixing the problems listed above?

Every page you click on wants to add a Quicktime add-on to my IE7. Could that be slowing things down a bit?

Nice site.

now that is the first time i've heard that.

The Quicktime or the nice site? :-)

Immediate fix/test might be to try to reboot your server. I'm no expert but would guess that you are running out of ram or have to many mysql connections. A reboot might reset that.

The Quicktime. The tech support guy at mediatemple thinks your computer is set to open Quicktime when it detects some sort of file that I have opening on some of my pages.

wp_170_referer_visitLog

What table is that created by? i'm guessing some type of stats plugin. those can usually cause a huge load.

I have removed any such stats plugin from the mu-plugins folder.