…_comment | Initialized (0) | | wsrep_cert_index_size | 2 | | wsrep_cluster_conf_id | 18446744073709551615 | | wsrep_cluster_size | 1 | | wsrep_cluster_state_uuid…_comment | Initialized (0) | | wsrep_cert_index_size | 2 | | wsrep_cluster_conf_id | 18446744073709551615 | | wsrep_cluster_size | 1 | | wsrep_cluster_state_uuid… not work properly currently, I needed to change it in my.cnf and restart the nodes) wsrep_provider_options = “pc.ignore…
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 12 Comments
Recently some of my fellow Perconians and I have noticed a bit of an … nproc/nofile limits in /etc/security/limits.conf or even this new 90-nproc.conf file is that these files are used… server’s limits are sufficient. Edit 90-nproc.conf (or create 91-mysql.conf) to set the desired process/thread limits to…
Comment: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… 5.6 on a system with 32 GB of memory: My sysctl.conf looks like this: # Memory optimization vm.nr_hugepages = 14336 vm.hugetlb_shm_group = 27 kernel.shmmax = 8589934592 kernel.shmall = 4194304 My…: 0 Hugepagesize: 2048 kB My limits.conf looks like this: mysql soft memlock unlimited mysql hard memlock unlimited My my.cnf looks like this…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… show folks what they should be watching (at least from my opinion, this is subject to change!). First, let’s take… will not allow database operations. cnf This is wserep_cluster_conf_id — the version # of the cluster configuration. This changes every… replication speed at all. Conflct Replication conflicts, as described in my last post. lcf is local certification failures, and bfa is…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
… any other conf file other than /etc/my.cnf [root@tstlx1 mysql]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… want to upgrade the OS, but otherwise keep it simple. My suggestion? Plan on allocating partitions roughly as follows, based on… /dev/sda3 27344896 856422399 414538752 83 Linux Several months ago my colleague Aurimas posted two excellent blogs on both the theory… make it permanent, add ‘elevator=
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 13, 2011 By 38 Comments
… config mechanisms with monolithic single static files (e.g. httpd.conf). Debian and Ubuntu increasingly use .d folders, meaning it’s… across OS releases. I thought I’d double check on my RHN account to see what RH are pushing for RHEL… any official package info; all par for the course in my experience. RH’s site threw a “redhat.com is temporarily…
Comment: Percona XtraDB Cluster reference architecture with HaProxy
December 18, 2012 By 63 Comments
… your “wait_timeout” value of MySQL (28800 by default). In my case, I have set the MySQL “wait_timeout” to 3600….ipv4.tcp_tw_reuse” to 1 in your /etc/sysctl.conf file (don’t forget to apply with “sysctl -p” 
). You…
Comment: Getting MySQL Core file on Linux
April 19, 2012 By 1 Comment
I was trying to do the same but adjusting to my environment (and also puppetising) and could not get things to… a couple of the proc changes via sysctl (/etc/sysctl.conf) that has the advantage of being durable compared to changing…
Comment: Why you should ignore MySQL's key cache hit ratio
December 2, 2010 By 28 Comments
Hi, I am not an expert at mysql. Can you help me optimize my server? (Might give me a conf file example?) 
Thies are te informations I have about mysql: [Ed: deleted output of a tuning script]
