…with O_DIRECT. There are results for “single file” with O_DIRECT case (sysbench fileio 16 KiB blocksize random write workload): ext4 1…MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5…
Post: InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
… Why? Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.21-beta-log Source distribution…to use –with-plugins=innodb (or max, or max-no-ndb, which includes set of more engines) ./configure —prefix=/dir/to/mysql –with-plugins=innodb make make…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… memory and the I/O subsystem. Also, it seems MySQL 5.1 with the InnoDB-plugin, MySQL 5.5, and Percona Server show about the same performance in… are flush list bound, then for MySQL 5.1/InnoDB-plugin or MySQL 5.5 the setting of innodb_adaptive_flushing, innodb_max_dirty_pages_pct, innodb_io…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… I compared MySQL 5.1.30 trees – MySQL 5.1.30 with standard InnoDB, MySQL 5.1.30 with InnoDB-plugin-1.0.2 and MySQL 5.1.30 with XtraDB (all plugins statically compiled in MySQL) For …group = 3 innodb_max_dirty_pages_pct = 90 innodb_flush_method=O_DIRECT innodb_file_per_table = 1 And for XtraDB …
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…5.0), we added adaptive checkpoint algorithms, and later the InnoDB-plugin…with FusionIO I use 4096 bytes, to align IO with internal FusionIO size. You can see that MySQL 5.5…_per_table=1 innodb_flush_…max_connections=3000 query_cache_size=0 skip-name-resolve table_cache=10000 [mysql] socket=/tmp/mysql…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
… tasks there. The goal of benchmarks was investigation of InnoDB-plugin and XtraDB scalability in CPU-bound load. CPU specification: processor…, 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, Xtradb-1.0.2-1, and XtraDB-1.0.2-2 (rel2). XtraDB-rel2… = 16 join_buffer_size=1M max_allowed_packet=1M max_connections=3000 max_heap_table_size=64M max_prepared_stmt_count=1000000 query_cache…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…1, dbsize = 1000000, no thinktime XtraDB: (mysql-5.1.39 + XtraDB-1…Plugin and we can set XtraDB same to InnoDB Plugin at least. The following graphs are results of XtraDB and Plugin with…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments. Sets the max…so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1, to implement XA, and …
Post: MySQL and IBM
April 6, 2009 By 17 Comments
…mysql.com/doc/refman/5.1/en/news-5-1-33.html. Quick look into source code says MYSQL_STORAGE_ENGINE([ibmdb2i], [], [IBM DB2 for i Storage Engine], [IBM DB2 for i Storage Engine], [max,max-no-ndb]) MYSQL_PLUGIN… use in source and binary forms, with or without modification, are permitted provided …
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
… run it with innodb_thread_concurrency=16 to match threads inside InnoDB with count of cores. Results for InnoDB-plugin-1.0.2 were kind of discouraging, dropping down just after 8 connections, si I decided to test MySQL-5.1.30 with standard…, and expect new results. for reference InnoDB was run with next parameters: –max_connections=3000 \ –table_cache=2048 \ –query_cache_size=0…
