Hi1
>>>>> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Liz Marlow writes:
>> We've upgraded from 3.22.27 to 3.23.39 to utilise replication but have found
>> that this version is significantly slower that our old version (we haven't
>> switched replication on yet either). Has anyone else noticed this or have
>> any suggestions to improve performance.
>>
>> We upgraded MySQLdb from MySQLdb-0.1.2 to MySQL-python-0.9.0 and Python from
>> 2.0 to 2.1 at the same time but we don't think it's these. When we're
>> running a quite large series of updates the CPU usage is at 90ish% but
>> memory seems ok.
>>
>> We're running on Linux - Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0
>> on an i686.
>>
>> Any suggestions gratefully accepted:-)
>>
>> Many thanks
>> Liz
Sinisa> 3.23.39 should be MUCH faster then 3.22, provided you have converted
Sinisa> your tables from ISAM to MyISAM.
Even if you don't convert the tables to NISAM, MySQL 3.23 should be
faster in most cases.
Could you find out which queries that are slower in 3.23 ?
We have added lots of more optimizations to MySQL 3.23, but there may
always be some case that goes a bit slower. On the other hand, MySQL
3.23 provides a lot of workarounds, like 'ignore index' to solve
these.
Regards,
Monty
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
