7.12. MySQL常见问题

Date:

2018-11

7.12.1. MySQL安装过程问题

7.12.1.1. 磁盘空间占满报错

make install 错误细节

  1. 第一种错误情况

1Linking CXX static library libsql.a
2/usr/bin/ranlib: libsql.a: No space left on device
3make[2]: *** [sql/libsql.a] Error 1
4make[1]: *** [sql/CMakeFiles/sql.dir/all] Error 2
5make: *** [all] Error 2

  1. 第二种错误情况

1[ 95%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/sql_lex.cc.o
2/data/tools/mysql-5.5.60/sql/sql_lex.cc:3432: fatal error: error writing to /tmp/cc5dzwNw.s: No space left on device
3compilation terminated.
4make[2]: *** [libmysqld/CMakeFiles/sql_embedded.dir/__/sql/sql_lex.cc.o] Error 1
5make[1]: *** [libmysqld/CMakeFiles/sql_embedded.dir/all] Error 2
6make: *** [all] Error 2

查看系统信息：

1[root@mysql_001 mysql-5.5.60]# df -h
2Filesystem      Size  Used Avail Use% Mounted on
3/dev/sda3       2.5G  2.4G     0 100% /
4tmpfs           491M     0  491M   0% /dev/shm
5/dev/sda1       477M   28M  424M   7% /boot

7.12.2. MySQL启动过程问题

7.12.2.1. 启动报错

报错详细：

1[root@mysql_001 mysql]# /etc/init.d/mysqld start
2Starting MySQL... ERROR! The server quit without updating PID file (/app/mysql-5.5.60/data/mysql_001.pid).

查看日志：

 1[root@mysql_001 mysql]# cat data/mysql_001.err
 2181127  1:33:27 [Note] Plugin 'FEDERATED' is disabled.
 3181127  1:33:27 InnoDB: The InnoDB memory heap is disabled
 4181127  1:33:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
 5181127  1:33:27 InnoDB: Compressed tables use zlib 1.2.3
 6181127  1:33:27 InnoDB: Using Linux native AIO
 7181127  1:33:27 InnoDB: Initializing buffer pool, size = 128.0M
 8181127  1:33:27 InnoDB: Completed initialization of buffer pool
 9181127  1:33:27 InnoDB: highest supported file format is Barracuda.
10181127  1:33:27  InnoDB: Waiting for the background threads to start
11181127  1:33:28 InnoDB: 5.5.60 started; log sequence number 1595675
12181127  1:33:28 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
13181127  1:33:28 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
14181127  1:33:28 [Note] Server socket created on IP: '0.0.0.0'.
15181127  1:33:28 [ERROR] Can't start server : Bind on unix socket: Permission denied
16181127  1:33:28 [ERROR] Do you already have another mysqld server running on socket: /app/mysql-5.5.60/tmp/mysql.sock ?
17181127  1:33:28 [ERROR] Aborting
18
19181127  1:33:28  InnoDB: Starting shutdown...
20181127  1:33:29  InnoDB: Shutdown completed; log sequence number 1595675
21181127  1:33:29 [Note] /app/mysql-5.5.60/bin/mysqld: Shutdown complete

从上面报错可以看到是mysql.socket文件权限问题。即`` /app/mysql-5.5.60/tmp/`` 目录权限需要设置，需要设置 1777

1chmod 1777 /app/mysql-5.5.60/tmp/