Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook Tuesday at 01:29 PM
AlexJ Posted March 5, 2019 Share Posted March 5, 2019 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 More sharing options...
Norbee. Posted March 10, 2019 Share Posted March 10, 2019 If you have lot of database then te best if you give the mysql more ram. Link to comment Share on other sites More sharing options...
AlexJ Posted March 10, 2019 Author Share Posted March 10, 2019 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? Link to comment Share on other sites More sharing options...
bfarber Posted March 11, 2019 Share Posted March 11, 2019 https://www.speedemy.com/how-to-speed-up-mysql-restart/ You might want to review this Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.