MyBB Community Forums

Full Version: Slow MySQL - corrupted?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi.

I'm getting a feeling my MySQL database is somehow corrupted and therefore has a very slow loading time. It's often that loading times when viewing a thread or any page of the forum exceeds 30 seconds... like this:

Generated in 37.7803819 seconds (1.44% PHP / 98.56% MySQL)

This is extremely frustrating when I'm trying to have a fast-loading forum. I'm trying to find out if there's a way to see wether this is a hosting issue or if the database itself is corrupted? And if it's the database, could it somehow be fixed?

Thanks for any replies.
[wiki]Admin_CP_Database_Tools#Optimize_Database[/wiki]
Try running that to optimize your database tables.
(Found in the Admin CP under "Database Tools")

Did your forums start this way, or was it faster in the beginning?
Click on the "[advanced details]" link in the footer and MyBB will give you an overview of any queries taking large amounts of time.
Thanks for replies.

I optimized and I'll see if it helps.

This is the advanced details page:
http://www.deletionquality.net/forum/index.php?debug=1

By the way, the forum is not always slow. It's sometimes fast but usually in mornings and noon it's slow.
Quote:This is the advanced details page:
http://www.deletionquality.net/forum/index.php?debug=1

Note: That page can only be accessed by Administrators of your board.
Oscar Wrote:Thanks for replies.

I optimized and I'll see if it helps.

This is the advanced details page:
http://www.deletionquality.net/forum/index.php?debug=1

By the way, the forum is not always slow. It's sometimes fast but usually in mornings and noon it's slow.
If it varies it is probably a problem with the server. If the problem continues you should contact your host about it.
Will do that. Thanks again