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.

Help with mysql optimization

Discussion in 'Workarounds and Optimization' started by Milan, Aug 30, 2011.

  1. Milan

    Milan Registered

    Joined:
    Jul 13, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Hello i have 1 GB database. (SMF forum)




    Here is my.cnf

    Code:
    query_cache_size = 128M
    join_buffer_size = 1M
    tmp_table_size = 64M
    max_heap_table_size = 64M
    thread_cache_size = 4
    table_cache = 500
    key_buffer_size = 128M
    query_cache_limit=2M
    query_cache_type= 1
    local-infile=0

    I have 1.5 gb ram memory.
     
  2. ES - George

    ES - George Well-Known Member
    PartnerNOC

    Joined:
    Jun 12, 2011
    Messages:
    142
    Likes Received:
    1
    Trophy Points:
    16
    Location:
    UK
    cPanel Access Level:
    Root Administrator
    Does the website get a lot of traffic? I.e. are their many people online at the same time? Or is that 1gb caused by a lot of posts, topics, etc?
     
  3. Milan

    Milan Registered

    Joined:
    Jul 13, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Site gets 7000 unique visits per day.
    300-500 in 30 minutes active users.

    1 gb i caused by a lot of post, topics, members...
     
Loading...

Share This Page