1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Reduce temporary tables

Discussion in 'Server Configuration and Hosting' started by FabioCesar, Mar 26, 2013.

  1. FabioCesar

    FabioCesar Member

    after many tests to find the optimal setting, I reached the current my.cnf
    after many tests to find the optimal setting, I reached the current my.cnf
    The server has 8GB of Ram, running nginx and php-fpm with no admin panel .. tableas are MyIsam..
    Any suggestions to reduce the number of temporary tables?
     
  2. hellreturn

    hellreturn Active Member

    read_buffer_size = 2M
    join_buffer_size = 4M
    key_buffer_size = 256M

    Try those and see how it goes.
     
  3. FabioCesar

    FabioCesar Member

    same thing ...

    Got a considerable reduction changing the engine of the tables:
    xf_attachment_view, xf_thread_view, xf_session_activity
     
  4. shawn

    shawn Well-Known Member

    Why are you not using innodb?
     
  5. FabioCesar

    FabioCesar Member

    all tables are innodb
     

Share This Page