…_info when doing the backup of MySQL and Percona Server 5.6 with the GTID mode enabled. Example of how this information can… #1095972. Percona XtraBackup would fail when preparing the MySQL 5.6 backup if the log files were bigger than 4G on the source server. Bug fixed #1164979. Due to different implementation in MySQL 5.6…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can …failures that are caused by the log records in the transactional log being overwritten before they are …doing the backup of MySQL and Percona Server 5.6 with the GTID mode enabled. Example of how …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…Percona Software Repositories. Percona XtraBackup enables backups without blocking user queries,…secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows …MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465… is that vCache with time-based flushing enabled actually produces better and more consistent performance … innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default has been… intensive workload will do a lot better on MySQL 5.6 with default configuration back_log Minor increase 50 to 80 does not… this is as far as MySQL 5.6 goes – STRICT_MODE and other safer behaviors are not enabled by default. innodb_old_blocks…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
MySQL 5.6 is GA! Now we have new things to play … is that if you want GTID support log_slave_updates will need to be enabled in slave server and the performance impact… with GTID enabled. Instead we need to know in which GTID is the master and set it on the slave. MySQL keeps…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… behavior prior to MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL 5.5.3 a… an important question. If Query Cache is enabled and the SELECT can be serviced from…000005 | | sending cached result to clien | 0.000011 | | logging slow query | 0.000002 | | cleaning up | 0.000002 |…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… conclusion is: With doublewrite enabled, you can get a more or less stable line in MySQL 5.5.8 by tuning innodb_max… log space. And, the Percona Server result is ~2x better than the best result I received with MySQL 5.5.8 (with innodb_doublewrite enabled). In summary, my conclusion is: You can try to get stable throughput in MySQL 5.5.8Â…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…from logs. General Query Log The first option is the General Query Log. Let’s see an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log…problematic approach. From 5.5 it’s possible to log access denied messages to the error log. We just need to enable log_warnings with a…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
… MySQL 5.0. What can you do in MySQL 5.0 and below ? Use Our Patch – With this patch you can get all queries logged… general query log – for example connects or queries with syntax errors will not be logged. Enable logging to /dev/null You can enable queries to say “all_queries” log and symlink that to /dev…
