… tracking was enabled and variable innodb_flush_method was set to ALL_O_DIRECT….5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack … hold the log system mutex for the log reads needlessly, potentially limiting performance on write-intensive…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For…/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size=4G innodb…/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues… innodb_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication…an lower bound on performance, only a upper bound. The best performance you can expect … might consider relaxing the fsync: set innodb_flush_log_at_trx_commit to something besides …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
….g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but nothing unexpected. So… innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration …100M innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…performs if PK is (`id`,`hid`,`mid`). This also will affect select performance…flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases…. Percona XtraBackup would fail when preparing the MySQL 5.6 backup if the log files were bigger than 4G on the source… with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying logs. Fixed by terminating xtrabackup process immediately on log copying…
