Marcos Bianchi Posted May 29, 2021 Share Posted May 29, 2021 I am facing some processes that have been making my server very slow. I would like to know if there is anything I can do, follow the mysql processes. Brainy S. 1 Link to comment Share on other sites More sharing options...
NoSpy Posted June 22, 2021 Share Posted June 22, 2021 What version of PHP (8.0.5) do you have and what version of MySQL 8 are you using? Link to comment Share on other sites More sharing options...
Marcos Bianchi Posted July 25, 2021 Author Share Posted July 25, 2021 PHP 7.3 and MariaDB 10.3 Link to comment Share on other sites More sharing options...
NoSpy Posted July 26, 2021 Share Posted July 26, 2021 if you have a dedicated server have you tried to restart it? in case it doesn't change anything check if there is a hardware problem or a conflict. Link to comment Share on other sites More sharing options...
CoffeeCake Posted July 26, 2021 Share Posted July 26, 2021 While turning it off and on again is a tried and true method of fixing the most dastardly of computer issues, this queries appear to be related to your usage of the ACP and looking at members listings who haven't yet validated. Is it slow in other areas or just here? Have you run the support tool in ACP to ensure your database schema is correct? Have you looked into MySQL maintenance (ANALYZE/CHECK/OPTIMIZE)? https://dev.mysql.com/doc/refman/8.0/en/table-maintenance-statements.html Link to comment Share on other sites More sharing options...
Recommended Posts