Skip Navigation

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.

This topic contains 23 replies, has 2 voices.

Last updated by Dat Hoang 6 years, 1 month ago.

Assigned support staff: Dat Hoang.

Author Posts
September 14, 2015 at 1:52 pm #703675

ferjoltO

Hello,
I had this kind of problem from the beginning but, somehow, it clears itself and start working somehow good, but now, everything stops working 15-20mins after wpml plugin is activated. I have upgraded mysql as your collegues suggested on some other posts to 5.5 and my php is 5.4.x. Also, i have installed APC but the website still don't work as it should. Immediately after i disable the WPML plugin, the website works perfectly well and the server don't overload.
I need some help on this, please.
WP - 4.3
WPML - the last one
Theme: NewsPlus (from themeforest - is wpml compatible)
OS - CentOS 6.7
CPU - Intel(R) Xeon(R) CPU E5620 @ 2.40GHz, 16 cores
RAM - 16GB
Virtual Memory - 50GB
When the server overloads, it has from 15 to 57 Tasks running, and all of them are mysql tasks. And the load came instantly and not step by step. It goes from 1-3 tasks, to 35 immediately. I have attached a printscreen of those tasks with this post, to have an idea what's going on.

server-overload1.jpg
September 15, 2015 at 7:20 am #704164

Dat Hoang

Your WPML versions are up-to-date (WPML 3.2.7 and its add-ons).

#1,
Currently you're using PHP 5.4.x. If possible, we suggest using PHP 5.6+. As you may know, WordPress core team has just changed the requirement of WordPress: https://wordpress.org/about/requirements/

Upgrading to PHP.5.6+ does help?

#2,
Please review this article: http://wpml.org/2012/01/can-your-site-run-faster/ especially the section under “Using WPML Better” and confirm that the following settings are OFF or disabled
- Auto ID adjust state
- Track where strings appear
- Auto register strings

#3,
1. Please follow the debugging information provided here: http://wpml.org/documentation/support/debugging-wpml/,
2. Repeat the action of surfing your site.
3. Copy and paste the contents of debug.log (log file inside the /wp-content/ directory) here for me to see

September 15, 2015 at 2:38 pm #704699

ferjoltO

Hello,
Thank you for your reply.

#1 I don't think that this overloading is caused by Php version. Anyway, if you say so, i'll upgrade it to 5.6 and let you know.

#2 Auto ID adjust state is OFF. The other 2 options, i didn't find anywhere.

#3 The only thing on the debug is this Notice:
[15-Sep-2015 14:20:24 UTC] The called constructor method for WP_Widget is deprecated since version 4.3.0! Use __construct() instead. in /home/xxxxxxx/public_html/wp-includes/functions.php on line 3457

I have installed WP Super Cache and OPcache. Also, i have a cloudflare account that can do the minify and other performance tweaks. Also, attached is a printscreen from today where my server was overloaded.

Thank you!

server-load2.jpg
September 15, 2015 at 2:46 pm #704712

ferjoltO

I have just upgraded PHP to 5.6.13:

PHP 5.6.13 (cli) (built: Sep 5 2015 07:10:08)
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend Technologies
with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2015, by Zend Technologies

I'll let you know if anything changes.
Thank you!

September 16, 2015 at 4:28 am #705073

Dat Hoang

#1,
OK. Update me when you have new results with PHP 5.6.x

#2,
OK. Thanks for your info.

#3,
With just this warning, it should not deteriorate your site performance.

September 16, 2015 at 12:51 pm #705537

ferjoltO

Hello,
Today, i had the same problem. The site was inaccessible until i restarted many times the mysqld and, after that, i was obligated to disable the wpml plugin. Without wpml, everything worked as it should. Everything is happening when the article writers are online and working on wp-admin (postin articles in default language and translating them in 2 other languages).
It's obvious that everything is caused by wpml, but i cannot get the reason. I hope you can help me as soon as possible since the website is for a governmental news agency and everyone is under pressure because of this problem.
Thank you!
P.S. You can see the server overload now in the img attached

server-loading3.jpg
September 17, 2015 at 5:17 am #706131

Dat Hoang

#1,
I see the front-end loads fine. So the problem is on the back-end wp-admin only?

#2,
Please install this plugin https://wordpress.org/plugins/query-monitor/ . Query Monitor provides generic and detailed reports: total SQL queries and the response time .

I would like to see the reports in these cases:
+ The current state: plugins enabled + current theme + WPML and add-ons enabled.
+ Disable all non-related WPML plugins + one of default themes + WPML and add-ons enabled.
+ Enable all non-related WPML plugins + one of default themes + WPML and add-ons disabled.

September 17, 2015 at 12:33 pm #706607

ferjoltO

The problem doesn't appear all the time. It has some moments when it works great, and instantly it overloads the server. It happened only when the article writers are online and logged in in the admin dashboard. Also, if the user permission is Administrator, it wont load the "All Posts" page (wp-admin/edit.php). If i disable WPML, it loads correctly.

#2 I have installed the query monitor, and it shows at least 111Queries on Dashboard loading (wp-admin/index.php) and at least 1 Slow Queires that is as follow:

SELECT post_status, COUNT( * ) AS num_posts
FROM xxx_posts
WHERE post_type = 'post'
GROUP BY post_status

Queries by components looks as follow:

Core	                                               30	 0      0.0783
Plugin: sitepress-multilingual-cms	26	 2	0.0090
Theme	                                        44	 0	0.0040

