…perform the backups. The write load is not excessive so a single server can easily handle the write load of all the MySQL…could even be more zealous. Pretty interesting to speed up point in time recovery when you… tpcc database, which contains a lot of random data that doesn’t compress well showed a…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… third one features even higher QPI speed (and thus, faster inter-process/node communication…_cache_type=OFF performance_schema=0 warmup To warmup server and load data and indices…–percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB… now avoids loading non-relevant tablespaces when partial backup is being taken which speeds up the …fixed #1169509. innobackupex wasn’t handling the innodb_data_file_path option which could cause backup …
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
…significantly slower (and more CPU-intensive under high load) than PCIe flash For example, see http://… Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the… closer to memory speed than a regular SSD or HDD RAID), I can write data out to spinning…
Post: Testing MySQL column stores
August 16, 2010 By 15 Comments
…data set against two MySQL…data set. The second part of my testing compared the performance and accuracy of ICE with InfiniDB Community Edition on a 950GB data…Loading capability and speed of loading Accuracy of results of queries over the large data set Speed of results of queries over the large data…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…”). So how did it work? Did it speed up the load? Not appreciably. There actually was a tiny …time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set unique_checks=0; load data local infile… I/O-bound server and see what the performance impact is, especially on other transactions running at …
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
…words” by duplicating the entire set multiple times. mysql> load data infile ‘/tmp/words’ into table words (chars); … (5.00 sec) Since the data fits in memory speed is near constant and the single…SQL execution time, and parse time, respectively. Actually performance is a little worse. This is not …
Post: Predicting how long data load would take
May 24, 2007 By 14 Comments
… 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… memory) plus we loaded data in parallel and our rows were relatively long. In most cases I would expect load speed to be a…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…load on the system. MySQL Log analyzes with Mk-Log-Parser is a very good start for a ways to generally optimize MySQL load…performance optimization it is important there is enough instrumentation and production performance logging in place so you really can focus on hard data…speed up Sphinx and MySQL…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…may not be available, especially for CPU bound MySQL Load. The benefit in this case is less space… performance also means if your goal is faster local network transfer default GZIP compression will not speed things…32MB/sec of archive read speed and same 100MB/sec of uncompressed data. Do we have any …
