MySQL 5.5

drtech · Post by **drtech** » Sat Feb 26, 2011 4:13 pm

Anyone using MySQL 5.5 yet? I am having trouble with MySQL 5.1 running out of resources and now current Ubuntu has phased out v 5.0, so I am trying out 5.5 tonight on a test server to see what happens.

Current windows version supported by OpenDental is MySQL 5.0, so this is certainly an upgrade, but according to Oracle, the speed performance is quite impressive with 5.5...we shall see...

drtech · Post by **drtech** » Sat Feb 26, 2011 4:43 pm

most things work fine with V5.5...I was running and testing all sorts of functions...finally came across database maint that is incompatible with MySQL 5.5. So..for now, that nixes using that...

drtech · Post by **drtech** » Sun Feb 27, 2011 3:17 pm

Jordan, any testing and plans to move to 5.5? Are the speed improvements anything you think would improve OD performance?

MySQL 5.0 is no longer even supported by Oracle, therefore I can't even install it easily on linux because it has been depreciated...so I think it would be a good idea to get it up and running on a new version for windows too since it is technically out of date as of May 2010.

http://dev.mysql.com/doc/refman/5.0/en/news-5-0-91.html

drtech · Post by **drtech** » Mon Feb 28, 2011 4:52 am

Any thoughts?

drtech · Post by **drtech** » Thu Mar 03, 2011 10:03 am

I am working well now with MySQL 5.1 now on my server after increasing the open file limit... but the question still is....what about MySQL 5.5? It is supposed to be faster, is that something we will see in the near future?

Roy Bloom · Post by **Roy Bloom** » Thu Mar 03, 2011 2:48 pm

drtech wrote:I am working well now with MySQL 5.1 now on my server after increasing the open file limit... but the question still is....what about MySQL 5.5? It is supposed to be faster, is that something we will see in the near future?

Are you supposed to download the 32 or 64 bit version? I am running win7pro 64bit but still have programs that are running at 32 bit.

drtech · Post by **drtech** » Thu Mar 03, 2011 4:26 pm

If you are running windows, just stay with the MySQL 5.0 version would be my opinion, I am only "forced" to run v 5.1 because 5.0 is no longer supported and maintained as a viable package in modern linux distributions as it is so old.

But if you wanted to download 5.1 and you have 64 bit windows, then the 64 bit would be the way to go. You can't use 5.5 yet for mainstream because some of Open Dental would have to be modified to keep up with the changes. Example, currently it crashes in database maintenance when using MySQL 5.5.

drtech · Post by **drtech** » Tue Mar 08, 2011 6:47 pm

from: http://70.90.133.65:1942/ODBugTracker/P ... sions.aspx

"Various MySQL errors such as "can't open file .frm" and "out of resources". In response, we are moving to a newer version of MySQL."

YES! Thank you!

Post by **jordansparks** » Wed Mar 09, 2011 7:14 pm

Yes, working hard on mysql 5.5.9.

enamelrod · Post by **enamelrod** » Thu Mar 24, 2011 1:51 pm

so is it yes it works with linux 5.5 mysql or no stay on 5.0

drtech · Post by **drtech** » Thu Mar 24, 2011 4:17 pm

Ubuntu still does not have a .deb package. If you run Readhad/OpenSuse, etc then there are RPM packages ready to run.

I almost have a 5.5. deb package made...just haven't had time to see if it is going to work.

drtech · Post by **drtech** » Wed Jul 27, 2011 3:52 pm

I got it to work on Ubuntu!

Installed MySQL 5.5.14

http://www.smilecouple.org/2011/07/25/h ... -on-ubuntu

Post by **jordansparks** » Fri Aug 05, 2011 4:10 pm

My goodness. You are very persistent.

tmv2 · Post by **tmv2** » Sat Aug 06, 2011 1:26 pm

Why not download the .tar ball from MySQL site and install it? I'm still on Ubuntu 8.04.4 from 4 years ago. I have different versions of MySQL on the same Ubuntu to test. All I need to do is change a soft-link to tell Ubuntu which version of MySQL to run.

drtech · Post by **drtech** » Sat Aug 06, 2011 4:43 pm

I could not get it to install from the tar ball ( I really don't know how to manually install things in linux if I don't have a script to run)

wjstarck · Post by **wjstarck** » Mon Aug 08, 2011 10:04 am

Hmmm...shouldn't be too hard.

Here's a nice link --> http://dev.mysql.com/doc/refman/5.1/en/ ... ation.html

I know what you mean though.

.deb installers for Ubuntu have made me really lazy

drtech · Post by **drtech** » Tue Aug 09, 2011 3:02 am

Thanks, I tired the manual install from the MySQL website a while back, and was having problems....but I am sure I just wasn't doing something right (obviously :p)

Yes, Jordan...you know 1% inspiration and 99% perspiration.

Open Dental

MySQL 5.5

MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5

Re: MySQL 5.5