mysql 5.0.23 vs 5.5 performance benefits and upgrade issues?
Posted
by
WarDoGG
on Server Fault
See other posts from Server Fault
or by WarDoGG
Published on 2011-03-06T22:39:20Z
Indexed on
2012/06/03
16:42 UTC
Read the original article
Hit count: 218
I have been told that mysql 5.5 has a significant performance boost compared to 5.0
Our server handles a lot of data (around 30 million records processed per 5-10 seconds) and requires every drop of performance boost we can give. Will it be beneficial if we upgrade from 5.0.23 to mysql 5.5?
Also, we have lots of database indexes setup on the tables and I've been told that sometimes the indexes become corrupt after a version upgrade and they have to be rebuilt. Is this true?
© Server Fault or respective owner