…thing that has come up here, and that is the importance of the size of the buffer used for sorting the secondary key tuples. If the…the optimizer chooses the wrong query execution plan. Let’s take a look at what are the good…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… line yet they are seen in one of the lines below. The most likely cause for Innodb run …thing about memory leaks is because it is memory which is allocated and forgotten about, unless it is very small…good tools to detect memory leaks like valgrind are too slow to run in production. So the best thing…
Post: Small things are better
October 8, 2006 By 15 Comments
…. The good practice to approach this kind of problem is first to have enough redundancy. I always assume any component, such as piece of… full redundancy for everything (and probably even if you do) the good idea is to keep your objects smaller so if you… reason to keep tables small, so you do not have to use complicated scenarios to do simple things. Assume for example you…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…, which significantly ( Graph 1) reduces dataset and decreases the amount of IO operations. The benefit of small size is also that TokuDB can keep in… not so good. I think there we meet one of current restrictions of TokuDB – SERIALIZABLE isolation level for transactions. Speaking about restrictions, the current… appears to be positioned to do quite good at. There are operation issues which make things more complex and, probably, I would…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… a lot of interesting and complex things to think about here and research further: Most writes are less than 4k, but the operating…’s possible that even if the largest write is quite small, a small log buffer size wouldn’t be good and could cause additional lock contention. (There is a single mutex around the…
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…a tremendous amount of information, from which you can compute lots of other things. And by the way, it’s a good thing the two basic …about the same number of extra completions from the previous interval. And anyway, the number of requests that span the transition between seconds will be small. …
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… the good time too. Even though a lot of bugs being found and reported only small fraction of them apply to any given user. The bad thing… in Enterprise version have tendency to stay for long time. The good thing about this item is – it is easily fixable. Just get… very good in terms of quality for version having first public release as we tested it back in April. The Good News in the End The good…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… of it (assuming you configure the file system correctly). I would however mention couple things…the file system. The goal is to write and read as little as possible. If you gonna be writing small…the start of the stripe element. In addition to setting correct options for pvcreate it is also a good…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
…’ll have web server crashes and this sort of things. You can ether clone web servers from template…) per box (which is probably bad idea anyway). The good use for such extra memory is probably caching -… “Services” – these could be small enough to be single shared box (or pair of shared boxes for HA)….
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…of concept, I’ll built 2 m1.small instances, fell free to use other types. At the time I wrote this, the…. The first thing to is to set up the hostname on both host. Heartbeat identifies the…the configuration file per say. On both host, the chosen key in the authkeys file must be identical and good…
