…customer benchmarking insert performance on Amazon …each) 1690 GB of instance storage 64-bit platform I/O …s come to the MySQL configuration. MySQL Configuration I used Percona …ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN (900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer… are performed in a single call to the storage engine and the counters Handler_read_key and Innodb…Rowid-ordered scan; Using temporary; Using filesort 1 SIMPLE customer eq_ref PRIMARY,i_c_nationkey PRIMARY 4…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…are batched together and sent to the storage engine. The storage engine then uses the MRR interface (which… l_discount)) as revenue, o_orderdate, o_shippriority from customer, orders, lineitem FORCE INDEX (i_l_orderkey)…the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows third parties to create their own storage engines…great Innovation I think happens with custom storage engines which are not designed to be run as core storage engines and are not match of…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
Today we officially announce our new storage engine, “Percona XtraDB”, which is based on the InnoDB storage engine. It’s 100% backwards-compatible with… as drop-in plugin for existing MySQL-5.1.30 installation http://www.percona.com/mysql/5.1.30/binary/percona-xtradb…. Percona will improve this storage engine using our own ideas, as well as incorporate improvements specifically sponsored by customers. Please contact us if…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… storage engine. The biggest problem is that MySQL does not yet provide an interface for that. This is going to be fixed in MySQL 6.0, but I can’t yet say how it will work with mix of storage engines. – The Tokutek engine I… complex and, probably, I would not put yet TokuDB on customer production boxes, but it may good fit to non-critical…
Post: All thouse new MySQL Storage Engines
April 17, 2008 By 8 Comments
MySQL Users Conference 2008 has number of Storage Engines presented which claim to Kick Ass. Walking in exhibition hall … (Kickfire also uses proprietary custom hardware) which makes it hard to get independent product evaluation. Many of storage engines will indeed offer you…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… later after you got well performing baseline. Do not change storage engine at the same time eather. Make sure you’re looking… as innodb-stats-method and myisam-stats-method. For Innodb storage engines it is possible for stats to be different for the… on MySQL server of the same version. If you’re Support customer you do not need to do it as Support Engineer can…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…are based on our analysis of several hundred customer downtime incidents, and their causes and preventions. …a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence …problems in the server as well as the storage engine. For example, a pile-up of connections …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… XtraDB. That means Galera supports the XtraDB storage engine. Support for multi-threaded slaves. Using custom scripts for node propagation. RSYNC method comes…three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance…
