… 310MB 40% better than compressed by gzip. I wish Archive storage engine would specify archiving method and compression level. Some people may like fast…_size used by MyISAM. Summary: Archive storage engine does compresses your data and should be good for log storage or storing something which needs…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… other databases. MEMORY storage engine is old timer of this type, ARCHIVE, CSV are other good examples. There are also storage engines out where to read sensor data, talk to memcache or external search engine…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…’ ‘–with-ndbcluster’ ‘–with-innodb’ ‘–with-csv-storage-engine‘ ‘–with-archive-storage-engine‘ ‘–with-blackhole-storage-engine‘ ‘–with-example-storage-engine‘ ‘–with-federated-storage-engine‘ ‘–without-bench’ ‘–with-zlib-dir=bundled’ ‘–with…’ ‘–with-ndbcluster’ ‘–with-innodb’ ‘–with-csv-storage-engine‘ ‘–with-archive-storage-engine‘ ‘–with-blackhole-storage-engine‘ ‘–with-example-storage-engine‘ ‘–with-federated-storage-engine‘ ‘–without-bench’ ‘–with-zlib-dir=bundled’ ‘–with…
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… performance requirements, not to mention different load: Log tables. Now Archive storage engine can be even better. Read only data, especially packed with…
Comment: 5.0.75-build12 Percona binaries
January 26, 2009 By 18 Comments
…-b12′ ‘–without-embedded-server’ ‘–with-innodb’ ‘–with-csv-storage-engine‘ ‘–with-archive-storage-engine‘ ‘–with-blackhole-storage-engine‘ ‘–with-federated-storage-engine‘ ‘–without-bench’ ‘–with-zlib-dir=bundled’ ‘–with…
Comment: MySQL Crash Recovery
October 12, 2007 By 26 Comments
… both speed AND safety in many cases. Though MyISAM, MEMORY, ARCHIVE storage engines all can be faster for some workloads. Indeed you’re…
Comment: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 14, 2007 By 37 Comments
…) – build www.mysqlperformanceblog.com\” \ –with-server-suffix=’%{server_suffix}’ \ –with-archive-storage-engine \ –with-innodb \ –with-big-tables I took it from generic…
Comment: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 13, 2007 By 37 Comments
…-dir=bundled’ ‘–with-big-tables’ \ ‘–with-yassl’ ‘–with-readline’ ‘–with-archive-storage-engine‘ ‘–with-innodb’ ‘–with-extra-charsets=complex’ ‘CC=gcc’ ‘CXX=gcc’
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… 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…
