Your WordPress Website is Slow? – perhaps you have WP-Statistics plugin installed?

Etc

A few days ago a client contacted me and said that their website is down. I checked the server, and indeed the server is very overloaded. In total it got 36 cores – and they’re all 100% utilized.

As usual I checked the whole stack, but today it’s something different – the MySQL / database server was the culprit. It was performing very slowly, and in turn caused the webserver to slow down as well.

In the slow query log, some queries kept showing up with crazy query times, in tens of seconds.
For comparison – all of the other queries finishes in less than a second.

MySQL’s slow query log is your friend – it enable you to find problematic queries very quickly.

And all those slow queries are in these tables:

wp_statistics_useronline
wp_statistics_visitor

I checked the currently running queries with “mysqladmin processlist“, and almost all (hundreds of them) queued queries are those involving those tables, looking for specific content in the field “ip”. They’re all looked like these:

SELECT location FROM wp_statistics_visitor WHERE ip = '88.88.88.88'
SELECT * FROM wp_statistics_useronline WHERE ip = '99.99.99.99'

On a hunch, I checked the structure of those tables. And right enough, there’s no index for “ip”

An index can increase a query’s performance by a, very, significant amount.

When the size of those tables are big enough, and you have a higher traffic than usual (they just published a very important information that’s of interest to a lot of people) – then suddenly these seemingly innocent queries were able to bring down a 36-core server to its knees.

Anyway, now we know the culprit, the solution is easy enough:

alter table wp_statistics_useronline add index (ip);
alter table wp_statistics_visitor add index (ip);

And voilà – in an instant, the website was up again, and the CPU utilization dropped to nearly zero.

Everyone’s happy, and I have also notified the developers about the issue as well.

