Guest User

SHOW VARIABLES

a guest
Aug 26th, 2015
554
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data