E ainda mandei um "excessão"... PQP. "s/ss/ç/". []´s Helio Loureiro http://helio.loureiro.eng.br http://hloureiro.multiply.com http://twitter.com/helioloureiro
Em 5 de dezembro de 2010 15:35, Helio Loureiro <[email protected]>escreveu: > 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 <[email protected]>escreveu: > > Você está tentando acessar via IP ou via nome? Tenta via IP. >> >> Eden Caldas >> Consultor de TI >> [email protected] >> (81) 9653 7220 >> LINUX FÁCIL – Consultoria e Serviços em TI >> >> >> Em 3 de dezembro de 2010 16:04, Roberto Torres <[email protected]>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/ >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> >> >
