Hi,

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

That is the latest version available for Ubuntu 10.04.

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).

_________________

/* TODO: need to add signature to posts */

Here is a similar error to mine, except it didn't happen when installed, but it happens in every page of my site:

http://xenforo.com/community/threads/er ... all.17901/

Anyway, I've upgraded to Ubuntu 11.10, and increased the value of table_definition_cache 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.

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 table_definition_cache 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?

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.

_________________
rsk, providing useless advice on the Internet since 2005.

Things are a bit more complicated nowadays, because PHP has been gradually switching to mysqlnd.

So in your case, upgrade + table_definition_cache 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.

OK, thanks.




I'm not sure why, but they said they approach database access in a different way, and they totally depends on Zend Framework.

... 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?

_________________
rsk, providing useless advice on the Internet since 2005.

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...

_________________
rsk, providing useless advice on the Internet since 2005.

It's an entirely different kind of flying.

I once knew a guy named Ted, with a drinking problem...

_________________
rsk, providing useless advice on the Internet since 2005.