… one machine to another and configured with Linux network interface bonding in balance-rr mode;…way is to set up replication filters on the slave, as described in the MySQL manual. You …disabled; on the relay master you add binary log filters; this ensures that the top-level master and its binary logs…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… the MySQL 5.6 backup if the log files were…logs. Fixed by terminating xtrabackup process immediately on log copying failure. Bug fixed #1170806. innobackupex would fail if the SQL_MODE was set…have an option to disable DTrace like innodb55 has. … For the Debian and the Linux binaries, the –version …
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
…The commands below are only available for Unix/Linux. Using pager Most of the graphical tools …want to disable paging, you can simply run: mysql> pager Default pager wasn’t set, using stdout…. the Unix tee command: mysql> tee queries.log Logging to file ‘queries.log‘ mysql> use sakila Reading table …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/mysq | | CHARACTER_SETS_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE…_stats_on_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default… because Innodb was disabled for some reason was very error prone gotcha. Note this is as far as MySQL 5.6 goes…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
…limit 78000,1′ with, of course, the query cache disabled. I also verified that during the whole process, the… 1 1000` do START=`date +%s.%N` OUT=`mysql -e “set session sort_buffer_size=32*1024*$i;select * from…09:39:35 UTC 2010 i686 GNU/Linux MySQL: 5.1.41-3ubuntu12.6-log P.S.: Gnumerics for graphs is…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL… v0123456789 (Other) Service Tag | 0123456789 Platform | Linux Release | Ubuntu 12.04.1 LTS…: Comment: 1 row in set (0.02 sec) The…MySQL 5.5 (different version is added back in MySQL 5.6) so I tried that as well as disabling…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… work on virtually any Linux distribution and possibly under most other systems. The patch is currently available for MySQL 5.0.45… you cannot change at runtime from MySQL console wit SET or SET GLOBAL command. log_slow_filter=name Log only the queries that followed certain… limiting is disabled for the replication thread. Can be changed at run time with both SET SESSION and SET GLOBAL. log_slow_verbosity=name…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…, the instructions are similar for any Linux distribution. The client node will have …local_state variable. To set it up, create the clustercheck user. mysql> grant process on *.* to …disable = no flags = REUSE socket_type = stream port = 9200 wait = no user = nobody server = /usr/bin/clustercheck log…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…# Aspersa System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS…mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log… happened with setting #3 when WB cache was disabled, what …
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… in MySQL data directory. Unfortunately this is a startup time parameter, so unless you set it … to be periodically printed into MySQL error log. You can later disable logging by simply dropping the table…. system. However on many systems such as Linux or Solaris, but possibly also others, there…
