…MySQL, you’re going to end up heavily I/O bound. Listen to any of the talks at past MySQL…define the physical order rows are stored in. That lets you choose which rows are stored close to each other, which… that really needs to be solved with intelligent engineering, instead of massive resources…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…this article, the key cache miss rate is defined as the number of misses per unit …to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM, which is more important to you, etc) and choose…is a shame. When you are new to MySQL, trying to configure my.cnf, and you have heard…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…to point to the new master. This solution works well with all the MySQL storage engines…MySQL replication. The main limitation, in term of HA, is the asynchronous design of MySQL replication which does not allow the master to…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…to the MySQL configuration. MySQL…ENGINE = InnoDB, PARTITION p8 VALUES LESS THAN (900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE…to choose a table structure with no secondary indexes. Other important things to…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
…which can be very expensive. Today I would like to… ) ENGINE=InnoDB; Why did I use this solution compared to … MySQL/System crash is painful and great to be … extra indexes are defined. The primary key…choosing url as the key. It surely makes inserts slower as they are random and page splits have to…
