Recently I've need to do some table repair and got into my variables and noticed some bizzare numbers. For those of you that know MySQL, these may be familiar to you, so I'll just list the variables and values:
max_join_size: 18446744073709551615
max_seeks_for_key: 18446744073709551615
max_write_lock_count: 18446744073709551615
myisam_max_sort_file_size: 9223372036853727232
myisam_mmap_size: 18446744073709551615
The value I'm most interested in is the sort file size, because I need to repair a MYISAM table. however, my drive is NOT that large! Is this normal to have such high numbers? From what I'm reading the "default" max file size should be 2GB, not like 9 exabytes!
Does this make sense to anyone? Should I change these values?
Thanks