…to change the replication topology when using GTID-based replication. That will show where GTIDs shine and where… can find part one here. Our goal will be to go from setup #1 to … can be read in the auto.cnf file in the datadir). So the… of course, but very poor in my opinion: look for the binlog file…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…to Galera is existence of a replication feedback mechanism, unlike anything you find in standard async MySQL replication. It is my…therefore time-consuming to the application. How to tell if flow control is happening and where it is … Ops Bytes Flow Conflct time name P cnf # name cmt sta Up Dn Up Dn …
Post: How to start a Percona XtraDB Cluster
January 29, 2013 By 10 Comments
… find any node running the cluster, in that case mysqld failed to start. To avoid this, when all nodes where down and you wanted to… nice feature, especially for people that didn’t want to modify my.cnf after starting the first node initializing the cluster or people… start –wsrep-cluster-address=”gcomm://” As there is no need to modify my.cnf, this is how I recommend to do it.
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
… will not allow database operations. cnf This is wserep_cluster_conf_id — …performance issues where I noticed that the Ops and Bytes went to Zeros …were SENT from this node. Handy to find the node slowing the others down… I had to decrease my table size from 250k to 2.5k to start seeing replication…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB’s buffer pool. For this, you need to find a way to tell Linux to keep a small OS… showed up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size 10624987, used…
Post: Win a free ticket to RailsConf!
May 15, 2011 By 10 Comments
… as a consolation prize. Here’s the catch: you have to find at least one thing wrong with the following typical logrotate… password you have to create a # /root/.my.cnf configuration file with the following # content: # # [mysqladmin] # password =
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… will fail to start on a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try…/run_worker to contain the following: #!/bin/bash while [ 1 ] do ./worker >> /dev/null 2>&1 < /dev/null done; Where to find the images….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…will find lots of advice on “tuning by ratio,” including phrases such as “The ratio of key_reads to… very slow relative to other parts of the computer. And here’s where I return to what I called …is a shame. When you are new to MySQL, trying to configure my.cnf, and you have heard guidance that seems …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… people fail to provide any reasonable answer to this question, and how many servers are where in … not going to grow dramatically do not oversize innodb_buffer_pool_size you might find better … contains bunch of sample my.cnf files which may be great templates to use. Typically they would …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… from /etc/my.cnf. I’ve seen a lot of cases where there’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The way to find this out is to look at…
