… and built Percona Server 5.5.30 with TokuDB’s storage engine. This is an experimental build and I am just going…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… the same 2.2TB Virident FlashMAX II as the cache storage device. EXT4 is the filesystem, and CentOS 6.4 the… MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? After creating a vCache device… \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… on storage engine internally. We have to deal with different locking strategies storage engines may have and if we venture into using cross storage engine transactions we’re up for a lot of surprises. Backup Cross storage engine…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… 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… storage engine being developed inside MySQL. All of these storage engines are however similar in their features and focus – all of them are transactional storage engines…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… – Enables concurrent insert (while Selects are running) for MyISAM storage engine. Other Storage engine ether always have it (ie Innodb) or do not support… Delayed inserts configuration. Technically it is not storage engine dependent, in practice however not all storage engines support it. For example Innodb tables do…
Post: Countless storage engines
May 3, 2007 By 6 Comments
… of storage engines were presented. In good old time when Oracle bought InnoDB, MySQL did one step – announced MySQL supports Plugginable Storage Architecture…, but currently we all see it. Let me list Transactional Storage Engines I heard of on Conference and main impression about. InnoDB… life. Also nobody prohibits to add such index to other storage engine if it will show good performance results. The wide choice…
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… a new storage engine that will eventually become much more than just small variations from standard InnoDB. Percona will improve this storage engine using…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… session about PBXT because this is storage engine does not target the same general purpose transactional storage engine market a lot of other people… Conference only allowed 45 minutes for Storage Engine presentations. This is complex topic and especially newsly presented storage engines deserved more than 45 minutes…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
… try how much archive storage engine could help me in this case. Original Table: *************************** 1. row *************************** Name: requests_061111 Engine: MyISAM Version: 9… used by MyISAM. Summary: Archive storage engine does compresses your data and should be good for log storage or storing something which needs…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… for wide range of queries. [+] Ordered data reads Unlike other storage engines which will read row data as they traverse the index… outside of MySQL Storage Engine level for MySQL – reading rows in their physical order can be applied to most storage engines, it certainly can… changing default value needs table rebuild even though for other storage engines it often could be done simply by changing meta data…
