XxUnkn0wnxX
Active member
i recently had issues like to many max user connections, i hopefully fixed that in the my.cnf file on my sever
This all i can provide/allow for the public to see of the current server Statistics:
I am using CentOS Linux Operating system, and it is a managed server wont tell u what panel i am using though..
4 GB High Performance RAM and around 800gb storage
Intel Xeon Dual Core, 2.3GHz (4 threads)
10 TB Bandwidth
now i am still learning about systems admin but i am not sure how i can get the full potential out of my dedicated server i am renting.
is there any other tweaks i can do in the my.cnf file? or php.ini file?
i just want to make my xenforo site to process information quicker, load faster, process templates faster, process overall all information faster and serve them quicker.
this what i have now in my.cnf:
This all i can provide/allow for the public to see of the current server Statistics:
I am using CentOS Linux Operating system, and it is a managed server wont tell u what panel i am using though..
4 GB High Performance RAM and around 800gb storage
Intel Xeon Dual Core, 2.3GHz (4 threads)
10 TB Bandwidth
now i am still learning about systems admin but i am not sure how i can get the full potential out of my dedicated server i am renting.
is there any other tweaks i can do in the my.cnf file? or php.ini file?
i just want to make my xenforo site to process information quicker, load faster, process templates faster, process overall all information faster and serve them quicker.
this what i have now in my.cnf:
Code:
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
open_files_limit=3072
query_cache_size=200M
max_connections=1000
max_user_connections=300
wait_timeout=60
tmp_table_size=119M
max_heap_table_size=119M
thread_cache_size=128
key_buffer_size=32M
max_allowed_packet=16M
table_cache=868
table_definition_cache=3072
#delayed_insert_timeout=20 # Turn on if max_connections being reached due to delayed inserts
#delayed_queue_size=300 # Turn on if max_connections being reached due to delayed inserts
myisam_sort_buffer_size=2M # can be increased per sessions if needed for alter tables (indexes, repair)
#query_cache_limit=2M # leave at default unless there is a good reason
#join_buffer=2M # leave at default unless there is a good reason
#sort_buffer_size=2M # leave at default unless there is a good reason
#read_rnd_buffer_size=256K # leave at default unless there is a good reason
#read_buffer_size=2M # leave at default unless there is a good reason
collation_server=utf8_unicode_ci
character_set_server=utf8
#general_log=1
slow_query_log=1
log-output=TABLE # select * from mysql.general_log order by event_time desc limit 10;
long_query_time=5 # select * from mysql.slow_log order by start_time desc limit 10;
innodb_file_per_table=1
innodb_flush_method=O_DIRECT
innodb_buffer_pool_size=265 # check mysql -e "SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';" - free vs total
innodb_additional_mem_pool_size=30M
innodb_log_buffer_size=29M
innodb_thread_concurrency=4 # Number of physical + virtual CPU's, preset when server is provisioned to have correct # of cores