This utility displays critical information about a server for use in diagnosing problems. The information displayed includes the following:
Server connection information
Server version number
Data directory path name
Base directory path name
Plugin directory path name
Configuration file location and name
Current binary log coordinates (file name and position)
Current relay log coordinates (file name and position)
This utility can be used to see the diagnostic information for
servers that are running or offline. If you want to see
information about an offline server, the utility starts the server
in read-only mode. In this case, you must specify the
--basedir,
--datadir, and
--start options to prevent
the utility from starting an offline server accidentally. Note: Be
sure to consider the ramifications of starting an offline server
on the error and similar logs. It is best to save this information
prior to running this utility.
To specify how to display output, use one of the following values
with the --format option:
grid (default)
Display output in grid or table format like that of the mysql monitor.
csv
Display output in comma-separated values format.
tab
Display output in tab-separated format.
vertical
Display output in single-column format like that of the
\G command for the mysql
monitor.
To turn off the headers for csv
or tab display format, specify
the --no-headers option.
To see the common default settings for the local server's
configuration file, use the
--show-defaults option.
This option reads the configuration file on the machine where the
utility is run, not the machine for the host that the
--server option specifies.
To run the utility against several servers, specify the
--server option multiple
times. In this case, the utility attempts to connect to each
server and read the information.
To see the MySQL servers running on the local machine, use the
--show-servers option.
This shows all the servers with their process ID and data
directory. On Windows, the utility shows only the process ID and
port.
mysqlserverinfo accepts the following command-line options:
The port range to check for finding running servers. This
option applies only to Windows and is ignored unless
--show-servers is
given. The default range is 3306:3333.
For the --format option,
the permitted values are not case sensitive. In addition, values
may be specified as any unambiguous prefix of a valid value. For
example, --format=g
specifies the grid format. An error occurs if a prefix matches
more than one valid value.
The path to the MySQL client tools should be included in the PATH environment variable in order to use the authentication mechanism with login-paths. This will allow the utility to use the my_print_defaults tools which is required to read the login-path values from the login configuration file (.mylogin.cnf).
To display the server information for the local server and the settings for mysqld in the configuration file with the output in a vertical list, use this command:
$ mysqlserverinfo --server=root:pass@localhost -d --format=vertical
# Source on localhost: ... connected.
************************* 1. row *************************
server: localhost:3306
version: 5.1.50-log
datadir: /usr/local/mysql/data/
basedir: /usr/local/mysql-5.1.50-osx10.6-x86_64/
plugin_dir: /usr/local/mysql-5.1.50-osx10.6-x86_64/lib/plugin
config_file: /etc/my.cnf
binary_log: my_log.000068
binary_log_pos: 212383
relay_log: None
relay_log_pos: None
1 rows.
Defaults for server localhost:3306
--port=3306
--basedir=/usr/local/mysql
--datadir=/usr/local/mysql/data
--server_id=5
--log-bin=my_log
--general_log
--slow_query_log
--innodb_data_file_path=ibdata1:778M;ibdata2:50M:autoextend
#...done.