Not sure if this counts as an SEO question but I need some help/advice with this as getting a number of 503 errors over the past few days… and I am looking for someone reliable/trustworthy etc Reply from Siteground We have conducted a detailed investigation and it turned out that your application executes slow queries towards its database, which eventually hogs the server. The server tries to execute your slow queries while putting other processes in the queue until some memory is freed. While they are waiting however, they stack up and cause further problems. There can be many reasons for slow database queries, but the following 3 are the most common ones 1. Large database 2. Not well written scripts 3. Large number of internal links that query the database directly. Note – I have recently changed permalinks and also installed Social Warfare social media plugin. Help anyone?
Samantha Boone: It sounds like you are using WordPress on shared hosting or low budget cloud hosting. And it also sounds like you are maxing out on the allocated resources for your level of Web hosting. In the past I have pushed low budget hosting to the max with large, busy Websites, heavily modified WordPress sites, etc. They run slow, get errors, and generally dont perform well. You probably need to upgrade to more powerful hosting.
Chase Price: Siteground on own server… and yes WordPress
Chase Price: This issue has only been apparent over the past few days…
Samantha Boone: Inadequate resources only become apparent at peak traffic times. If you have been growing the sites traffic and if its running on a low end hosting plan its probably time to upgrade.
Chase Price: I believe this is correct – Cloud (1 Month) (CPU: 3Cores, Storage: 50GB, RAM: 6GB
Samantha Boone: Chase Price: How has your bandwidth usage grown over the past six months? Keep in mind that your problem could also be due to rogue crawlers hammering your site. If youre not blocking the SEO crawlers you should be, as well as business intelligence bots.
Adriel Snyder: Chase Price: can you share with me the domain so I can run a few tests on your site, no need for admin yet.
Chase Price: Londontheatre1.com
London Theatre Tickets – Reviews – News – Interviews
londontheatre1.com
Chase Price: Sorry, I assume you mean to share on this thread
Adriel Snyder: Chase Price: can you also post a link that has given the 503 errors, thanks!
Chase Price: the 503 seem to occur when I am logged in.. and are infrequent.. but I think when posting or updating…
Adriel Snyder: Chase Price: I have mulled over your site, and run a few test. The site looks well optimized. When you said 503 I expected a woocommerce site with 100k products with a 30 second load time, but no. so considering how well optimized the site is and t…See more
Query Monitor
en-gb.wordpress.org
Chase Price: Adriel Snyder: Many thanks for your help. I was using ADDToAny until last week and the ONLY reason for opting for the Warfare one was the retention of social counts (which the jury is out as to whether of significant benefit or not) – this was due to a change in permalink structure.
Adriel Snyder: Chase Price: The only thing with retention of share counts is that it is required to check the share counts on every single page load so it can not be cached. The correct way to do this would be to call for the apis direct, but as you are using a plu…See more
Chase Price: from siteground: Most probably cause are the scripts that are executed when your cron jobs are triggered. You should check them out and optimize them along with the database.Code:Database Tables Views InnoDB MyISAM Slow Queries Slowest Query DB Size———————– —— —– —— —— ———— ————- ——–londont9_wp575 174 0 98 76 10 1.307 516.0 MBlondont9_wp575_st1 181 0 105 76 2 1.785 335.0 MB=== TOP 5 of 5 (total) Slow Queries for the past 24 hours ==========1. Executed 1d 3h 15m 45s ago for 8.059792 sec on Database –> londont9_wp575Date: 2018-04-08 12:03:50 Query_time: 8.059792 Rows_examined: 1273: Rows_sent 1085 Lock_time: 0.000661# Schema: londont9_wp575 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_options WHERE autoload = yes;——————————————————————————————————2. Executed 4h 49m 25s ago for 6.141975 sec on Database –> londont9_wp575Date: 2018-04-09 10:30:10 Query_time: 6.141975 Rows_examined: 22170: Rows_sent 5 Lock_time: 0.000258# Schema: londont9_wp575 Last_errno: 0 Killed: 0 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (1150) ) AND wp_posts.post_type = post AND (wp_posts.post_status = publish) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 1470, 5;—————————————————————————————————-3. Executed 5h 37m 47s ago for 3.3668 sec on Database –>londont9_wp575Date: 2018-04-09 09:41:48 Query_time: 3.366800 Rows_examined: 1362: Rows_sent 1085 Lock_time: 0.000127# Schema: londont9_wp575 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_options WHERE autoload = yes;——————————————————————————————————4. Executed 5h 37m 47s ago for 3.356344 sec on Database –> londont9_wp575Date: 2018-04-09 09:41:48 Query_time: 3.356344 Rows_examined: 1362: Rows_sent 1085 Lock_time: 0.000122# Schema: londont9_wp575 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_options WHERE autoload = yes;——————————————————————————————————5. Executed 5h 37m 47s ago for 3.271884 sec on Database –> londont9_wp575Date: 2018-04-09 09:41:48 Query_time: 3.271884 Rows_examined: 1362: Rows_sent 1085 Lock_time: 0.000083# Schema: londont9_wp575 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_options WHERE autoload = yes;——————————————————————————————————6. Executed 5h 37m 47s ago for 3.215424 sec on Database –> londont9_wp575Date: 2018-04-09 09:41:48 Query_time: 3.215424 Rows_examined: 1362: Rows_sent 1085 Lock_time: 0.000741# Schema: londont9_wp575 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_options WHERE autoload = yes;——————————————————————————————————7. Executed 5h 37m 47s ago for 3.213884 sec on Database –> londont9_wp575Date: 2018-04-09 09:41:48 Query_time: 3.213884 Rows_examined: 1362: Rows_sent 1085 Lock_time: 0.000119# Schema: londont9_wp575 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_options WHERE autoload = yes;——————————————————————————————————8. Executed 1d 3h 15m 41s ago for 3.176942 sec on Database –> londont9_wp575Date: 2018-04-08 12:03:54 Query_time: 3.176942 Rows_examined: 7872: Rows_sent 5 Lock_time: 0.000455# Schema: londont9_wp575 Last_errno: 0 Killed: 0 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (wp_posts.post_author = 1) AND wp_posts.post_type = post AND (wp_posts.post_status = publish) ORDER BY wp_posts.post_date DESC LIMIT 0, 5;—————————————————————————————————9. Executed 5h 37m 47s ago for 3.058565 sec on Database –> londont9_wp575Date: 2018-04-09 09:41:48 Query_time: 3.058565 Rows_examined: 1362: Rows_sent 1085 Lock_time: 0.000142# Schema: londont9_wp575 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_options WHERE autoload = yes;——————————————————————————————————10. Executed 5h 37m 47s ago for 2.856252 sec on Database –> londont9_wp575Date: 2018-04-09 09:41:48 Query_time: 2.856252 Rows_examined: 1362: Rows_sent 1085 Lock_time: 0.001429# Schema: londont9_wp575 Last_errno: 0 Killed: 0 SELECT option_name, option_value FROM wp_options WHERE autoload = yes;——————————————————————————————————
Samantha Boone: What are you trying to do with these scripts?
Chase Price: I have no idea what scripts they are referring to
Samantha Boone: Then its probably normal WordPress behavior and most likely youre back to looking at traffic.
Chase Price: The TWO main factors that spring to mind over the past few days – are 1. Changed permalinks and 2 added social warfare social media plugin
Samantha Boone: So did you turn off the plugin?
Chase Price: not yet…. on my list with coming here and asking first…
Chase Price: Traffic is average at the moment…
Chase Price: and my dan m key on keyboard is playing up so excuse typos…
Lorelai Erickson: You can try installing a cache plugin, that way it runs static copies of the pages instead of running database queries. Also try a good database caching plugin. If the same queries run over and over, a database caching plugin can help decrease the load on the database.
Samantha Boone: You could try installing the WP-Memory-Usage plugin. It creates an admin dashboard widget that shows you how much memory your site is using. There are other performance plugins that tell you what is going on. Your Web hosting dashboard may tell you if you are approaching any limits. You should be looking for peak demand times, not average times.
Samantha Boone: Codex.wordpress.org
High Traffic Tips For WordPress « WordPress Codex
codex.wordpress.org
Chase Price: Traffic is about 2500 a day spread over the day…
Samantha Boone: Well, if we assume that your cloud hosting plan delivers as promised then something funky is going on. You should check your hosting dashboard (I assume it gives you performance metrics) when you get an error. It has been a few years since I managed …See more
Lorelei Lindsey: As mentioned above, try installing a performance plugin, then you can try disabling plugins one at a time to see which if any are causing problems. If possible look at installing a caching plugin which could remove most of the DB interactions.
Chase Price: There is Sitegrounds own Cache plugin
Lorelei Lindsey: Not familiar with Siteground, so cant offer much. WPSuperCache or W3TC are the ones I used to use. Not really in touch with WP ecosystem these days.
Chase Price: WPSuperCache this is standard on Siteground and on this site
Lorelei Lindsey: if your pages are properly cached then page requests shouldnt be affecting things to this degree. You need to install a profiling plugin which will show you the queries etc. Something doesnt sound right TBH, especially if your site is being cached.
Adriel Snyder: Lorelei Lindsey: its sounds like live share counts are causing issues. Because they are live they can not be cached and need to be queried for every page load and for each share platform.
Chase Price: Adriel Snyder: Thanks – I believe Social warfare doesnt pull them in live but need to check it out…
Samantha Boone: Try this plugin. It was recommended to me by a mod at WordPress-dot-Org. WordPress.org
Health Check
wordpress.org
Chase Price: Thanks