1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

any good tweaks to make php and MySQL preform better?

Discussion in 'General PHP and MySQL Discussions' started by XxUnkn0wnxX, Dec 14, 2013.

  1. XxUnkn0wnxX

    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:
    [​IMG]
    [​IMG]

    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
     

Share This Page