MySQL 4.0 - your oppinions please

[datune]

Hello!

Is anybody using MySQL 4.0 already?

Is it worth to upgrade or would it be better to wait for at least beta release?

If you are using it, did you have any problems so far?

[Ingoal]

Originally posted by datune
Hello!

Is anybody using MySQL 4.0 already?

Is it worth to upgrade or would it be better to wait for at least beta release?

If you are using it, did you have any problems so far?

Nope, i´m not using it atm...and there´s no way i´m gonna take the risk of using an alpha version....I´m using mysql 3.23 atm...

If you wanna go for MySQL4 i would wait on the beta release...

Cheers Ingoal

[seanf]

Actually it is supposed to be very stable

Sean

[DR_LaRRY_PEpPeR]

as i've said before, i'd be using 4 without hesitation if i had my own server. it's tested very well before being released and i don't think little Web scripts will reveal any bugs.

there are a bunch of things that i'd love about it (over 3.23). here's some i can think of now:

• should be faster
• should be scale better (i saw someone on the vBulletin forum that was having table locking problems with 3.23; switched to 4.0.1 and they went away).
• query cache. will make queries a lot faster from tables that aren't often updated
• SELECT SQL_CALC_FOUND_ROWS ... that will save you from having to 1) SELECT more rows that you need just to count them, or 2) run a seperate SELECT COUNT(*) query.

of course, if you switch to 4, make sure you test the queries on 3.23 if there's any chance that the scripts will be run using it.

[Hierophant]

I used 4.0 on my own PC for a while. However I had a problem with database corruption and now I have a database that I can't make any changes (alter, update, delete, drop, etc...)

I switched back 3.23.49-NT and not had any problems yet though I am still trying to repair the other database.