… the kernel in use for all of the benchmarks on both systems. The benchmark tool used was sysbench 0.5 and … #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb_…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… /dev/null, and only have a log file for debugging purposes. Streaming logs from stdin…query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and… stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…available for download from our repositories. Benchmark showing the impact of memory…once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and… If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and… them to our bug tracking system. UPDATE[18-04-2013]: There…
Post: MySQL File System Fragmentation Benchmarks
March 21, 2008 By 28 Comments
… set innodb_buffer_pool_size=8G innodb_flush_logs_at_trx_commit=2 innodb_log_file_size=256M innodb_flush_method=O_DIRECT for Innodb. The… times. Innodb in single tablespace mode showed following results: [root@DB10 ~]# for i in 1 10 100 1000 10000; do ./benchmark.php…. Innodb with innodb_file_per_table=1 had the following results: [root@DB10 ~]# for i in 1 10 100 1000 10000; do ./benchmark.php…
Post: Effect from innodb log block size 4096 bytes
January 3, 2011 By 19 Comments
…innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=4G innodb…innodb-log-block-size ( 512 bytes), and another with –innodb-log-block-size=4096. Full benchmark…is Found 1 ioDrive in this system Fusion-io driver version: 2….
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
In my recent benchmarks, such as this one about the Virident TachIon card, I used different values for innodb_buffer_pool_size…, it seems different file systems behave differently. You will see this in my upcoming posts. It defines your MySQL InnoDB tuning. Now I….1/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io_capacity, and innodb_log_file_size…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
….sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log… LVM on top of aligned partition table, used proper file system alignment. Benchmark results I had a hard time thinking how it would…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… in the benchmarks ? As otherwise you also need to boost tmp_table_size to deal with implicit memory tables. innodb_file_per_table – so I assume storing each table in its own file worked better for this benchmark. Depending on… could be done a lot better in Innodb (and we have patches for this) Operating System Notes from database server: UFS Options…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…Star Schema Benchmark[/caption] So far most of the benchmarks posted… used by default, the file system cache will give better …INNODB_BUFFER_POOL_READS | 191571 | | INNODB_DATA_PENDING_READS | 0 | | INNODB_DATA_READ | 3140882432 | | INNODB_DATA_READS | 191581 | | INNODB_PAGES_READ | 191570 | | INNODB…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 13 Comments
…MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin…in software RAID0 to store InnoDB datafiles. For InnoDB logs and system tablespace I used partition on…about 88% worse than all files on FusionIO) To summarize MySQL InnoDB/InnoDB-plugin/XtraDB is not …
