Welcome to OMG boards community!
Community of friends where we talk about daily life, offtopic stuff, and what keeps us busy.

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

MySQL optimization for Chat Server(red5)

Discussion in 'Manage your Site' started by ihostman, Oct 22, 2009.

  1. ihostman

    ihostman OMG Member

    Threads:
    1
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    40
    MySQL optimization for Chat Server(red5)

    guys, we are running chat server(red5). servers specs are: Intel Xeon QuadCore SingleProc Sata,

    2GB ram with latest cPanel, apache and mysql...server is running fine with the mysql config, still i

    want to show my mysql config file to you guys so that you can suggest me something more for

    better performance for those chatrooms.

    Here is my my.cnf:
    ============================================
    [mysqld]
    set-variable = max_connections=300
    safe-show-database
    max_user_connection=100
    query_cache_size=256M
    query_cache_limit=32M
    query_cache_type = 1
    max_allowed_packet=16M
    table_cache=1024
    thread_cache_size = 256
    key_buffer_size=64M
    wait_timeout=75
    connect_timeout=50
    interactive_timeout=100
    #slave_net_timeout=35
    tmp_table_size=128M
    read_buffer_size=2M
    sort_buffer_size=2M
    read_rnd_buffer_size=2M
    myisam_sort_buffer_size=128M
    record_buffer=1M
    thread_concurrency=4
    local-infile=0
    ============================================
     
  2. Floris

    Floris I'm just me :) Hi. Staff Member

    Threads:
    10,386
    Messages:
    36,946
    Likes Received:
    587
    Trophy Points:
    855
    Gender:
    Male
    We run a chat network for the wetalk communities.
    You could use that, avoiding the stress on the MySQL.
    We're a bunch of servers, open and free to use, and everybody can have their own channel if needed.

    Check it out, add pjirc.com to your site and point it to irc.vbirc.com on port 6669.
    And either have it join #chat or #yourownchannel.

    For help configuring your own channel feel free to give us a poke.
     
  3. aisloy15

    aisloy15 OMG Member

    Threads:
    0
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    35
    I like your discussion.Thank you very much.
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice