…hot test, the data fits in the buffer pool and has been loaded by the …faster using MyISAM than InnoDB. Like the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data…[mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin …
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for faster server warmup after the start. This feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL…. Bug fixed #1130145. Percona XtraBackup didn’t initialize per-thread data in the log copying thread which could cause XtraBackup to…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for faster server warmup after the start. This feature is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL… typo. Bug fixed #1172016. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup to fail. Bug…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… even higher QPI speed (and thus, faster inter-process/node communication). Results: First of…schema=0 warmup To warmup server and load data and indices to the buffer pool …–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…the buffer pool pages were loaded from disk. Replaying Queries Working …playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema …, and DELETEs from corrupting the data on the standby server. You…duplicate key errors may be faster than an actual database write….
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… money to store all my data on SSD when some of that data might just be sitting idle? … significantly slower (and more CPU-intensive under high load) than PCIe flash For example, see http://www….in TPCC-MySQL performance between that card and a traditional SSD – the PCIe card is about 3x faster. By …
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
… to load data in MySQL you can use Multiple value insert (standard mysqldump output) or LOAD DATA INFILE (–tab mysqldump output). Generally LOAD DATA can be optimized better and a bit faster because of easier…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… to think how long. I’m sure it would be faster to just shut everything down and re-clone the machine… chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘infile… ]; do time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile ‘/tmp…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… capturing enough data and copying the slow query log to the DEV server we can replay the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log… seconds to execute the load but it was 47 seconds originally on the production server. 98966 queries were faster and 330501 slower…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the…/buffer-pool-contents.txt’; I loaded this file into a table on my laptop with LOAD DATA INFILE and kept it for later… have to be the tools I used — it could be MySQL Proxy or a TCP sniffer or anything else. But if…
