MYSQL-mysqladmin命令
原创woxuewangluo 博主文章分类:MYSQL文档 ©著作权
©著作权归作者所有:来自51CTO博客作者woxuewangluo的原创作品,请联系作者获取转载授权,否则将追究法律责任
1、mysql查看进程语句:
mysqladmin -uroot -ppassword processlist | grep -i -E 'sleep' | grep '08piao'
2、mysql查看是否存活:
[root@localhost ~]# mysqladmin -uroot -pCAhz6kJmkLXvcefSp51 ping
mysqld is alive
3、停止同步:
C:\Documents and Settings\Administrator>mysqladmin -u root -p stop-slave
Enter password:
Slave stopped
4、开启同步:
C:\Documents and Settings\Administrator>mysqladmin -u root -p start-slave
5、查看版本:
C:\Documents and Settings\Administrator>mysqladmin version
mysqladmin Ver 8.42 Distrib 5.5.25, for Win32 on x86
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Server version 5.5.25
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 6 hours 8 min 37 sec
Threads: 1 Questions: 9 Slow queries: 0 Opens: 33 Flush tables: 1 Open tabl
es: 0 Queries per second avg: 0.000
6、查看参数配置:
C:\Documents and Settings\Administrator>mysqladmin variables
语法:
[root@localhost ~]# mysqladmin --help
mysqladmin Ver 8.41 Distrib 5.0.95, for redhat-linux-gnu on x86_64
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Administration program for the mysqld daemon.
Usage: mysqladmin [OPTIONS] command command....
Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- -----------------------------
count 0
force FALSE
compress FALSE
character-sets-dir (No default value)
default-character-set (No default value)
host (No default value)
port 0
relative FALSE
socket (No default value)
sleep 0
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-verify-server-cert FALSE
user (No default value)
verbose FALSE
vertical FALSE
connect_timeout 43200
shutdown_timeout 3600
Default options are read from the following files in the given order:
/etc/my.cnf ~/.my.cnf
The following groups are read: mysqladmin client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read
Where command is a one or more of: (Commands may be shortened)
上一篇:MYSQL-优化
下一篇:MYSQL—连接超时
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
mysqladmin命令使用示例
mysqladmin是一个强大的命令行工具,用于执行各种MySQL服务器管理任务。
数据库 mysql MySQL