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
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,
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 appreciate someone from the development team explain the behavior of using this method.
Best Regards,