mysql connect speed is slow
When there is no name-resolve, the mysql connection will be slow.
Add 'skip-name-resolve' under '[mysqld]' section in /etc/my.cnf will resolve this problem.
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/545828/viewspace-1024087/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ELK收集mysql_slow.logMySql
- MySQL:慢SQL(slow_log)MySql
- MySQL slow log相關引數MySql
- [MySQL Slow log]正確安全清空線上慢查詢日誌slow log的流程MySql
- mysql之 slow log 慢查詢日誌MySql
- MySQL Slow Query log(慢查詢日誌)MySql
- MySQL slow log相關引數解釋MySql
- mysql 配置 General Query Log和# Slow Query LogMySql
- MySQL slow query [慢查詢] 資料整理MySql
- MySQL-undefinedfunctionmysql_connect()MySqlUndefinedFunction
- 【MySQL】Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)MySql
- Host 'localhost' is not allowed to connect to this MySQL serverlocalhostMySqlServer
- Speed Up Your WordPress Site
- mysql遠端連線 Host * is not allowed to connect to this MySQL serverMySqlServer
- MySQL-1130-host ... is not allowed to connect to this MySql serverMySqlServer
- Oracle Transparent GateWay connect to MYSQL fix BUGOracleGatewayMySql
- Optimize Slow VBA Code
- Slow decade counter
- 上手MySQL之解決問題:not allowed to connect to this MySQL serverMySqlServer
- 解決Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future:MySqlREM
- ntpdate會導致mysql slow query log出現很大的query timeMySql
- mysql_real_connect 埠號說明MySql
- MySQL連線提示Can't connect to local MySQL server through socketMySqlServer
- Can't connect to local MySQL server through socket '/tmp/mysql.sock'MySqlServer
- Host 'xxx' is not allowed to connect to this MySQL server.MySqlServer
- Xtrabackup備份報錯Failed to connect to MySQL serverAIMySqlServer
- Navicat連線centos裡mysql報錯Host is not allowed to connect to this MySQL serverCentOSMySqlServer
- [Slow log]正確安全清空線上慢查詢日誌slow log的流程
- Mysql資料庫Slow_log中的lock_Time和Query_timeMySql資料庫
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't existErrorMySql
- 判斷環境使用 Laravel Page SpeedLaravel
- Middle Speed Decanter Centrifuge exported to KazakhstanExport
- Improving the speed of the Miller-Rabin Prime Test
- 連線MySQL錯誤:Can't connect to MySQL server (10060)MySqlServer
- MySQL效能引數詳解 - max_connect_errorsMySqlError
- mysql init_connect 引數的其他用處MySql
- mysql can't connect error about privilege----not root userMySqlError
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock錯誤MySqlServer