求助，mysql启动报/usr/local/mysql/bin/mysqld_safe: line 183: 2664 Killed

[小张快跑]

mysql启动报错


/usr/local/mysql/bin/mysqld_safe: line 183: 10859 Killed nohup /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=/usr/local/mysql/data/mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 >
/usr/local/mysql/bin/mysqld_safe: line 183: 13277 Killed nohup /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=/usr/local/mysql/data/mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 >
/usr/local/mysql/bin/mysqld_safe: line 183: 12060 Killed nohup /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=/usr/local/mysql/data/mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 >

......


一直这样，

修改my.cnf 没有用。

重装也没有用。

[小张快跑]

引用 1 楼 受了伤风的星辰 的回复:

bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &

谢谢你,不过好像没有解决 成了 这样 ./bin/mysqld_safe: line 183: 953 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:05 mysqld_safe Number of processes running now: 0 190508 14:59:05 mysqld_safe mysqld restarted ./bin/mysqld_safe: line 183: 1307 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:11 mysqld_safe Number of processes running now: 0 190508 14:59:11 mysqld_safe mysqld restarted

[遇星]

引用 2 楼 qq_45028549 的回复:

[quote=引用 1 楼 受了伤风的星辰 的回复:] bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &

谢谢你,不过好像没有解决 成了 这样 ./bin/mysqld_safe: line 183: 953 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:05 mysqld_safe Number of processes running now: 0 190508 14:59:05 mysqld_safe mysqld restarted ./bin/mysqld_safe: line 183: 1307 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:11 mysqld_safe Number of processes running now: 0 190508 14:59:11 mysqld_safe mysqld restarted [/quote] 看看mysql.err这个文件里面的报错信息

[小张快跑]

引用 3 楼 受了伤风的星辰 的回复:

[quote=引用 2 楼 qq_45028549 的回复:] [quote=引用 1 楼 受了伤风的星辰 的回复:] bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &

谢谢你,不过好像没有解决 成了 这样 ./bin/mysqld_safe: line 183: 953 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:05 mysqld_safe Number of processes running now: 0 190508 14:59:05 mysqld_safe mysqld restarted ./bin/mysqld_safe: line 183: 1307 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:11 mysqld_safe Number of processes running now: 0 190508 14:59:11 mysqld_safe mysqld restarted [/quote] 看看mysql.err这个文件里面的报错信息[/quote] 2019-05-08 16:00:57 3791 [Note] Plugin 'FEDERATED' is disabled. 2019-05-08 16:00:57 3791 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-05-08 16:00:57 3791 [Note] InnoDB: The InnoDB memory heap is disabled 2019-05-08 16:00:57 3791 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-08 16:00:57 3791 [Note] InnoDB: Memory barrier is not used 2019-05-08 16:00:57 3791 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-08 16:00:57 3791 [Note] InnoDB: Using Linux native AIO 2019-05-08 16:00:57 3791 [Note] InnoDB: Using CPU crc32 instructions 2019-05-08 16:00:57 3791 [Note] InnoDB: Initializing buffer pool, size = 56.0M 2019-05-08 16:00:57 3791 [Note] InnoDB: Completed initialization of buffer pool 2019-05-08 16:00:57 3791 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-08 16:00:57 3791 [Note] InnoDB: 128 rollback segment(s) are active. 2019-05-08 16:00:57 3791 [Note] InnoDB: Waiting for purge to start 2019-05-08 16:00:57 3791 [Note] InnoDB: 5.6.44 started; log sequence number 1817039 2019-05-08 16:00:57 3791 [Note] Server hostname (bind-address): '*'; port: 3306 2019-05-08 16:00:57 3791 [Note] IPv6 is available. 2019-05-08 16:00:57 3791 [Note] - '::' resolves to '::'; 2019-05-08 16:00:57 3791 [Note] Server socket created on IP: '::'. 2019-05-08 16:00:57 3791 [Note] Event Scheduler: Loaded 0 events 2019-05-08 16:00:57 3791 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.44' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 2019-05-08 16:01:01 4122 [Note] Plugin 'FEDERATED' is disabled. 2019-05-08 16:01:01 4122 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-05-08 16:01:01 4122 [Note] InnoDB: The InnoDB memory heap is disabled 2019-05-08 16:01:01 4122 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-08 16:01:01 4122 [Note] InnoDB: Memory barrier is not used 2019-05-08 16:01:01 4122 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-08 16:01:01 4122 [Note] InnoDB: Using Linux native AIO 2019-05-08 16:01:01 4122 [Note] InnoDB: Using CPU crc32 instructions 2019-05-08 16:01:01 4122 [Note] InnoDB: Initializing buffer pool, size = 56.0M 2019-05-08 16:01:01 4122 [Note] InnoDB: Completed initialization of buffer pool 2019-05-08 16:01:01 4122 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-08 16:01:01 4122 [Note] InnoDB: The log sequence numbers 1817039 and 1817039 in ibdata files do not match the log sequence number 1817049 in the ib_logfiles! 2019-05-08 16:01:01 4122 [Note] InnoDB: Database was not shutdown normally! 2019-05-08 16:01:01 4122 [Note] InnoDB: Starting crash recovery. 2019-05-08 16:01:01 4122 [Note] InnoDB: Reading tablespace information from the .ibd files... 2019-05-08 16:01:01 4122 [Note] InnoDB: Restoring possible half-written data pages 2019-05-08 16:01:01 4122 [Note] InnoDB: from the doublewrite buffer... 2019-05-08 16:01:01 4122 [Note] InnoDB: 128 rollback segment(s) are active. 2019-05-08 16:01:01 4122 [Note] InnoDB: Waiting for purge to start 2019-05-08 16:01:01 4122 [Note] InnoDB: 5.6.44 started; log sequence number 1817049 2019-05-08 16:01:01 4122 [Note] Server hostname (bind-address): '*'; port: 3306 2019-05-08 16:01:01 4122 [Note] IPv6 is available. 2019-05-08 16:01:01 4122 [Note] - '::' resolves to '::'; 2019-05-08 16:01:01 4122 [Note] Server socket created on IP: '::'. 2019-05-08 16:01:01 4122 [Note] Event Scheduler: Loaded 0 events 2019-05-08 16:01:01 4122 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.44' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) ...... 我看不出什么

