31.3. Limitations of INFORMATION_SCHEMA


31.3. Limitations of INFORMATION_SCHEMA

The INFORMATION_SCHEMA implementation is fairly complete, but there are some kinds of information that it does not yet contain. For example, there are no tables for routine parameters or referential constraints for foreign keys. These omissions may be addressed in the future.

INFORMATION_SCHEMA serves solely as a means of access for metadata. SHOW statements also serve this purpose, but the domain of SHOW extends into other areas as well. Certain SHOW statements provide information about the server's configuration or operational state. Some examples:

  • SHOW VARIABLES displays system variables that describe server configuration.

  • SHOW STATUS displays status variables that provide information about current server operation.

  • SHOW ENGINES lists the storage engines that the server knows about.

  • SHOW PROCESSLIST provides information about the currently executing server threads.

  • SHOW MASTER STATUS and SHOW SLAVE STATUS provide information about replication servers.



MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net