… is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases… Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for faster server… is copied back to data directory. After the backup is restored buffer pool dump can be loaded by the server either automatically…
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…not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… vs MySQL 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL…_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30/data/dpe0 | /mnt/data/sandboxes/msb_5_6_10/data/dpe0 | | PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… 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… on an I/O-bound server and see what the performance impact is, especially on other transactions running at the same…
Post: Why do we care about MySQL Performance at High Concurrency?
February 26, 2013 By 9 Comments
… production system: root@smt2:/mnt/data/ mysqladmin extended -i1 | grep Threads_running | Threads_running …really run MySQL with high concurrency does it really matter how MySQL performs with …load. So yes. The performance at high concurrency matters as it helps systems in distress. But performance…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… chance to check out MySQL Performance on “Memory Appliance” by Violin Memory …performance. Interesting enough utilization in iostat never went over few percents and load was mostly CPU bound. Next I went on testing MySQL…to have as much data in buffer pool as possible for best performance. Hopefully …
Post: Yahoo Search Suggestions for MySQL
August 16, 2007 By 5 Comments
… and type MySQL to Search field it gives you suggestions for MySQL, which are: * loading javascript arrays with mysql data * mysql performance blog * mysql download * mysql administrator download * mysql front…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up… and so forth. If the server is heavily loaded or has a lot of data, touching the INFORMATION_SCHEMA can take a…
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
…. Data Insert Order It is well known it is important to load data in primary key order into Innodb tables for optimal performance, but… to perform load effectively Load Options There two main ways to load data in MySQL you can use Multiple value insert (standard mysqldump output) or LOAD DATA INFILE…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
