MySQL 4.0.1

[andethen]

I'm looking to upgrade MySQL to 4.0.1 because I'd really like to take advantage of some of the new features it's offering, and the increased speed. The server I run has about 40 accounts on it, but 35 of them are mine and the others belong to a developer who's very keen on the idea as well. I'm perfectly aware of all of the costs involved with running development software.

Installing it etc. is no problem, but I'm worried about it messing with cpanel. Anyone have any experience with this?

--Matt

 

[bdraco]

Just make sure you install the offical rpms and you shouldn't have a problem

 

[andethen]

Okay I'll try that and keep everyone updated on what happens.

 

[andethen]

Well everything is installed and updated, and seems to be working great. All the queries I tested are running fast, and even faster when it caches them.

One problem: checkservd is restarting mysql *every* 8 minutes or so. Checking mysql error logs there is nothing there but a ton of restart commands. Is there a fix for this?

 

[HOSTFORWEB]

[quote:133c529516][i:133c529516]Originally posted by andethen[/i:133c529516]

Well everything is installed and updated, and seems to be working great. All the queries I tested are running fast, and even faster when it caches them.

One problem: checkservd is restarting mysql *every* 8 minutes or so. Checking mysql error logs there is nothing there but a ton of restart commands. Is there a fix for this?[/quote:133c529516]

Yes we are also running 4.0.1
To fix chkserv do next:
goto /etc/chkserv.d/
and delete &mysql& file
restart chkserv.

Max J.

 

[andethen]

I had tried that, but I simply forgot to restart chkservd. *duh*

Anyway, is there a way to have it actually check MySQL without returning an error?