…, 5.6-style buffer pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5…-copy-interval. Making the interval configurable allows to reduce the time between checks which can prevent XtraBackup failures that are caused… leave xbtemp temp files behind due to a typo. Bug fixed #1172016. innobackupex wasn’t handling the innodb_data_file_path option which…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
…, which basically controls how important is the file cache for Linux. Basically, with InnoDB, since the file cache is not important we add… using the numactl utility, drop the file cache and pre-allocate the innodb buffer pool with the innodb_buffer_pool_populate option. That…, top, iostat, etc all saving to disk with the current time stamp in front of each line. I quickly found that…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb_io_capacity, but they didn’t and a lot of people are going to waste time and lose…_and_free_block they are trying to do it. I filed a few bugs for this and I hope most of…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… innodb_lru_scan_depth to a value similar to innodb_io_capacity. They should have made LRU page flushing a function of innodb_io_capacity, but they didn’t and a lot of people are going to waste time and lose…_and_free_block they are trying to do it. I filed a few bugs for this and I hope most of…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… designs and benchmarks.) First, we set long_query_time to 0 in order to log every query. (… to /dev/null, and only have a log file for debugging purposes. Streaming logs from stdin Percona …init-query command-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs, and DELETEs …
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
…after doing memory allocation setting in my.cnf file, site performance was good. But from second …many process stay in sleeping condition for long time like 200-300 processes. Current Server Details (Dedicated …1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware:…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… tries and wait time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait…-in, like other tools: –user, –host, –port, –password, –socket, –defaults-file. So now the command line is what you expect: pt… in 2.2 to make their run-related options (–run-time, –interval, –iterations) standard. If you hadn’t noticed, one tool…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… data infile concurrently results for two threads is 20 times slower then 1 file after the other. This could not be related… we are facing more and more big data challenges where innoDB and TokuDB will have to be compare with LevelDB at…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin… to try to convert customer’s data to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I…% mostly waiting for I/O) 0.01 sec average lookup time by primary key (from 1-20 sec before the conversion…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… similar variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb does not… was about the same, taking 1sec (on the second time) . Whenever innodb_open_files_limit was 64 (virtually all misses ) or 16384 (all…
