The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Who can i Fully optimize Mysql in CPU X3440 | 8 GIG Ram for Shared-Hosting ?

Discussion in 'Workarounds and Optimization' started by polkocholo, Aug 26, 2011.

  1. polkocholo

    polkocholo Active Member

    Joined:
    Nov 22, 2010
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    Who can i Fully optimize Mysql in CPU X3440 | 8 GIG Ram for Shared-Hosting ?

    This is body of /etc/my.cnf:

    Code:
    [mysqld]
    set-variable = max_connections=500
    log-slow-queries
    safe-show-database
    local-infile=0
    query_cache_size =8M
    join_buffer_size=25 
    tmp_table_size=32M
    max_heap_table_size=16M
    thread_cache_size=4
    table_cache=64
    set-variable = max_allowed_packet=32M
    innodb_buffer_pool_size=33M

    in My server +300 Domanis account

    Wordpress
    Joolma
    PHPNuke
    Vbulletin
    PHPBB
    MyBB
    SMF
    and ...
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,467
    Likes Received:
    196
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
Loading...

Share This Page