… compiled from sources with options: ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb and next startup options were used: libexec/mysqld –no-defaults –user=root –innodb-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… install) Only changes from defaults was that both servers are compiled without the PERFORMANCE_SCHEMA, and paths are unique for basedir… difference with innodb_old_blocks_time=0; mysql> set global innodb_old_blocks_time=0; Query OK, 0 rows affected (0.00 sec) mysql> select… 1 row in set (0.00 sec) And with innodb_old_blocks_time=0: mysql> select straight_join sum(lo_extendedprice*lo_discount…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…with_limitblogpercona.commanual Uptimeblogpercona.commanual Uptime_since_flush_statusblogpercona.commanual userblogpercona.commanual verboseblogpercona.commanual versionblogpercona.commanual version_commentblogpercona.commanual version_compile…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | /mnt/data/sandboxes/msb_5_6_10/data/msan | | VERSION_COMPILE_OS | linux2.6 | linux-glibc2.5 | | THREAD_CACHE_SIZE | 0… | | INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE… operation (such as using MySQL on NFS file system). innodb_data_file_path got a small change with starting ibdata1 size raised from…
Post: Percona Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
… from the Percona Software Repositories). Based on MySQL 5.5.18, including all the bug… import operation. This allows queries accessing other InnoDB tables to proceed normally and not be …-bit systems when compiled without i686+ support. There were no observed issues with the previous implementation, …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… for MyISAM / InnoDB and pbxt-0.9.85-beta.tar.gz Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark: 1. Prepare table with 1,000,000…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
…compile in debug mode, I am redoing the benchmarks. Updated version here. I recently had to work with many customers having large number of connections opened in MySQL and although I told…which easily fits inside the buffer pool. Then, with innodb_flush_log_at_trx_commit=0, I ensured…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or … now you can be locked sub-second. Even with innodb only this can greatly cut down on the… will have to compile it yourself as binary packages aren’t distributed Be careful with importing a dump…
Post: Pretty-formatted index fragmentation with xtrabackup
March 15, 2011 By 4 Comments
The xtrabackup compiled C binary (as distinct from XtraBackup, which is the combination … stats on InnoDB tables and indexes. This can be useful to examine whether you’d benefit from “defragmenting” your MySQL database with OPTIMIZE…. It’s an initial draft, and if you find issues with it I would like to know so I can fix…
Post: Percona Server tree with support of Fusion-io atomic writes and DirectFS
September 24, 2012 By Leave a Comment
… uses direct API access. The main idea that with this functionality you can disable “innodb-doublewrite”, retain ACID compliance by using atomic… latency variability reduction expected soon. Percona Server 5.5.27 with Fusion-io atomic writes is available from Launchpad repository: lp…-atomic, and the patch itself is the revision 300. To compile it you need access to Fusion-io SDK, which is…
