What are the simplest ways to prevent mysql write (bad queries?) data to disk (write to RAM? or no write?) without changing mysql database structure? Why im asking this? Because i do not own hosted mysql databases. moreover i already tunned mysql values in my.cnf according to two mysql tunning scripts and they appears quite optimal. Ways to prevent mysql data writing to disk?
Lots of actual RAM is important. We try to run a minimum of 32Gb in our production servers. Use Innodb instead of Myisam and make sure you have a large innodb_buffer_pool_size is the best way to prevent arbitrary disk writes. You can also use memory type tables in certain circumstances such as session management, but typically these aren't the usage that's going to cause problems in the first place.