[遇星]

引用 4 楼 qq_45028549 的回复:

[quote=引用 3 楼 受了伤风的星辰 的回复:] [quote=引用 2 楼 qq_45028549 的回复:] [quote=引用 1 楼 受了伤风的星辰 的回复:] bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &

谢谢你,不过好像没有解决 成了 这样 ./bin/mysqld_safe: line 183: 953 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:05 mysqld_safe Number of processes running now: 0 190508 14:59:05 mysqld_safe mysqld restarted ./bin/mysqld_safe: line 183: 1307 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:11 mysqld_safe Number of processes running now: 0 190508 14:59:11 mysqld_safe mysqld restarted [/quote] 看看mysql.err这个文件里面的报错信息[/quote] 2019-05-08 16:00:57 3791 [Note] Plugin 'FEDERATED' is disabled. 2019-05-08 16:00:57 3791 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-05-08 16:00:57 3791 [Note] InnoDB: The InnoDB memory heap is disabled 2019-05-08 16:00:57 3791 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-08 16:00:57 3791 [Note] InnoDB: Memory barrier is not used 2019-05-08 16:00:57 3791 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-08 16:00:57 3791 [Note] InnoDB: Using Linux native AIO 2019-05-08 16:00:57 3791 [Note] InnoDB: Using CPU crc32 instructions 2019-05-08 16:00:57 3791 [Note] InnoDB: Initializing buffer pool, size = 56.0M 2019-05-08 16:00:57 3791 [Note] InnoDB: Completed initialization of buffer pool 2019-05-08 16:00:57 3791 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-08 16:00:57 3791 [Note] InnoDB: 128 rollback segment(s) are active. 2019-05-08 16:00:57 3791 [Note] InnoDB: Waiting for purge to start 2019-05-08 16:00:57 3791 [Note] InnoDB: 5.6.44 started; log sequence number 1817039 2019-05-08 16:00:57 3791 [Note] Server hostname (bind-address): '*'; port: 3306 2019-05-08 16:00:57 3791 [Note] IPv6 is available. 2019-05-08 16:00:57 3791 [Note] - '::' resolves to '::'; 2019-05-08 16:00:57 3791 [Note] Server socket created on IP: '::'. 2019-05-08 16:00:57 3791 [Note] Event Scheduler: Loaded 0 events 2019-05-08 16:00:57 3791 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.44' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 2019-05-08 16:01:01 4122 [Note] Plugin 'FEDERATED' is disabled. 2019-05-08 16:01:01 4122 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-05-08 16:01:01 4122 [Note] InnoDB: The InnoDB memory heap is disabled 2019-05-08 16:01:01 4122 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-08 16:01:01 4122 [Note] InnoDB: Memory barrier is not used 2019-05-08 16:01:01 4122 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-08 16:01:01 4122 [Note] InnoDB: Using Linux native AIO 2019-05-08 16:01:01 4122 [Note] InnoDB: Using CPU crc32 instructions 2019-05-08 16:01:01 4122 [Note] InnoDB: Initializing buffer pool, size = 56.0M 2019-05-08 16:01:01 4122 [Note] InnoDB: Completed initialization of buffer pool 2019-05-08 16:01:01 4122 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-08 16:01:01 4122 [Note] InnoDB: The log sequence numbers 1817039 and 1817039 in ibdata files do not match the log sequence number 1817049 in the ib_logfiles! 2019-05-08 16:01:01 4122 [Note] InnoDB: Database was not shutdown normally! 2019-05-08 16:01:01 4122 [Note] InnoDB: Starting crash recovery. 2019-05-08 16:01:01 4122 [Note] InnoDB: Reading tablespace information from the .ibd files... 2019-05-08 16:01:01 4122 [Note] InnoDB: Restoring possible half-written data pages 2019-05-08 16:01:01 4122 [Note] InnoDB: from the doublewrite buffer... 2019-05-08 16:01:01 4122 [Note] InnoDB: 128 rollback segment(s) are active. 2019-05-08 16:01:01 4122 [Note] InnoDB: Waiting for purge to start 2019-05-08 16:01:01 4122 [Note] InnoDB: 5.6.44 started; log sequence number 1817049 2019-05-08 16:01:01 4122 [Note] Server hostname (bind-address): '*'; port: 3306 2019-05-08 16:01:01 4122 [Note] IPv6 is available. 2019-05-08 16:01:01 4122 [Note] - '::' resolves to '::'; 2019-05-08 16:01:01 4122 [Note] Server socket created on IP: '::'. 2019-05-08 16:01:01 4122 [Note] Event Scheduler: Loaded 0 events 2019-05-08 16:01:01 4122 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.44' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) ...... 我看不出什么 [/quote] 看日志应该是MySQL实例开起来了，你看一下有没有MySQL进程 ps -ef|grep mysql

