The Curious Engineer

All blogs / Databases

Yoshinori Matsunobu's blog

yoshinorimatsunobu.blogspot.com

DatabasesLinux / UnixStorage / filesystemsPerformance / optimization

’10’15’20’25
Posts
40 from 24 Apr 2009 to 9 Nov 2017
Posting
quiet since 2017
Kind
personal blog
Feed
http://yoshinorimatsunobu.blogspot.com/feeds/posts/default

2017 1

  1. Towards Bigger Small Data

2016 1

  1. MyRocks Deep Dive -- slides available

2015 1

  1. Performance issues and fixes -- MySQL 5.6 Semi-Synchrnous Replication

2014 5

  1. Semi-Synchronous Replication at Facebook
  2. MHA 0.56 is now available
  3. Speaking about MySQL5.6 and WebScaleSQL at Percona Live
  4. How sync_file_range() really works
  5. Why buffered writes are sometimes stalled

2013 4

  1. Single thread performance regression in 5.6 - Replication
  2. Making full table scan 10x faster in InnoDB
  3. Another reason to disable performance schema
  4. Speaking at MySQL Conference and Expo 2013

2012 5

  1. Non-persistent connection performance improvements in 5.6
  2. Automating master failover is possible but needs care
  3. Relocating to US and joining Facebook
  4. Speaking at Game Developer Conference 2012
  5. MHA for MySQL 0.53 released

2011 12

  1. Making slave pre-fetching work better with SSD
  2. Testing MySQL 5.6.3 network performance improvements
  3. MHA for MySQL 0.52 released
  4. Speaking at Oracle Open World and Percona Live London
  5. MySQL-MHA: Support for multi-master configuration
  6. Announcing MySQL-MHA: "MySQL Master High Availability manager and tools"
  7. New Oracle ACE Director
  8. Proper handling of insert-mostly, select-recently datasets
  9. Slides: Automated, Non-Stop MySQL operations and failover
  10. Slides: Linux and H/W optimizations for MySQL
  11. Tracking long running transactions in MySQL
  12. Speaking at MySQL Conference and Expo 2011

2010 3

  1. Thanks for releasing MySQL 5.5 GA!
  2. Handling long texts/blobs in InnoDB - 1 to 1 relationship, covering index
  3. Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server

2009 8

  1. Accessing MySQL tables from UDF + storage engine API
  2. Great performance effect of fixing broken group commit
  3. iostat: (r/s + w/s) * svctm = %util on Linux
  4. Overwriting is much faster than appending
  5. Make sure write cache is enabled on your RAID controller
  6. Tables on SSD, Redo/Binlog/SYSTEM-tablespace on HDD
  7. Linux I/O scheduler queue size and MyISAM performance
  8. Mastering the Art of Indexing - slides available