… 0 @ 2.20GHz Memory: 192GB Storage: Very Fast PCIe Flash Card Filesystem: ext4 Software OS: CentOS 6.3 MySQL Version: 5.6.7-RC Benchmark specification Benchmark name: tpcc-mysql Scale…_size:13, 25, 50, 75, 100, 125GB to have different memory/data ration. We vary innodb_buffer_pool_instances: 1 and…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…CPU X5650 @ 2.67GHz Caches | 24×12288 KB # Memory ##################################################### Total | 23.59G … Locator Size Speed…alignment, not different MySQL configurations, I didn’t try out different MySQL versions or …plan to look at IO alignment on Flash cards to see what benefits …
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… needs high insertion rate for data which generally fits in memory. Last time I worked with similar system it used MyISAM… better RAID or Flash) which is a very cool number. Of course, mind you this is in memory insertion in the simple…_pool_instances=8 was very important. Second thing – Partitioning. Unfortunately MySQL 5.5 leaves the huge bottleneck for write workloads in…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… the Virident tachIOn PCI-E Flash card. As you can see, in the 13G case (where memory to data ratio is about… defined by available memory and the I/O subsystem. Also, it seems MySQL 5.1 with the InnoDB-plugin, MySQL 5.5, and… more memory or upgrade the I/O subsystem. If you are flush list bound, then for MySQL 5.1/InnoDB-plugin or MySQL…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… buffer pool in memory between restarts of MySQL servers. This can result in a significant decrease in warmup time after MySQL restarts. Starting… in a shared memory segment between restarts of the server. (Yasufumi Kinoshita) Option syslog was added to the mysql server. If enabled… in SHOW PROCESSLIST. Bug #606965 – Allows preventing data caching to flash storage during a query. Bug #609027 – Allows query cache use…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… IO. However, even today in our modern flash storage world where random IO is significantly … checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence … numbers are relevant from the BUFFER POOL AND MEMORY section of SHOW ENGINE INNODB STATUS: Database pages …
Comment: Modeling InnoDB Scalability on Multi-Core Servers
January 31, 2012 By 11 Comments
… : open flash device failed 120131 16:00:43 [Note] Plugin ‘FEDERATED’ is disabled. 120131 16:00:43 InnoDB: The InnoDB memory heap… sequence number 1604009568 120131 16:00:44 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable ‘innodb-adaptive-hash-partitions=8′ 120131… sequence number 1604009568 120131 16:00:49 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 120131 16:00:49 mysqld_safe…
Comment: FlashCache: tpcc workload
May 29, 2010 By 18 Comments
… one for flash cache or to house MySQL directly. Our data set is about 30GB, but we only have 12GB of memory on…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… of data loss, instead it is used as memory by the Intel SATA/flash controller for deciding exactly where to write data… I encourage you to test yourself (my full scripts and mysql config files are on Wiki page). There are binaries for…
