jecy 发表于 2013-9-17 23:26:41

MYSQL问题,求大拿

启动不了mysql
# service mysql start
Starting MySQL..................................................................
................................... ERROR! The server quit without updating PID file (/usr/local/mysql/var/MyVPS2393.pid).

查看错误文件
# less MyVPS2393.err
130606 09:00:19 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
1306069:00:19 InnoDB: The InnoDB memory heap is disabled
1306069:00:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins
1306069:00:19 InnoDB: Compressed tables use zlib 1.2.3
1306069:00:19 InnoDB: Initializing buffer pool, size = 16.0M
1306069:00:19 InnoDB: Completed initialization of buffer pool
1306069:00:19 InnoDB: highest supported file format is Barracuda.
1306069:00:19InnoDB: Waiting for the background threads to start
1306069:00:20 InnoDB: 1.1.8 started; log sequence number 1595675
1306069:00:20 Recovering after a crash using mysql-bin
1306069:00:20 Starting crash recovery...
1306069:00:20 Crash recovery finished.
1306069:00:20 Server hostname (bind-address): '0.0.0.0'; port: 3306
1306069:00:20    - '0.0.0.0' resolves to '0.0.0.0';
1306069:00:20 Server socket created on IP: '0.0.0.0'.
1306069:00:20 Event Scheduler: Loaded 0 events
1306069:00:20 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.28-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
1306069:46:09 IP address '173.208.202.190' could not be resolved: Name or service not known
130606 12:11:44 IP address '121.199.41.41' could not be resolved: Name or service not known
130606 12:19:19 IP address '222.66.154.138' could not be resolved: Name or service not known
130606 16:28:41 IP address '111.2.100.197' could not be resolved: Temporary failure in name resolution
130607 11:23:15 IP address '218.61.104.25' could not be resolved: Name or service not known
130607 21:22:38 IP address '27.36.163.121' could not be resolved: Name or service not known
130608 23:41:12 IP address '121.199.11.115' could not be resolved: Name or service not known
1306099:37:15 IP address '173.208.249.117' could not be resolved: Name or service not known
130609 19:48:45 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:46 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:46 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:46 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:46 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:46 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:47 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:48 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:48 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:49 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:49 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
130609 19:48:49 IP address '222.169.86.74' could not be resolved: Temporary failure in name resolution
页: [1]
查看完整版本: MYSQL问题,求大拿