…quorum… [ OK ] Starting fenced… [ OK ] Starting dlm_controld… [ OK ] Tuning DLM kernel config… [ OK ] Starting gfs_controld… [ OK ] …command install crmsh (crm shell from another repository) or just install pcs (Pacemaker Configuration System) [root@percona2 percona]# yum -y install…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… vCache and FlashCache. Ease of basic installation. The setup process was simply a matter of installing two RPMs and running a couple… is superior. Winner: vCache. Ease of post-setup modification / advanced installation. Many of the FlashCache device parameters can be easily modified… via /proc, I’d vote in the other direction. Stay tuned for part two of this series, wherein we’ll take…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort to… store against both a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin. Here are…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… to ask them what should be tuned in MySQL Server straight after installation, assuming it was installed with default settings. I’m surprised… 70-80% of memory often make sense for Innodb only installations. Same rules as for key_buffer apply – if you have… sec worth of updates. 8MB-16MB are typically enough. Smaller installations should use smaller values. innodb_flush_log_at_trx_commit…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… serendipitous call (thanks!) yesterday asking what would be needed to tune[1] a database for better performance. It is a question…, so keep in mind that the vast majority of MySQL installations don’t suffer from the variety and severity of problems… configuration alone. [1] I prefer to avoid the word “tuning,” because database tuning is an activity that can be done endlessly, with…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… tickets a query uses, making this parameter notoriously difficult to tune. It is important to note that this variable only comes… innodb_thread_concurrency is greater than zero. On a stock install of MySQL, here are some example queries and the corresponding…_concurrency (which is why these two variables are most often tuned in concert). To continue the example, if innodb_thread_concurrency…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… local virtualbox instance, and I tried to show the minimal installation required for XtraDB cluster. Unfortunately enough, I didn’t include…-in mysql replication are independent from each other. Q: I installed Percona as cluster database working with Zabbix (innodb), do you…’t have any specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments, you may want…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… can work with systems that are at any level of tuning, from completely untuned to a system that’s already had… of information on the box’s hardware, including RAID controllers, installed memory, and so on in the boot output. In addition… can check whether MegaCli is installed, and use it to get information about the physical drives installed; then I can find out…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… is not by design. While I try to only add tuning parameters that are absolutely necessary, PBXT is not specifically designed… is twofold: I hope that most installations can get away with setting a minimum of tuning parameters, in particular, just the cache values. On the other hand, I aim to provide expert tuning parameters for installations that…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… boring process – install, configure, tune, start/stop MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security… distribution where there are no issues with packages consistency. Unfinished installations, unresolved conflicts are so common that it’s just beyond…
