… machine and you forget to change the server-id in my.cnf. You change the server-id interactively, this is an action…… it was always 1 !! There was a hidden character in my.cnf that was unvalidating the value and then it was set… usage and the replication lag… once again cacti is very helpful ! How to fix then ? There are several possibilities to fix…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 27, 2012 By 102 Comments
… your instruction. There are many error I received. Please help me! My Set up Enviroment is: All server use CentOS 6.2…=”/usr/local/bin/mysqld_safe” OCF_RESKEY_config_default=”/etc/my.cnf” OCF_RESKEY_datadir_default=”/var/mysql” OCF_RESKEY_user_default…/mysqld_safe” OCF_RESKEY_config_default=”/usr/local/mysql/etc/my.cnf” OCF_RESKEY_datadir_default=”/usr/local/mysql/data” OCF_RESKEY…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… user mysqld will now run under (check ‘user’ setting in my.cnf also) (see here if this is not clear) Now, before…}’ could for instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to point mysqld… to the function grow significantly accross the snapshots. This example helped to pin down a memory leak bug on a filtered…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… their my.cnf file by default. One example is Debian and its variants. Furthermore the default my.cnf files of MySQL like my-large.cnf, my-innodb-heavy-4G.cnf and so on have the thread_concurrency enabled with a tune advice helping… get better performance. If you have the variable in your my.cnf don’t panic because it does nothing and you’ve…
Comment: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
… what value, and when. I’ve already found this to help out in the initial problem you describe: what happens when… exactly which my.cnf files are being used by the server (I hate hunting them down). Is it /etc/my.cnf? /etc/mysql/my.cnf? /usr/local/mysql/data/my.cnf? /var/lib/mysql/my.cnf?
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
… a trouble and need your help! i setup percona cluster in vm, if in file /etc/my.cnf,i add wsrep_cluster_address=gcomm:// to fill it ,the mysql server will not running [root@mysql1 ~]# vi /etc/my.cnf… crashed, something is definitely wrong and this may fail. Please help us make Percona Server better by reporting any bugs at…
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
… different database server and here is where Percona Playback can help us. Percona Playback is a new tool that can replay… tool you can measure how a database upgrade, change on my.cnf or schema change can affect the overall performance of your… meassure the impact of my.cnf changes replaying a slow query log. The service starts with an empty my.cnf configuration so all parameters…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… names may be trademarks of their respective owners. Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement… not work properly currently, I needed to change it in my.cnf and restart the nodes) wsrep_provider_options = “pc.ignore_quorum… by adding wsrep_provider_options = “pc.ignore_sb = true” in my.cnf Then we can insert in both nodes without any problem…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set… which options a program supports, run the program # with the “–help” option. # The following options will be passed to all MySQL…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances.*EDIT… 20 for best results. There is a helpful utility (included in the image) to help configure the cluster and it uses a….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket…
