…MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing I discovered that innodb…. Each query in each flight (Q1.1 for example) is tested with a …. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the InnoDB tests…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb…innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… is still zero. If you know how InnoDB uses `PREC` please let me know. mysql> select * from SYS_COLUMNS WHERE TABLE_ID…-tool-for-innodb 1. Compile the dictionary parsers make dict_parsers 2. Split ibdata1 with page_parser ./page_parser -f /var/lib/mysql/ibdata1… ‘”‘ LINES STARTING BY ‘SYS_FIELDS\t’ (`INDEX_ID`, `POS`, `COL_NAME`); 5. Now everything is ready to generate a CREATE TABLE statement…
Post: InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 9 Comments
… to compile MySQL from sources by yourself, for different needs, like …/to/mysql make make install and then, for example, load the dump of InnoDB from previous version: mysql testdatabase …Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.21-…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…5_5_30/data/msan | /mnt/data/sandboxes/msb_5_6_10/data/msan | | VERSION_COMPILE_OS | linux2.6 | linux-glibc2.5…innodb_stats_on_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…MySQL 5.0 or 5.1 prior to version 5.1.24. A fix for a MySQL bug (#27877) introduced an incompatible change in collations in MySQL 5.1… the deprecated options (innodb_buffer_pool_shm_key and innodb_buffer_pool_shm… on platform-specific distribution: The compilation of the Response Time Distribution…
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
… on MySQL 5.1.47, and XtraDB is now based on InnoDB plugin 1.0.8. XtraDB now uses the fast recovery code released in InnoDB… more tests to the MySQL test framework. Fixed bugs #573100 Can’t compile 5.1.46 #573104 separate name in INNODB_SYS_TABLES table #580324 Security bug in upstream #586579 Percona Server 11 fails to compile…
Post: Percona Server 5.1.52-12.3
December 13, 2010 By 2 Comments
… or Changed Percona Server 5.1.52-12.3 is now based on MySQL 5.1.52. New Features…innodb_extra_undoslots option is disabled but it was enabled before” was sometimes reported after upgrading from MySQL 5…a to failing compile-time assertion in mysqld.cc. (Alexey Kopytov) Bug #673567 – Compiler could …
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
…Changed  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.  New … system variable have_response_time_distribution and compile option –without-response_time_distribution in Response… systems. (Aleksandr Kuzminsky) Bug #677407 – The innodb.innodb_information_schema test could fail sporadically…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
…some compiler warnings. (Stewart Smith) Ported XtraBackup to MySQL 5.1.55, MySQL 5.5.9, Percona Server 5.1.55-12.6, and Percona Server 5.5.9-20.1 code bases. The xtrabackup_55 binary is now based on Percona Server 5.5, rather than MySQL 5.5. Support for building against InnoDB plugin in MySQL 5.1…
