… is important to consider them. How about Mixing Storage Engines ? Sure you can mix storage engines but I suggest you doing is wisely. It… storage engines may not be well balanced or replication of mixed table types which is quite complicated. I prefer to pick one storage engine… 5% performance improvement but I can perfectly use MyISAM (or Archive) for logging. Innodb Needs Tuning As a final note about…
Post: Give me 8 hours, and I'll help you build a better application
August 29, 2009 By 4 Comments
… them — read on for the details. 1. Archive or Purge Your Database Data archiving is crucial. There is a difference between data… growing. The simplest way is to prevent it from growing. Archiving and purging unnecessary data is probably one of the highest… unused rows can bloat and dilute your indexes and tables. Storage engines such as InnoDB also don’t have features such as…
Post: MVCC: Transaction IDs, Log Sequence numbers and Snapshots
December 19, 2007 By 3 Comments
MySQL Storage Engines implementing Multi Version Concurrency Control have several internal identifiers related … to the data space” this means you can discard or archive logs for LSN earlier than that. When doing log recovery… started. Note: These are far from all functions which MVCC storage engines may place on these identifiers. This is not extensive list…
Comment: The Doom of Multiple Storage Engines
May 9, 2010 By 22 Comments
PeterZ, most of these commercial storage engines do not exist – at least where I work. See http://mysqldump.azundris.com/archives/87-Why-commercial-storage-engines-do-not-excite-me.html
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
…)” in many cases and foreign keys are still handled on storage engine level making them not working for partitioned tables as well… you have parent and child tables and you want to archive some records from parent table which will make some children…_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 INSERT INTO parent(parent_id) VALUES…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… a NCPK and most of those demand using some other storage engine like Archive… > 3. Using multiple databases Honestly I do not see… applications, using tens of thousands > of tables per host and archiving great performance by doing so. > Using multiple tables gives some…
Comment: Percona Server 5.1.47-rel11.0
June 25, 2010 By 13 Comments
…-path=/opt/xtradb/tmp/mysql.sock –with-plugins=partition,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,innodb_plugin,myisam,myisammrg…-dir=bundled –with-ssl my.ini add options default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda…
Comment: Percona Server 5.1.47-rel11.0
June 24, 2010 By 13 Comments
…-path=/opt/xtradb/tmp/mysql.sock –with-plugins=partition,archive,blackhole,csv,federated,heap,ibmdb2i,innobase,innodb_plugin,myisam,myisammrg…-dir=bundled –with-ssl my.ini add options default-storage-engine=InnoDB innodb_file_per_table=1 innodb_file_format=barracuda…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
… add amount of cached data per table for MyISAM and Archive tables to INFORMATION_SCHEMA (or other system tables) which would… than one would need to implement cache content tracking for storage engines which cache everything in their own cache memory – Innodb, Falcon…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… system. If you have fair amount of MyISAM, Archive, PBXT, Falcon or other storage engines then you will get into complex balancing game…
