…. Mysqldump works well for this, but can quite slow on larger schemas. One of the downsides to… Similarly, reloading the data will be a very IO intense operation (redo logs, binlogs, etc) as well… sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…server with hundreds of snapshots. With LVM, your IO performance drops to 33% after the first …raid controller write cache use. Even the fairly slow gzip-1 mode works well. The tpcc database,… on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… massive slow log volume.) The slow logs are served, via HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log… – http://master_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log…. The y axis is logarithmic, so the difference between the IO usage is 2 orders of magnitude. All graphs looked like…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… version of Percona XtraBackup has implemented full support for new MySQL 5.6 features (GTID, remote/transportable tablespaces, separate undo tablespace… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced…. Bug fixed #1079135. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced…. Bug fixed #1116177. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening all… #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer…
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
….m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In… Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time… include: Bottlenecks with Disk IO Problems with excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…. It also reads every type of log now (slow, general, binary, and tcpdump), so you shouldn’t …, now it’s on by default. If the IO::Socket::SSL Perl module is installed (easily available …standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…variables were added: | slow_query_log | ON | | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat…each datafile pages | 1.0 | Percona | GPL | INFORMATION_SCHEMA.INNODB_IO_PATTERN | | microsec_process.patch | Adds INFOMATION_SCHEMA.PROCESSLIST with …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… Innodb which combine index access with data access, saving you IO for completely disk bound workloads. There are certain optimizations in… completely disk bound can be very slow. One of the reasons elevating this problem in MySQL is lack of advanced join methods… large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by one…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… is smaller than data and the IO is slow (when the FS cache is cold, IO to slow IO subsystem happens) Repeated runs test a buffer pool which is smaller than the data but underlying IO is fast… pool hit ratio during the MySQL 5.6 runs and MySQL 5.6.10 was doing more IO as a consequence. To confirm…
