CALS NOTE

  • Home
  • Archives
  • Cheatsheets
  • rss
  • About
  • Friends
2018-04-17 Calvin Lam
Comments

Basic MySQL status command

MySQL

Basic usage

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
# show connection status
status;

# show connections
show processlist;

# show runtime env
SHOW VARIABLES;
SHOW VARIABLES WHERE Variable_name = 'hostname';

# show tables satus
show table status;
show table status where name = 'users';

# show server variables
select @@sql_mode;

# exit
exit;
  • Cheatsheet
  • Cli
  • MySQL
Newer
Docker container set timezone
Older
Nginx password protect through htpasswd

CALS NOTE

© 2020 Calvin Lam
Modify from Apollo theme, designed by SANOGRAPHIX.NET
Powered by Hexo