Server System Variables Scope Global Dynamic No SET_VAR  Hint Applies No Type Directory name Default Value parent of mysqld installation directory The path to the MySQL installation base directory. • big_tables • bind_address Command-Line Format --big-tables[={OFF|ON}] System Variable big_tables Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF If enabled, the server stores all temporary tables on disk rather than in memory. This prevents most  The table  tbl_name  is full  errors for  SELECT  operations that require a large temporary table, but also slows down queries for which in-memory tables would suffice. The default value for new connections is  OFF  (use in-memory temporary tables). Normally, it should never be necessary to enable this variable. When in-memory  internal  temporary tables are managed by the  TempTable  storage engine (the default), and the maximum amount of memory that can be occupied by the  TempTable  storage engine is exceeded, the  TempTable  storage engine starts storing data to temporary files on disk. When in-memory temporary tables are managed by the  MEMORY  storage engine, in-memory tables are automatically converted to disk-based tables as required. For more information, see Section 8.4.4, “Internal Temporary Table Use in MySQL” . Command-Line Format --bind-address=addr System Variable bind_address Scope Global Dynamic No SET_VAR  Hint Applies No Type String Default Value * The MySQL server listens on one or more network sockets for TCP/IP connections. Each socket is bound to one address, but it is possible for an address to map onto multiple network interfaces. To specify how the server should listen for TCP/IP connections, set the  bind_address  system variable 772