List:General Discussion« Previous MessageNext Message »
From:Nick Gaugler Date:August 28 2003 8:20pm
Subject:RE: FreeBSD 4.8 runaway MySQL 4.0.14
View as plain text  
Ken, 

Thanks for the response.  I really wish MySQL AB would compile FreeBSD
binaries with LinuxThreads.  It's really a pain when you find a bug, the
first thing they ask is "have you compiled this yourself" when in this
case you have no choice but to compile it yourself.

Maybe Jeremy could compile "unofficial but recommended" binaries that
MySQL AB would support more like official binaries? :)  If he's got
nothing better to do of course, he already puts in so much time to the
MySQL community as is.


Nick


-----Original Message-----
From: Ken Menzel [mailto:kenmysql@stripped] 
Sent: Thursday, August 28, 2003 4:14 PM
To: Nick Gaugler; mysql@stripped
Subject: Re: FreeBSD 4.8 runaway MySQL 4.0.14

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" <ngaugler@stripped>
To: <mysql@stripped>
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/mysql?unsub=1
>
>

Thread
FW: FreeBSD 4.8 runaway MySQL 4.0.14Nick Gaugler28 Aug
  • Re: FreeBSD 4.8 runaway MySQL 4.0.14Ken Menzel28 Aug
    • RE: FreeBSD 4.8 runaway MySQL 4.0.14Nick Gaugler28 Aug
      • Re: FreeBSD 4.8 runaway MySQL 4.0.14Jeremy Zawodny12 Sep
        • Re: FreeBSD 4.8 runaway MySQL 4.0.14Lenz Grimmer12 Sep
          • Re: FreeBSD 4.8 runaway MySQL 4.0.14Jeremy Zawodny12 Sep
            • Re: FreeBSD 4.8 runaway MySQL 4.0.14Lenz Grimmer12 Sep
    • Re: FreeBSD 4.8 runaway MySQL 4.0.14Jeremy Zawodny12 Sep