I site have high CPU and mysql is taking the power.
Found this
I run mysql -e 'show full processlist' and the result is alot of lines like these
In my Apache log I have these lines alot (sensitive data replaced by x)
If I run query in phpmyadmin I get 0 results.
How can I fins what is wrong?
Found this
I run mysql -e 'show full processlist' and the result is alot of lines like these
Code:
SELECT `varname`,`languageid`,`text` FROM vb5_phrase WHERE `varname` IN ('page_4ecbdac82f039695291108_title','page_4ecbdac 82f039695291108_metadesc') AND `languageid` IN (1,0,-1)
Code:
[Sun May 08 07:13:15.847656 2022] [php7:warn] [pid 140030] [client xxx.xxx.xxx.xxx:26147] PHP Warning: Use of undefined constant title - assumed 'title' (this will throw an Error in a future version of PHP) in /xxx/xxx/forum/core/cache/template/template62418.php on line 25
How can I fins what is wrong?
Comment