Sun Aug 21 14:00:03 EDT 2005
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
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...
> 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
> %Be sure to check out our Jobs and NYCBUG-announce lists
> %We meet the first Wednesday of the month
More information about the talk