… were facing the performance issue. Still MYSQL load was very high but site was not going down. Then we did some… some memory allocation setting in my.cnf file. On first day after doing memory allocation setting in my.cnf file, site performance was good… it is slow again. MySQL load is not going very high. We have also noticed that many process stay in sleeping…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… fail-over that server. Bug fixed #1035927 (Raghavendra D Prabhu). High values in variables evs.send_window and evs.user_send_window could trigger cluster crash under high load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would… was specified more than once in the MySQL configuration file (my.cnf). Bugs fixed #1160047 and #1086978 (Raghavendra D Prabhu). Donor node…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the event…-dir option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the event…-dir option was set in the [client] section of the my.cnf. Bug fixed #1155859 (Sergei Glushchenko). Fixed the upstream bug #68845…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…” primitive p_mysql ocf:heartbeat:mysql \ params config=”/etc/mysql/my.cnf” pid=”/var/run/mysqld/mysqld.pid” \ socket=”/var/run/mysqld… ones I had to define: config: The path of the my.cnf file. Remember that Pacemaker will start MySQL, not the regular… know if MySQL is already running. It should match the my.cnf pid_file setting. socket: The MySQL unix socket file replication…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… -pi -e ‘s/bind-address/#bind-address/g’ /etc/mysql/my.cnf sudo service mysql restart sleep 5 /usr/bin/mysql -u…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… way here — we focus on far more than my.cnf files. In fact my.cnf files are usually one of the smallest levers we… look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf without… topics such as monitoring, alerting, backups, caching, reverse proxies, and high availability solutions, all of which we can frequently help customers…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… not ‘pc.bootstrap=true’. Q: Can you quickly show the my.cnf settings again? A: Sure, see this post or webinar recording… many parallel threads, this means that you can achieve a high throughput despite the response time limitations. Even with parallel replication…’t store or serve data. Q: Is the configuration file my.cnf ? A: Yes. Q: If the cluster blocks write while it…
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… – 80 % # of RAM but beware of setting memory usage too high innodb_buffer_pool_size = 8000M #innodb_additional_mem_pool_size…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… 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… passive to disable any automatic failover during the process because high availability tools like mmm can cause failover if you stop…
