… instance and a minimally tuned MySQL 5.6 instance running the memcached plugin. Here are some details about the test: Minimal hardware (vBox…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql… to date without needing to use wsrep_causal_reads. It minimizes the expense of certification by keeping the window between new… smaller in memory. It keeps the certification interval small, which minimizes replication conflicts on a cluster where writes happen on all…
Post: Scaling to 256-way the Sun way
November 11, 2008 By 13 Comments
… 256 threads ? Especially with the goal of “Do it with minimal tuning i.e as close as possible as out-of-the…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically designed to mock and…, we can further assume the following: It is good to minimize Key_reads because they are slow and cause random disk…) apply to all types of ratio-based and counter-based tuning techniques. Summary Major points in this article: Counter ratios are…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… help to speed up allocation,purging of the dirty pages, minimize impact of the memory fragmentation is so significant that becomes… the query processing. I believe that both allocators can be tuned to handle such cases better – for instance allocate more arenas…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… my local virtualbox instance, and I tried to show the minimal installation required for XtraDB cluster. Unfortunately enough, I didn’t…’t have any specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments, you may want…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 59 Comments
… integrity is a MUST – you should not use MyISAM. If minimal to no loss of data on a system crash is… query speeds, tables which are easily maintained, is more easily tuned and a system that will run even when things aren…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
… sniffing would be very appreciated — libpcap allows the user to tune this exchange, so if you have suggestions on how to…’ve performed tests on servers with high loads and observed minimal resource consumption. I personally have been running it for many…
Comment: MySQL on OSCON
July 30, 2007 By 13 Comments
… seeing you talk, although I would have preferred something about tuning and performance analysis to a survey of not-quite-ready… I’m sure they did the best they could to minimize conflicts. Don’t take it as a lack of interest…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…. It may be as simple as adding few indexes and tuning MySQL Server settings. It is more the question of knowing… be too much business for us, we do not have minimal number of hours at all. Large number of such jobs…
