content_image/701328.jpg content_image/701331.jpg content_image/701336.jpg content_image/701339.jpg
<img src='content_image/701328.jpg'>

Whether to write a core file if the server unexpectedly exits. This variable is set by the --core-file option. 

• create_admin_listener_thread 

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

Whether to use a dedicated listening thread for client connections on the administrative network interface (see Section 5.1.12.1, “Connection Interfaces” ). The default is OFF ; that is, the manager thread for ordinary connections on the main interface also handles connections for the administrative interface. 

Depending on factors such as platform type and workload, you may find one setting for this variable yields better performance than the other setting. 

Setting create_admin_listener_thread  has no effect if admin_address  is not specified because in that case the server maintains no administrative network interface. 

• cte_max_recursion_depth 

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

The common table expression (CTE) maximum recursion depth. The server terminates execution of any CTE that recurses more levels than the value of this variable. For more information, see Limiting Common Table Expression Recursion. 

• datadir 

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

