Increase performance settings for streaming server?

siidsidou

Member
Dec 21, 2017
6
0
1
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
 
Last edited by a moderator:

LucasRolff

Well-Known Member
Community Guide Contributor
May 27, 2013
143
88
78
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.
 

siidsidou

Member
Dec 21, 2017
6
0
1
algeria
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.
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 ?
 

LucasRolff

Well-Known Member
Community Guide Contributor
May 27, 2013
143
88
78
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 ?
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.
 
  • Like
Reactions: cPanelMichael

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
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.