…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
…, ARCHIVE, CSV are other good examples. There are also storage engines out where to read sensor data, talk to memcache or external search engine . As MySQL 5… by use of MySQL Storage Engine interface, which means it is also has to be implemented through hacks. In any case this is very interesting how…
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…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…to use the example of search engine…to think about how to avoid enormous tables that are hard to…to each other makes me think of putting cards next to each other and shoving). Archive…use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL…
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… MySQL server – in particular Optimizer may have harder time because costs between storage engines…to MyISAM because it gives 5% performance improvement but I can perfectly use MyISAM (or Archive…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…to beat MySQLi in speed. It is however bad idea to use > mysql_ functions directly as well – I would go for using…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: The tool I've been waiting for years
March 18, 2008 By 10 Comments
…how to use the function so you can write real stuff. For example using this tool MySQL…to implement cache content tracking for storage engines which cache everything in their own cache memory – Innodb, Falcon, Maria. Having information about how…
Comment: MySQL Crash Recovery
October 12, 2007 By 26 Comments
…ARCHIVE storage engines all can be faster for some workloads. Indeed you’re right many people have heard MySQL…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…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
…to leave space for other MySQL needs while factoring this in. The next step would be to decide How… may want to do different VM memory adjustments. You may want to make MySQL to use Large Pages for … you have fair amount of MyISAM, Archive, PBXT, Falcon or other storage engines then you will get into …
