… table rather than incremental insertions. I also compared it to compressed MyISAM – this would take 1250MB so Archive does compress a bit… 310MB 40% better than compressed by gzip. I wish Archive storage engine would specify archiving method and compression level. Some people may like fast…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… have the same view on Storage Engines – Innodb is my oppinion is better choise for general purpose storage engine – it better matches what you… select statements but it has to be one insert at the time. Happily inserts in MyISAM are rather fast so it rarely… performance requirements, not to mention different load: Log tables. Now Archive storage engine can be even better. Read only data, especially packed with…
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… your indexes and tables. Storage engines such as InnoDB also don’t have features such as midpoint insertion algorithms for cache control, so…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… and foreign keys are still handled on storage engine level making them not working for partitioned…and child tables and you want to archive some records from parent table which …parent` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 INSERT INTO parent(parent_id) VALUES(1,”"); INSERT INTO child(…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 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… create indexes. Foreign key references may add processing time to inserts, updates, and deletes but there are other benefits. Also – if…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… only contain data pages – it also contain adaptive hash indexes, insert buffer, locks which also take some time. Though it is… system. If you have fair amount of MyISAM, Archive, PBXT, Falcon or other storage engines then you will get into complex balancing game…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… click analysis, site analytics, search engine marketing, online advertising, user behavior … database server for the initial insertion, because you can write CSV …day becomes a fixed overhead of storage size. So, you actually … The benefits of purging and archiving data can be dramatic. Take …
