Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

typical max-connect-errors mysql

/* 
In the case of active connections using temporary/memory tables, 
memory usage can go even higher. 

On systems with small RAM or with a hard number of connections control on application side:
max_connections = 100-300. 

Systems with 16G RAM or higher: 
max_connections = 1000

Per-connection buffer should have good/default values while on some systems we can see 
up to max_connections = 8000
*/
Source by www.percona.com #
 
PREVIOUS NEXT
Tagged: #typical #mysql
ADD COMMENT
Topic
Name
2+3 =