[nycbug-talk] MySQL

[Charles Sprickman]

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.

I need to check out where Postgres is at with replication, and how well 
vpopmail is supporting Postgres...

Charles

> I am just starting to read up on MySQL and looking into optimizations.
>
> Our queries are primarily  against a single table using index access. We use 
> mySQl primarily in conjunction with Postfix so the queries are just lookups 
> of email addresses.
> _______________________________________________
> % NYC*BUG talk mailing list
> http://lists.nycbug.org/mailman/listinfo/talk
> %Be sure to check out our Jobs and NYCBUG-announce lists
> %We meet the first Wednesday of the month
>