…the same page multiple times. Consider if you have a small buffer pool and a very large number of rows from… is slow as compared to MySQL 5.6. Next interesting thing are the last two columns of the table above and the… now it looks like Nested Loop Join is a much better general purpose join algorithm.
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… tables can take memory. There are implicit MEMORY tables which are allocated for query execution, …connection. In Percona Server you can do better as you can query temporary tables too: …thing about memory leaks is because it is memory which is allocated and forgotten about, unless it is very small…
Post: Small things are better
October 8, 2006 By 15 Comments
… have your recovery plan this kind failures. This is one thing you better to have backups for. Backups however take time to… reason to keep tables small, so you do not have to use complicated scenarios to do simple things. Assume for example you… small tables. Not to mention splitting 500 tables to several servers will likely be easy than splitting one big one. There are…
Comment: Why you don't want to shard.
August 14, 2009 By 33 Comments
… – databases in TB range are often not fun in MySQL due to challenges with backups and expecially things as alter table. http://www.mysqlperformanceblog.com/2006/10/08/small-things-are-better/ With backups – the concern is…
Comment: Small things are better
March 25, 2008 By 15 Comments
[...] After following the scale up path (i.e. buy bigger boxes) for a while now, we definitely need to scale out as things start to become “unhandy” and simply HUGE. (See small things are better) [...]
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… things I don’t usually see. Anything out of the ordinary or out of proportion. These things are often…without seeing all the comments, which a) are often a small novel, b) often say what the sysadmin… we’re showing, and why the proposed modifications are better. If the client approves it, we may make…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… many others however onsite consulting is just better understandable by management or considered less risky… there to change things rather than changing things ourselves. We love these small project which …and sometimes there is simply customer impression things are taking long, even though we were …
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…two things are bad advice. Problem 1: Ratios don’t show magnitude Ratios of counters are …are so small. The second server has been online practically forever, and that’s why its counters are…buffer_size setting, but there are many unscientific approaches that are better than ratio-based tuning. …
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… administration thing and I would like database to manage things for me but it should first prove it can do it better than… you find Falcon or Innodb behavior better still prepare for this to be area where things are different and your application may need… memory to hold all transaction changes. I agree most transactions are small and should be fine but if you have long running…
Post: Sharding and Time Base Partitioning
March 14, 2008 By 12 Comments
…significantly for reads by using caching (if things are accessed frequently they are served from cache) but you … on table (or partition) level to get better “clustering” – because data is usually cached by … level. Keeping Hot and Production Critical dataset small you can both make system to perform …
