[nycbug-talk] MySQL

[Hans Zaunere]

talk-bounces at lists.nycbug.org wrote on Sunday, August 21, 2005 2:00 PM:
> On Sun, 21 Aug 2005, Francisco Reyes wrote:
> 
> > On Sat, 20 Aug 2005, Bob Ippolito wrote:
> > 
> > > Uh yeah.  I've had more bad experiences this month with MySQL
> > > than anyone should ever have with a RDBMS.  These things are
> > > supposed to be robust and reliable, MySQL is neither.  Granted,
> > > we're doing ~150 queries/sec and have
> > > > 4GB data in there, but still.  Stay away if you can!
> > 
> > I have 20 to 60 queries per second and MySQL is using up 50% to 70%
> > of CPU. What optimizations have you done that you could recommend?
> 
> I enjoy it when mysql does this while handling a whopping 20-40
> selects/second:
> 
> PID USERNAME  PRI NICE  SIZE    RES STATE  C   TIME   WCPU
> CPU COMMAND
> 60151 mysql   64   0  86832K 47436K CPU1   0  35.6H 96.73%
> 96.73% mysqld
> 
> It's bogus of course, the thing is just spinning on something and once
> it's stopped/restarted it uses almost no CPU.  Annoying as hell
> though. At least these days it can be gracefully shutdown when hung
> like that.  It used to require a -9 to stop it.

It's because of the threading libraries - it's a classic thread problem on
FreeBSD.

Download the LinuxThreads binary from dev.mysql.com and use that.

H