284 Part III . Administration Table 11-1 (continued)

284 Part III . Administration Table 11-1 (continued) Variable What it does max_binlog_cache_size Sets maximum size of the cache for the binary log. max_binlog_size Sets maximum size of the binary log. max_connections Sets maximum number of simultaneous connections. max_connect_errors Sets maximum number of errors from a given host. max_delayed_threads Sets maximum number of threads to start for INSERT DELAYED statements. max_heap_table_size Sets maximum size for a HEAP table. max_join_size Sets maximum size for joins. max_sort_length Sets number of bytes to use for sorting BLOB and TEXT columns. max_user_connections Sets maximum number of simultaneous user connections. max_tmp_tables Sets maximum number of temporary tables to create. max_write_lock_count Sets number of write locks that occur before a read lock is enabled. myisam_max_extra_sort_ Sets maximum size before the key cache is used. file_size myisam_max_sort_file_size Sets maximum size of the temporary file used to create an index with myisam table. myisam_sort_buffer_size Sets size of buffer for myisam index functions. net_buffer_length Sets size of communications buffer. net_read_timeout Specifies time to wait between reads before closing a thread. net_retry_count Specifies number of times to retry a connection before closing. net_write_timeout Specifies time to wait between writes before closing a thread. open_files_limit Specifies number of file descriptors to open. query_buffer_size Sets initial size of the query buffer. record_buffer Specifies buffer to use for threads that do sequential scans. skip_locking Indicates whether internal or external locking is in use.
We recommend cheap and reliable webhost to host and run your web applications: Coldfusion Web Hosting services.

Leave a Reply