Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Increase performance settings for streaming server?

Discussion in 'Workarounds and Optimization' started by siidsidou, Nov 4, 2018.

  1. siidsidou

    siidsidou Member

    Joined:
    Dec 21, 2017
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    algeria
    cPanel Access Level:
    Root Administrator
    hi guys im looking for help i have 3 website streaming music so I Need best performance setting for easyapcha 4 because they start become a little bit slow so i need good cong of (module,extesnion etc.) and im using MySQL 5.7 and nginx my configuration
    Dual Intel Xeon Processor X5675 24 core
    Ram 16gb
    Bandwidth Usage 1Gbps Unmetered and this is my
    • Edit my.cnf

    Code:
    # For advice on how to change settings please see
    # [URL]http://dev.mysql.com/…/en/server-configuration-defaults.html[/URL]
    
    [mysqld]
    performance-schema=0
    #
    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M
    #
    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin
    #
    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    performance-schema=0
    # Disabling symbolic-links is recommended to prevent assorted security risks
    symbolic-links=0
    
    performance-schema=0
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    innodb_file_per_table=1
    default-storage-engine=MyISAM
    open_files_limit=20000
    max_connections = 50
    max_user_connections=150
    key_buffer_size = 28M
    myisam_sort_buffer_size = 28M
    read_buffer_size = 1M
    table_open_cache = 3000
    thread_cache_size = 384
    wait_timeout = 20
    connect_timeout = 10
    tmp_table_size = 64M
    max_heap_table_size = 64M
    max_allowed_packet=268435456
    net_buffer_length = 1638
    max_connect_errors = 10
    concurrent_insert = 2
    read_rnd_buffer_size = 78643
    bulk_insert_buffer_size = 8M
    query_cache_limit = 5M
    query_cache_size = 64M
    query_cache_type = 1
    query_prealloc_size = 262144
    query_alloc_block_size = 65535
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    max_write_lock_count = 8
    slow_query_log
    log-error
    
    
     
    #1 siidsidou, Nov 4, 2018
    Last edited by a moderator: Nov 4, 2018
  2. LucasRolff

    LucasRolff Well-Known Member

    Joined:
    May 27, 2013
    Messages:
    64
    Likes Received:
    49
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Your streaming performance has nothing to do with your MySQL settings, it's depending on your webserver settings.

    Your MySQL configuration should be changed depending on your MySQL workload, and only you know this one.
     
  3. siidsidou

    siidsidou Member

    Joined:
    Dec 21, 2017
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    algeria
    cPanel Access Level:
    Root Administrator
    so what shoud do now because all my server It became slow after too much consumption of network speed about 500-600 mbit(s should upgrad network speed to 2gbps ?
     
  4. LucasRolff

    LucasRolff Well-Known Member

    Joined:
    May 27, 2013
    Messages:
    64
    Likes Received:
    49
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    You should optimize what makes sense, possibly even use a CDN that is specialized in what you want to do.

    Your server needs to surely have the connectivity that you require, you don't need a lot of hardware to be able to serve 10-15gbps of traffic if you're using the right web server (LiteSpeed or nginx), and the correct settings of those web servers as well.

    Understand exactly what you're trying to deliver, and then optimize your web server configuration based on those requirements. If you're serving HLS chunks, then optimize your configs based on that, if you're serving very small files, optimize for that, if you're serving long mp4 files, you have to optimize for that.
     
    cPanelMichael likes this.
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,555
    Likes Received:
    2,182
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @siidsidou,

    You may also need to consider reaching out to a system administration service provider that specializes in optimization/performance. You can find a list of companies offering system admin services at:

    System Administration Services | cPanel Forums

    Thank you.
     
Loading...

Share This Page

  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