[nycbug-talk] MySQL
Hans Zaunere
lists
Sun Aug 21 14:33:46 EDT 2005
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
More information about the talk
mailing list