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

Where to change mySQL variables for client databases.

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by dschmid, May 9, 2012.

  1. dschmid

    dschmid Guest

    Hi, I'm running plesk with 25 wordpress sites on it. And the biggest site is now making problems. Checking the phpmyadmin runtime information suggested me (Watch this picture: http://screencast.com/t/s4y2sIYz4L1 ) to change some mysql variables like tmp_table_size and table_cache.

    So I logged in through ssh and changed some variables in the /etc/mysql/my.cnf file and restarted mysql. ( I don't have a /etc/my.cnf file)

    So far so good, but as you can see on this picture http://screencast.com/t/Lhs0UlkkjR that the "global" variables are changed but not for my clients site.

    Is there a specific configuration file for client databases. I searched now for over 2 hours but did not find a solution.

    Thanks, for any help.