I have mysql and i use a tmpfs disk that is 768 M. Mysql uses about 70% of the memory. There is about 1170 M available.
If mysql uses ram to the point there is less than 768; will my RAM disk be limited in size?
MySQL tmp and tmpfs disk
MySQL
Related Question
- MySQL – Questions About Using Tmpfs for MySQL Tmp Directory
- MySQL – High CPU Usage Due to ‘Copying to tmp table on disk’ and ‘Converting HEAP to MyISAM’
- MySQL – Handling Queries Larger Than tmpfs (RAM Disk)
- MySQL crash/restart during thesqldump
- MySQL Optimization – Using tmpfs for MariaDB Temporary Tables
- MySQL – How to Make MySQL Faster
- MySQL DBs taking up way too much disk space
- Mysql – Error 1041 “Out Of Memory” after pointing tmpdir to new disk space
Best Answer
In my opinion, the RAM given over to a RAM disk would be better utilized for other caching. If InnoDB, give it to innodb_buffer_pool_size. For MyISAM, give a little to key_buffer_size, leave most for data caching, which the OS does.