… snapshot of an entire database even when tables use different engine types. The API does not yet support incremental backup, but this is planned… causes instabilities that then have to be fixed. How to optimize the program without compromising data integrity is a constant question…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…performance it will give. As “SHOW TABLE STATUS” is not showing index sized in the release… I’m not sure there they are now. [-] No Clustering Index support Unlike Innodb Falcon does not cluster… say Falcon does not need clustering because of optimized read by the index. This is not the case….
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…data you’ll need in those aggregate tables, and include columns to support these queries. But beware of denormalizing … you want to build your aggregate tables to avoid joins. Watch Data Types Does your ad ID look like “…fine to use it for things that it’s not 100% optimal for. But if the costs of …
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…the tables that I have used in the benchmarks: Table ‘lineitem’: 3.8G Table ‘supplier’: 11M Table ‘orders’:…enhanced to support the possibility of existence of different join algorithms. So what does that mean… always uses BKAH (a variant of BKA). Optimizer does not try to check which algorithm is the…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…optimization. I frequently see batch jobs killing server performance overtaking buffer pool. Though full table scan is only one of replacement policy optimizations…does not lock the ‘gaps’, and it does not lock rows whose latest committed version does not…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…supported, except GROUP_CONCAT and AVG(distinct). **non-deterministic functions like RAND(),NOW(), etc, are not supported…table with CREATE TABLE .. AS SELECT. In fact, this is actually part of what the COMPLETE refresh method does… more expensive. This is an optimization which is required to …
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… role does not suite it well as well for our performance optimization works – …tables and other tricks we use when such need arises but we still can’t deny – MySQL does not handle complex queries well, being able to use only one CPU effectively on single node and no true federation support…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…these queries doing large sorts, using temporary tables or having other significant memory requirements … as images which also does not need MySQL connection open. In optimal configuration with Apache …So persistent connections are not evil but they need some MySQL support to be properly implemented…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… tool called Flexviews which supports incrementally maintaining materialized views. …This means that Shard-Query does not have to have any…OPTIMIZATIONS: * Base level table name: `aggregation_tmp#74082863` * IN list optimization enabled * Detected an IN list with 2 items * IN list compression is not…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… hot backup in many cases. Replication Support for different storage engines is a pain…does not matter). We could save a lot of CPU cycles by having storage format same as processing format. We could tune Optimizer…example one can imagine having Innodb tables which do not log the changes, hence being …
