…single person, with another person reading all the notes and … information on the box’s hardware, including RAID controllers, installed memory, and…Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | 38563413074 |…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…at a time. The read aio thread will normally read all the 64 page read requests in a readahead,… memory which is battery backed up just as RAID cache so it can handle system restarts. When putting…Contention and thread thrashing depends very much on the hardware, and also on the OS version. In our …
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…if you do not have battery backed up RAID cache as when write IO may suffer. innodb_file…- set it to be default as transaction-isolation=READ-COMMITTED. This option has some performance benefits, …MySQL with defaults run it on hardware without battery backed up cache with no OS changes and have…
Post: Sharding and Time Base Partitioning
March 14, 2008 By 12 Comments
… consider your scaling problems solved – by getting more and more hardware you can grow. As I recently wrote it however does… level off this significantly for reads by using caching (if things are accessed frequently they are served from cache) but you still have… can also use different hardware for different parts of data – you can hold “Hot” data on fast RAID volume or even SSD…
Post: How does MySQL Replication really work?
January 9, 2013 By 9 Comments
… or days ago – master may no longer have these cached, so disk reads will occur. If master does not have free IO… in the controller cache and because internally RAID card can parallelize writes to disks. Hence replication slave with similar hardware can write just as fast as master can. Now Reads…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… a battery-backed cache on your RAID card). This scenario may also appear when being on battery and your RAID card dies, automatically switching from write-back to write-through cache mode. We benchmarked the systems… and oltp read-write workload. All scripts, raw results and config files are available on our launchpad results page. The hardware used…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
…fair enough, RAID 10 + BBU is probably the most common and natural…software based reordering matters when one don’t have hardware to handle it, MySQL using O_DIRECT to … reads, and cpu bound moments, not just huge sustained writes) would give controller better chances to reorder properly before cache…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…RAID: [mysqld] long_query_time=5 skip-bdb skip-innodb skip-locking query_cache_limit=1M query_cache_size=32M query_cache…=16M table_cache=1800 record_buffer=10M sort_buffer_size=24M read_buffer_size=…a bunch of issues including questioning our hardware and our system administrators 
When we switched…
Comment: When to use Hardware upgrade instead of Software Optimization
December 7, 2008 By 5 Comments
… attached storage is often good answer for that. Think about Caching too. Collapsing 4 boxes into one you need 4x more… reading word “commodity” as “cheap crap”. So they end up buying very cheap boxes for databases – little memory, no good RAID, poor hardware…
