… about how hard they have to work on I/O capacity. What does this have to do with InnoDB? Data clustering… MySQL doesn’t tend to perform well on a data warehousing workload. The nested-loop joins are not all that fast… of MySQL‘s weaknesses in some cases. Not only that, but star schemas are not intended to be fast. The star schema is…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
… –tables=art.link* –datadir=/mnt/data/mysql/ which will show something like this…PRIMARY key (which is the table by itself, as InnoDB is clustering data by …feature to address this is in XtraDB/InnoDB plugin – fast index creation. With …it would be interesting to see how it will grow with further …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… index reserves different extents from the clustered index. Q4: Does Innodb ever merges…is not serializable. PZ: Cool. This is one of little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is…be relaxed, though). The index is required for fast lookups: it can be …
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
…and how Percona Supports MariaDB. We support all variants and flavors of “MySQL” – Oracle MySQL, MariaDB… this competitive innovation is what is moving “MySQL” on a very fast pace and ensures it…software, including Percona Server, Percona XtraDB Cluster, Percona XtraBackup, and Percona Toolkit, all…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
… application compressing on application is typically better idea because …fast as each row will need to be decompressed) it also makes data easier to work with with console MySQL…run some checks to see how much compression will benefit you….own page (allocated outside of clustered index) if the whole …
Post: State of the art: Galera - synchronous replication for InnoDB
October 27, 2009 By 15 Comments
…your-mysql-high-availability-solution-%e2%80%93-the-questions/. I am not sure how … Although it also has serious drawback – our cluster is fast as fast the “weakest” node in the chain….is set of patches, and I see it is quite possible to make the same for Postgres. So MySQL-Postgres cluster setup is…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…typical use of Innodb clustering – users mailbox, clustered by (user_id,message_id). [+] Row compression Falcon uses some nice fast row compression methods…is not implemented in MySQL anyway though). Very interesting to see how this one will compare to transparent gzip page compression which is being…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…is frequently told by people with traditional database background. > Things are different with MySQL. Good design will help dictate how…clustering so table becomes hot very quickly due to data locality > once this user starts his queries. It is… disk. Because indexes are fast by storing them as fixed…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…://mysqlha.blogspot.com/2009/03/pbxt-is-fast-no-kidding.html) by Mark …clustered indexes which I mentioned in more details later. How does online backup work in PBXT, and is…MySQL Backup API which was originally implemented in MySQL 6.0. This feature is now scheduled for an upcoming version of MySQL…
Post: BoardReader - Forum Search Engine
November 29, 2006 By 13 Comments
… sites. It is easy for outgoing part as we already cluster by sites but It is hard for incoming … to use sphinx instead (it can do extremely fast parallel group-by on many servers, in google … link to search our MySQL Performance Forums Second – note the graph which shows how many results were found …
