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 explicily given a command to do so. Both on select and update operations which will be what most operations will consist of. the reason for this is firstly speed but almost more importantly I am using flashdisk which has a limited life (baout 2000000) write actions and my application will performing update operations on a single entry at anything up to 1000 times per second. It is absolutely not critical should I lose the values in case of a powerdown. In fact it would suffice to not use the tables on the disk at all except to provide default values. From the documentation I gathered that MySQL refers to writing to disk as a flush operation. Doing a SHOW VARIABLES reveals that there are variables called flush OFF flush_delay 0 Since I have made no modifications yet these are default values. I must misunderstandign something because this would imply that automatic writing to disk is already inhibited and that seems unlikely. My question is thus whether and if yes how i can control (minimize at least) the writing to disk. Also given the smallness of my tables what would be the best way of setting up the database (what table type?) for maximum performance? Thanks for any help. Regards, Roland. -- -"I have not failed. I've just found 10,000 ways that won't work." -(Thomas Alva Edison 1847-1931) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
