…Engine: ARCHIVE Version: 9 Row_format: Dynamic Rows: 8048913 Avg_row_length: 0 Data_length: 0 Max_data_length: NULL Index_length: 0 Data…go and check size of on disk file: -rw-rw—- 1 mysql mysql 19 …the size of archive table. I guess this is due to incremental compression which Archive engine uses, …
Post: Adventures in archiving
February 11, 2013 By 16 Comments
…(`id`) ) ENGINE=ARCHIVE DEFAULT CHARSET=latin1; CREATE TABLE `compressed_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `dat` blob, PRIMARY KEY (`id`) ) ENGINE=…create the schema adventures_in_archiving. It will then attempt to regenerate the payload file adventures_in_archiving_data.sql (4GB) if it …
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
…can easily add amount of cached data per table for MyISAM and Archive tables to INFORMATION_SCHEMA (or…need to implement cache content tracking for storage engines which cache everything in their own cache memory – …core for 1 file; 0.00 pages, 0.0 bytes per file. Out of 250GB innodb data file none of…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… later. Alternately, you can store the atomic data as CSV files and use the CSV engine so you have an SQL interface to… CSV files with any programming language. Naturally, CSV files don’t store as compactly on disk as [Compressed] MyISAM or Archive. These… three-part article on data archiving on my own blog a while back. The benefits of purging and archiving data can be dramatic…
Post: Give me 8 hours, and I'll help you build a better application
August 29, 2009 By 4 Comments
…Archive or Purge Your Database Data archiving is crucial. There is a difference between data that your application needs now, and data…bloat and dilute your indexes and tables. Storage engines such as InnoDB also don’t have …disk and found it’d filled up with files due to an infinite loop in some code…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… decent myisam_sort_buffer_size and large myisam_max_sort_file_size otherwise recovery may be done by key_cache rather… unnoticed with MyISAM storage engine. This hidden corruption may later cause crashes wrong query results and further data corruption. Partial updates. MyISAM… to mention different load: Log tables. Now Archive storage engine can be even better. Read only data, especially packed with myisampack. This can…
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… case, InnoDB has to flush some data to be able to perform the …post, http://dimitrik.free.fr/blog/archives/2010/12/mysql-performance-analyzing-perconas…list? You could periodically check SHOW ENGINE INNODB STATUS, and see something like …3/4 of innodb_log_file_size * innodb_log_files_in_group. If you…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…most of those demand using some other storage engine like Archive… > 3. Using multiple databases Honestly I …such as > you do with directories to group files. I think this makes a lot of > sense…. Having a logical separation of data sets helps document relationships of data. There is no reason why …
Post: MVCC: Transaction IDs, Log Sequence numbers and Snapshots
December 19, 2007 By 3 Comments
…are now flushed to the data space” this means you can discard or archive logs for LSN …changes from different transactions are intermixed in the log files and many LSNs can correspond to changes …These are far from all functions which MVCC storage engines may place on these identifiers. This is …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…Innodb TableSpaces) because it does not only contain data pages – it also contain adaptive hash indexes, insert …to serve writes to these log files as IO to the log files is not aligned to the…you have fair amount of MyISAM, Archive, PBXT, Falcon or other storage engines then you will get into complex…
