Too many SQL commands and crashing website

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	10:00 – 17:00	-
-	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	18:00 – 19:00	-

Supporter timezone: Asia/Kathmandu (GMT+05:45)

This topic contains 24 replies, has 2 voices.

Last updated by Shekhar Bhandari 1 year, 7 months ago.

Assisted by: Shekhar Bhandari.

Author	Posts
November 29, 2023 at 9:34 am #14948093
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, The test website is not working for me, can you please check? Also, can you provide feedback on my previous response? Look forward to your reply. Thanks
November 29, 2023 at 9:37 am #14948113
jonC-13	please add 77.235.58.16 test.theolivepress.es to host file
November 29, 2023 at 9:42 am #14948201
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	I added it, and it works now but the test site redirects to the main site, can you please check? Also, please provide feedback on the following: Can you also check if the problem exists on the test server? Also, test it by disabling everything except WPML.
November 29, 2023 at 3:23 pm #14953335
jonC-13	The website is now accessible if you want to check. I am looking further into the plugins and see if continues
November 29, 2023 at 9:08 pm #14956317
jonC-13	yes it is still having issues. In the test website I have disabled all plugins except WPML and still the same problems. Please take a look.
November 30, 2023 at 6:44 am #14958127
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello Jon 🙂 Thank you for confirming. I am monitoring the test site to see when it crashes, do I need to follow some steps, or the crash is automatically fixed after some time? I assume when the site crashes the front end will show some message or will be inaccessible, correct? Look forward to your reply. Thanks
November 30, 2023 at 12:38 pm #14962475
jonC-13	OK we had some problems with Redis and it affected live website. We now have them working independently from each other. After about 10 mins it starts to run really slow until the server crashes. I tested last night with only WPML plugins enabled and problem still happened. and crashed the test and the live website. it is just constantly hitting the DB with these commands. is it because we have so many posts? SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts JOIN wp_icl_translations wpml_translatio \| \| 5380592 \| theolive_wrdp1 \| localhost \| theolive_wrdp1 \| Query \| 28 \| executing \| SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts JOIN wp_icl_translations wpml_translatio \| \| 5380595 \| theolive_wrdp1 \| localhost \| theolive_wrdp1 \| Query \| 32 \| executing \| SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts JOIN wp_icl_translations wpml_translatio \| \| 5380705 \| theolive_wrdp1 \| localhost \| theolive_wrdp1 \| Query \| 50 \| executing \| SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_p \| \| 5380783 \| theolive_wrdp1 \| localhost \| theolive_wrdp1 \| Query \| 30 \| executing \| SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts JOIN wp_icl_translations wpml_translatio \| \| 5380813 \| theolive_wrdp1 \| localhost \| theolive_wrdp1 \| Query \| 9 \| executing \| SELECT p.ID FROM wp_posts AS p JOIN wp_icl_translations wpml_translations ON wpml_translations.elem \| \| 5380826 \| theolive_wrdp1 \| localhost \| theolive_wrdp1 \| Query \| 1 \| executing \| SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts JOIN wp_icl_translations wpml_translatio \| \| 5380837 \| theolive_wrdp1 \| localhost \| theolive_wrdp1 \| Query \| 7 \| executing \| SELECT p.ID FROM wp_posts AS p JOIN wp_icl_translations wpml_translations ON wpml_translations.elem \| \| 5380838 \| theolive_wrdp1 \| localhost \| theolive_wrdp1 \| Query \| 5 \| executing \| SELECT p.ID FROM wp_posts AS p JOIN wp_icl_translations wpml_translations ON wpml_translations.elem \| \| 5380839 \| theolive_wrdp1 \| localhost \| theolive_wrdp1 \| Query \| 2 \| executing \| SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts JOIN wp_icl_translations wpml_translatio \| \| 5380852 \| theolive_wrdp1 \| localhost \| theolive_wrdp1 \| Query \| 1 \| executing \| SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
December 1, 2023 at 9:15 am #14970279
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, I have asked our 2nd tier for further feedback and when they tested the issue, they couldn't see the issue. So we would need more info on how to replicate the issue, can you leave the site as it is when it's crashed? They tested on this page: hidden link 0.04s query time with 58 queries on the above page. Also, they mentioned that the query is a standard query to select posts/pages. Look forward to your reply. Thanks Thanks
December 8, 2023 at 9:00 am #15023535
jonC-13	OK we are still checking on this, we can't understand why it would be working on the test website but not the live. it is an exact copy. The hosting has advised us to update all tables to INNODB format and then try again. Would this make a difference?
December 8, 2023 at 10:18 am #15024407
Shekhar Bhandari WPML Supporter since 03/2015 Languages: English (English ) Timezone: Asia/Kathmandu (GMT+05:45)	Hello there, The hosting has advised us to update all tables to InnoDB format and then try again. Would this make a difference? If they advised it, then it should help, I am not sure if it will be a huge difference or not, but I suggest trying the steps hosting advises you. Thanks

The topic ‘[Closed] Too many SQL commands and crashing website’ is closed to new replies.