Mysql 5.5 數據庫開啟關閉命令

2024-07-24 12:32:21

字體：大中小

來源：轉載

供稿：網友

啟動MySQL服務
./bin/mysqld_safe --defaults-file=/etc/my.cnf &

[1] 21698
[root@localhost bin]# 160402 05:57:36 mysqld_safe Logging to '/log/err.log'.
160402 05:57:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

error日志中的記錄如下：

160402 05:57:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160402 5:57:36 [Note] /data/bin/mysqld (mysqld 5.5.48-log) starting as process 22108 ...
160402 5:57:36 InnoDB: The InnoDB memory heap is disabled
160402 5:57:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160402 5:57:36 InnoDB: Compressed tables use zlib 1.2.3
160402 5:57:36 InnoDB: Using Linux native AIO
160402 5:57:36 InnoDB: Initializing buffer pool, size = 100.0M
160402 5:57:36 InnoDB: Completed initialization of buffer pool
160402 5:57:36 InnoDB: highest supported file format is Barracuda.
160402 5:57:37 InnoDB: Waiting for the background threads to start
160402 5:57:38 InnoDB: 5.5.48 started; log sequence number 1595675
160402 5:57:38 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160402 5:57:38 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160402 5:57:38 [Note] Server socket created on IP: '0.0.0.0'.
160402 5:57:38 [Note] Event Scheduler: Loaded 0 events
160402 5:57:38 [Note] /data/bin/mysqld: ready for connections.
Version: '5.5.48-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 production environment

關閉MySQL服務
./bin/mysqladmin -u root -p shutdown

Enter password:
160402 05:56:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[1]+ Done ./mysqld_safe --defaults-file=/etc/my.cnf

error日志中的記錄如下：

160402 5:56:09 [Note] /data/bin/mysqld: Normal shutdown

160402 5:56:09 [Note] Event Scheduler: Purging the queue. 0 events
160402 5:56:09 InnoDB: Starting shutdown...
160402 5:56:10 InnoDB: Shutdown completed; log sequence number 1595675
160402 5:56:10 [Note] /data/bin/mysqld: Shutdown complete

160402 05:56:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

（編輯：武林網）

上一篇：semi-sync插件崩潰導致MySQL重啟的故障分析全過程

下一篇：mysql.gtid_executed表Previous gtid Event的更改