1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Ways to prevent mysql data writing to disk

Discussion in 'MySQL' started by postcd, May 30, 2014.

0
  1. #1
    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?
     
    postcd, May 30, 2014 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    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.
     
    jestep, Jun 4, 2014 IP