Announcement

Collapse
No announcement yet.

MySQL optimization for Chat Server(red5)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    ============================================
    A very welcome new user!
    Sig is gone! Please read the sig rules before applying one!

  • #2
    How big is the database? More RAM and 64bit MySQL would probably help performance.

    Comment


    • #3
      I'm no MySql guru, but if that were Oracle, which I don't consider a million miles away, my read/sort/read-rnd buffers would be a bunch larger than that - however I guess that depends what the record / query sizes are..
      Peter Knapp - CCS Leeds Ltd - www.ccsleeds.co.uk
      Coal Road, Leeds. LS14 2AQ / Co. reg: 03507910 / VAT reg: GB 698 2027 05 / Tel: 0113 294 66 99
      UK Leased Lines | Hosted VoIP & SIP Trunks | EFM - Ethernet First Mile
      Free Install and Cisco Router on Fully Managed EFM at up to 20Mb/s only £300 per month

      Comment


      • #4
        those values are per sql connection on mysql i believe, thus if you set them too high your going to fork up your server when you run out of ram?
        Admin for Webhostchat.co.uk

        Comment


        • #5
          mysqltuner.pl

          will give you some clues.

          Also look at tuning apache and other o/s things such as disabling atime on the disks.

          Comment


          • #6
            To the OP, if you are not pretty sure about the mysql optimization, then I would suggest you to try optimizing mysql based on standard optimization techniques .. For eg, you can download the els script from servermonkeys.com which will auto-configure and optimize your mysql configuration. However, like mentioned earlier, it is the standard optimization script which will calculate and configure default values in my.cnf based on server's hardware specification...

            Comment

            Working...
            X