….6/en/replication-gtids-concepts.html One thing that worths to mention is that if you want GTID support log_slave_updates… restore it on the slave to set up a new replication server. master > show global variables like ‘gtid_executed’; +—————+——————————————-+ | Variable_name…-sync. How to restore a slave in a good and slow way The good way is mysqldump again. We take a…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… query execution logged into slow log, however the new version is loaded with a set of cool new features. CONNECTION IDENTIFIER Each slow log entry…_sent: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed by the slaveâ…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… with replication lag (and performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log… nice to analyze your replication traffic regularly with mk-query-digest (Percona Server marks Slave Thread in slow query log so it is…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
…_binlog=0 and innodb_flush_log_at_trx_commit=2 I noted however if I enable replication – connect the slave to this…. If I would pause replication for prolonged period of time and let few GB of binary logs to accumulate the performance on Master will be high even with replication running, but it will slow down as…
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
…-set=latin1 [mysqld] port=3306 log-bin=mysql-bin server-id=2 replicate-wild-do-table=schema1.% replicate-ignore-table=schema1.table1 basedir… log-slow-queries = “D:/work/MySQL Datafiles/wrl-server-knp-slow.log” long_query_time = 2 wait_timeout = 1000 max_allowed_packet = 16M back_log…_additional_mem_pool_size=7M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=3499k innodb_buffer_pool_size=339M…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…-query-digest master/data/telecaster-slow.log. As mentioned during the webinar, the tool auto detects the log type so typically you will…=msandbox,D=percona,t=reviews –report-all master/data/telecaster-slow.log Slide 45 is the default output for pt-upgrade, obtained… differences between two (or more) servers, if using statement based replication, it is possible that new differences are introduced while the…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… about – each slave can be at different coordinates in binary log compared to masters. There can be some events which are… semi synchronous replication does not wait for execution only for queing event in relay log. Now lets see how Synchronous Replication solutions such… case of MySQL Replication is handled by cluster internally – for example if timeouts are reconfigured the transient network slowness can be seen…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… write query it clogs replication stream and small and fast updates which go after it in MySQL binary log can’t proceed… the transactions are buffered together and when dumped to binary log as one big chunk which can’t be interleaved by… out and slow down your batch job (such as adding sleep calls) to ensure there is enough breathing room for replication thread…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
… timestamp with no query. Slow logs which include timestamps but no query–which can happen if using slow_query_log_timestamp_always in Percona…: pt-table-checksum doesn’t ignore tables for –replicate-check-only. When using –replicate-check-only, filter options like –databases and –tables…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… from 5.0: extended slow.log USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS ( coming in release-10) Extended slow.log is now even more…, idea and implementation was taken from Facebook patches InnoDB big log files ( bigger 4GB). As our benchmarks on FusionIO shows, you… of buffer_pool Transactional replication Show internal InnoDB data dictionary Show InnoDB locking/io profiling in slow.log I hope you enjoy our…
