设为首页 加入收藏

TOP

Onsql和MySQL的启停脚本(一)
2015-11-21 01:51:18 来源: 作者: 【 】 浏览:0
Tags:Onsql MySQL 脚本

启停onesql,总共四个参数{start|stop|restart|status},只要稍微改一下头部的三个文件路径,即可完成mysql单实例的启停。

?

[#9(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 
Usage:sh /etc/init.d/onesql5.6.26  {start|stop|restart|status}

详细执行效果如下:

?

?

[#2(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 status
There is no mysqld process  ! 
[#3(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 stop
The mysqld process is already stopped ! 
[#4(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 start
Starting MySQL.
150830 13:15:06 mysqld_safe Logging to '/data/mysql/mysql_3307/logs/error3307.log'.
150830 13:15:06 mysqld_safe Starting mysqld daemon with databases from /data/mysql/mysql_3307/data
Starting MySQL.. SUCCESS! 
[#5(zhouxx_vm(node3:192.168.56.103))#root@node3~]#
[#5(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 status


root      2319     1  2 13:15 pts/0    00:00:00 /bin/sh /usr/local/onesql5.6/bin/mysqld_safe --defaults-file=/data/mysql/mysql_3307/my_3307.cnf --user=mysql --datadir=/data/mysql/mysql_3307/data --basedir=/usr/local/onesql5.6
mysql     3163  2319 44 13:15 pts/0    00:00:02 /usr/local/onesql5.6/bin/mysqld --defaults-file=/data/mysql/mysql_3307/my_3307.cnf --basedir=/usr/local/onesql5.6 --datadir=/data/mysql/mysql_3307/data --plugin-dir=/usr/local/onesql5.6/lib/plugin --user=mysql --log-error=/data/mysql/mysql_3307/logs/error3307.log --open-files-limit=58000 --pid-file=/data/mysql/mysql_3307/logs/mysql_3307.pid --socket=/tmp/mysql_3307.sock --port=3307
MySQL(pid=3163) Status 
 
--------------
/usr/local/onesql5.6/bin/mysql  Ver 14.14 Distrib 5.6.25, for Linux (x86_64) using  EditLine wrapper

Connection id:          4
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.6.26-log (OneSQL) Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /tmp/mysql_3307.sock
Uptime:                 5 sec

Threads: 4  Questions: 5  Slow queries: 0  Opens: 18  Flush tables: 1  Open tables: 11  Queries per second avg: 1.000
--------------



[#6(zhouxx_vm(node3:192.168.56.103))#root@node3~]#
[#6(zhouxx_vm(node3:192.168.56.103))#root@node3~]#
[#6(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 stop
150830 13:15:19 mysqld_safe mysqld from pid file /data/mysql/mysql_3307/logs/mysql_3307.pid ended
Stopping MySQL SUCCESS! 
[#7(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 restart
The mysqld process is already stopped ! 
150830 13:15:32 mysqld_safe Logging to '/data/mysql/mysql_3307/logs/error3307.log'.
150830 13:15:32 mysqld_safe Starting mysqld daemon with databases from /data/mysql/mysql_3307/data
Starting MySQL. SUCCESS! 
[#8(zhouxx_vm(node3:192.168.56.103))#root@node3~]#service onesql5.6.26 status


root      3266     1  3 13:15 pts/0    00:00:00 /bin/sh /usr/local/onesql5.6/bin/mysqld_safe --defaults-file=/data/mysql/mysql_3307/my_3307.cnf --user=mysql --datadir=/data/mysql/mysql_3307/data --basedir=/usr/local/onesql5.6
mysql     4107  326
首页 上一页 1 2 3 下一页 尾页 1/3/3
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇mysql行转列利用casewhen 下一篇实现树形的遍历(关于多级菜单栏..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: