… stored in database focusing on delivering high performance for large databases. We look at performance properties of MySQL build in full text search functionality…. It also contains some multithreaded high performance programming tips which should be of general interest. Download Advanced Innodb Optimization MySQL Users Conference 2005, Santa…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…against (more, more) using of MySQL and DRBD as a high availability practice. I personally think…further degraded performance. In the large databases I run in production relaying on MySQL Replication for…ensured consistency – MySQL Replication can out of sync – and there is bunch of tips in …
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
… by a single mutex. On servers with many cores, a high volume of queries can cause extensive mutex contention. Percona Server… cache stampedes are essentially the cause of the unpredictable performance of the MySQL query cache, since the rate of invalidation can not…-compute, and your website performance is dependent on your cache, then you could have a serious performance problem if your cache is…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
… especially together with LIMIT is often the cause of MySQL Performance problems. Here is what you need to know about…I know on high end custom search solutions can be developed, but if we stick to simple MySQL using …be just 5 in this case. Many of the tips I’ve mentioned here work for ORDER BY …
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
… public road map either. Though this is just tip of the iceberg of not so helpful or … to tell you why operation could not be performed (read error, out of file descriptors etc). In … engine interface Sun/MySQL spends some time to make things consistent. There should be general high level error …
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
… pain) and 37Signals When doing Performance Audit we tend to …MySQL redundancy for very high quality/high scale applications. I’ve seen applications having no downtime running for years on single MySQL…tip and do not complicate beyond the need. You may start with couple of replicated nodes for high…
Comment: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
…’ve seen great speed improvements using just these tips alone. What I don’t see here …set your buffers and settings too high and restart your mysql server, mysql wont instantly complain. What I …slow. This can seriously impair your performance! My only wishes for mysql would be that they would allow…
Post: Why you don't want to shard.
August 6, 2009 By 33 Comments
…Optimize everything else first, and then if performance still isn’t good enough, it…, and move them onto their own MySQL server. Partition-by-function keeps…are overloaded while others are not.(Tip: There are a few famous cases of… exist on?”. It’s a highly scalable architecture, and once you write…
Comment: How we work on High Performance MySQL Second Edition
November 12, 2007 By 12 Comments
… be reading about something that could give me a huge performance increase only to find the disclaimer at the end that… some of our own tricks both inside and outside of mysql for this purpose such as making clever use of distributed… deep voodoo with mysql binlogs, but I am hoping the second edition will give a lot more tips for when high availability and…
