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
