…how…to run: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql…max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…mysql-status plugin to alert when the server’s Uptime variable is too small. The server is approaching max_connections. Overflowing the max_connections setting…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
…to the tools might be needed on other platforms. The rest of this blog post is about how to set…in MySQL, and they usually begin microscopically and get worse over time, sometimes abruptly worse. I’ll try to…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…Connection Related Allocations Another set of buffers correspond to connections – orphaned prepared statements, user variables, huge network buffer (can grow up to max_packet_size per connection…connection. In Percona Server you can do better as you can query temporary tables too: mysql…
Post: Too many connections? No problem!
March 23, 2010 By 28 Comments
…mysql_sandbox5087.pid) \ -ex “set max_connections…to clear the current input statement. mysql [localhost] {msandbox} ((none)) > select @@global.max_connections; +————————–+ | @@global.max_connections | +————————–+ | 5000 | +————————–+ 1 row in set…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
…MySQL parameter back_log which has default value of just 50. You may want to set it to…how MySQL accepts connection. There is single main thread which is accepting connections coming to LISTEN sockets. Once there is connection coming it it needs to…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…connections are killed on the demoted master to avoid replication conflicts All slaves are in…slaves: A mandatory to set this to false otherwise Pacemaker will stop MySQL on a …how Pacemaker defines an asymmetrical resource having a master and slaves. The only thing that may change here is clone-max…
Comment: Why MySQL could be slow with large tables ?
December 17, 2012 By 141 Comments
…how to solve performance issue in mysql…mysql socket=/var/lib/mysql/mysql.sock user=mysql init_connect=’SET collation_connection = utf8_general_ci; SET NAMES utf8;’ default-character-set=utf8 character-set…
Comment: Are PHP persistent connections evil ?
March 27, 2008 By 32 Comments
how to increasr max connection limit in mysql i am getting error too many connection as i am using Shared hosting ,. how to change the setting in Cpanel
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By 2 Comments
…in my research to be frequent, severe, or subtle causes of problems in MySQL systems. They are intentionally not generic because I wanted to…connected is approaching max_connections, which can be inconvenient to solve in some environments However, there’s no reason not to…how to…