130 thoughts on “Your WordPress Website is Slow? – perhaps you have WP-Statistics plugin installed?”

  1. terima kasih banng infonya, ini sangat membantu untuk kecepatan website, kalo pake plugin kecepatan wordpress yang terbaik apa ya?

  6. Wow wonderful blog layout How long have you been blogging for you make blogging look easy The overall look of your site is great as well as the content

  7. Your website is a sanctuary for the seekers of profound thought, where the altar of enlightenment is adorned with the incense of your articulate expression. Each visit is a pilgrimage, and readers find solace in the intellectual serenity you provide.

  8. Bonjour, je crois que j’ai vu que vous avez visité mon blog et je suis venu vous rendre la pareille. J’essaie de trouver des choses pour améliorer mon site web et je suppose qu’il est possible d’utiliser certaines de vos idées.

  10. Hi Neat post Theres an issue together with your web site in internet explorer may test this IE still is the marketplace chief and a good component of people will pass over your fantastic writing due to this problem

  11. Your positive energy and enthusiasm radiate through your writing It’s obvious that you are truly passionate about what you do

  12. Your blog always puts a smile on my face and makes me feel better about the world Thank you for being a source of light and positivity

  13. Hi Neat post Theres an issue together with your web site in internet explorer may test this IE still is the marketplace chief and a good component of people will pass over your fantastic writing due to this problem

  14. From start to finish, this blog post had us hooked. The content was insightful, entertaining, and had us feeling grateful for all the amazing resources out there. Keep up the great work!

  15. Your blog has helped me become a more positive and mindful person I am grateful for the transformative effect your words have had on me

  16. I couldn’t stop scrolling and reading, your content is truly one-of-a-kind. Thank you for all the time and effort you put into creating such amazing content.

  19. Thank you for providing a positive and constructive space for discussion It’s refreshing to see a blog with a kind and respectful community

  21. Hey, cool post You can check if there’s a problem with your website with Internet Explorer. Because of this issue, many readers will overlook your excellent writing because IE is still the most popular browser.

  25. Wow wonderful blog layout How long have you been blogging for you make blogging look easy The overall look of your site is great as well as the content

  26. Wow superb blog layout How long have you been blogging for you make blogging look easy The overall look of your site is magnificent as well as the content

  28. obviously like your website but you need to test the spelling on quite a few of your posts Several of them are rife with spelling problems and I to find it very troublesome to inform the reality on the other hand Ill certainly come back again

  29. Its like you read my mind You appear to know a lot about this like you wrote the book in it or something I think that you could do with some pics to drive the message home a little bit but instead of that this is fantastic blog An excellent read I will certainly be back

  30. Usually I do not read article on blogs however I would like to say that this writeup very compelled me to take a look at and do so Your writing taste has been amazed me Thanks quite nice post

  31. You stretch my mind to ponder new dimensions beyond habitual ruts. Sincerest thanks for continually pushing my thinking! Encore!

  32. Fantastic site A lot of helpful info here Im sending it to some buddies ans additionally sharing in delicious And naturally thanks on your sweat

  33. upysm.com ????????????????????????????Instagram?Facebook?Youtube?????????????????????????????????????????????????????????????

  38. Thanks for another excellent post. Where else may anyone get that kind of information in such an ideal means of writing? I’ve a presentation pg 1688 ????? next week, and I am at the search for such info.

  39. Its like you read my mind You appear to know a lot about this like you wrote the book in it or something I think that you could do with some pics to drive the message home a little bit but instead of that this is fantastic blog An excellent read I will certainly be back

  40. Nice blog here Also your site loads up very fast What host are you using Can I get your affiliate link to your host I wish my site loaded up as quickly as yours lol

  42. Thanks for another excellent post. Where else may anyone get that pung777 kind of information in such an ideal means of writing? I’ve a presentation next week, and I am at the search for such info.

  43. Hi ??????????????? there, You have done an incredible job. I’ll certainly digg it and personally suggest to my friends. I’m sure they will be benefited from this site.

  44. Nice blog here! Also your site loads up fast! What host are you monsterxbet using? Can I get your affiliate link to your host? I wish my web site loaded up as quickly as yours lol

  45. I do trust all the ideas youve presented in your post They are really convincing and will definitely work Nonetheless the posts are too short for newbies May just you please lengthen them a bit from next time Thank you for the post

  46. Usually I do not read article on blogs however I would like to say that this writeup very compelled me to take a look at and do it Your writing style has been amazed me Thank you very nice article

  47. Thanks for another excellent post. Where else may anyone get that kind of information in such pgzeed24h an ideal means of writing? I’ve a presentation next week, and I am at the search for such info.

  48. hello!,I like your writing very so much! proportion we keep up a correspondence extra approximately your post usun68 on AOL? I need an expert in this space to unravel my problem. May be that is you! Taking a look forward to see you.

  49. Nice blog here! Also your site loads up fast! What host are you ???????? using? Can I get your affiliate link to your host? I wish my web site loaded up as quickly as yours lol

  50. Wonderful web site. Lots of useful info here. I’m sending it to a few friends ans additionally sharing in betflix119 delicious. And obviously, thanks to your effort!

  52. Thanks for another excellent post. Where else may anyone get that kind of information in such an ideal means of writing? I’ve a presentation zbti9dot next week, and I am at the search for such info.

  53. hello!,I like your writing very so much! proportion we keep up a correspondence extra approximately your post on AOL? I need an expert in this space to unravel my problem. May be that is you! Taking a look fifarich88 forward to see you.

  54. Thanks for another excellent post. Where else may anyone get that kind of information in such an ????????? ideal means of writing? I’ve a presentation next week, and I am at the search for such info.

  55. Wonderful web site. Lots of useful info here. I’m sending it to a few friends ans additionally ????????????? sharing in delicious. And obviously, thanks to your effort!

  56. hello!,I like ????? ??????? your writing very so much! proportion we keep up a correspondence extra approximately your post on AOL? I need an expert in this space to unravel my problem. May be that is you! Taking a look forward to see you.

  63. Thanks for another excellent post. Where else may anyone get that kind of information in such an ideal means of writing? I’ve a presentation next ????? week, and I am at the search for such info.

  69. Thanks for another excellent post. Where else may anyone get ????? ??????????? that kind of information in such an ideal means of writing? I’ve a presentation next week, and I am at the search for such info.

  71. Nice blog here! Also your site loads up fast! What host are ?????????? ??????? you using? Can I get your affiliate link to your host? I wish my web site loaded up as quickly as yours lol

  74. Thanks for ????? another excellent post. Where else may anyone get that kind of information in such an ideal means of writing? I’ve a presentation next week, and I am at the search for such info.

  75. Thanks for another excellent post. Where else may anyone get that kind of ???? ????? pdf information in such an ideal means of writing? I’ve a presentation next week, and I am at the search for such info.

  76. Hi there, You have done an incredible job. I’ll certainly digg it and personally suggest to my friends. I’m sure they will be benefited from this ??????? site.

  77. Thanks for another excellent post. Where else may anyone get that kind of information in such an ideal means of writing? I’ve a presentation next week, ???????????? and I am at the search for such info.

  78. I enjoy looking through an article that can ????? make men and women think. Also, thank you for allowing for me to comment!

  79. hello!,I like your writing very so much! proportion we keep up a correspondence extra approximately your post on AOL? I need an expert in this space to unravel my problem. May be that is you! ????? Taking a look forward to see you.

  80. Hi there, You have done an incredible job. I’ll certainly digg it and personally ????? suggest to my friends. I’m sure they will be benefited from this site.

  81. hello!,I like your writing very so much! proportion we keep up a ????????????? correspondence extra approximately your post on AOL? I need an expert in this space to unravel my problem. May be that is you! Taking a look forward to see you.

  82. Hi there, You have done an incredible job. I’ll certainly digg it and personally suggest to my friends. I’m sure they will gaojing 888 be benefited from this site.

  83. Hi there, You have done an incredible job. I’ll certainly digg it ????? ??? and personally suggest to my friends. I’m sure they will be benefited from this site.

  84. Thanks for another excellent post. Where else may anyone get that kind of information in such an ideal ??????????? means of writing? I’ve a presentation next week, and I am at the search for such info.

  85. ??????ggongta.com,??? ????,?????? ?? ??? ? ?? I do trust all the ideas youve presented in your post They are really convincing and will definitely work Nonetheless the posts are too short for newbies May just you please lengthen them a bit from next time Thank you for the post

  87. Wonderful web site. Lots of ????? pdf useful info here. I’m sending it to a few friends ans additionally sharing in delicious. And obviously, thanks to your effort!

  89. Thanks for another excellent ?????18+ post. Where else may anyone get that kind of information in such an ideal means of writing? I’ve a presentation next week, and I am at the search for such info.

  90. Wonderful web site. Lots of useful info here. I’m sending it to ???????? a few friends ans additionally sharing in delicious. And obviously, thanks to your effort!

  92. Its like you read my mind You appear to know so much about this like you wrote the book in it or something I think that you can do with a few pics to drive the message home a little bit but other than that this is fantastic blog A great read Ill certainly be back

  93. I just could not depart your web site prior to suggesting that I really loved the usual info an individual supply in your visitors Is gonna be back regularly to check up on new posts

  94. Your writing is like a breath of fresh air in the often stale world of online content. Your unique perspective and engaging style set you apart from the crowd. Thank you for sharing your talents with us.

  97. Hello my loved one I want to say that this post is amazing great written and include almost all significant infos I would like to look extra posts like this

  98. “This article is a great resource for [Topic]. I enjoyed reading your perspectives and learned a lot from this post. Thank you for sharing your knowledge!”

  99. “I found your blog post very helpful for understanding [Topic]. The way you break down the concepts makes it easy to grasp. Looking forward to more content from you.”

  100. hello!,I like your writing very so much! proportion we keep up a correspondence extra approximately your post on AOL? I need an expert ??????????? ????? pg in this space to unravel my problem. May be that is you! Taking a look forward to see you.

  101. “I stumbled upon this blog while researching [topic], and I’m glad I did. The quality of the content speaks volumes about the credibility of the author. I’m impressed by the level of detail and the balanced perspective presented here. Kudos to the team for creating such valuable resources!”

  102. of course like your website but you have to check the spelling on several of your posts A number of them are rife with spelling issues and I in finding it very troublesome to inform the reality on the other hand I will certainly come back again

  103. Your writing is so relatable and down-to-earth It’s like having a conversation with a good friend Thank you for always being real with your readers

  104. Somebody essentially lend a hand to make significantly posts I might state That is the very first time I frequented your web page and up to now I surprised with the research you made to create this particular put up amazing Excellent job

  106. Your piece was tremendously insightful! The comprehensiveness of the material and the engaging presentation captivated me. The extent of research and expertise apparent throughout substantially elevates the content’s caliber. The revelations in the opening and closing sections were particularly compelling, igniting novel ideas and queries that I hope you’ll investigate in future works. If there are supplementary resources for further exploration on this subject, I’d be delighted to immerse myself in them. Thank you for sharing your knowledge and enriching our grasp of this topic. The exceptional quality of this work prompted me to comment right after reading. Maintain the fantastic efforts—I’ll definitely revisit for more updates. Your commitment to crafting such an excellent article is greatly appreciated!

  107. Your piece was tremendously insightful! The comprehensiveness of the material and the engaging presentation captivated me. The extent of research and expertise apparent throughout substantially elevates the content’s caliber. The revelations in the opening and closing sections were particularly compelling, igniting novel ideas and queries that I hope you’ll investigate in future works. If there are supplementary resources for further exploration on this subject, I’d be delighted to immerse myself in them. Thank you for sharing your knowledge and enriching our grasp of this topic. The exceptional quality of this work prompted me to comment right after reading. Maintain the fantastic efforts—I’ll definitely revisit for more updates. Your commitment to crafting such an excellent article is greatly appreciated!

  109. I was suggested this web site by my cousin Im not sure whether this post is written by him as no one else know such detailed about my trouble You are incredible Thanks

  111. This piece was incredibly enlightening! The level of detail and clarity in the information provided was truly captivating. The extensive research and deep expertise evident in this article are truly impressive, greatly enhancing its overall quality. The insights offered at both the beginning and end were particularly striking, sparking numerous new ideas and questions for further exploration.The way complex topics were broken down into easily understandable segments was highly engaging. The logical flow of information kept me thoroughly engaged from start to finish, making it easy to immerse myself in the subject matter. Should there be any additional resources or further reading on this topic, I would love to explore them. The knowledge shared here has significantly broadened my understanding and ignited my curiosity for more. I felt compelled to express my appreciation immediately after reading due to the exceptional quality of this article. Your dedication to crafting such outstanding content is highly appreciated, and I eagerly await future updates. Please continue with your excellent work—I will definitely be returning for more insights. Thank you for your unwavering commitment to sharing your expertise and for greatly enriching our understanding of this subject.

  112. Your writing is so relatable and down-to-earth It’s like having a conversation with a good friend Thank you for always being real with your readers

  114. Your blog has become my go-to source for positive and uplifting content Thank you for consistently delivering high-quality posts

  115. Your writing is so eloquent and engaging You have a gift for connecting with your readers and making us feel understood

  116. ?? ??? ????? ???? ??? ?????? ??? ?? ??? ??? 100% ??? ? ?? ???? ???? ?????! ??? ??? ?? ?? ???? ?????. 

  124. Fantastic beat ! I would like to apprentice while you amend your web site, how could i subscribe for a blog site? The account helped me a acceptable deal. I had been a little bit acquainted of this your broadcast offered bright clear concept

  130. Your content is always spot-on and very informative. Thank you for sharing!”
    By the way, if anyone needs a good IPTV service in the UK, BestIPTVShop.uk is highly recommended. They offer a variety of channels and superb quality.

Leave a Reply

Your email address will not be published. Required fields are marked *