… user variables, huge network buffer (can grow up to max_packet_size per connection) are all connection buffers and so if you close connection MySQL … Lock system 318875832 (318747272 + 128560) Recovery system 0 (0 + 0) Threads 425080 (406936 + 18144) Dictionary memory allocated 2623331 Buffer pool …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… the alert spam. I’ve spoken to a lot of users with monitoring systems over the years, and everyone says that… this error appropriately. The pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_connections too closely, which can give…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_connect_errorsblogpercona.commanual max_connectionsblogpercona.commanual max_delayed_threadsblogpercona.commanual max_error_countblogpercona.commanual max_heap_table_sizeblogpercona.commanual max_insert_delayed_threadsblogpercona.commanual max…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
…MySQL server connections. Some people simply do not realize you can increase max_connections variable and get over 100 concurrent connections with MySQL…Connections with MySQL, it however might not be overly efficient – managing large number of threads may be a bit more expensive. Threads…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…connections as in MySQL. This is very helpful for measurement as otherwise we might not catch some long running connections…11:26 # User@Host: msandbox[msandbox] @ localhost [] # Thread_id:…pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30 wait_timeout=15 max_allowed_packet=64M default-…_flush_log_at_trx_commit=2 [mysql.server] user=mysql basedir=/var/lib thread_concurrency = 8 max_allowed_packet = 64M [mysqld_safe] log-…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’Threads_cached’, ’0′ ‘Threads_connected‘, ’260′ ‘Threads_created’, ’124272′ ‘Threads_running’, ’3′ ‘Uptime’, ’4433556′ # top 18:38:40 up 175 days, 2:56, 1 user, …/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…mysql reports max connections reached and freezes, with a bunch of processes waiting to finish. Also, mysql…thread_cache = 40 max_connections=500 query_cache_size = 2000M # Try number of CPU’s*2 for thread_concurrency thread…
Post: Too many connections? No problem!
March 23, 2010 By 28 Comments
…mysql_sandbox5087.pid) \ -ex “set max_connections=5000″ -batch [Thread debugging using libthread_db enabled] [New Thread 0x2ad3fe33b5c0 (LWP 1809)] [New Thread 0x4ed19940 (LWP 27302)] [New Thread…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED…
