coloca no tey /etc/my.cnf isso: [client] port = 3306 socket = /var/lib/mysql/mysql.sock
[mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking skip-innodb skip-bdb set-variable = key_buffer=384M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=8 set-variable = myisam_sort_buffer_size=64M set-variable = thread_concurrency=4 server-id = 1 set-variable = max_connections=1300 set-variable = connect_timeout=50 set-variable = wait_timeout=1800 set-variable = interactive_timeout=1800 set-variable = max_user_connections=1200 set-variable = max_connect_errors=100 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable = key_buffer=256M set-variable = sort_buffer=256M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=256M set-variable = sort_buffer=256M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout Vinicius Maciel Simchak ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <Freebsd@fug.com.br> Sent: Wednesday, April 13, 2005 3:22 PM Subject: [FUG-BR] Servidor Mysql > Boa tarde, > > Estou com problema de conexoes no Mysql, estou rodando a versao 4.0.21. > Em alguns horarios de picos, quando tento acessar a pagina, me retorna a > seguinte mensagem. > > Warning: mysql_pconnect(): Too many connections > > Editei o arquivo mysqld_safe, e setei "ulimit para 2048", mas mesmo assim > o erro persiste. > Alguem teria alguma solucao para resolver o problema de conexao com o > servidor Mysql. > > > Obrigado. > > > _______________________________________________ > Freebsd mailing list > Freebsd@fug.com.br > http://mail.fug.com.br/mailman/listinfo/freebsd_fug.com.br > _______________________________________________ Freebsd mailing list Freebsd@fug.com.br http://mail.fug.com.br/mailman/listinfo/freebsd_fug.com.br
