…speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also … Innodb team will put on their roadmap. With SSD coming this will be important. And it is …sending it back to the client. I tested MyISAM with myisam_use_mmap option which did not seems to …
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding…IO at the time if Innodb or MyISAM tables are used. There is read-ahead…should also evaluate external directly attached storage, SSDs, Increasing system memory as well as …
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
… spend large portion of my life working on MySQL Performance Optimization and so MySQL Optimizer is quite important to me. For probably… to stick to old optimizer behavior with new MySQL Version. Make Cost Model Adjustable MySQL Optimizer looks at query plan in terms…% in RAM (even for Disk tables such MyISAM or Innodb) others keep database on SSD which has completely different ratio between CPU…
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
… Keep’s blog post on InnoDB-vs-MyISAM benchmarks that Oracle recently published prompted me to do some… read-write tests, and the server has two Intel SSDs, 64GB of memory, and 4 x 12-core AMD … another machine, instead of taking 12 cores away from MySQL and giving them to sysbench. That way we could …
