MYSQL Upgrade 3.23 -> 4.1 - 5.0?

[thilo]

Hi,
i have some trouble with my Server Database. Here some Info`s about the Server Hard & Software:

CPU: Intel P4 CPU 2.80GHz
RAM: 512

Mysql version: 3.23.58
BS: Fedora Core 2 + Plesk 7.5.3

One of my clients is running a huge phpbb forum (180GB Traffic/month) it needs the hole power of the db, in rush hours the db is not reachable (Too Many Connections)
So is started to fix this problem, first read the mysql Manual. I found some Contents for a better performance by editing the my.cnf values
here is what i did:

sort_buffer           current value: 2 097 144 <---- 4M
table_cache           current value: 64 <---- 256 
record_buffer         current value: 131072 <---- 1M 
key_buffer_size       current value:  8 388 600   <---- 32M

the other variables are default

i restart mysql -> after one hour the server performance was horrible, so i set the cnf back to defaults.
A Friend of mine told me I should update MYSQL up to 4.1 / 5.0 to fix this problem.

My Question`s
- Should i upgrade the database up to 4.1 or 5.0?
- If I upgrade mysql, is there a problem with plesk (things to do before?)
- Are there other ways to fix it?

Sorry for the bad english written skills

greets thilo

 

[GARMTECH]

Your version of Plesk supports only MySQL 4.1. There theoretically no problem upgrading.

 

[thilo]

thx for the fast reply -
i think i`ll upgrade mysql up to 4.1 these days

 

[Highland]

Use Yum and ART to upgrade to 4.1 and save yourself some headaches