How to check MySQL settings

Use “mysql> show variables;” or “mysql> status;” to check your MySQL settings.

mysql> status
mysql Ver 14.12 Distrib 5.0.27, for redhat-linux-gnu (i686) using readline 5.0

Connection id: 292
Current database:
Current user: [email protected]
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.27
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: utf8
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 1 day 21 hours 55 min 32 sec

Threads: 1 Questions: 5351 Slow queries: 0 Opens: 121 Flush tables: 1 Open tables: 36 Queries per second avg: 0.032
This post is also available in other languages.