T
thilo
Guest
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:
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
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:
Code:
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
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