Showing entries 1 to 1
Displaying posts with tag: realestate.com.au (reset)
How MySQL Innodb works and how realestate.com.au configures their databases

I  gave a lightning talk on MySQL Innodb and how realestate.com.au configures their databases to the DevOPS Melbourne meetup last night.

My slides can be found here.

Simply some take aways are

  • Use Innodb for everything (unless another engine is appropriate)
  • Having the working set in bufferpool makes MySQL Innodb fast by eliminating those foreground randrom reads of tablespace
  • Use a RAID controller with BBU and write back cache for transactional log performance


Thanks To Evan Bottcher for owning and organising the meetup! 

Showing entries 1 to 1