[小张快跑]

引用 5 楼 受了伤风的星辰 的回复:

[quote=引用 4 楼 qq_45028549 的回复:] [quote=引用 3 楼 受了伤风的星辰 的回复:] [quote=引用 2 楼 qq_45028549 的回复:] [quote=引用 1 楼 受了伤风的星辰 的回复:] bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &

谢谢你,不过好像没有解决 成了 这样 ./bin/mysqld_safe: line 183: 953 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:05 mysqld_safe Number of processes running now: 0 190508 14:59:05 mysqld_safe mysqld restarted ./bin/mysqld_safe: line 183: 1307 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:11 mysqld_safe Number of processes running now: 0 190508 14:59:11 mysqld_safe mysqld restarted [/quote] 看看mysql.err这个文件里面的报错信息[/quote] 2019-05-08 16:00:57 3791 [Note] Plugin 'FEDERATED' is disabled. 2019-05-08 16:00:57 3791 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-05-08 16:00:57 3791 [Note] InnoDB: The InnoDB memory heap is disabled 2019-05-08 16:00:57 3791 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-08 16:00:57 3791 [Note] InnoDB: Memory barrier is not used 2019-05-08 16:00:57 3791 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-08 16:00:57 3791 [Note] InnoDB: Using Linux native AIO 2019-05-08 16:00:57 3791 [Note] InnoDB: Using CPU crc32 instructions 2019-05-08 16:00:57 3791 [Note] InnoDB: Initializing buffer pool, size = 56.0M 2019-05-08 16:00:57 3791 [Note] InnoDB: Completed initialization of buffer pool 2019-05-08 16:00:57 3791 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-08 16:00:57 3791 [Note] InnoDB: 128 rollback segment(s) are active. 2019-05-08 16:00:57 3791 [Note] InnoDB: Waiting for purge to start 2019-05-08 16:00:57 3791 [Note] InnoDB: 5.6.44 started; log sequence number 1817039 2019-05-08 16:00:57 3791 [Note] Server hostname (bind-address): '*'; port: 3306 2019-05-08 16:00:57 3791 [Note] IPv6 is available. 2019-05-08 16:00:57 3791 [Note] - '::' resolves to '::'; 2019-05-08 16:00:57 3791 [Note] Server socket created on IP: '::'. 2019-05-08 16:00:57 3791 [Note] Event Scheduler: Loaded 0 events 2019-05-08 16:00:57 3791 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.44' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 2019-05-08 16:01:01 4122 [Note] Plugin 'FEDERATED' is disabled. 2019-05-08 16:01:01 4122 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-05-08 16:01:01 4122 [Note] InnoDB: The InnoDB memory heap is disabled 2019-05-08 16:01:01 4122 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-08 16:01:01 4122 [Note] InnoDB: Memory barrier is not used 2019-05-08 16:01:01 4122 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-08 16:01:01 4122 [Note] InnoDB: Using Linux native AIO 2019-05-08 16:01:01 4122 [Note] InnoDB: Using CPU crc32 instructions 2019-05-08 16:01:01 4122 [Note] InnoDB: Initializing buffer pool, size = 56.0M 2019-05-08 16:01:01 4122 [Note] InnoDB: Completed initialization of buffer pool 2019-05-08 16:01:01 4122 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-08 16:01:01 4122 [Note] InnoDB: The log sequence numbers 1817039 and 1817039 in ibdata files do not match the log sequence number 1817049 in the ib_logfiles! 2019-05-08 16:01:01 4122 [Note] InnoDB: Database was not shutdown normally! 2019-05-08 16:01:01 4122 [Note] InnoDB: Starting crash recovery. 2019-05-08 16:01:01 4122 [Note] InnoDB: Reading tablespace information from the .ibd files... 2019-05-08 16:01:01 4122 [Note] InnoDB: Restoring possible half-written data pages 2019-05-08 16:01:01 4122 [Note] InnoDB: from the doublewrite buffer... 2019-05-08 16:01:01 4122 [Note] InnoDB: 128 rollback segment(s) are active. 2019-05-08 16:01:01 4122 [Note] InnoDB: Waiting for purge to start 2019-05-08 16:01:01 4122 [Note] InnoDB: 5.6.44 started; log sequence number 1817049 2019-05-08 16:01:01 4122 [Note] Server hostname (bind-address): '*'; port: 3306 2019-05-08 16:01:01 4122 [Note] IPv6 is available. 2019-05-08 16:01:01 4122 [Note] - '::' resolves to '::'; 2019-05-08 16:01:01 4122 [Note] Server socket created on IP: '::'. 2019-05-08 16:01:01 4122 [Note] Event Scheduler: Loaded 0 events 2019-05-08 16:01:01 4122 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.44' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) ...... 我看不出什么 [/quote] 看日志应该是MySQL实例开起来了，你看一下有没有MySQL进程 ps -ef|grep mysql[/quote] mysql 是启动了的,但是过一段时间(一分钟左右) 会把这个进程killed, 好像自动又启动了..循环往复

