Re: flush and flush delay

Right, MySQL would be configured so that the data directory is on the RAM disk. On power-up you would recreate the RAM disk, fill it with the last backup from the flashdisk, then start mysqld. You would, of course, lose everything since the last backup, but you said that was OK for your app.

flush and flush delay

Hello, I am using a MySQL database for a somewhat odd application. In this application I will have relatively small tables and relatively few tables. I would like to set the variables so that all the operations on the database takes place in RAM and that it does not write to disk unless

Re: flush and flush delay

Those 2 variables are explained in the manual http://dev.mysql.com/doc/mysql/en/Server_system_variables.html. flush This is ON if you have started mysqld with the --flush option. This variable was added in MySQL 3.22.9. flush_time If this is set to a non-zero value, all tables

Re: flush and flush delay

Thanks for this. Very useful. In particular your idea of using a RAM disk sounds interesting but I am not sure how you imagine I use it? I presume that on power down everythign on a ramdisk is lost so on every power=up I would have to put my data directory on the RAM-disk while the settings in