MySQL 5.5 GA

Quote:

---

Originally Posted by eva2000

Can get messy if you leave 5.5 to default to innodb as some scripts don't define the storage engine in their mysql create statements. You'll be getting alot of support tickets asking how to convert innodb tables back to myisam ! Unless, you're prepared to also provide optimisation and tuning advice for innodb related options and performance tuning. As well guides on how to properly backup innodb databases and repair/recovery of corrupted innodb tables and proper handling of innodb shared table space (ibdata1).

Average joe ain't up to speed on innodb vs myisam differences, so enabling 5.5 to default to innodb storage engine may get messy. Safer method would be to set mysql 5.5 to default to myisam via my.cnf options above. And let those that understand innodb enable it themselves.

---

This is a very true point.

+1 from me. I see no immediate need today but I don't think that should limit what we offer our customers.

MySQL 5.5.15 Released

MySQL :: MySQL 5.5 Reference Manual :: D.1.2 Changes in MySQL 5.5.15 (28 July 2011)

I don't understand the differences technically speaking, but I know I use myisam and i've read all the posts here, and I agree with eva200. This sounds bad for all the sites I manage, but at the same time I want to upgrade (for other reasons)... +()

Quote:

---

Originally Posted by friedmayofan

I don't understand the differences technically speaking, but I know I use myisam and i've read all the posts here, and I agree with eva200. This sounds bad for all the sites I manage, but at the same time I want to upgrade (for other reasons)... +()

---

well it ain't that bad, just BEFORE/AFTER you upgrade to MySQL 5.5 via WHM, put in your my.cnf these 3 lines to disable innodb and default to myisam for MySQL 5.5

Quote:

---

skip-innodb
default-storage-engine = MyISAM
sql-mode = NO_ENGINE_SUBSTITUTION

---

Per your feedback we altered our implementation of MySQL 5.5. to default to MyISAM rather than InnoDB.

Quote:

---

Originally Posted by cpanelkenneth

Per your feedback we altered our implementation of MySQL 5.5. to default to MyISAM rather than InnoDB.

---

Thank you very much for this wise move!

You're welcome. Thank you for the feedback. We actually made the change some time ago, I simply forgot to update the thread :)

Quote:

---

Originally Posted by cpanelkenneth

Per your feedback we altered our implementation of MySQL 5.5. to default to MyISAM rather than InnoDB.

---

Awesome thanks for listening - have saved alot of potential headaches for unsuspecting folks :)

Quote:

---

Originally Posted by cpanelkenneth

This is unknown. An uneducated guess is that version 11.32 would be promoted to the RELEASE tier sometime mid-August.

---

Now is Setember. ETA for 11.32 RELEASE?

Quote:

---

Originally Posted by asturmas

Now is Setember. ETA for 11.32 RELEASE?

---

Sometime in 2011, hopefully.

eva200,
Thanks for the info! Just when i read it I saw that they made the change anyway! Thanks for helping me, and everyone deal with that! Now I feel a little safer upgrading for my clients' CMS's.

Have you guys hired any Duke Nukem Forever developers by any chance?

Quote:

---

Originally Posted by DjiXas

Have you guys hired any Duke Nukem Forever developers by any chance?

---

HA HA that made me chuckle.

MySQL 5.5.16 Released

MySQL :: MySQL 5.5 Reference Manual :: D.1.1 Changes in MySQL 5.5.16 (15 September 2011)