… packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL client to abort the connections… clients when plugin-dir option was set in the [client] section of the …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL client to abort the connections… clients when plugin-dir option was set in the [client] section of the …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…variable…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: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | INNODB_AUTOEXTEND_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT…set (0.00 sec) mysql [localhost] {msandbox} (test) > select * from var56 where variable_name=’OPTIMIZER_SWITCH’ \G *************************** 1. row *************************** VARIABLE_NAME: OPTIMIZER_SWITCH VARIABLE…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…connections is using too many MySQL server connections. Some people simply do not realize you can increase max_connections variable and get over 100 concurrent connections…
Comment: Too many connections? No problem!
March 23, 2010 By 28 Comments
Aurimas, One question one may have is how does GDB able to execute MySQL command “set max_connections=5000″ – the thing is it is not MySQL but GDB command in this case which just happen to look the same which sets global variable with max_connections name to value of 5000.
Comment: Time for Zero Administration effort at MySQL ?
January 9, 2012 By 4 Comments
…_pool_instances. These and a few other settings are usually fine in their default setting, but once you have a problem restarting… many settings (such as max_connections) can affect the total memory usage and since you really have to know how all these settings work… at configuration settings (from my.cnf or SHOW GLOBAL VARIABLES) and just tells you how much memory will be allocated for those settings.
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… possibilities were validated. Session variables There is no restriction on how large you can set per connection variables for unprivileged user which …server by simulating number of failed connections. This can be avoided by having high max_connect_errors variables but this will obviously disable …
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… to number of connections. You can get 1000s of connections a second even from as little as 100 connections, hence max_connections would be small… the first 500 max_connections + 1 for every 20 max_connections over 500, capped at 2000 Same thing. What number of max connections has to do… selection of variable default seems to be removed, while it could be needed as it is easy enough to set max_connections to over…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
Has anyone seen a situation where mysql reports max connections reached and freezes, with a bunch of processes waiting to …-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache_size = 2000M # Try number of CPU’s…=3306, # MASTER_USER=’joe’, MASTER_PASSWORD=’secret’; # # OR # # 2) Set the variables below. However, in case you choose this method, then # start…
