… x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 … –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 …of innodb_log_file_size. I won’t give you a full rundown over every option in the file. But…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…_log_files_in_group = 3 xtrabackup: innodb_log_file_size = 536870912 xtrabackup: use O_DIRECT >> log scanned up to (3 767617628) Copying ./ibdata1 to /data/vadim/mysql… 78 for 5.0.83 unknown-linux-gnu (x86_64) xtrabackup: cd to /data/vadim/mysql/export/ xtrabackup: This target seems to…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file…2.3 120619 13:21:17 InnoDB: Using Linux native AIO 120619 13:21:17 InnoDB: … will see this as a single MySQL server running on localhost. In order to achieve this, we will…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
….4 Mbytes in core for 1 file; 24169.00 pages, 94.4 Mbytes per file. So we can see one of Innodb log files is… direct IO to log files on Linux because it is not aligned. [root@DB01 mysql]# du -h ibdata* 246G ibdata1 [root@DB01 mysql]# perl /tmp… can see some pages remaining. Today log file is 50% in cache. Knowing access pattern to the file you can draw some conclusions about…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…_N_SEGMENTS in coregrind/m_aspacemgr/aspacemgr-linux.c (when you see…file=/etc/my.cnf (if this is where your my.cnf file is located) in order to point mysqld to your settings file…Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL … as well and skip binary logs in your backup process. 7) Unmount filesystem…log position: change master to master_host=”master”, master_user=”user”, master_password=”password”, master_log_file=”host-bin.000335″, master_log…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… on Linux. It is no harder in principle on other OSes, but we have so many customers on Linux … the script can log into MySQL (if necessary, put a password into .my.cnf, or in the MYSQLOPTIONS variable). … hit the Return key and start browsing the files. The tool is keystroke-driven, Vim-style, so …
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
….5, rather than MySQL 5.5. Support for building against InnoDB plugin in MySQL 5.1 has been … file on Linux is disallowed. Fixed innobackupex and tar4ibd to use O_DIRECT on input InnoDB files… in the Perl version string in innobackupex. (Baron Schwartz) Bug #672384 – When no log files can be found in …
Comment: xtrabackup-1.2
May 10, 2010 By 2 Comments
… OS: centos , MYSQL :MYSQL 5.1.30 ./bin/xtrabackup Ver 1.2 Rev undefined for 5.1.45 pc-linux-gnu (i686) xtrabackup… innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 2097152 xtrabackup…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
…MySQL using O_DIRECT to move data from sequentially written log files to the more write-costly spreaded/random innodb data file… queue and the innodb log file in the background may not…Linux got a lot of refining in order to expose and enforce I/O priorities and arbitration. I’m not sure whether MySQL…
