On Wed, Nov 05, 2003 at 10:38:05PM +0530, 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.
That sucks. > 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 ??. Can what be the reason? You say your tables are all healthy. > (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 --- --- The problem seem pretty clear to me. You have a ton of connctions coming from localhost. Fix the code that's doing that and the "problem" will go away. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 1,974,887,441 queries (430/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
