… Chris, try this: innodb_log_file_size = 64M (without the “B” in “MB” string) This works on my site on a Debian…_log_file_size is always a fixed parameter and it is quite difficult to extend at a later time with no trouble… a dynamic innodb log file RECREATE did NOT seem to work if you are going to delete the log files later (or even…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… working for a customer benchmarking insert performance on Amazon EC2…_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances… ENGINE = InnoDB) */ While the structure of the table with secondary indexes is as follows: CREATE TABLE `purchases_index` …
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… –file-test-mode=rndwr –max-time=18000 –max-requests=0 –num-threads=$numthreads –rand-init=on –file-num=64 –file-io-mode=async –file-extra-flags=direct –file-fsync-freq=0 –file-block-size=16384 –report-interval…. In general I have very good experience with this card, and it seems suitable to work with MySQL. I will publish sysbench oltp…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… format to work with parallel compression. The xbstream format is now supported along with the tar format. The new xbstream format works with parallel compression to (without caching) stream several compressed files at once…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… it uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables ?… + 2382090360) Page hash 127499384 Dictionary cache 512619219 (509995888 + 2623331) File system 294352 (82672 + 211680) Lock system 318875832 (318747272 + 128560)…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements …
Comment: Connecting orphaned .ibd files
April 6, 2012 By 12 Comments
… partition appears in the dictionary as a normal table, but with name st_results#P#p_1. ibdconnect scans SYS_TABLES… -t “st_results#P#p_1″ If doesn’t work please file a bug here https://bugs.launchpad.net/percona-data-recovery…
Comment: Emulating global transaction ID with pt-heartbeat
April 24, 2012 By 6 Comments
… and captured information is telling that B ( relay_master_log_file: test_file , exec_master_log_pos: 2399 ) was replicating from these… can tell C to start replicating from A with “relay_master_log_file: test_file , exec_master_log_pos: 2399″ and ignore the duplicate key errors for some time untill replication catches up.This should work…
Comment: ext4 vs xfs on SSD
March 25, 2012 By 23 Comments
…, YOu’ve just found a known problem that we are working to fix. This is regressions as a result of cleaning… tests on a 2GB ramdisk with a 1.8Gb file. Unpatched results – the numbers are throughput /IOPS, with throughput being in GB/s… on this machine with this patch has given close to a million 4k overwrite IOPS to a single file when completely CPU…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
….e. stable) release of Percona XtraBackup 2.0. We have worked hard since our last major release on improving the reliability… cores if needed. In previous versions, compression was only possible with streaming backups + external (usually single-threaded) compression utilities, which also… of other limitations (e.g. could not be used with parallel file copying, it was required to uncompress the entire backup to…
