Normalmente não respondo mails que têm a palavra "Windows", mas vou abrir uma excessão.
Tente evitar o reverso do endereço. Isso deve aumentar a velocidade de conexão. Parâmetro " --skip-name-resolve". http://dev.mysql.com/doc/refman/5.1/en/dns.html []´s Helio Loureiro http://helio.loureiro.eng.br http://hloureiro.multiply.com http://twitter.com/helioloureiro Em 3 de dezembro de 2010 17:06, Eden Caldas <edencal...@gmail.com> escreveu: > Você está tentando acessar via IP ou via nome? Tenta via IP. > > Eden Caldas > Consultor de TI > e...@linuxfacil.srv.br > (81) 9653 7220 > LINUX FÁCIL – Consultoria e Serviços em TI > > > Em 3 de dezembro de 2010 16:04, Roberto Torres <jrtor...@bol.com.br>escreveu: > > Tenho um Debian Lenny rodando um servidor MySql. >> >> >> >> Quando vou acessar o MySql do meu note (Windows) ou qualquer outra maquina >> da rede através de algum cliente (Mysql-admin ou Navicat) ele demora uns 60 >> segundos ou mais. >> >> >> >> >> >> Essa demora é normal ? >> >> >> >> Segue conf do meu my.cnf >> >> >> >> >> >> # >> >> # The MySQL database server configuration file. >> >> # >> >> # You can copy this to one of: >> >> # - "/etc/mysql/my.cnf" to set global options, >> >> # - "~/.my.cnf" to set user-specific options. >> >> # >> >> # One can use all long options that the program supports. >> >> # Run program with --help to get a list of available options and with >> >> # --print-defaults to see which it would actually understand and use. >> >> # >> >> # For explanations see >> >> # http://dev.mysql.com/doc/mysql/en/server-system-variables.html >> >> >> >> # This will be passed to all mysql clients >> >> # It has been reported that passwords should be enclosed with ticks/quotes >> >> # escpecially if they contain "#" chars... >> >> # Remember to edit /etc/mysql/debian.cnf when changing the socket >> location. >> >> [client] >> >> port = 3306 >> >> socket = /var/run/mysqld/mysqld.sock >> >> >> >> # Here is entries for some specific programs >> >> # The following values assume you have at least 32M ram >> >> >> >> # This was formally known as [safe_mysqld]. Both versions are currently >> parsed. >> >> [mysqld_safe] >> >> socket = /var/run/mysqld/mysqld.sock >> >> nice = 0 >> >> >> >> [mysqld] >> >> # >> >> # * Basic Settings >> >> # >> >> user = mysql >> >> pid-file = /var/run/mysqld/mysqld.pid >> >> socket = /var/run/mysqld/mysqld.sock >> >> port = 3306 >> >> basedir = /usr >> >> datadir = /var/lib/mysql >> >> tmpdir = /tmp >> >> language = /usr/share/mysql/english >> >> skip-external-locking >> >> # >> >> # Instead of skip-networking the default is now to listen only on >> >> # localhost which is more compatible and is not less secure. >> >> #bind-address = 127.0.0.1 >> >> # >> >> # * Fine Tuning >> >> # >> >> key_buffer = 312M >> >> max_allowed_packet = 256M >> >> thread_stack = 256K >> >> thread_cache_size = 8 >> >> # This replaces the startup script and checks MyISAM tables if needed >> >> # the first time they are touched >> >> myisam-recover = BACKUP >> >> max_connections = 10000 >> >> table_cache = 20000 >> >> thread_concurrency = 10 >> >> # >> >> # * Query Cache Configuration >> >> # >> >> query_cache_limit = 4M >> >> query_cache_size = 128M >> >> # >> >> # * Logging and Replication >> >> # >> >> # Both location gets rotated by the cronjob. >> >> # Be aware that this log type is a performance killer. >> >> #log = /var/log/mysql/mysql.log >> >> # >> >> # Error logging goes to syslog. This is a Debian improvement :) >> >> # >> >> # Here you can see queries with especially long duration >> >> #log_slow_queries = /var/log/mysql/mysql-slow.log >> >> #long_query_time = 2 >> >> #log-queries-not-using-indexes >> >> # >> >> # The following can be used as easy to replay backup logs or for >> replication. >> >> # note: if you are setting up a replication slave, see README.Debian about >> >> # other settings you may need to change. >> >> #server-id = 1 >> >> #log_bin = /var/log/mysql/mysql-bin.log >> >> expire_logs_days = 10 >> >> max_binlog_size = 100M >> >> #binlog_do_db = include_database_name >> >> #binlog_ignore_db = include_database_name >> >> # >> >> # * BerkeleyDB >> >> # >> >> # Using BerkeleyDB is now discouraged as its support will cease in 5.1.12. >> >> skip-bdb >> >> # >> >> # * InnoDB >> >> # >> >> # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/. >> >> # Read the manual for more InnoDB related options. There are many! >> >> # You might want to disable InnoDB to shrink the mysqld process by circa >> 100MB. >> >> #skip-innodb >> >> # >> >> # * Security Features >> >> # >> >> # Read the manual, too, if you want chroot! >> >> # chroot = /var/lib/mysql/ >> >> # >> >> # For generating SSL certificates I recommend the OpenSSL GUI "tinyca". >> >> # >> >> # ssl-ca=/etc/mysql/cacert.pem >> >> # ssl-cert=/etc/mysql/server-cert.pem >> >> # ssl-key=/etc/mysql/server-key.pem >> >> >> >> >> >> >> >> [mysqldump] >> >> quick >> >> quote-names >> >> max_allowed_packet = 32M >> >> >> >> [mysql] >> >> #no-auto-rehash # faster start of mysql but no tab completition >> >> >> >> [isamchk] >> >> key_buffer = 64M >> >> >> >> # >> >> # * NDB Cluster >> >> # >> >> # See /usr/share/doc/mysql-server-*/README.Debian for more information. >> >> # >> >> # The following configuration is read by the NDB Data Nodes (ndbd >> processes) >> >> # not from the NDB Management Nodes (ndb_mgmd processes). >> >> # >> >> # [MYSQL_CLUSTER] >> >> # ndb-connectstring=127.0.0.1 >> >> >> >> >> >> # >> >> # * IMPORTANT: Additional settings that can override those from this file! >> >> # The files must end with '.cnf', otherwise they'll be ignored. >> >> # >> >> !includedir /etc/mysql/conf.d/ >> >> >> >> >> >> >> >> >> >> >> > >
