… sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? After … –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration …
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… given storage engine. Synchronization The top level on MySQL side, such as .frm files and binary log files has to be synchronized with storage engine… tests being run for different storage engines, but really this is not enough as MySQL allows you using multiple storage engines in the query you…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… rows used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory, which is… or for example local flash storage for storage. Compression You can see it as a property of Storage Engine but let me put it separately as well. I believe Query Storage…
Post: XtraDB storage engine release 1.0.4-8
October 12, 2009 By 12 Comments
… on startup on windows fix-import-extern-pages Number of mysql-tests are fixed The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb/5.1.39-8/ The latest source code of… # apt-get install mysql-server-5.1 Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL. For general questions…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… of 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… Falcon 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
… storage engines only and which are used on SQL layer and apply to all storage engines. Lets start with a bit of history. When MySQL was just written there was not that many storage engines – there was… HEAP for in memory tables. So first MySQL versions did not bother naming variables with storage engines prefix. This is why we have…
Post: Countless storage engines
May 3, 2007 By 6 Comments
… count of storage engines were presented. In good old time when Oracle bought InnoDB, MySQL did one step – announced MySQL supports Plugginable Storage Architecture. In… developers promise to fix it soon. Falcon The Storage Engine which is developed in MySQL. The performance we see in our previous benchmarks…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… too bad MySQL Users Conference only allowed 45 minutes for Storage Engine presentations. This is complex topic and especially newsly presented storage engines deserved more… with same pace and dedication it will become one major storage engine for MySQL. We surely should get back soon and run more…
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… 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: 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… file: -rw-rw—- 1 mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql 984628803 Nov 12 11:29… used by MyISAM. Summary: Archive storage engine does compresses your data and should be good for log storage or storing something which needs…
