… (0.00 sec) Now let’s see how performance is affected when turning expand_fast_index_creation on. Here and in later examples… for InnoDB tables and thus, is just a special case of the previous one: mysql> SET expand_fast_index_creation=OFF; Query OK… picks such an index as the clustered one. References: Peter’s post MySQL bug #57583 MySQL bug #49120 Fast Index Creation page in Percona…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… Similarly, MySQL replication is an asynchronous process and although it is fairly fast at transferring data between the master and the slaves, there is … Good MySQL DBA + strong Sysadmin skills NDB Cluster Very high, Specific NDB knowledge, strom MySQL skills and strong Sysadmin skills 7. How deep …
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
…how people tend to use MySQL in modern applications and it stroke me in many cases MySQL is…processing your request, but you get reply fast because hundreds and thousands of CPUs … the roadmap. Indeed MySQL has MySQL Cluster but it is quite different. MySQL Cluster at this point is a cluster in terms …
Page: Consulting for MySQL
July 31, 2006 By
…MySQL Replication, Active-Passive clustering, DRBD, MySQL Cluster, Load balancing and other tools. MySQL Replication Advanced MySQL…MySQL Want your developers to learn MySQL best practices ? How to work with large data sets in MySQL or how… curve is as fast as possible. Data Recovery for MySQL Lost …
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…, which is just like normal master-slave replication except that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the best general-purpose way to get fast failover and a bunch… can be completely unusable for a long time. To measure how much this really matters, I did some tests for a…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…can then compare using MySQL to using MySQL + Memcached, and then…cluster, more memcached. We need to cover up the databases inefficiencies to ensure that our application scales. The problem is… loves memcached, it’s simple, fast, and just works. When…memory at it!! How can that be! Memcached is not a …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… it is important to examine the differences in size. This will give us some interesting information about how…file-size=128M innodb-open-files=1000 innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead…-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster from 1…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… 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 17 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 …
