We're running MariaDB version 10. To speed up queries we have set up
tmpdir to be RAMDISK with size of 35GB.
The challenge we have is that from time to time (like once or twice a week) MariaDB fills the
tmpdir, after which the whole system freezes up till we have to stop MariaDB, unmount the
tmpdir and remount.
tmpdir was 15GB we have been increasing it over time with hope that more space will prevent MariaDB filling up the
tmpdir but we realize it's not ending. We could still expand
tmpdir but we don't have unlimited RAM and are not sure how much will be enough.
At this time we're wondering whether there's a way to prevent MariaDB from filling up
tmpdir? The alternative is to move
tmpdir to disk but this is a route we're avoiding since it would present a performance nightmare.
query_cache_size = 0
delayed_insert_timeout=20 # Turn on if max_connections being reached due to delayed inserts
delayed_queue_size=300 # Turn on if max_connections being reached due to delayed inserts
myisam_sort_buffer_size=512M # can be increased per sessions if needed for alter tables (indexes, repair)
query_cache_limit=32M # leave at default unless there is a good reason
read_rnd_buffer_size=16M # leave at default unless there is a good reason
log-output=TABLE # select * from mysql.general_log order by event_time desc limit 10;
innodb_thread_concurrency=8 # Number of physical + virtual CPU's, preset when server is provisioned to have correct # of cores
innodb_doublewrite = 0
innodb-flush-log-at-trx-commit = 2