MySQL Overload

Hi,

I have a website having daily statistic just about 500visitors, 7000pageviews, 8000hits and 1800mb bandwidth running on a VPS Virtuozzo VPS plans (1.8 GHz CPU, 1.5 GB RAM, 20 GB Data Storage, 0.6 TB Data Transfer) but loading very slow.

I consult with hosting tech support said because of MySQL overload. So s.o could advise how to fix this overload?

Thanks,
Shem

Have you check the slow query log to see if there are any queries taking a long time?

Are you opening one connection from the application to MySQL or are you opening up many connections?

Hi, I open just only one connection. However, how can I check the slow query log? FYI: my site is using wordpress. You can check at www.samboads.com Thanks

Were any plugins installed around the time that the slowness started?

No, but I have a few plugin running

I scan the plugin with below result but I don’t understand the figure. Could you advise?

That’s the problem → WordPress.
Better use CodeIgniter or Laravel.

(Just a suggestion)

1 Like

Has the site always been poor performing or is the lack of performance a new thing?

hi oddz, what does it mean by poor performing?

@transcamhost

Is it possible to enable caching?

Has the site ALWAYS been slow or is this a site that has NOT been slow (historically) and has BEGUN running slow recently?

1 Like

The problem won’t be MySQL. It might be the way you have implemented it (designed the database, the queries you use etc).

I analysed your page with PageSpeed, and it looks like the problem is likely that you have a huge number of redirects going on.

Minimise redirects

Minimising HTTP redirects from one URL to another cuts out additional RTTs and wait time for users
Learn more

Suggestions for this page

Remove the following redirect chain, if possible:
http://0.gravatar.com/.../029cb53362fbc235f138004249106b9d?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../0b16825da680d6d4abd6c3b347e654dc?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../2546174414f3721898aa9fe6cf308e36?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../48a71a06db6998736fc5328304005c4c?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../4c63b944c27e2ed075d2716e993a1544?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../608cb7a7af46191411b762a4217622a0?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../6864c5d12fc32b93911407ceec457e1a?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../6b42b1942e1e3a851fa745e03686fbd5?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../6c1fc960da8bc1e1ca794f3a7f4ad14e?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../6d699128d39793ba201e59a0d22b3a35?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../804abfc1330843c99798a75a9b28c85e?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../81d9ea1c0ba68e2fd018ea7c7a02b432?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../849ce8ac08c41606f0e7b035c64531b8?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../8e2cf0f6bc318f658515bf0bdfb493b3?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../a23b5cfe2638b103e2d28e56dcd7ee81?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../a41682d57a9e63ac86b2f715b7f4473c?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../aefe98e8fd14be546cc4c86dd627334e?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../cab7eb1e04367bd8d97c8126eb5fbf04?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../cd23f5f12c22bb297152f6583c56515a?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../e10884f4c995573d6301404c7903cfd9?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../eaab21129b2cf28fc61f9c5fef9e71f3?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../ec2f6416d971f263471192e9af6eabb8?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../ed50cbbe30b875747b9c8778fe7ca786?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://0.gravatar.com/.../ee24cb894babce96dd4df1a84b2d86e3?
http://0.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../166b9276f0e32063724b0c4174e71d83?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../1721bea55ccf97b6b738dab1e75bf036?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../3658bba3b21290bcdc38fd8c2b1498d0?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../3a1c4eb82ed22fb3af1ce4f0f67ffcd3?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../3ba2524e54fd0a3a03cfddee8d407ad0?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../3f07645584829b8d2567f2fc80d45f64?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../54195167257bfabb21a41a62d0926e8b?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../5505b6f0e8a2cedf76985e8607cac1bd?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../5cadcec9554d7ede34e96bc7ab4f1547?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../5d720edd1c2fbf385b786e046b77d3e1?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../71d6a41e3e19711e058ec60bcbe05de0?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../7efe195fb39c2343ed5dfb1495bcde99?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../969fd639ca05683fdcb9501b216d12f5?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../970ae67d74d2f1067c359a79693a91d3?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../b70f4ea948b07bac7b08b6889237affa?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../b87e18fd0fcd39dd2dec3928a54bb884?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../d14bcbf1d7a585ed56e837889abe6d92?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../db3d17b8064baf644187cebc185807e6?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../de4015a8ad3782eb4310cb37aeb2d00a?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../df678747496844fac5730f95766d9ccb?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../f44fdbe5cdf73660fee967b118755ce5?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://1.gravatar.com/.../f8774af639dd85d47210cb90932a9442?
http://1.gravatar.com/.../ad516503a11cd5ca435acc9bb6523536?
Remove the following redirect chain, if possible:
http://www.facebook.com/.../likebox.php?
https://www.facebook.com/.../likebox.php?

Also you can cache your images browser side, your images, css, and javascript can be significantly compressed, and your images reduced in size.

And you have dead links too:

Avoid bad requests

Removing “broken links”, or requests that result in 404/410 errors, avoids wasteful requests.
Learn more

Suggestions for this page

The following requests are returning 404/410 responses. Either fix the broken links or remove the references to the non-existent resources.
http://samboads.com/…/blank.gif
http://samboads.com/…/263696-75x75.jpg
http://samboads.com/…/642651-75x75.jpg
http://samboads.com/…/logo_partner.jpg

it running better now but not sure in future

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.