Guest User

SHOW GLOBAL VARIABLES

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