…. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests, a 64GB buffer pool was used. O_DIRECT was used so, there was no caching of data at the filesystem level. The…=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size…
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… move for a MySQL dba to steal 20GB memory from the Innodb buffer pool to give it to the filesystem. I took a…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… FlashMAX II as the cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre…=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G…id = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… 6.3, and for the sysbench fileIO tests, the EXT4 filesystem was used. The card itself is the 700GB model. So… it perform with MySQL? Exact results vary, depending upon the usual factors (read/write ratio, working set size, buffer pool size, etc… P320h on a standard TPCC-MySQL test to the original FusionIO and the Intel i910 with assorted buffer pool sizes: And in…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… referring to the amazing MySQL manual, especially the option and variable reference table. …buffer_pool_read_requestsblogpercona.commanual Innodb_buffer_pool_readsblogpercona.commanual innodb_buffer_pool_sizeblogpercona.commanual Innodb_buffer_pool_wait_freeblogpercona.commanual Innodb_buffer…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… Flash Card Filesystem: ext4 Software OS: CentOS 6.3 MySQL Version: 5.6.7-RC Benchmark specification Benchmark name: tpcc-mysql Scale factor… Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M myisam_sort_buffer_size = 8M…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number… and to obey the LRU in the buffer pool. Since buffers can and will be flushed out of order… AIO. These can also be rendered useless by filesystems that don’t allow parallel writing to the …
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… Innodb tables on ext3 filesystem. Here is what I found: The fragmentation we speak in this article is filesystem fragmentation or internal… random tables. I used default MySQL settings for MyISAM (table_cache=64) and set innodb_buffer_pool_size=8G innodb_flush_logs…. Note: As I checked later contrary to my expectation this filesystem was created without dir_index option which should add significant…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and…Core Xeon running CentOS5 was tested using ext2 filesystem and SysBench tool. Using 16K read sizes …tried running with key buffer on and off. Interesting enough disabling key buffer actually worked better for…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… they have instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important… memory will also be different. Now let me come to filesystem layout issues This is where a lot of roads meet… is happening and why. A lot of pieces – filesystem, disk scheduling, database buffer management can be rather complex but you need to…
