Hi,
I am having a terrible problem with MySQL and I am desperated as
nobody seems to find the source. I have a Web site ( www.genteirc.com )
whith MySQL database access. The problem is that those Mysql processes are
growing continuously until they consume all of the memory ( 2 Gigas ). I
include at the end of the message two files that we have captured just
before the reboot of the
machine. Somebody is saying that MySQL doesn´t work with Intel
multiprocessors and his solutions is to remove one of the proccesors ¿¿??.
Can you please help me ?.
Thanks very much in advanced.
Best regards,
Salvador
6:47pm up 1 day, 23:05, 2 users, load average: 2.57, 3.04, 3.06
407 processes: 402 sleeping, 5 running, 0 zombie, 0 stopped
CPU states: 33.9% user, 51.4% system, 0.0% nice, 14.6% idle
Mem: 2074332K av, 2062048K used, 12284K free, 259320K shrd, 42224K
buff
Swap: 1052248K av, 752252K used, 299996K free 47108K
cached
PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
9035 cvsanon 12 0 832 796 324 R 0 15.2 0.0 7:15 top
11435 root 2 0 45536 42M 1044 S 0 5.5 2.0 0:03 mysqld
11448 root 1 0 45536 42M 1044 S 0 4.1 2.0 0:01 mysqld
11488 root 1 0 45536 42M 1044 S 0 4.0 2.0 0:00 mysqld
11437 root 1 0 45536 42M 1044 S 0 3.7 2.0 0:04 mysqld
11502 root 1 0 45536 42M 1044 S 0 3.7 2.0 0:00 mysqld
11459 root 1 0 45536 42M 1044 S 0 3.5 2.0 0:02 mysqld
11442 root 1 0 45536 42M 1044 S 0 3.4 2.0 0:00 mysqld
11450 root 1 0 45536 42M 1044 R 0 3.4 2.0 0:02 mysqld
11509 root 1 0 45556 42M 1044 S 0 3.4 2.0 0:00 mysqld
11470 root 1 0 45536 42M 1044 S 0 3.2 2.0 0:01 mysqld
11244 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:05 mysqld
11407 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:02 mysqld
11425 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:02 mysqld
11455 root 1 0 45536 42M 1044 S 0 3.1 2.0 0:01 mysqld
| 221860 | genteirc | localhost | genteirc | Query | 10 | Locked |
SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1'
|
| 221861 | genteirc | localhost | genteirc | Query | 9 | Locked |
SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1'
|
| 221864 | genteirc | localhost | genteirc | Query | 9 | Locked |
SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1'
|
| 221893 | genteirc | localhost | genteirc | Query | 4 | Locked |
update genteirc set novedad=0 where novedad=1 AND
to_days(now())-to_days(Alta) > 10 |
| 221911 | genteirc | localhost | genteirc | Query | 2 | Locked |
SELECT COUNT(*) as nregs FROM genteirc WHERE OK='1'
|
| 221917 | genteirc | localhost | genteirc | Query | 0 | Locked |
update genteirc set novedad=0 where novedad=1 AND
to_days(now())-to_days(Alta) > 10 |
| 221918 | root | localhost | | Query | 0 | |
show processlist
|
+--------+----------+-----------+----------+---------+-------+----------+---
----------------------------------------------------------------------------
-----------------------+
Uptime: 69622 Threads: 231 Questions: 4679585 Slow queries: 2395 Opens:
320 Flush tables: 1 Open tables: 314 Queries per second avg: 67.214
+--------+----------+-----------+----------+---------+-------+--------------
--+-------------------------------------------------------------------------
-----------------------------+
| Id | User | Host | db | Command | Time | State
| Info
|
+--------+----------+-----------+----------+---------+-------+--------------
--+-------------------------------------------------------------------------
-----------------------------+
| 15406 | genteirc | localhost | genteirc | Sleep | 14 |
|
|
| 111020 | genteirc | localhost | genteirc | Sleep | 3 |
|
|
| 128653 | genteirc | localhost | genteirc | Sleep | 3 |
|
|
| 129780 | genteirc | localhost | genteirc | Sleep | 2 |
|
|
| 130243 | genteirc | localhost | genteirc | Sleep | 862 |
|
|
| 131061 | genteirc | localhost | genteirc | Sleep | 44 |
|
|
| 131752 | nobody | localhost | | Sleep | 22713 |
|
|
| 131842 | genteirc | localhost | genteirc | Sleep | 86 |
|
|
| 131935 | genteirc | localhost | genteirc | Sleep | 63 |
|
|
| 132576 | genteirc | localhost | genteirc | Sleep | 204 |
---------------------------------------------------------------------
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
