… file: -rw-rw—- 1 mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql 984628803 Nov 12 11:29… 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
…MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows third parties to create their own storage engines… databases. MEMORY storage engine is old timer of this type, ARCHIVE, CSV are other good examples. There are also storage engines out where…
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…/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…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… bad memory OS or MySQL bugs but corruption may happen and go for long unnoticed with MyISAM storage engine. This hidden corruption may… 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
…-storage-engine‘ ‘–with-archive-storage-engine‘ ‘–with-blackhole-storage-engine‘ ‘–with-federated-storage-engine‘ ‘–without-bench’ ‘–with-zlib-dir=bundled’ ‘–with-big-tables’ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… readers ! Now back to HardCore MySQL business – foreign Keys. MySQL supported Foreign Keys for Innodb for many…cases 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 will …
Comment: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 14, 2007 By 37 Comments
…=complex \ –with-comment=\”MySQL Community Edition – Standard (GPL) – build www.mysqlperformanceblog.com\” \ –with-server-suffix=’%{server_suffix}’ \ –with-archive-storage-engine \ –with-innodb \ –with-big-tables I took it from generic mysql.spec file from MySQL release, so our RPMS…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… Store optimization, and I’m now on my own, offering MySQL and LAMP Consuilting Services. 2. Not using auto_increment functionality… are different with MySQL. There are many successful applications, using tens of thousands of tables per host and archiving great performance by… are OS and File System dependent, others correspond to Innodb storage engine or using innodb_file_per_table option in particular. 4…
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… in case you’re using Innodb tables. I never said MySQL is for everyone. But this blog is for people trying to get most out of their MySQL install as well as know how to avoid the issues…
Comment: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 13, 2007 By 37 Comments
…MySQL binary release: ./configure ‘–prefix=/usr/local/mysql‘ ‘–localstatedir=/usr/local/mysql/data’ ‘–libexecdir=/usr/local/mysql/bin’ \ ‘–with-comment=MySQL…-big-tables’ \ ‘–with-yassl’ ‘–with-readline’ ‘–with-archive-storage-engine‘ ‘–with-innodb’ ‘–with-extra-charsets=complex’ ‘CC=gcc’…
