Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Mysql 5.5Database startup shutdown command

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Start the MySQL service

. / 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

The records in the error log are as follows:

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.09.

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 socket:' / var/lib/mysql/mysql.sock' port: 3306 production environment

Turn off the MySQL service

. / 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

The records in the error log are as follows:

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report