Those are threads, not processes. Each connection gets a thread. Many connections waiting for disk space will give you this problem.
Jobs PHP Workshop wrote:
Hi, Problem is, Mysql server in our production machine keeps spawning child processes and it reaches to a level where mysql hangs and the only solution is to restart our mysql server. I have checked all the databases using "mysqlcheck" command and every table is OK now. Recently, MySQL server suffered from low disk space and hence some of the tables got corrupted. We have repaired them using "mysqlcheck -r" option. Can this be a Reason of the mysqld process spawning problem ??. Some help will really save me as this is a production machine. We have MySQL 3.23.x running and Following is more technical details that you may need to think upon: (1) HERE IS THE PARTIAL OUTPUT OF 'TOP' COMMAND:
2:52pm up 1 day, 22:34, 2 users, load average: 0.30, 0.09, 0.03 134 processes: 133 sleeping, 1 running, 0 zombie, 0 stopped CPU states: 0.9% user, 2.7% system, 0.0% nice, 96.3% idle Mem: 1028316K av, 1015484K used, 12832K free, 0K shrd, 180292K buff Swap: 522072K av, 4096K used, 517976K free 470328K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 6097 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6099 mysql 8 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6100 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6105 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:03 mysqld 6108 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld 6109 mysql 9 0 23004 22M 1528 S 0.0 2.2 0:00 mysqld
(2) HERE IS THE PARTIAL LIST OF PROCESSES OUT OF TOTAL 94 AS A RESULT OF 'SHOW PROCESSLIST' COMMAND.REST OTHER PROCESSES ARE ALSO SIMILAR:
id User Host Database Command Time Status
SQL-query
------------------------------------------------------------------------
---
131 u125 localhost db125 Sleep 6243 --- --- 139 csha localhost db_cshaw_com Sleep 2494 --- --- 140 tanb localhost db_tban_com Sleep 1985 --- --- 141 tanb localhost db_tban_com Sleep 2006 --- --- 142 tanb localhost db_tban_com Sleep 1977 --- --- 143 tanb localhost db_tban_com Sleep 1948 --- --- 144 tanb localhost db_tban_com Sleep 1939 --- --- 145 tanb localhost db_tban_com Sleep 1410 --- --- 146 tanb localhost db_tban_com Sleep 1394 --- --- 147 dbpr localhost dbpropertydb Sleep 1092 --- --- 154 root localhost mysql Query 0 --- SHOW
PROCESSLIST
(3) HERE IS THE 'extended-status' of MySQL:
+--------------------------+----------+ | Variable_name | Value | +--------------------------+----------+ | Aborted_clients | 1 | | Aborted_connects | 0 | | Bytes_received | 6271826 | | Bytes_sent | 18499758 | | Connections | 158 | | Created_tmp_disk_tables | 105 | | Created_tmp_tables | 1174 | | Created_tmp_files | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 283 | | Handler_read_first | 618 | | Handler_read_key | 598750 | | Handler_read_next | 600043 | | Handler_read_prev | 0 | | Handler_read_rnd | 20400 | | Handler_read_rnd_next | 21962199 | | Handler_update | 1035 | | Handler_write | 22201 | | Key_blocks_used | 15582 | | Key_read_requests | 1403805 | | Key_reads | 85703 | | Key_write_requests | 5742 | | Key_writes | 4974 | | Max_used_connections | 88 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 64 | | Open_files | 131 | | Open_streams | 0 | | Opened_tables | 20961 | | Questions | 63778 | | Select_full_join | 1288 | | Select_full_range_join | 0 | | Select_range | 0 | | Select_range_check | 0 | | Select_scan | 7348 | | Slave_running | OFF | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 0 | | Sort_merge_passes | 0 | | Sort_range | 0 | | Sort_rows | 20400 | | Sort_scan | 1405 | | Table_locks_immediate | 49707 | | Table_locks_waited | 1 | | Threads_cached | 0 | | Threads_created | 157 | | Threads_connected | 88 | | Threads_running | 1 | | Uptime | 18794 | +--------------------------+----------+
Thanks.., Shailesh Agrawal.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
