Hello mysql, I've just upgraded my WEB-Server box (2xPIII-500Mhz, 1Gb mem) to FreeBSD 4.3-RELEASE & update mysql to 3.23.38. (mysql Ver 11.15 Distrib 3.23.38, for -freebsd4.3 (i386)) Usually mysqld was taken 8-20% of CPU usage (top results). But after some days i'am notice that mysql takes all resources, avialable on 1 cpu ;( After mysqladmin shutdown and start it again all goes normal some time.. (8-20% of load), but it grows with days ;( Is there any solution for this problem ? - 'top' -------------------------------------- last pid: 62113; load averages: 1.91, 1.96, 1.97 up 17+04:35:35 16:38:58 112 processes: 2 running, 110 sleeping CPU states: 21.6% user, 0.0% nice, 46.0% system, 0.0% interrupt, 32.3% idle Mem: 385M Active, 419M Inact, 150M Wired, 31M Cache, 98M Buf, 20M Free Swap: 2048M Total, 4304K Used, 2044M Free PID USERNAME PRI NICE SIZE RES STATE C TIME WCPU CPU COMMAND 23130 mysql 62 0 425M 170M CPU1 0 107:08 79.15% 79.15% mysqld 62009 apache 18 0 15900K 10652K lockf 1 0:01 4.53% 3.03% httpd ----------------------------- Generally Mysql is used from PHP-4.0.5 as mod_php from apache. And there is no noticed worked mysql threads - 'mysqladmin processlist | grep -v Sleep' -------------- | Id | User | Host | db | Command | Time | State | |Info | | 3851 | DELAYED | localhost | webchat | Delayed_insert | 2 | Waiting on cond | |messages | | 4446 | DELAYED | localhost | webchat | Delayed_insert | 201 | Waiting on cond | |pager | | 4605 | root | localhost | | Query | 0 | | |show processlist | ----------------------------------------------------------- - 'mysqladmin status' -------------------------------------- Uptime: 9732 Threads: 58 Questions: 530902 Slow queries: 56 Opens: 3159 Flush tables: 1 Open tables: 249 Queries per second avg: 54.552 -------------------------------------------- С уважением, Алексей Русанов Научно-производственное предприятие "Юникон Плюс", Новосибирск Ведущий специалист отдела Internet технологий Unix network administrator Тел: +7 3832 23-94-06 +7 3832 10-00-50 Факс: +7 3832 23-94-06 ICQ UIN: 8397628 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php