D. System, Status, and User Variable Reference

This appendix describes several types of MySQL variables:

• System variables that you can set to configure the server or check to obtain the current configuration

• Status variables that provide information about the server’s current operational state

• User variables that you can define, assign values to, and refer to in expressions

Values for variables that represent buffer sizes or lengths generally are given in bytes. Exceptions are noted as necessary.

Unless otherwise indicated, the variables listed here have been present in MySQL at least as early as MySQL 5.5.0. Variables that were introduced or that have changed in meaning since then are noted.

D.1. System Variables

System variables provide ...

Get MySQL, 5th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.