… to see MySQL memory consumption plotted. I use “VSZ” columns from “ps” output on Linux. It…log ps aux | grep mysqld >> ps.log sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL…connections might have created and forgot to remove (or still use for processing). Of course…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
…MySQL you might need to deal with RAID …takes you to the point where last binary log was backed up. I wanted for a …SSH it can be recovered as any generic Linux server. When you restart the system RAID5 volume…change status of rebuilding drive into “failed” and removed in “active sync” but I could not …
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… Linux RPM” spec file on CentOS 4.4 (RHEL compatible) x86_64 (Links removed) We added one more RPM to stantard MySQL RPMs – MySQL…/09/06/slow-query-log-analyzes-tools/ http://bugs.mysql.com/bug.php?id=25412 Also we propose Linux (AMD64 / Intel EM64T) binaries in tar.gz archive (Link removed) The…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…_64 x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 (… –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11…client’s developers are in the process of removing from the application completely. That’s all! I…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
…MySQL 5.5. Support for building against InnoDB plugin in MySQL 5.1 has been removed…Removed the bogus warning about invalid data in the Perl version string in innobackupex. (Baron Schwartz) Bug #672384 – When no log… with an assertion failure on non-Linux platforms. (Alexey Kopytov) Bug #703077 -…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL and run FLUSH TABLES WITH… log position you’ll need to point your MySQL Slaves created from this snapshot. 4) Snapshot created, now you want to let MySQL… as well and skip binary logs in your backup process. 7) Unmount filesystem umount /mnt/backup 
Remove snapshot: lvremove -f /dev…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… on (for brevity I have removed some irrelevant information): # Aspersa System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 …mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…: memlock already works – it is global MySQL Server option, though it may have problems on Linux if you lock very large portion… InnoDB log flush with a mutex in 5.1, to implement XA, and switching off the XA will not remove that serialization. MySQL‘s binlog and InnoDB’s log must have the transactions in the same order, for a recovery based on MySQL…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… writes to the first file in the log file group and the SSD dynamic wear leveling…mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql… also on the OS version. In our tests, removing one bottleneck moves the contention to another place….
Post: Copying InnoDB tables between servers
July 31, 2009 By 10 Comments
… /data/vadim/mysql/export//tpcc/order_line.ibd >> log scanned up to (3 770393658) … >> log scanned up to…5.0.83 unknown-linux-gnu (x86_64) xtrabackup: cd to /data/vadim/mysql/export/ xtrabackup: This …ENGINE=InnoDB DEFAULT CHARSET=latin1 Next step is to remove created .ibd file, it’s done by command…
