…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters. For… vCache performance results were obtained with the default vCache configuration, I think vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…-node (on the left) vs. two-node (on the right) configuration. No surprises here, the general pattern is consistent with what….g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but nothing unexpected. So… tests setup and clarifies the scope of descriptors optimization. Server Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… few settings that are relevant here, and they are all configured via the wsrep_provider_options global variable. gcs.fc_limit… other magic that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls when flow… soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… is the world’s only open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases… by log copying thread is now configurable by innobackupex –log-copy-interval. Making the interval configurable allows to reduce the time between… #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It … malloc after the startup phase and hence its rather complex configuration. Probably most readers of this blog know (or should know…, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… performance issue. Still MYSQL load was very high but site was not going down. Then we did some R&D on Percona MYSQL server and found that Percona need some configuration setting regarding to memory allocation. So… file, site performance was good. But from second day again performance degradation started and now it is slow again. MySQL load is not…
Post: Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
March 13, 2012 By 5 Comments
…”How to Turbocharge Your MySQL Performance Using Flash Storage” (From Virident side: Shridar Subramanian and Shirish Jamthe). Running MySQL on SSD in… we will cover: Configuration and optimization techniques to fully leverage flash-based storage solutions in MySQL environments Evaluation criteria and…
Page: Consulting for MySQL
July 31, 2006 By
…: MySQL Performance Optimization and Scaling – All aspects of MySQL Performance Optimization and Scaling Consulting – Hardware and OS configuration, MySQL Server Configuration, Schema, Queries, Application Architecture, Caching etc. MySQL… for MySQL Need choosing Hardware and OS for MySQL ? Performing configuration and troubleshooting platform related issues ? We can help you designing optimal hardware configuration and…
Post: Why do we care about MySQL Performance at High Concurrency?
February 26, 2013 By 9 Comments
… if people do not really run MySQL with high concurrency does it really matter how MySQL performs with high concurrency or is it just marketing gimmicks to promote new software versions ? Performance at High Concurrency… having Apache configured to run up to 100 apache children concurrently each of which might open a connection to MySQL server… this…
Post: Basic performance and diagnostic tools on Solaris
February 14, 2011 By 7 Comments
… the MySQL blogs about basic tools to find one’s way around a Solaris system and discover the system, get fundamental performance, configuration…. To display information about processors, use psrinfo. To print system configuration (such as sysctl gives you), use prtconf and/or sysdef…
