… back. The benefits of purging and archiving data can be dramatic. Take It Easy On Replication Building … can be overcome, but how much time do you have? And the gains are simply limited by some of MySQL… queries that read a lot of rows — MySQL can‘t handle too many of those at once. Aside from …
Post: How InnoDB handles REDO logging
February 3, 2011 By 19 Comments
… transaction log. The InnoDB transaction log handles REDO logging, this is the …MySQL configuration and hardware will affect the speed at which InnoDB can log. You can… the event of a MySQL crash the data will still be consistent, … which has much faster access than the underlying disk(s). How are the…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
…itself. It’s just that MySQL can‘t tolerate these weaknesses very… due to the way InnoDB handles I/O. If you …how much memory and disk resources are required. The application’s access patterns can be just as powerful a lever. Thus, careful design can…but if you can fit your working set of data into the…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…data that I showed how to maintain cheaply in the previous post. Here are some things we can do: Plot the data…’s just so much you can do with arrival …MySQL servers I work with when they’re running a simple read-mostly workload with most data…agree? Suppose the server handles 20k requests per second…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… that you can fail over in both directions. Aside from MySQL Cluster,… guarantees against data loss if mysqld crashes. And you can use the standby…can‘t load the pair of servers more than a single server can handle. (You can…, it can be completely unusable for a long time. To measure how much this …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
… or blogs you probably heard complains about MySQL being unable to handle more than 1.000.000 (…inner works of MySQL. If you design your data wisely considering what MySQL can do and what it can‘t …how much having data in memory changed things here is small example with numbers. If you have your data …
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… this solution is affected by how much the slaves were behind … handles for read and write operations, this HA solution can … from writes Supports MyISAM Can lose data Caches on failover …MySQL servers lags behind too much, its read VIP will be moved to another server. As a conclusion, replication can…
Post: Using UNION to implement loose index scan in MySQL
August 10, 2006 By 15 Comments
…data from the index. MySQL can…can give a hand to MySQL Optimizer and change the query so it can handle it well…. use UNION: mysql…much more complicated MySQL is able to execute it much faster, delivering us expected performance. You can…
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
… also a raising concern how long it can survive. As we know, a MLC NAND module can handle 5,000-10,000… we can expect under a tpcc-mysql workload. I put 32 users threads against 5000W dataset (about 500GB of data on… know and 2. A throughput on regular RAID is much less than on SSD and you do not know…