[遇星]

引用 6 楼 qq_45028549 的回复:

[quote=引用 5 楼 受了伤风的星辰 的回复:] [quote=引用 4 楼 qq_45028549 的回复:] [quote=引用 3 楼 受了伤风的星辰 的回复:] [quote=引用 2 楼 qq_45028549 的回复:] [quote=引用 1 楼 受了伤风的星辰 的回复:] bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &

谢谢你,不过好像没有解决 成了 这样 ./bin/mysqld_safe: line 183: 953 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:05 mysqld_safe Number of processes running now: 0 190508 14:59:05 mysqld_safe mysqld restarted ./bin/mysqld_safe: line 183: 1307 Killed nohup /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=mysql.err --pid-file=mysql.pid < /dev/null > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 > /dev/null 2>&1 190508 14:59:11 mysqld_safe Number of processes running now: 0 190508 14:59:11 mysqld_safe mysqld restarted [/quote] 看看mysql.err这个文件里面的报错信息[/quote] 2019-05-08 16:00:57 3791 [Note] Plugin 'FEDERATED' is disabled. 2019-05-08 16:00:57 3791 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-05-08 16:00:57 3791 [Note] InnoDB: The InnoDB memory heap is disabled 2019-05-08 16:00:57 3791 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-08 16:00:57 3791 [Note] InnoDB: Memory barrier is not used 2019-05-08 16:00:57 3791 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-08 16:00:57 3791 [Note] InnoDB: Using Linux native AIO 2019-05-08 16:00:57 3791 [Note] InnoDB: Using CPU crc32 instructions 2019-05-08 16:00:57 3791 [Note] InnoDB: Initializing buffer pool, size = 56.0M 2019-05-08 16:00:57 3791 [Note] InnoDB: Completed initialization of buffer pool 2019-05-08 16:00:57 3791 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-08 16:00:57 3791 [Note] InnoDB: 128 rollback segment(s) are active. 2019-05-08 16:00:57 3791 [Note] InnoDB: Waiting for purge to start 2019-05-08 16:00:57 3791 [Note] InnoDB: 5.6.44 started; log sequence number 1817039 2019-05-08 16:00:57 3791 [Note] Server hostname (bind-address): '*'; port: 3306 2019-05-08 16:00:57 3791 [Note] IPv6 is available. 2019-05-08 16:00:57 3791 [Note] - '::' resolves to '::'; 2019-05-08 16:00:57 3791 [Note] Server socket created on IP: '::'. 2019-05-08 16:00:57 3791 [Note] Event Scheduler: Loaded 0 events 2019-05-08 16:00:57 3791 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.44' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) 2019-05-08 16:01:01 4122 [Note] Plugin 'FEDERATED' is disabled. 2019-05-08 16:01:01 4122 [Note] InnoDB: Using atomics to ref count buffer pool pages 2019-05-08 16:01:01 4122 [Note] InnoDB: The InnoDB memory heap is disabled 2019-05-08 16:01:01 4122 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-05-08 16:01:01 4122 [Note] InnoDB: Memory barrier is not used 2019-05-08 16:01:01 4122 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-05-08 16:01:01 4122 [Note] InnoDB: Using Linux native AIO 2019-05-08 16:01:01 4122 [Note] InnoDB: Using CPU crc32 instructions 2019-05-08 16:01:01 4122 [Note] InnoDB: Initializing buffer pool, size = 56.0M 2019-05-08 16:01:01 4122 [Note] InnoDB: Completed initialization of buffer pool 2019-05-08 16:01:01 4122 [Note] InnoDB: Highest supported file format is Barracuda. 2019-05-08 16:01:01 4122 [Note] InnoDB: The log sequence numbers 1817039 and 1817039 in ibdata files do not match the log sequence number 1817049 in the ib_logfiles! 2019-05-08 16:01:01 4122 [Note] InnoDB: Database was not shutdown normally! 2019-05-08 16:01:01 4122 [Note] InnoDB: Starting crash recovery. 2019-05-08 16:01:01 4122 [Note] InnoDB: Reading tablespace information from the .ibd files... 2019-05-08 16:01:01 4122 [Note] InnoDB: Restoring possible half-written data pages 2019-05-08 16:01:01 4122 [Note] InnoDB: from the doublewrite buffer... 2019-05-08 16:01:01 4122 [Note] InnoDB: 128 rollback segment(s) are active. 2019-05-08 16:01:01 4122 [Note] InnoDB: Waiting for purge to start 2019-05-08 16:01:01 4122 [Note] InnoDB: 5.6.44 started; log sequence number 1817049 2019-05-08 16:01:01 4122 [Note] Server hostname (bind-address): '*'; port: 3306 2019-05-08 16:01:01 4122 [Note] IPv6 is available. 2019-05-08 16:01:01 4122 [Note] - '::' resolves to '::'; 2019-05-08 16:01:01 4122 [Note] Server socket created on IP: '::'. 2019-05-08 16:01:01 4122 [Note] Event Scheduler: Loaded 0 events 2019-05-08 16:01:01 4122 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.6.44' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server (GPL) ...... 我看不出什么 [/quote] 看日志应该是MySQL实例开起来了，你看一下有没有MySQL进程 ps -ef|grep mysql[/quote] mysql 是启动了的,但是过一段时间(一分钟左右) 会把这个进程killed, 好像自动又启动了..循环往复 [/quote] 也许是你my.cnf里的一些参数配置不合适，例如一些涉及内存分配的参数，你检查看看； 先把不是必要的，指定数值的参数去掉，再重启试试

[小张快跑]

引用 7 楼 受了伤风的星辰 的回复:

mysql 是启动了的,但是过一段时间(一分钟左右) 会把这个进程killed, 好像自动又启动了..循环往复

也许是你my.cnf里的一些参数配置不合适，例如一些涉及内存分配的参数，你检查看看； 先把不是必要的，指定数值的参数去掉，再重启试试[/quote] 好的 多谢

[遇星]

bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql &