Hi Nick, This is due (so I am told) to a problem in FreeBSD threads. I have this happen once in a while also. There have been some threads changes for 4.9 but I am not sure there is any change in this.
The common suggestion is to compile with LINUXTHREADS option using the ports tree. This will solve that and give you better performance on a multi CPU system. (cd /usr/ports/databases/mysql41-server; more Makefile ) or see http://jeremy.zawodny.com/blog/archives/000458.html Another option would be to update to FreeBSD 5.1 and use the new threading (not so easy). I personaly hope 4.9 will settle this down some as I don't see the need to go to LINUX Threads for a single proc machine! Best of Luck Ken ----- Original Message ----- From: "Nick Gaugler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 28, 2003 3:53 PM Subject: FW: FreeBSD 4.8 runaway MySQL 4.0.14 > I am running the binary installation of MySQL 4.0.14 on FreeBSD 4.8, all > MyISAM tables, and after alittle while mysqld will jump to 100% of my > CPU and go crazy. I've investigated SHOW INNODB STATUS, and as you can > see below, there is nothing happening with Innodb. Infact my Innodb > files have not even changed since I last restarted. But for some reason > MySQLd uses 100% of my CPU with no queries happening. I tried to run > ktrace and this was all I saw: > > > 30488 mysqld CALL gettimeofday(0x2846e288,0) > 30488 mysqld RET gettimeofday 0 > 30488 mysqld CALL poll(0x83b6000,0xc,0) > 30488 mysqld RET poll 0 > 30488 mysqld CALL poll(0x83b6000,0xd,0x126) > 30488 mysqld RET poll 1 > 30488 mysqld CALL gettimeofday(0x2846e288,0) > 30488 mysqld RET gettimeofday 0 > 30488 mysqld CALL poll(0x83b6000,0xd,0x126) > 30488 mysqld RET poll 1 > > With an occasional > > 30488 mysqld CALL poll(0x83b6000,0xd,0x126) > 30488 mysqld PSIG SIGPROF caught handler=0x2842562c mask=0x0 > code=0x0 > 30488 mysqld RET poll 1 > 30488 mysqld CALL gettimeofday(0x2846e288,0) > 30488 mysqld RET gettimeofday 0 > 30488 mysqld CALL sigreturn(0x83a9db8) > 30488 mysqld RET sigreturn JUSTRETURN > > > Has anyone experienced a runway mysqld on FreeBSD before? Is there > anything I can do to fix this or solve this problem? Below is show > innodb status\g > > ===================================== > 030828 14:36:37 INNODB MONITOR OUTPUT > ===================================== > Per second averages calculated from the last 16 seconds > ---------- > SEMAPHORES > ---------- > OS WAIT ARRAY INFO: reservation count 4, signal count 4 > Mutex spin waits 0, rounds 0, OS waits 0 > RW-shared spins 6, OS waits 3; RW-excl spins 1, OS waits 1 > ------------ > TRANSACTIONS > ------------ > Trx id counter 0 1280 > Purge done for trx's n:o < 0 0 undo n:o < 0 0 > Total number of lock structs in row lock hash table 0 > LIST OF TRANSACTIONS FOR EACH SESSION: > ---TRANSACTION 0 0, not started, OS thread id 299134976 > MySQL thread id 176926, query id 516226 localhost root > show innodb status > -------- > FILE I/O > -------- > I/O thread 0 state: waiting for i/o request (insert buffer thread) > I/O thread 1 state: waiting for i/o request (log thread) > I/O thread 2 state: waiting for i/o request (read thread) > I/O thread 3 state: waiting for i/o request (write thread) > Pending normal aio reads: 0, aio writes: 0, > ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 > Pending flushes (fsync) log: 0; buffer pool: 0 > 40 OS file reads, 4 OS file writes, 4 OS fsyncs > 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s > ------------------------------------- > INSERT BUFFER AND ADAPTIVE HASH INDEX > ------------------------------------- > Ibuf for space 0: size 1, free list len 0, seg size 2, > 0 inserts, 0 merged recs, 0 merges > Hash table size 34679, used cells 0, node heap has 0 buffer(s) > 0.00 hash searches/s, 0.00 non-hash searches/s > --- > LOG > --- > Log sequence number 0 43892 > Log flushed up to 0 43892 > Last checkpoint at 0 43892 > 0 pending log writes, 0 pending chkp writes > 9 log i/o's done, 0.00 log i/o's/second > ---------------------- > BUFFER POOL AND MEMORY > ---------------------- > Total memory allocated 16338600; in additional pool allocated 641280 > Buffer pool size 512 > Free buffers 493 > Database pages 19 > Modified db pages 0 > Pending reads 0 > Pending writes: LRU 0, flush list 0, single page 0 > Pages read 19, created 0, written 0 > 0.00 reads/s, 0.00 creates/s, 0.00 writes/s > No buffer pool page gets since the last printout > -------------- > ROW OPERATIONS > -------------- > 0 queries inside InnoDB, 0 queries in queue > Main thread id 158370816, state: waiting for server activity > Number of rows inserted 0, updated 0, deleted 0, read 0 > 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s > ---------------------------- > END OF INNODB MONITOR OUTPUT > > Nick > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
