Jump to content

MySQL Taking long time to start and shutdown


Recommended Posts

Stopping and starting MySQL server takes a while. I am not sure what's causing the issue. Server RAM - 32GB.  Was wondering anyone can take a look at it? I have couple of database of 3GB in size.  MySQL version 5.6.29

[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
lc-messages-dir	= /usr/share/mysql
skip-external-locking
skip-name-resolve
explicit_defaults_for_timestamp = 1
character-set-server = utf8
collation_server = utf8_unicode_ci
ft_min_word_len=3
innodb_ft_min_token_size=3

bind-address		= 127.0.0.1

key_buffer_size = 2G
max_allowed_packet	= 64M
#thread_stack = 192K
thread_cache_size   = 128

myisam-recover-options = BACKUP
max_connections = 300

open_files_limit = 8000
table_definition_cache = 4000 
table_open_cache = 4000

tmp_table_size = 256M
max_heap_table_size = 256M

interactive_timeout = 60
connect_timeout = 15
wait_timeout = 60

innodb_buffer_pool_size = 6G
innodb_log_file_size = 768M
innodb_log_buffer_size = 256M
innodb_file_per_table   = 1
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
innodb_additional_mem_pool_size = 8M
innodb_buffer_pool_instances = 6

#Buffer Sizes
sort_buffer_size = 4M 
read_buffer_size = 2M 
read_rnd_buffer_size = 2M 
join_buffer_size = 4M 
myisam_sort_buffer_size = 512M 
low_priority_updates=1
concurrent_insert=2

query_cache_limit = 1M
query_cache_size  = 256M
query_cache_type = 2

log_error = /var/log/mysql/error.log
slow_query_log                  = 1
slow_query_log_file             = /var/log/mysql/slow.log
long_query_time                 = 5

expire_logs_days	= 10
max_binlog_size         = 100M

[mysqldump]
quick
quote-names
max_allowed_packet	= 512M

[mysql]
no-auto-rehash	# faster start of mysql but no tab completition

[isamchk]
key_buffer		= 512M
sort_buffer_size = 384M
read_buffer = 16M
write_buffer = 16M

[myisamchk]
key_buffer = 512M
sort_buffer_size = 384M
read_buffer = 16M
write_buffer = 16M
ft_min_word_len=3

!includedir /etc/mysql/conf.d/

 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...