API tools faq
paste
Advertisement
Guest User

SHOW VARIABLES

a guest
Aug 26th, 2015
826
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 12.61 KB | None | 0 0
raw download clone embed print report
  1. SHOW VARIABLES
  2.  
  3. auto_increment_increment,1
  4. auto_increment_offset,1
  5. autocommit,ON
  6. automatic_sp_privileges,ON
  7. back_log,70
  8. basedir,"C:/Program Files/MySQL/MySQL Server 5.6"
  9. big_tables,OFF
  10. bind_address,*
  11. binlog_cache_size,32768
  12. binlog_checksum,CRC32
  13. binlog_direct_non_transactional_updates,OFF
  14. binlog_format,STATEMENT
  15. binlog_max_flush_queue_time,0
  16. binlog_order_commits,ON
  17. binlog_row_image,FULL
  18. binlog_rows_query_log_events,OFF
  19. binlog_stmt_cache_size,32768
  20. bulk_insert_buffer_size,8388608
  21. character_set_client,utf8
  22. character_set_connection,utf8
  23. character_set_database,utf8
  24. character_set_filesystem,BINARY
  25. character_set_results,utf8
  26. character_set_server,utf8
  27. character_set_system,utf8
  28. character_sets_dir,"C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\"
  29. collation_connection,utf8_general_ci
  30. collation_database,utf8_general_ci
  31. collation_server,utf8_general_ci
  32. completion_type,NO_CHAIN
  33. concurrent_insert,AUTO
  34. connect_timeout,10
  35. core_file,OFF
  36. datadir,D:\MYSQL\data\
  37. date_format,%Y-%m-%d
  38. datetime_format,"%Y-%m-%d %H:%i:%s"
  39. default_storage_engine,InnoDB
  40. default_tmp_storage_engine,InnoDB
  41. default_week_format,0
  42. delay_key_write,ON
  43. delayed_insert_limit,100
  44. delayed_insert_timeout,300
  45. delayed_queue_size,1000
  46. disconnect_on_expired_password,ON
  47. div_precision_increment,4
  48. end_markers_in_json,OFF
  49. enforce_gtid_consistency,OFF
  50. eq_range_index_dive_limit,10
  51. error_count,0
  52. event_scheduler,OFF
  53. expire_logs_days,0
  54. explicit_defaults_for_timestamp,OFF
  55. external_user,
  56. flush,OFF
  57. flush_time,0
  58. foreign_key_checks,ON
  59. ft_boolean_syntax,"+ -><()~*:""""&|"
  60. ft_max_word_len,84
  61. ft_min_word_len,4
  62. ft_query_expansion_limit,20
  63. ft_stopword_file,(built-in)
  64. general_log,OFF
  65. general_log_file,"C:\ProgramData\MySQL\MySQL Server 5.6\mysql_general.log"
  66. group_concat_max_len,1024
  67. gtid_executed,
  68. gtid_mode,OFF
  69. gtid_next,AUTOMATIC
  70. gtid_owned,
  71. gtid_purged,
  72. have_compress,YES
  73. have_crypt,NO
  74. have_dynamic_loading,YES
  75. have_geometry,YES
  76. have_openssl,DISABLED
  77. have_profiling,YES
  78. have_query_cache,YES
  79. have_rtree_keys,YES
  80. have_ssl,DISABLED
  81. have_symlink,YES
  82. host_cache_size,378
  83. hostname,521144-web1
  84. identity,0
  85. ignore_builtin_innodb,OFF
  86. ignore_db_dirs,
  87. init_connect,
  88. init_file,
  89. init_slave,
  90. innodb_adaptive_flushing,ON
  91. innodb_adaptive_flushing_lwm,10
  92. innodb_adaptive_hash_index,ON
  93. innodb_adaptive_max_sleep_delay,150000
  94. innodb_additional_mem_pool_size,26214400
  95. innodb_api_bk_commit_interval,5
  96. innodb_api_disable_rowlock,OFF
  97. innodb_api_enable_binlog,OFF
  98. innodb_api_enable_mdl,OFF
  99. innodb_api_trx_level,0
  100. innodb_autoextend_increment,1000
  101. innodb_autoinc_lock_mode,1
  102. innodb_buffer_pool_dump_at_shutdown,OFF
  103. innodb_buffer_pool_dump_now,OFF
  104. innodb_buffer_pool_filename,ib_buffer_pool
  105. innodb_buffer_pool_instances,8
  106. innodb_buffer_pool_load_abort,OFF
  107. innodb_buffer_pool_load_at_startup,OFF
  108. innodb_buffer_pool_load_now,OFF
  109. innodb_buffer_pool_size,12884901888
  110. innodb_change_buffer_max_size,25
  111. innodb_change_buffering,all
  112. innodb_checksum_algorithm,crc32
  113. innodb_checksums,ON
  114. innodb_cmp_per_index_enabled,OFF
  115. innodb_commit_concurrency,0
  116. innodb_compression_failure_threshold_pct,5
  117. innodb_compression_level,6
  118. innodb_compression_pad_pct_max,50
  119. innodb_concurrency_tickets,5000
  120. innodb_data_file_path,ibdata1:12M:autoextend
  121. innodb_data_home_dir,D:\MYSQL\Data
  122. innodb_disable_sort_file_cache,OFF
  123. innodb_doublewrite,ON
  124. innodb_fast_shutdown,1
  125. innodb_file_format,Antelope
  126. innodb_file_format_check,ON
  127. innodb_file_format_max,Antelope
  128. innodb_file_per_table,ON
  129. innodb_flush_log_at_timeout,1
  130. innodb_flush_log_at_trx_commit,1
  131. innodb_flush_method,
  132. innodb_flush_neighbors,1
  133. innodb_flushing_avg_loops,30
  134. innodb_force_load_corrupted,OFF
  135. innodb_force_recovery,0
  136. innodb_ft_aux_table,
  137. innodb_ft_cache_size,8000000
  138. innodb_ft_enable_diag_print,OFF
  139. innodb_ft_enable_stopword,ON
  140. innodb_ft_max_token_size,84
  141. innodb_ft_min_token_size,3
  142. innodb_ft_num_word_optimize,2000
  143. innodb_ft_result_cache_limit,2000000000
  144. innodb_ft_server_stopword_table,
  145. innodb_ft_sort_pll_degree,2
  146. innodb_ft_total_cache_size,640000000
  147. innodb_ft_user_stopword_table,
  148. innodb_io_capacity,200
  149. innodb_io_capacity_max,2000
  150. innodb_large_prefix,OFF
  151. innodb_lock_wait_timeout,50
  152. innodb_locks_unsafe_for_binlog,OFF
  153. innodb_log_buffer_size,13631488
  154. innodb_log_compressed_pages,ON
  155. innodb_log_file_size,50331648
  156. innodb_log_files_in_group,2
  157. innodb_log_group_home_dir,.\
  158. innodb_lru_scan_depth,1024
  159. innodb_max_dirty_pages_pct,75
  160. innodb_max_dirty_pages_pct_lwm,0
  161. innodb_max_purge_lag,0
  162. innodb_max_purge_lag_delay,0
  163. innodb_mirrored_log_groups,1
  164. innodb_monitor_disable,
  165. innodb_monitor_enable,
  166. innodb_monitor_reset,
  167. innodb_monitor_reset_all,
  168. innodb_old_blocks_pct,37
  169. innodb_old_blocks_time,1000
  170. innodb_online_alter_log_max_size,134217728
  171. innodb_open_files,300
  172. innodb_optimize_fulltext_only,OFF
  173. innodb_page_size,16384
  174. innodb_print_all_deadlocks,OFF
  175. innodb_purge_batch_size,300
  176. innodb_purge_threads,1
  177. innodb_random_read_ahead,OFF
  178. innodb_read_ahead_threshold,56
  179. innodb_read_io_threads,4
  180. innodb_read_only,OFF
  181. innodb_replication_delay,0
  182. innodb_rollback_on_timeout,OFF
  183. innodb_rollback_segments,128
  184. innodb_sort_buffer_size,1048576
  185. innodb_spin_wait_delay,6
  186. innodb_stats_auto_recalc,ON
  187. innodb_stats_method,nulls_equal
  188. innodb_stats_on_metadata,OFF
  189. innodb_stats_persistent,ON
  190. innodb_stats_persistent_sample_pages,20
  191. innodb_stats_sample_pages,8
  192. innodb_stats_transient_sample_pages,8
  193. innodb_strict_mode,OFF
  194. innodb_support_xa,ON
  195. innodb_sync_array_size,1
  196. innodb_sync_spin_loops,30
  197. innodb_table_locks,ON
  198. innodb_thread_concurrency,17
  199. innodb_thread_sleep_delay,0
  200. innodb_undo_directory,.
  201. innodb_undo_logs,128
  202. innodb_undo_tablespaces,0
  203. innodb_use_native_aio,ON
  204. innodb_use_sys_malloc,ON
  205. innodb_version,5.6.13
  206. innodb_write_io_threads,4
  207. insert_id,0
  208. interactive_timeout,28800
  209. join_buffer_size,262144
  210. keep_files_on_create,OFF
  211. key_buffer_size,8388608
  212. key_cache_age_threshold,300
  213. key_cache_block_size,1024
  214. key_cache_division_limit,100
  215. large_files_support,ON
  216. large_page_size,0
  217. large_pages,OFF
  218. last_insert_id,0
  219. lc_messages,en_US
  220. lc_messages_dir,"C:\Program Files\MySQL\MySQL Server 5.6\share\"
  221. lc_time_names,en_US
  222. license,GPL
  223. local_infile,ON
  224. lock_wait_timeout,31536000
  225. log_bin,OFF
  226. log_bin_basename,
  227. log_bin_index,
  228. log_bin_trust_function_creators,OFF
  229. log_bin_use_v1_row_events,OFF
  230. log_error,D:\MYSQL\logs\error.log
  231. log_output,FILE
  232. log_queries_not_using_indexes,OFF
  233. log_slave_updates,OFF
  234. log_slow_admin_statements,OFF
  235. log_slow_slave_statements,OFF
  236. log_throttle_queries_not_using_indexes,0
  237. log_warnings,1
  238. long_query_time,10.000000
  239. low_priority_updates,OFF
  240. lower_case_file_system,ON
  241. lower_case_table_names,1
  242. master_info_repository,FILE
  243. master_verify_checksum,OFF
  244. max_allowed_packet,4194304
  245. max_binlog_cache_size,18446744073709547520
  246. max_binlog_size,1073741824
  247. max_binlog_stmt_cache_size,18446744073709547520
  248. max_connect_errors,100
  249. max_connections,250
  250. max_delayed_threads,20
  251. max_error_count,64
  252. max_heap_table_size,16777216
  253. max_insert_delayed_threads,20
  254. max_join_size,18446744073709551615
  255. max_length_for_sort_data,1024
  256. max_prepared_stmt_count,16382
  257. max_relay_log_size,0
  258. max_seeks_for_key,4294967295
  259. max_sort_length,1024
  260. max_sp_recursion_depth,0
  261. max_tmp_tables,32
  262. max_user_connections,0
  263. max_write_lock_count,4294967295
  264. metadata_locks_cache_size,1024
  265. metadata_locks_hash_instances,8
  266. min_examined_row_limit,0
  267. multi_range_count,256
  268. myisam_data_pointer_size,6
  269. myisam_max_sort_file_size,107374182400
  270. myisam_mmap_size,18446744073709551615
  271. myisam_recover_options,OFF
  272. myisam_repair_threads,1
  273. myisam_sort_buffer_size,373293056
  274. myisam_stats_method,nulls_unequal
  275. myisam_use_mmap,OFF
  276. named_pipe,OFF
  277. net_buffer_length,16384
  278. net_read_timeout,30
  279. net_retry_count,10
  280. net_write_timeout,60
  281. new,OFF
  282. old,OFF
  283. old_alter_table,OFF
  284. old_passwords,0
  285. open_files_limit,6308
  286. optimizer_prune_level,1
  287. optimizer_search_depth,62
  288. optimizer_switch,"index_merge=ON,index_merge_union=ON,index_merge_sort_union=ON,index_merge_intersection=ON,engine_condition_pushdown=ON,index_condition_pushdown=ON,mrr=ON,mrr_cost_based=ON,block_nested_loop=ON,batched_key_access=off,materialization=ON,semijoin=ON,loosescan=ON,firstmatch=ON,subquery_materialization_cost_based=ON,use_index_extensions=ON"
  289. optimizer_trace,"enabled=off,one_line=off"
  290. optimizer_trace_features,"greedy_search=ON,range_optimizer=ON,dynamic_range=ON,repeated_subselect=ON"
  291. optimizer_trace_limit,1
  292. optimizer_trace_max_mem_size,16384
  293. optimizer_trace_offset,-1
  294. performance_schema,ON
  295. performance_schema_accounts_size,100
  296. performance_schema_digests_size,10000
  297. performance_schema_events_stages_history_long_size,10000
  298. performance_schema_events_stages_history_size,10
  299. performance_schema_events_statements_history_long_size,10000
  300. performance_schema_events_statements_history_size,10
  301. performance_schema_events_waits_history_long_size,10000
  302. performance_schema_events_waits_history_size,10
  303. performance_schema_hosts_size,100
  304. performance_schema_max_cond_classes,80
  305. performance_schema_max_cond_instances,3900
  306. performance_schema_max_file_classes,50
  307. performance_schema_max_file_handles,32768
  308. performance_schema_max_file_instances,6770
  309. performance_schema_max_mutex_classes,200
  310. performance_schema_max_mutex_instances,16500
  311. performance_schema_max_rwlock_classes,30
  312. performance_schema_max_rwlock_instances,9300
  313. performance_schema_max_socket_classes,10
  314. performance_schema_max_socket_instances,520
  315. performance_schema_max_stage_classes,150
  316. performance_schema_max_statement_classes,168
  317. performance_schema_max_table_handles,4000
  318. performance_schema_max_table_instances,12500
  319. performance_schema_max_thread_classes,50
  320. performance_schema_max_thread_instances,600
  321. performance_schema_session_connect_attrs_size,512
  322. performance_schema_setup_actors_size,100
  323. performance_schema_setup_objects_size,100
  324. performance_schema_users_size,100
  325. pid_file,D:\MYSQL\data\521144-web1.pid
  326. plugin_dir,"C:\Program Files\MySQL\MySQL Server 5.6\lib\plugin\"
  327. port,3306
  328. preload_buffer_size,32768
  329. profiling,OFF
  330. profiling_history_size,15
  331. protocol_version,10
  332. proxy_user,
  333. pseudo_slave_mode,OFF
  334. pseudo_thread_id,21015
  335. query_alloc_block_size,8192
  336. query_cache_limit,1048576
  337. query_cache_min_res_unit,4096
  338. query_cache_size,0
  339. query_cache_type,OFF
  340. query_cache_wlock_invalidate,OFF
  341. query_prealloc_size,8192
  342. rand_seed1,0
  343. rand_seed2,0
  344. range_alloc_block_size,4096
  345. read_buffer_size,65536
  346. read_only,OFF
  347. read_rnd_buffer_size,262144
  348. relay_log,
  349. relay_log_basename,
  350. relay_log_index,
  351. relay_log_info_file,relay-log.info
  352. relay_log_info_repository,FILE
  353. relay_log_purge,ON
  354. relay_log_recovery,OFF
  355. relay_log_space_limit,0
  356. report_host,
  357. report_password,
  358. report_port,3306
  359. report_user,
  360. rpl_stop_slave_timeout,31536000
  361. secure_auth,ON
  362. secure_file_priv,
  363. server_id,0
  364. server_id_bits,32
  365. server_uuid,c9ce50ce-13aa-11e3-831b-b8ac6f900bdd
  366. shared_memory,OFF
  367. shared_memory_base_name,MYSQL
  368. skip_external_locking,ON
  369. skip_name_resolve,OFF
  370. skip_networking,OFF
  371. skip_show_database,OFF
  372. slave_allow_batching,OFF
  373. slave_checkpoint_group,512
  374. slave_checkpoint_period,300
  375. slave_compressed_protocol,OFF
  376. slave_exec_mode,STRICT
  377. slave_load_tmpdir,C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp
  378. slave_max_allowed_packet,1073741824
  379. slave_net_timeout,3600
  380. slave_parallel_workers,0
  381. slave_pending_jobs_size_max,16777216
  382. slave_rows_search_algorithms,"TABLE_SCAN,INDEX_SCAN"
  383. slave_skip_errors,OFF
  384. slave_sql_verify_checksum,ON
  385. slave_transaction_retries,10
  386. slave_type_conversions,
  387. slow_launch_time,2
  388. slow_query_log,ON
  389. slow_query_log_file,D:/MYSQL/logs/slow_query.log
  390. socket,MySQL
  391. sort_buffer_size,2097152
  392. sql_auto_is_null,OFF
  393. sql_big_selects,ON
  394. sql_buffer_result,OFF
  395. sql_log_bin,ON
  396. sql_log_off,OFF
  397. sql_mode,"STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  398. sql_notes,ON
  399. sql_quote_show_create,ON
  400. sql_safe_updates,OFF
  401. sql_select_limit,18446744073709551615
  402. sql_slave_skip_counter,0
  403. sql_warnings,OFF
  404. ssl_ca,
  405. ssl_capath,
  406. ssl_cert,
  407. ssl_cipher,
  408. ssl_crl,
  409. ssl_crlpath,
  410. ssl_key,
  411. storage_engine,InnoDB
  412. stored_program_cache,256
  413. sync_binlog,0
  414. sync_frm,ON
  415. sync_master_info,10000
  416. sync_relay_log,10000
  417. sync_relay_log_info,10000
  418. system_time_zone,"GMT Standard TIME"
  419. table_definition_cache,1400
  420. table_open_cache,2000
  421. table_open_cache_instances,1
  422. thread_cache_size,9
  423. thread_concurrency,10
  424. thread_handling,one-thread-per-connection
  425. thread_stack,262144
  426. time_format,%H:%i:%s
  427. time_zone,SYSTEM
  428. timed_mutexes,OFF
  429. timestamp,1440583107.941044
  430. tmp_table_size,187695104
  431. tmpdir,C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp
  432. transaction_alloc_block_size,8192
  433. transaction_allow_batching,OFF
  434. transaction_prealloc_size,4096
  435. tx_isolation,REPEATABLE-READ
  436. tx_read_only,OFF
  437. unique_checks,ON
  438. updatable_views_with_limit,YES
  439. version,5.6.13-log
  440. version_comment,"MySQL Community Server (GPL)"
  441. version_compile_machine,x86_64
  442. version_compile_os,Win64
  443. wait_timeout,28800
  444. warning_count,0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!