… throughput after 2 threads, and the result averages at 300 MiB/sec. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1 thread…=’6a6a6a’;l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313′;
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 9, 2012 By 28 Comments
Good to see a healthy thread spread across a good number of years. Thanks Baron! As … in MySQL 5.5 (vanilla version). “The big LOAD DATA INFILE clogs the binary log and slows replication down. If the load takes 4 hours on the master, it will cause the slave to fall 4 hours…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the …_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## …and MySQL. Now as far as the benchmark itself is concerned, I made no code changes to iiBench, and…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
….6.5 at the time of writing). This beta adds some really exciting features and bug fixes. New features include: Backup and restore… example, ‘–parallel=4 –compress –compress-threads=2′ will create 4 IO threads that will read the data and pipe it to 2 compression threads. New streaming…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…): ext4 1 thread: 87 MiB/sec ext4 4 threads: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for ext4… amount of threads does not affect the result significantly. This is to another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important?”, and it seems it is not. In…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…; +——+ | age | +——+ | 21 | | 25 | | 30 | +——+ Start a transaction and delete the record 25: transaction1 > START …4 lock struct(s), heap size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread…dev.mysql.com/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… and focusing on throughput does not get any closer to reality. Benchmarks, like sysbench or tpcc-mysql, start N threads and try…see interval is far from being strict 0.5 sec, but 0.5 is the mean of this random …l=’y';fs=’16′;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’s'; pid=’109242749016593233313…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
… unique fixes such as different innodb_thread_concurrency handling and other optimization. Should we take Innodb from MySQL 5.4 and merry it with unique Percona patches (adaptive checkpoints, additional undo slots, profiling, etc) and integrate it with MySQL 5.0 ? How…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
MySQL 5.5 and Percona Server 5.5 do not solve all scalability problems even for read only …_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_conn ection,handle_one_connection,start_thread,clone 4 pthread…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… MySQL 5.5 there is an option to have a single separate dedicated purge thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads too, although… 2800 seconds in 4 thread experiment), their activity could be throttled better as to not to penalize further TPS. MySQL 5.6.2 Results…
