Upgrade from mysqld 5.1.46 to mysql 6.0.x

[phil_discount]

Hello,

i'm using mysql Version 5.1.46. Is it possible to upgrade to mysql 6.0.x without any problems?

Regards
Philip

[mflorell]

We haven't tested it yet, if you do upgrade please let us know how it goes.

[phil_discount]

ok perhaps i setup a test db next month.
If I will do, i let you know
Thanks

[williamconley]

Not to be nosy ... but Why are you upgrading your db server again? (Always curious ...)

[phil_discount]

Some people told me that the new mysql should be faster while processing joins.
i've got a lot of custom queries (joins)

[williamconley]

Did they state this specifically when referring to MyISAM or were they referring to InnoDB?

Are you experiencing difficulties or bottlenecks resulting from joins? (crashes?)

[phil_discount]

no, notehing else
sometimes i've got waiting queries for about 2-5 secs while a big join is blocking a table.

[williamconley]

call me pessimistic, but i do not see an upgrade fixing that. LOL

perhaps you should look at a slave DB (run those reports on the slave DB which does not have an effect on the master, but has all the data).

or rewrite your queries to avoid the joins (often these can be replaced with work-horse php/perl scripts that gather the data more slowly but without any lockup time).

[phil_discount]

i already have two slaves

[williamconley]

Um ... run the query on one of the slaves to avoid locking up the master?

[phil_discount]

of course but some queries i cannot run on slave, must be on primary cause of the information must be syncrhon.
the slaves are sometimes a lot of seconds behind the master because of long joins

[williamconley]

sounds to me like you need to rethink these queries. rewrite to remove the intensity, break them into pieces to run without systemic overload.