API tools faq
paste
Advertisement
Guest User

SHOW GLOBAL VARIABLES

a guest
Aug 26th, 2015
462
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 12.37 KB | None | 0 0
raw download clone embed print report
  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
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!