#3 As per this, i cannot do as you suggest since I cannot disable themes and plugins since the website is online and it's a very important one. I can do those changes only at night, but it will not be relevant since, as i mentioned before, the problem appear when journalists are online and working on admin dashboard. At night, no one is online.

Thank you!

September 18, 2015 at 6:49 am #707206

Dat Hoang

#1,
OK. So the problem happens when many people work in the back-end.
Can you please let me know how many people works at the time the problem happens?

#2,
As you see in the report, WPML does not affect to much with this report.
Actually I don't have any idea more since the queries look fine.
I need to request temporary access (wp-admin and FTP) to your site in order to be of better help.

You will find the needed fields for this below the comment area when you log in to leave your next reply. hidden link

These info is private, and available to you and supporters only. Read more about this: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

Note that:
+ Backup (both files and database) your site before giving us your credentials
+ It would be BETTER if you give me the test site rather than the live site.

Then I will escalate this to our 2nd tier supporters.

October 12, 2015 at 1:57 pm #722916

ferjoltO

The problem persists. After 2 weeks of working somehow well, today is not working. Is blocking the whole server and WP is not responding. After i disable the wpml, everything works great. So, i don't know what report said but i know that everything works great when WPML is disabled.
I need urgent help, please!

October 12, 2015 at 2:55 pm #722977

ferjoltO

I disabled the WPML and the site works perfect without it. I enabled it again and immediate it blocked the whole server. I disabled it again and saw that i myslq slow logs, in only 2-3 minutes appear tooooo many slow queries. Below are only some of them"

 # User@Host: dbname[dbname] @ localhost []
# Query_time: 23.475179  Lock_time: 0.000134 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660931;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 1.899736  Lock_time: 0.000086 Rows_sent: 3  Rows_examined: 62031
SET timestamp=1444660931;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (6,7,8,9,10)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 3;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 23.285998  Lock_time: 0.000196 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660931;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 23.310835  Lock_time: 0.000146 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660931;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 23.293833  Lock_time: 0.000162 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660931;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# Time: 151012 16:42:12
# User@Host: dbname[dbname] @ localhost []
# Query_time: 22.512910  Lock_time: 0.000223 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660932;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 23.257120  Lock_time: 0.000148 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660932;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 22.952598  Lock_time: 0.000113 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660932;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 22.268291  Lock_time: 0.000195 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660932;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 22.143730  Lock_time: 0.000249 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660932;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 21.962353  Lock_time: 0.000149 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660932;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 21.973449  Lock_time: 0.000107 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660932;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 20.413678  Lock_time: 0.000169 Rows_sent: 10  Rows_examined: 509462
SET timestamp=1444660932;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (1,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,1110,7862,8246,8247)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 10;
# User@Host: dbname[dbname] @ localhost []
# Query_time: 2.768890  Lock_time: 0.000133 Rows_sent: 3  Rows_examined: 80798
SET timestamp=1444660932;
SELECT SQL_CALC_FOUND_ROWS  abcd_posts.ID FROM abcd_posts  INNER JOIN abcd_term_relationships ON (abcd_posts.ID = abcd_term_relationships.object_id) JOIN abcd_icl_translations t
							ON abcd_posts.ID = t.element_id
								AND t.element_type = CONCAT('post_', abcd_posts.post_type)  WHERE 1=1  AND ( 
  abcd_term_relationships.term_taxonomy_id IN (6,7,8,9,10)
) AND abcd_posts.post_type = 'post' AND ((abcd_posts.post_status = 'publish')) AND ( ( t.language_code = 'sq' AND abcd_posts.post_type  IN ('post','page' )  ) OR abcd_posts.post_type  NOT  IN ('post','page' )  ) GROUP BY abcd_posts.ID ORDER BY abcd_posts.post_date DESC LIMIT 0, 3;

I Need urgent help!

October 13, 2015 at 3:41 am #723317

Dat Hoang

#1,
Like you said, there was no problem in 2 recent weeks. And now the problem starts again?
Can you please let me know what did you do?

#2,
Again I reviewed your SQL queries, and they're fine and there are just problems related to the query time.
Can you please try to run these SQL queries in PHPMyadmin? How are they?

October 13, 2015 at 11:32 am #723691

ferjoltO

Hello,
I didn't do anything special. I even didn't enter at the dashboard at all for that time since the whole thing is managed by editor/journalists.
How you can say that the sql query is fine while it has problem related to the query time? I have pasted only some queries, but hey are many of them and all of them have query time problems. I don't know what to do.
I will remove at all the wpml plugin and reinstall it. Hope it will resolve the issue!

October 13, 2015 at 1:21 pm #723824

ferjoltO

I have removed the wpml at all and reinstalled it but the problem persists. Also, all with administrator privileges, when trying to access All Post section (wp-admin/edit.php), it just appear blank page. I have tried to find any clue on logs, nothing 🙁
This problem does not appear on any other user. Just at administrators.

October 14, 2015 at 4:23 am #724277

Dat Hoang

#1,
Thanks for your info.

#2,
I say these queries are fine, that means they have the correct syntax and there is nothing too special.
I just think they're just too many and your MySQL can not response on time.

I need to request temporary access (wp-admin and FTP) to your site in order to be of better help. You will find the needed fields for this below the comment area when you log in to leave your next reply. hidden link

These info is private, and available to you and supporters only. Read more about this: https://wpml.org/purchase/support-policy/privacy-and-security-when-providing-debug-information-for-support/

Note that:
+ Backup (both files and database) your site before giving us your credentials
+ It would be better if you give me the test site rather than the live site.