database overload - slow queries
My Gallery was shut down by my host ixwebhosting.com for one day yesterday. They said I have to optimize the queries of the database or else find a dedicated hosting service. Sound very cold.
I would like to hear from the experts here about this problem. My Gallery has on average less than 40 people viewing photos at any moment. I'm wondering whether it's their slow server and outdated hardware that is the problem.
You may take view my gallery at www.ganoi.com/photopost
I'm running version 5.31 of Photopost Pro. Our stat are:
Disk Space: 1,894.0mb
Below are the message from ixwebhosting.com.
You can try 5.5 but I think your server has some part in any slow queries
I did those same queries on a site that has roughly the same size database photos comments and I get these times
1. Showing rows 0 - 5 (6 total, Query took 0.0089 sec)
2. Showing rows 0 - 0 (1 total, Query took 0.0012 sec)
3. Showing rows 0 - 29 (337 total, Query took 0.0038 sec)
4. Showing rows 0 - 0 (1 total, Query took 0.0008 sec)
5. Showing rows 0 - 20 (21 total, Query took 0.0016 sec)
Now take note query timing varies and we will depend on other factors like how many cats you have photos comments etc etc
First thing I would suggest you do is REPAIR and OPTIMIZE your database
Thank you for your input Chuck. I will try to upgrade to 5.5 soon but please point me to where I can find instruction on how to REPAIR and OPTIMIZE the database.
|All times are GMT -5. The time now is 01:48 PM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0