Perguntas & Respostas

queria fazer isso aqui mais nao sei se funciona no windows ta bem ou so pra linux

Eu fiz o seguinte para melhorar a performance do MySQL.

Editei o arquivo my.cnf:

# vi /etc/mysql/my.cnf

Adicionei estas linhas logo após a entrada [mysqld]:

set-variable = max_connections=1000
set-variable = max_connect_errors=1000
set-variable = wait_timeout=300

Significado das variáveis:

* http://dev.mysql.com/doc/mysql/en/server-system-variables.html


* wait_timeout = tempo máximo em segundos que o servidor aguarda antes de fechar uma conexão sem atividade.
* max_connect_errors = If there are more than this number of interrupted connections from a host, that host is blocked from further connections. You can unblock blocked hosts with the FLUSH HOSTS statement.
* max_connections = The number of simultaneous client connections allowed. Increasing this value increases the number of file descriptors that mysqld requires. See section 7.4.8 How MySQL Opens and Closes Tables for comments on file descriptor limits. Also see section A.2.6 Too many connections.


Reiniciei o MySQL:

# /etc/init.d/mysql reload