content_image/812596.jpg content_image/812600.jpg content_image/812603.jpg
<img src='content_image/812596.jpg'>

The path to the MySQL installation base directory. 

• big_tables 

<img src='content_image/812600.jpg'>

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” . 

• bind_address 

<img src='content_image/812603.jpg'>

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 

