Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #
- #memory cache for bulk inserts the more the faster
- #
- bulk_insert_buffer_size = 1024M
- #
- #the more the merrier
- #
- key_buffer_size = 16048M
- #
- myisam_sort_buffer_size = 4024M
- #
- #both below must match or heap size will win even if its lower
- #
- tmp_table_size = 4048M
- #
- max_heap_table_size = 4048M
- #
- #other not so important stuff
- #
- max_allowed_packet = 64M
- #
- table_open_cache = 256
- #
- sort_buffer_size = 256M
- #
- read_buffer_size = 256M
- #
- read_rnd_buffer_size = 256M
- #
- thread_cache_size = 16
- #
- query_cache_size= 256M
- #
- #cpus * 2 is a good one here
- #
- thread_concurrency = 6
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement