…() function leveraging zlib to provide compression of data. MySQL’s Archive storage engine. Tooling The tooling phase consisted of producing scripts to… before attempting a table checksum. #57188 Repair tools will not function on Archive tables. #62054 Summary Archive in this instance is the solution…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and … parts of partitioning, such as maintenance and repair commands, that essentially negate the benefits of … back. The benefits of purging and archiving data can be dramatic. Take It Easy …
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… surprises. First – if you have many tables which are being repaired, each may allocate myisam_sort_buffer_size and MySQL could crash or go swapping. Second – table will be locked while repair is going. If this is frequently used table you may… requirements, not to mention different load: Log tables. Now Archive storage engine can be even better. Read only data, especially packed with…
Comment: Should you move from MyISAM to Innodb ?
February 1, 2010 By 59 Comments
…innodb file-per table. Our “Database File-Per-Table Archives” web site summarizes like this: “31 Hosts 90 …tables. Since every machine is a dedicated instance, mixing engines is not an issue. All DBs are fronted …one of the slaves the new master. We then repair/reload the new master and SYNC it from …
