[thelist] tuning MySQL
Matt McKeon
matt at camadro.com
Tue Nov 28 14:58:52 CST 2006
jason.handby wrote:
> Hi Matt,
>
>
>
>
>> This week at work we just got a new MySQL DB server because
>> the our old one was fading fast. So, I started to moved some
>> of the traffic over to it and its a Xeon 2.4ghz with 2GB RAM.
>> I would think it would hold up pretty well as just a DB
>> server, but after a few hours of use it started to kack.
>>
>> After 2.5 hours with about 20k of queries 11k of them failed
>> according to phpMyAdmin.
>> So I'm asking what can I do to optimize this? I have primary
>> keys and the scripts that are connecting to it are only doing
>> 1-2 SELECT's and 1 UPDATE I increased max_connections, and
>> query_cache_size but it just isn't doing it. I'm just not
>> sure where to begin to look for bottle necks. Any suggestions?
>>
>
> Could this be relevant?
>
> http://bugs.mysql.com/bug.php?id=15815
>
>
>
> Jason
>
They are talking about InnoDB tables, but I'm using MyISAM.
I'll take a look into it though.
Thanks,
Matt
More information about the thelist
mailing list