Portal Home > Knowledgebase > Articles Database > MYSQL 5.5
MYSQL 5.5
| Posted by brentpresley, 01-02-2011, 02:24 PM |
| Noticing that this was finalized about 2 weeks ago.
http://dev.mysql.com/tech-resources/...-mysql-55.html
Sun and the community in general are claiming large performance improvements from the database, much of it due to better multi-threaded coding and tweaking of the algorithms used for queries.
Has anyone deployed or tested version 5.5?
If so, do you have an performance data compared to the 5.1 stable releases?
Any installation issues or configuration problems you ran into?
|
| Posted by instantIT, 01-02-2011, 02:25 PM |
| Nope so far.
Afraid of getting unknown bugs and problems. We will request our RnD team to check it out.
|
| Posted by n3r0x, 01-02-2011, 04:56 PM |
| A friend tested it on a server running a larger torrentsite, it improved their load with alot.. from almost constantly using 50% cpu to around 10%. however since i don´t know the specs of his server i can´t say if this is a huge improvement.. but then again no mather the system 40% cpu usage drop should be a good thing.
As for bugs.. Remains to be seen, i won´t upgrade until it have been tested out. or i got time to simulate a test, (a few million inserts/updates/selects) and so on.
|
| Posted by webspark, 01-02-2011, 06:15 PM |
| Hi,
thanks for the heads up I wasn't aware that a new version was available, I'll give it a whirl over the next week or so and let you know what I find.
I wouldn't use it in a production environment right away though, I'd let some other people be the test subjects for a few months.
Thanks,
Mark
|
| Posted by petteyg359, 01-02-2011, 06:29 PM |
| 5.5 has been tested by various people for over a year already
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-x.html
|
| Posted by brentpresley, 01-02-2011, 06:32 PM |
| Yes, betas and RCs have been out a long time, however there are so many and varied distros out there, and everyone's server is setup and tweaked differently, that the questions I originally posted are still valid.
For example, cPanel forum users are posting some issues with the upgrade, while DirectAdmin forum users have had no reported problems. This is valuable to us, since we run servers with both (and Plesk, which I haven't even gotten to look at yet).
|
| Posted by Steven, 01-02-2011, 06:47 PM |
| We are using it on a few sites and getting really nice performance boosts with tuning.
|
| Posted by brentpresley, 01-02-2011, 06:52 PM |
| Can you give us some more details?
Server config, installation issues, website incompatibilities?
EDIT - what tuning was required on your sites?
|
| Posted by Steven, 01-02-2011, 06:56 PM |
| I dumped all the databases, Upgraded, Restored databases. I have upgraded from 5.1 directly and ran mysql_upgrade etc, but I find a fresh install to be less problematic - better in the long run.
So far the scripts have worked out of the box (drupal,wordpress,vbulletin). The tuning required was in my.cnf. I retune every time there is an upgrade.
|
| Posted by brentpresley, 01-02-2011, 06:57 PM |
| Thanks for the info.
|
| Posted by petteyg359, 01-02-2011, 07:18 PM |
| I agree that it could use a few more months, especially now that it will actually get "real" testing as a GA release. cPanel problems, however, are most likely cPanel problems. If somebody locks themselves into cPanel's horrible setup system... Heck, the cPanel people couldn't even figure out 5.1 a year after GA release.
|
| Posted by Steven, 01-02-2011, 07:42 PM |
| Cpanel has changed alot since the 5.1 initial attempt.
|
| Posted by M Bacon, 01-03-2011, 04:33 PM |
| cPanel still has 5.1.51
They are a bit out of date.
|
| Posted by iTom, 01-03-2011, 06:00 PM |
| Looks to offer some good performance improvements.
Going to do some testing my self soon, want to see its RAM usage while doing nothing or very little.
Might be an improvement for some of my "lowend" VM's where resources are minimal
|
| Posted by brentpresley, 01-05-2011, 01:48 PM |
| Been doing some internal testing with this for the past few days and it is looking good. No compatibility problems so far. RAM usage by mysql is down 10-15%, CPU usage is down 30%+ or more, and the disks are not getting hammered on requests.
So far, so good.
|
| Posted by tacos912, 01-06-2011, 05:35 PM |
| I haven't tested it yet because I'm waiting until they nail the bugs out of it and whatnot. From what I hear it really does improve performance quit a bit!
|
Add to Favourites 
Print this Article
Also Read
