… is flow control? One of the things that people don’t often expect…relaxed? There are a few settings that are relevant here, and they are all …node writing in PXC to perform better. gcs.fc_factor If fc_limit…memory. It keeps the certification interval small, which minimizes replication conflicts on a…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to a lot of buffer pool disk reads) but still small enough to fit into the cache device. In this post…, but it happens in the background, and while countdown messages are written to syslog as the operation proceeds, the device never… FlashCache. There are things that I really liked better with FlashCache, and there are other things that I thought vCache did a much better job with…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
…XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in… ROW based binlog format as well to achieve better consistency, if you have an async master <= 5... workload - it shines with small transactions but not with big ones. If you are consistently running overnight reporting…
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 34 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 28 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…
