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
.MYI
files? How much RAM do you have? Were you using theIGNORE LEAVES
option?