Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
B. MySQL Server Status > System Variables
System Variables
MySQL exposes many system variables through the SHOW VARIABLES SQL
command, as variables you can use in expressions, or with
mysqladmin variables at the command line. From MySQL 5.1, you can also access
them through tables in the INFORMATION_SCHEMA
database.
These variables represent a variety of configuration information,
such as the server’s default storage engine (storage_engine), the available time zones, the
connection’s collation, and startup parameters. We explained how to set
and use system variables in Chapter 8.