…high-performance systems to do this work. Let’s see some ways you can build the functionality you need and get the performance…. Avoid operations that update huge chunks of aggregated data at… problem is that MySQL doesn’t tend to perform well on a…disk drives with much less memory, or even with 10-15x…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the box’s hardware, including RAID controllers, installed memory, and so on in the boot output. In …, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first … analysis, and also might show me things like huge tables that should be archived, tables that I…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
…cores you can get, and I/O performance can be highly variable. You can mask I/O … and logical database design influences greatly how much memory and disk resources are required. The application’s…is that there is not a huge performance difference between EC2+EBS+MySQL versus RDS, in most cases, unless…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…performed on table2. Of course this could mean a lot of random lookups in case the dataset does not fit into memory…huge difference when the workload is IO bound and the query time drops from 2534.41s down to under a minute. MySQL…obvious improvement is shown by the high numbers of Innodb_buffer_pool_…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…MySQL 5.6, when the workload fits entirely in memory, because there is no extra cost for memory access at random locations versus memory…performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting high…. Conclusion There is a huge speedup when the workload is…
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
…system which needs high insertion rate for data which generally fits in memory. Last time I…as room for more performance optimizations. Dmitri has good suggestions on tuning MySQL 5.5 and…important. Second thing – Partitioning. Unfortunately MySQL 5.5 leaves the huge bottleneck for write workloads in …
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…, more) using of MySQL and DRBD as a high availability practice. …performance. In the large databases I run in production relaying on MySQL Replication for HA I often have 15+ minutes reply of Innodb Transactional log which would be a huge…not use this option wast memory and CPU cycles on double …
Comment: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
… of cache memory you have.” YES. Thank you! I was waiting form SOMEONE to bring up the problem with MySQL not using… Memcached you could literally use all this memory and you’d see a HUGE boost in performance. Were’nt you JUST saying the other day that the Linux page cache wasn’t very high performance?
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…high load situations where INNODB is using most of the system’s memory the kernel can decide (incorrectly) to swap out MySQL… large portion of physical memory. There is also third alternative – “huge pages” which can … you can get better performance by using couple of MySQL Servers on single node. …
Post: Living with backups
November 6, 2008 By 28 Comments
…price may actually be rather high. And the more effectively the… runs, it causes a huge number of requests being …memory access is way faster than any disk access, even with the fastest drives or RAID configurations, the performance… for performance problems to happen on the working instance of MySQL. …
