Just updated to svn 5020 and we are having a system resource overload. Mysql doesn’t seem to be dropping any connections now and apache has over 120+ children spawning when then computers check in with the client. From the time I started this topic to right now the sql connections have jumped from 300 to 1100… mysql is running around 30-35% CPU and the httpd processes are chewing up the rest of the CPU. This only started happening when we updated to 5020 from 4960 (but svn shows revision 4189?)

I added the following to the MySQL.class.php file to see how often it was creating a SQL connection: public function connect() try if (!$this->link) file_put_contents(‘php://stderr’, print_r(DATABASE_HOST, TRUE)) It seems to be getting called 7-10 times per second currently. Every single connection is p:127.0.0.1 so every connection is persistant…and they are not getting closed would be my guess. Thanks! Adam

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

MYSQL/HTTPD resource issues in 5020

Solved

Bug Reports

16.6k

J

Joseph Hales Testers
last edited by Oct 27, 2015, 6:26 PM

@Uncle-Frank said:

mysqladmin -u root -p -i 1 processlist;

New thread started here
https://forums.fogproject.org/topic/6020/fog-svn-5020-and-above-cpu-hammered-thread/1
RTFM
1 Reply Last reply
Reply Quote 0

209

Online

12.0k

Users

17.3k

Topics

155.2k

Posts