… think I can explain the performance you are seeing. But first I’d like to note that this experiment isn’t really… 100 disk seeks to answer a random query, assuming you can get each index query down to one disk seek.) I… up a partition and starting a new one. (If I read your graph correctly, you didn’t graph the performance on the…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… = 50 innodb_io_capacity = 800 innodb_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see… structure of the table with secondary indexes is as follows: CREATE TABLE `purchases_index` ( `transactionid` int(11) NOT NULL AUTO_INCREMENT…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… open-source and free, all the details of the release can be found in the 5.5.23-25.3 milestone… overwritten. This is now fixed by detecting the corruption and creating a new SYS_STATS table. Bug fixed #978036 (Laurynas Biveinis). Release…
Comment: Announcement of Percona XtraDB Cluster 5.5.23
May 16, 2012 By 9 Comments
Gilles, you can filter what tables to replicate using regular replication filter i.e. replicate_*, for it does not affect a node propagation. The new node still will copy all databases and instances.
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
….04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER…=” ” will make an error and stop this script. As I can see, Yves fixed this in his the last version on…
Comment: How much memory Innodb locks really take ?
May 19, 2012 By 11 Comments
… VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by one…
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
Rob, Easiest way – just put everything on the Fusion-io card. For more fine tuning it can be something more complex, but it is case-by-case.
Comment: Testing Fusion-io ioDrive - now with driver 3.1
May 18, 2012 By 2 Comments
… there? Or is it more complex than that? I’m new to Fusion-IO and I am going to do some…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Justin, I would be doing another benchmark and use ‘innodb_ibuf_accel_rate’ together with tuning other IO related parameters that I can tune to good affect, and I will post my results.
