Hello,
The categories queries take sometimes more that 1000 s to finish this is causing cpu charge 100% and server down.
Exemple from the slow query log:
# Query_time: 787 Lock_time: 0 Rows_sent: 9 Rows_examined: 19998
use com;
SELECT
`tgs`.`Category` as `Category`,
`tgs`.`Date` as `Date`,
COUNT(`tgs`.`ID`) AS `count`
FROM `sys_categories` `tgs` WHERE `tgs`.`Owner` != 0 AND `tgs`.`Category` IN (SELECT `Category` FROM `sys_categories` WHERE `Type` = tgs.`Type` AND `Owner` = 0) AND `tgs`.`Type` = 'bx_sites' AND tgs.`Status` = 'active' GROUP BY `Category`;
This need to be solved as soon as possible.
With all my respect.