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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

my.cnf and mysql auto shutdown

Discussion in 'Workarounds and Optimization' started by sa3dy, Nov 10, 2017.

  1. sa3dy

    sa3dy Registered

    Joined:
    Oct 20, 2017
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Egypt
    cPanel Access Level:
    Root Administrator
    I have a very busy website in this server:

    12 Cores E5-1650 v3 @ 3.50GHz
    128GB RAM

    MySQL 5.6
    CentOS 7.4


    /var/lib/mysql/.com.err

    Code:
    2017-11-10 17:10:24 27901 [Note] Giving 1 client threads a chance to die gracefully
    2017-11-10 17:10:24 27901 [Note] Event Scheduler: Purging the queue. 0 events
    2017-11-10 17:10:24 27901 [Note] Shutting down slave threads
    2017-11-10 17:10:26 27901 [Note] Forcefully disconnecting 0 remaining clients
    2017-11-10 17:10:26 27901 [Note] Binlog end
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'partition'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_METRICS'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_CMP'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_LOCKS'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'INNODB_TRX'
    2017-11-10 17:10:26 27901 [Note] Shutting down plugin 'InnoDB'
    2017-11-10 17:10:26 27901 [Note] InnoDB: FTS optimize thread exiting.
    2017-11-10 17:10:26 27901 [Note] InnoDB: Starting shutdown...
    2017-11-10 17:10:28 27901 [Note] InnoDB: Shutdown completed; log sequence number 6041482
    2017-11-10 17:10:28 27901 [Note] Shutting down plugin 'BLACKHOLE'
    2017-11-10 17:10:28 27901 [Note] Shutting down plugin 'ARCHIVE'
    2017-11-10 17:10:28 27901 [Note] Shutting down plugin 'MRG_MYISAM'
    2017-11-10 17:10:28 27901 [Note] Shutting down plugin 'MyISAM'
    2017-11-10 17:10:28 27901 [Note] Shutting down plugin 'MEMORY'
    2017-11-10 17:10:28 27901 [Note] Shutting down plugin 'CSV'
    2017-11-10 17:10:28 27901 [Note] Shutting down plugin 'sha256_password'
    2017-11-10 17:10:28 27901 [Note] Shutting down plugin 'mysql_old_password'
    2017-11-10 17:10:28 27901 [Note] Shutting down plugin 'mysql_native_password'
    2017-11-10 17:10:28 27901 [Note] Shutting down plugin 'binlog'
    2017-11-10 17:10:28 27901 [Note] /usr/sbin/mysqld: Shutdown complete
    I have this my.cnf config:

    Code:
    [mysqld]
    performance-schema=0
    local-infile=0
    skip-external-locking
    skip-networking
    default-storage-engine = innodb
    innodb_buffer_pool_size = 256M
    innodb_file_per_table = 1
    #innodb_file_format = Barracuda
    innodb_flush_log_at_trx_commit = 2
    innodb_log_buffer_size = 40M
    innodb_log_file_size = 32M
    #innodb_additional_mem_pool_size = 200M
    innodb_thread_concurrency = 8
    innodb_buffer_pool_instances=1
    long_query_time         = 1
    slow_query_log=OFF
    #log_slow_queries=OFF
    local-infile=0
    max_connect_errors=20
    max_connections=1500
    table_open_cache=250
    max_user_connections=400
    max_allowed_packet=524288000
    max_error_count=64
    max_sort_length=1024
    interactive_timeout=30
    wait_timeout=10
    connect_timeout=15
    query_cache_limit=10M
    query_cache_size=0
    tmp_table_size=128M
    max_heap_table_size=256M
    bind-address=127.0.0.1
    query_cache_type= OFF
    key_buffer_size=1024M   ## depends on your Indexes size, default 1024M
    key_buffer=3072M
    sort_buffer_size=24M
    read_buffer_size=24M
    read_rnd_buffer_size=24M
    thread_cache_size=2045
    thread_concurrency=16
    myisam_sort_buffer_size=24M
    
    performance-schema=0
    
    performance-schema=0
    open_files_limit=41000
    [mysqldump]
    quick
    max_allowed_packet=2048M
    Any idea or recommendations please?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    41,516
    Likes Received:
    1,616
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page