… where did all of the configuration go for example default_storage_engine, query_cache_size, e.t.c…. Is it something built…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 3.25 EC2 Compute Units each) 1690 GB of instance storage 64-bit platform I/O Performance: High API name: m2… LESS THAN (800000000) ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN (900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE = InnoDB, PARTITION p10… LESS THAN (800000000) ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN (900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE = InnoDB, PARTITION p10…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… no difference in query syntax, client-server protocol, or data storage on disk. Anything that runs on MySQL will run identically… Percona involved? Because providing quality server builds is a substantial engineering effort that requires a lot of expertise to do right…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 9, 2012 By 9 Comments
Yes, it should work with all storage engines, because everything it does is performed at the server layer, not the storage engine layer. And I have done just what you have asked, with success.
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… lookup on table2 are batched together and sent to the storage engine. The storage engine then uses the MRR interface (which I explained in…
Comment: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 23, 2012 By 10 Comments
…. That information needs to come from the storage engines. My idea is that the storage engines should take this into account when reporting the…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… these lookups are performed in a single call to the storage engine and the counters Handler_read_key and Innodb_rows_read… used then there are two separate calls made to the storage engine to perform the index record read and then to perform…
Post: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
… 16:56:45 [ERROR] Got an error from unknown thread, storage/myisam/mi_write.c:223 120326 16:56:45 [ERROR… really happened. MySQL created a temporary table, using the MyISAM storage engine, and when the disk filled up, MyISAM got an error…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 9, 2012 By 9 Comments
Quick question… does the pt-online-schema-change tool work at tables using the MyISAM storage engine? Would it work to convert a table from MyISAM to InnoDB?
Comment: Best kept MySQLDump Secret
March 26, 2012 By 11 Comments
… whenever MySQL will ever be redesigned to focus on transactional storage engines or whenever this will remain Drizzle’s turf.
