…log_binblogpercona.commanual log_binblogpercona.commanual log_bin_indexblogpercona.commanual log_bin_trust_function_creatorsblogpercona.commanual log_errorblogpercona.commanual log_isamblogpercona.commanual log_outputblogpercona.commanual log…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… /bin/sh /usr/bin/mysqld_safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… of examples for High Performance MySQL book. In the bug Heikki explains the code was probably removed in MySQL 5.0 during XA… MySQL is not impossible but surely more complicated and has much higher performance overhead – you can run slave with –sync-binlog and –log… also prints position in the MySQL binary log: InnoDB: Last MySQL binlog file position 0 589600615, file name ./galax-bin.001376 This one is…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… to have innodb_flush_logs_at_trx_commit=1 so transactions are truly durable. You have to have log-bin enabled to get… your performance back. XA support has its overhead anyway so you may not get same performance as with MySQL 4.1 Disable Binary Logging… MySQL 4.1 until MySQL has taken it away from you as already happened with MySQL 4.0. MySQL 5.0 can offer substantial performance…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… manual filtering – using SET SQL_LOG_BIN=0 if you need to skip some statements from binary logging. This command requires SUPER Privilege… set up replication becomes more tricky because you need to perform mapping between master positions which you get with backup to… in my todo to see how well MySQL 5.1 row based replication works and performs and I will be testing filtered…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
Jeremy Cole recently posted very nice post about MySQL Replication Performance. There are however few points I should comment on. Jeremy …’m surprised to read enabling binary log drops update performance. I guess Jeremy speaks about enabling binary log and setting sync_binlog option… not see such effect just by enabling log_bin. Innodb tables also have to flush logs on transaction commit unless you disable it…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…stop-position 336797133 mysql-bin.000022 | mysql [root@sb logs]# mysqlbinlog –verbose –base64-output=decode-rows –start-position 336797275 mysql-bin.000022 | mysql mysql> select … a production server with active snapshots can affect performance, this is not really an advisable backup solution….
Post: Debugging problems with row based replication
May 6, 2010 By 10 Comments
… binary logging will be performed by this statement in row-based logs, but the DELETE will be written to a statement based binary log… the binary log, only positions. mysqlbinlog mysql_sandbox25162-relay-bin.000005 –base64-output=decode-rows -v > decoded.log Examine the decoded binary log with the…
Post: Percona XtraBackup 1.6.4
December 19, 2011 By 9 Comments
… details. Bugs Fixed innobackupex assumed that /usr/bin/perl was where the Perl binary was …MySQL connection was given to innobackupex with the –passwordoption, innobackupex would log that password in plain text in the log… if it should STOP/START slave to perform a safe backup. However, in a later …
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
… 4GB file in one chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load… [ -e /tmp/my-fifo ]; do time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load… on an I/O-bound server and see what the performance impact is, especially on other transactions running at the same…
