Strange issue

aahmed3395

New Member
YetiShare User
Dec 27, 2013
2
0
0
Hello,

I'm using the script for one month right now. Yesterday I notice the website was hanging, I went to investigate and found the mysql and httpd service are 100% used. while looking to process list in mysql I found there almost 5000 process for this query

Code:
SELECT id, languageKey, defaultContent
FROM language_key
WHERE id NOT 
IN (

SELECT languageKeyId
FROM
I kept investigating I found this query used in file master.inc.php which used in every page of the website, even more the image plugin has the thumb page where people posting images in forums so each person looking to the image it process the above query.

I appreciate someone from the development team explain the behavior of using this method.

Best Regards,
 

adam

Administrator
Staff member
Dec 5, 2009
2,043
108
63
Hi,

This has been improved in the next release due soon. The query you mention is no longer called in master.inc.php, it's only called as needed by the translations. (which isn't used for the image previews)

Keep an eye on the site for more info on the release soon...

Thanks,
Asdam.