Good afternoon folks,
I have a problem when trying to load the indexes from the MyISAM tables into MySQL memory, even though there is space available in the key_buffer_size variable, it stops loading even though there are still indexes to be loaded.
Has anyone had this problem or know what I can do to solve it?
The server that is running the database is a windows server 2012 (¯_(ツ)_/¯ - and don't want to switch to linux server), MySQL is version 5.5.62 and in this instance I have 1210 databases with the structure of the tables in MyISAM.
Below is the configuration file (my.ini):
[mysqld] port=3306 basedir="C:/Program Files/MySQL/MySQL Server 5.5/" datadir="D:/MySQL/Data/" character-set-server=latin1 default-storage-engine=myisam sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=4500 query_cache_size=48M query_cache_type=1 tmp_table_size = 1G max_heap_table_size = 256M thread_cache_size=1300 key_buffer_size=62G read_buffer_size = 200M read_rnd_buffer_size = 100M sort_buffer_size = 1G myisam_sort_buffer_size = 4096M skip-innodb max_allowed_packet=16M interactive_timeout=300 wait_timeout=1700 max_sort_length=4096 max_connect_errors=1000000 table_open_cache=13999 table_definition_cache=4096 log-warnings long_query_time=10 open_files_limit=65535 slow-query-log slow_query_log_file = "D:/MySQL/Data/slowlog.txt" log_output = TABLE connect_timeout=30 net_read_timeout=65 net_write_timeout=65 tmpdir="D:/MySQL/Temp/"
Since there is still a lot of memory available for the cache and most of the scripts are data queries