Updatin/Upgrading MySql
Is there any step-by-step tutorial on how to update/upgrade MySql server?
I currently have version 5.1.41-3ubuntu12.10 and have some issues with it, and I was told that I need to upgrade to a newer/latest version of MySql.
I'm on Ubuntu 10.04.
Any help will be appreciate.
Thanks
13 Replies
What sort of problem are you having? It's a particularly bad idea to not use your distro's standard version unless you absolutely can't avoid it (and can't hold out until Ubuntu 12.04 LTS comes out in a few months).
Anyway, I've upgraded to Ubuntu 11.10, and increased the value of tabledefinitioncache from 256 to 1024. I don't know if there is side effects or whether that is good or bad for performance (if you have some suggestion or notices please let me know), but that seems to solve the problem for now.
@XO39:
I've upgraded to Ubuntu 11.10
That will probably solve the problem. The thread you linked to suggests that the error has something to do with "older versions of the client library", which is more about PHP than it is about MySQL. Upgrading would allow you to take advantage of newer PHP features. Yeah, 10.04 is getting a little long in the tooth.
@hybinet:
@XO39:I've upgraded to Ubuntu 11.10
That will probably solve the problem. The thread you linked to suggests that the error has something to do with "older versions of the client library", which is more about PHP than it is about MySQL. Upgrading would allow you to take advantage of newer PHP features. Yeah, 10.04 is getting a little long in the tooth.
Even after upgrading to 11.10, the problem was still there. It went away only after I increased the value of tabledefinitioncache from 256 to 1024.
By the way, does updating the client library is the same as updating PHP to a newer version?
I've searched for updating library and couldn't anything about that and thought it means updating PHP, am I correct?
In Debian and Ubuntu your libmysqlclient is usually the same version as the mysql server, unless you installed newer mysql server from the backports.
So in general, the way to upgrade your client library is to upgrade your distribution.
@XO39:
By the way, does updating the client library is the same as updating PHP to a newer version?
@rsk:It means updating your libmysqlclient, and if switching major versions, rebuilding PHP to use the new version.
Things are a bit more complicated nowadays, because PHP has been gradually switching to mysqlnd.
So in your case, upgrade + tabledefinitioncache seems to have done the trick. I still have difficulty understanding why ZenForo would want to modify table definitions in the middle of executing prepared statements, but hey, PHP CMS's tend to do weird things.
@rsk:
It means updating your libmysqlclient, and if switching major versions, rebuilding PHP to use the new version.
In Debian and Ubuntu your libmysqlclient is usually the same version as the mysql server, unless you installed newer mysql server from the backports.
So in general, the way to upgrade your client library is to upgrade your distribution.
OK, thanks.
@hybinet:
@XO39:By the way, does updating the client library is the same as updating PHP to a newer version?
@rsk:It means updating your libmysqlclient, and if switching major versions, rebuilding PHP to use the new version.
Things are a bit more complicated nowadays, because PHP has been gradually switching to mysqlnd.
So in your case, upgrade + tabledefinitioncache seems to have done the trick. I still have difficulty understanding why ZenForo would want to modify table definitions in the middle of executing prepared statements, but hey, PHP CMS's tend to do weird things.
I'm not sure why, but they said they approach database access in a different way, and they totally depends on Zend Framework.
@XO39:
I'm not sure why, but they said they approach database access in a different way, and they totally depends on Zend Framework.
>approach database access in a different way
… I think my brain segv'd upon reading that… that's the marketing way to say "we do weird things no one sane should and make the database look like autoportrait of drunk Cthulhu", right?
@hoopycat:
I flew single engine databases in the Net Force, but this database has four engines. It's an entirely different kind of flying, altogether.
Tom Clancy on the Airplane! ?
…hey, I think I've just accidentally made a reference to yet another movie…
@hoopycat:
I flew single engine databases in the Net Force, but this database has four engines. It's an entirely different kind of flying, altogether.
It's an entirely different kind of flying.
@Guspaz:
@hoopycat:I flew single engine databases in the Net Force, but this database has four engines. It's an entirely different kind of flying, altogether.
It's an entirely different kind of flying.
![](http://img51.imageshack.us/img51/5130/e … kindof.jpg">http://img51.imageshack.us/img51/5130/entirelydifferentkindof.jpg " />