1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MYSQL Upgrade 3.23 -> 4.1 - 5.0?

Discussion in 'Plesk for Linux - 8.x and Older' started by thilo, Mar 14, 2006.

  1. thilo

    thilo Guest

    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 Guest

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

    thilo Guest

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

    Highland Guest

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