MySQL Slow Query Problem

I run mcsaver.net, a wordpress based website with a MySQL Database. I recently got a notification from the host (000webhost.com) that I have MySQL Slow Query, and that I need to fix it asap.

Unfortunately, I know more or less nothing about MySQL and PHP. I know enough to download wordpress, create a database name, create a usename, and upload the wordpress files. That’s… pretty much it.

Obviously, my problem “how do I fix this” cannot be solved by simply asking that. So, what information do people need from me to try and resolve this issue?

I was told that I can turn off or remove some aspects of the database, but I looked at it in phpMyAdmin, and it was half greek to me. My website is pretty dang basic, and requires no posting, comments, or anything besides the Contact Form widget.

Hi Chazus,

I tested the load time of your webpage using http://tools.pingdom.com/?url=http://mcsaver.net. It seems fine.

According to me, the slow query could be a result of your permalink structure. What is your permalink structure? to check it : In the Settings → Permalinks panel (Options → Permalinks before WordPress 2.5)

or

You might need to optimize your database. Need to install a plugin that will optimize your database.
Read http://wpmu.org/wordpress-maintenance-101-how-to-optimize-and-repair-database-tables/

Permalink structure is Custom “/http:/mcsaver.net/”

I think I needed to do that to get my links to show up as specific names instead of dates

I got some of those optimizers and ran them. It found a bunch of orphaned stuff in the database and I had them removed, and optimized a few things. Website still works perfectly so I think that may be a win.

By the way, just for your information :

Please note: You never, ever put your site url in the permalinks slot. You must use one of the structure tags, or a combination of tags only.

Search for the above line on http://codex.wordpress.org/Using_Permalinks for more detailed information.

Sponsor our Newsletter | Privacy Policy | Terms of Service