… Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance… during installation. Bugs fixed #1031427 and #1051874 (Ignacio Nin). The log tracker thread was unaware of the situation when the oldest…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… second for MySQL 5.6.11. Conclusion: In CPU-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…_flush_method = O_DIRECT innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users …not be written to the slave’s binary unless log_slave_updates is enabled, this is similar to … without PK imposes an additional overhead, and because cluster performance is somewhat dependent on the slowest node – this overhead…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
…. Currently it can read queries from MySQL query-log and MySQL tcpdump files and run them on other MySQL server. With Percona Playback you… or schema change can affect the overall performance of your MySQL database server. Percona Playback for MySQL can also help evaluate new server…. Bug fixed #1072845 (Stewart Smith). Percona Playback for MySQL wouldn’t reconnect or log the error if the connection was broken during…
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… prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied by the…. Percona XtraBackup would fail when preparing the MySQL 5.6 backup if the log files were bigger than 4G on the source…
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…_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table…_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…standard 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 …consider relaxing the fsync: set innodb_flush_log_at_trx_commit to something besides …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower…started by XtraBackup when rebuilding secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows parallel processing of individual tables when…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
…their database server, leading to degraded application performance, and sometimes even short moments of downtime….here is also the simplest: the ‘raw’ log parser. If you specify –format rawlog, then… regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do …
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 parameters… = O_DIRECT innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group…
