Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted March 5, 20196 yr 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/
March 10, 20196 yr Author 7 hours ago, Norbee. said: If you have lot of database then te best if you give the mysql more ram. It's not even using the RAM, I have allocated to it so how allocating more RAM will make any difference?
March 11, 20196 yr https://www.speedemy.com/how-to-speed-up-mysql-restart/ You might want to review this
Archived
This topic is now archived and is closed to further replies.