…select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ Great! So again, using GTIDs avoids the tedious work of looking for the binlog… UUID can be read in the auto.cnf file in the datadir). So the …, but very poor in my opinion: look for the binlog file/position of the …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf…Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_… if possible (rewriting non-SELECT queries if needed, …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… MySQL 5.1+ row based logging (binlog_format=1) unique server_id in the my.cnf log_slave_updates=1, if this is…stores it progress in a metadata table: $ mysql -e ‘select * from flexviews.binlog_consumer_status\G’ -uroot *************************** 1. row *************************** server_id: 999 …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… the first node, my.cnf should look something like this on a relatively weak machine. [mysqld] server_id=1 binlog_format=ROW log…_xtrabackup ‘joiner’ ’10.195.206.117′ ” ‘/var/lib/mysql/’ ‘/etc/my.cnf‘ ’20758′ 2>sst.err’ 120619 13:20:19 [Note] WSREP… (ip-10-244-33-92) requested state transfer from ‘*any*’. Selected 1 (ip-10-112-39-98)(SYNCED) as donor. 120619…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… 8:31:49 38 Connect root@localhost on 38 Query select @@version_comment limit 1 User not correctly authenticated: 121227 8… in my.cnf: 5.5 userstat = 1 5.1 userstat_running = 1 Then we get the information about a particular user: mysql> select… BYTES_SENT: 14520 BINLOG_BYTES_WRITTEN: 0 ROWS_FETCHED: 783051 ROWS_UPDATED: 1017714 TABLE_ROWS_READ: 1484751 SELECT_COMMANDS: 14 UPDATE_COMMANDS…
Comment: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
I tried setting binlog_format=row in my.cnf, verified that it worked, and then ran an INSERT and an INSERT..SELECT. The results were the same: this code does not seem to be affected by the binary logging format at all.
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… (3 769009554) …done Copying ./mysql/ibbackup_binlog_marker.ibd is skipped. Copying ./…option “export” xtrabackup –defaults-file=/etc/my.reg.cnf –prepare –export –use-memory=…. When finished quick check mysql> select count(*) from order_line; +———-+ | count(*) | +———-+ | 32093604 | …
