Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It …. In summary, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache… was especially puzzling since MySQL was not involved. The server was running with nearly 7GB of free memory but the push to…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… only 500GB. What are my options for achieving the best performance? I could by a ton of RAM, but that isn… card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the PCIe card… my database to run in memory (not actual RAM, that’s true, but much closer to memory speed than a regular SSD…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… or work around it with by fsyncing to memory (Battery or capacitor-backed write cache), etc… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication…an lower bound on performance, only a upper bound. The best performance you can expect …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the …that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls…does however keep the certification index smaller in memory. It keeps the certification interval small, which …
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… on Percona MYSQL server and found that Percona need some configuration setting regarding to memory allocation. So we did some memory allocation setting… day after doing memory allocation setting in my.cnf file, site performance was good. But from second day again performance degradation started and…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters… themselves. When the working set outstrips the available buffer pool memory but still fits into the cache device, vCache shines. Compared…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… overview of these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and EBS isn’t… contention. The performance improvements I got with Percona Server were similar to the performance improvements I saw versus stock MySQL 5.1. This…. The physical and logical database design influences greatly how much memory and disk resources are required. The application’s access patterns…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… about memory usage are quite understandable. If you configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however configure it so it consumes too much memory it may be… small queries might only barely increase memory consumption for given thread, however if table will perform complex operations such as full table…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
Last time I wrote about memory allocators and how they can affect MySQL performance in general. This time I would like to explore… of processor cores have on different memory allocators and what difference we will see in MySQL performance in this scenario? Let me share… not by MySQL. Notes regarding jemalloc version I’ve used in my tests: I’ve noted notable impact on MySQL performance after version…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory…
