… file: -rw-rw—- 1 mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql 984628803 Nov 12 11:29… Archive storage engine using for reads – I could not find it as difference could be due to larger read_buffer_size used by MyISAM. Summary: Archive storage engine…
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… and LIMIT implementation – these can optimized but not by use of MySQL Storage Engine interface, which means it is also has to be implemented…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
…by using this significant number of tables. I still have the same view on Storage Engines – Innodb…or MySQL bugs but corruption may happen and go for long unnoticed with MyISAM storage engine. This… to mention different load: Log tables. Now Archive storage engine can be even better. Read only data,…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…mysql-5.0.51a) % ./configure ‘–disable-shared’ ‘–with-server-suffix=-community’ ‘–without-embedded-server’ ‘–with-ndbcluster’ ‘–with-innodb’ ‘–with-csv-storage-engine‘ ‘–with-archive-storage-engine… depend on many factors such as storage engines used (InnoDB will take significantly longer to …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… as CSV files and use the CSV engine so you have an …day becomes a fixed overhead of storage size. So, you actually… The benefits of purging and archiving data can be dramatic. Take…use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…. It is however bad idea to use > mysql_ functions directly as well – I would go for using mysqli object > approach. The great things… not using a NCPK and most of those demand using some other storage engine like Archive… > 3. Using multiple databases Honestly I do not see application using…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…with MySQL. There are many successful applications, using tens of thousands of tables per host and archiving great performance by doing so. Using …dependent, others correspond to Innodb storage engine or using innodb_file_per_table option in particular. 4. Not using relations This one is right…
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’
Comment: MySQL Crash Recovery
October 12, 2007 By 26 Comments
… MyISAM, MEMORY, ARCHIVE storage engines all can be faster for some workloads. Indeed you’re right many people have heard MySQL has transactions but do not bother to check it is in case you’re using Innodb tables. I never said MySQL… is for people trying to get most out of their MySQL install as well as know how to avoid the issues…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 53 Comments
… so common paths in the MySQL server – in particular Optimizer may have harder time because costs between storage engines may not be well… is quite complicated. I prefer to pick one storage engine (typically Innodb) and when use other tables when it really gives substantial gains… it gives 5% performance improvement but I can perfectly use MyISAM (or Archive) for logging. Innodb Needs Tuning As a final note…
