API tools faq
paste
Advertisement
roozgar

SHOW GLOBAL VARIABLES;

roozgar
Jun 15th, 2019
253
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.62 KB | None | 0 0
raw download clone embed print report
  1. Variable_name Value
  2. aria_block_size 8192
  3. aria_checkpoint_interval 30
  4. aria_checkpoint_log_activity 1048576
  5. aria_encrypt_tables OFF
  6. aria_force_start_after_recovery_failures 0
  7. aria_group_commit none
  8. aria_group_commit_interval 0
  9. aria_log_file_size 1073741824
  10. aria_log_purge_type immediate
  11. aria_max_sort_file_size 9.22337E+18
  12. aria_page_checksum ON
  13. aria_pagecache_age_threshold 300
  14. aria_pagecache_buffer_size 134217728
  15. aria_pagecache_division_limit 100
  16. aria_pagecache_file_hash_size 512
  17. aria_recover NORMAL
  18. aria_repair_threads 1
  19. aria_sort_buffer_size 268434432
  20. aria_stats_method nulls_unequal
  21. aria_sync_log_dir NEWFILE
  22. aria_used_for_temp_tables ON
  23. auto_increment_increment 1
  24. auto_increment_offset 1
  25. autocommit ON
  26. automatic_sp_privileges ON
  27. back_log 900
  28. basedir c:\xampp\mysql\
  29. big_tables OFF
  30. binlog_annotate_row_events OFF
  31. binlog_cache_size 32768
  32. binlog_checksum NONE
  33. binlog_commit_wait_count 0
  34. binlog_commit_wait_usec 100000
  35. binlog_direct_non_transactional_updates OFF
  36. binlog_format STATEMENT
  37. binlog_optimize_thread_scheduling ON
  38. binlog_row_image FULL
  39. binlog_stmt_cache_size 32768
  40. bulk_insert_buffer_size 8388608
  41. character_set_client latin1
  42. character_set_connection latin1
  43. character_set_database latin1
  44. character_set_filesystem binary
  45. character_set_results latin1
  46. character_set_server latin1
  47. character_set_system utf8
  48. character_sets_dir c:\xampp\mysql\share\charsets\
  49. collation_connection latin1_swedish_ci
  50. collation_database latin1_swedish_ci
  51. collation_server latin1_swedish_ci
  52. completion_type NO_CHAIN
  53. concurrent_insert AUTO
  54. connect_timeout 10
  55. core_file OFF
  56. datadir c:\xampp\mysql\data\
  57. date_format %Y-%m-%d
  58. datetime_format %Y-%m-%d %H:%i:%s
  59. deadlock_search_depth_long 15
  60. deadlock_search_depth_short 4
  61. deadlock_timeout_long 50000000
  62. deadlock_timeout_short 10000
  63. debug_no_thread_alarm OFF
  64. default_regex_flags
  65. default_storage_engine InnoDB
  66. default_tmp_storage_engine
  67. default_week_format 0
  68. delay_key_write ON
  69. delayed_insert_limit 100
  70. delayed_insert_timeout 300
  71. delayed_queue_size 1000
  72. div_precision_increment 4
  73. encrypt_binlog OFF
  74. encrypt_tmp_disk_tables OFF
  75. encrypt_tmp_files OFF
  76. enforce_storage_engine
  77. event_scheduler OFF
  78. expensive_subquery_limit 100
  79. expire_logs_days 0
  80. explicit_defaults_for_timestamp OFF
  81. extra_max_connections 1
  82. extra_port 0
  83. flush OFF
  84. flush_time 0
  85. foreign_key_checks ON
  86. ft_boolean_syntax + -><()~*:""&|
  87. ft_max_word_len 84
  88. ft_min_word_len 4
  89. ft_query_expansion_limit 20
  90. ft_stopword_file (built-in)
  91. general_log OFF
  92. general_log_file WIN-MQSFO0HAO75.log
  93. group_concat_max_len 1024
  94. gtid_binlog_pos 0-1-3249453
  95. gtid_binlog_state 0-1-3249453
  96. gtid_current_pos 0-1-3249453
  97. gtid_domain_id 0
  98. gtid_ignore_duplicates OFF
  99. gtid_slave_pos
  100. gtid_strict_mode OFF
  101. have_compress YES
  102. Variable_name Value
  103. have_crypt NO
  104. have_dynamic_loading YES
  105. have_geometry YES
  106. have_openssl NO
  107. have_profiling YES
  108. have_query_cache YES
  109. have_rtree_keys YES
  110. have_ssl DISABLED
  111. have_symlink NO
  112. histogram_size 0
  113. histogram_type SINGLE_PREC_HB
  114. host_cache_size 853
  115. hostname WIN-MQSFO0HAO75
  116. ignore_builtin_innodb OFF
  117. ignore_db_dirs
  118. init_connect
  119. init_file
  120. init_slave
  121. innodb_adaptive_flushing ON
  122. innodb_adaptive_flushing_lwm 10
  123. innodb_adaptive_hash_index ON
  124. innodb_adaptive_hash_index_partitions 1
  125. innodb_adaptive_max_sleep_delay 150000
  126. innodb_additional_mem_pool_size 8388608
  127. innodb_api_bk_commit_interval 5
  128. innodb_api_disable_rowlock OFF
  129. innodb_api_enable_binlog OFF
  130. innodb_api_enable_mdl OFF
  131. innodb_api_trx_level 0
  132. innodb_autoextend_increment 64
  133. innodb_autoinc_lock_mode 1
  134. innodb_background_scrub_data_check_interval 3600
  135. innodb_background_scrub_data_compressed OFF
  136. innodb_background_scrub_data_interval 604800
  137. innodb_background_scrub_data_uncompressed OFF
  138. innodb_buf_dump_status_frequency 0
  139. innodb_buffer_pool_dump_at_shutdown OFF
  140. innodb_buffer_pool_dump_now OFF
  141. innodb_buffer_pool_dump_pct 100
  142. innodb_buffer_pool_filename ib_buffer_pool
  143. innodb_buffer_pool_instances 20
  144. innodb_buffer_pool_load_abort OFF
  145. innodb_buffer_pool_load_at_startup OFF
  146. innodb_buffer_pool_load_now OFF
  147. innodb_buffer_pool_populate OFF
  148. innodb_buffer_pool_size 21474836480
  149. innodb_change_buffer_max_size 25
  150. innodb_change_buffering all
  151. innodb_checksum_algorithm INNODB
  152. innodb_checksums ON
  153. innodb_cleaner_lsn_age_factor HIGH_CHECKPOINT
  154. innodb_cmp_per_index_enabled OFF
  155. innodb_commit_concurrency 0
  156. innodb_compression_algorithm zlib
  157. innodb_compression_failure_threshold_pct 5
  158. innodb_compression_level 6
  159. innodb_compression_pad_pct_max 50
  160. innodb_concurrency_tickets 5000
  161. innodb_corrupt_table_action assert
  162. innodb_data_file_path ibdata1:12M:autoextend
  163. innodb_data_home_dir
  164. innodb_default_encryption_key_id 1
  165. innodb_default_row_format compact
  166. innodb_defragment OFF
  167. innodb_defragment_fill_factor 0.9
  168. innodb_defragment_fill_factor_n_recs 20
  169. innodb_defragment_frequency 40
  170. innodb_defragment_n_pages 7
  171. innodb_defragment_stats_accuracy 0
  172. innodb_disable_sort_file_cache OFF
  173. innodb_doublewrite ON
  174. innodb_empty_free_list_algorithm BACKOFF
  175. innodb_encrypt_log OFF
  176. innodb_encrypt_tables OFF
  177. innodb_encryption_rotate_key_age 1
  178. innodb_encryption_rotation_iops 100
  179. innodb_encryption_threads 0
  180. innodb_fake_changes OFF
  181. innodb_fast_shutdown 1
  182. innodb_fatal_semaphore_wait_threshold 600
  183. innodb_file_format Antelope
  184. innodb_file_format_check ON
  185. innodb_file_format_max Antelope
  186. innodb_file_per_table ON
  187. innodb_flush_log_at_timeout 1
  188. innodb_flush_log_at_trx_commit 1
  189. innodb_flush_method
  190. innodb_flush_neighbors 1
  191. innodb_flushing_avg_loops 30
  192. innodb_force_load_corrupted OFF
  193. innodb_force_primary_key OFF
  194. innodb_force_recovery 0
  195. innodb_foreground_preflush EXPONENTIAL_BACKOFF
  196. innodb_ft_aux_table
  197. innodb_ft_cache_size 8000000
  198. innodb_ft_enable_diag_print OFF
  199. innodb_ft_enable_stopword ON
  200. innodb_ft_max_token_size 84
  201. innodb_ft_min_token_size 3
  202. innodb_ft_num_word_optimize 2000
  203. Variable_name Value
  204. innodb_ft_result_cache_limit 2000000000
  205. innodb_ft_server_stopword_table
  206. innodb_ft_sort_pll_degree 2
  207. innodb_ft_total_cache_size 640000000
  208. innodb_ft_user_stopword_table
  209. innodb_idle_flush_pct 100
  210. innodb_immediate_scrub_data_uncompressed OFF
  211. innodb_instrument_semaphores OFF
  212. innodb_io_capacity 2000
  213. innodb_io_capacity_max 4000
  214. innodb_kill_idle_transaction 0
  215. innodb_large_prefix OFF
  216. innodb_lock_schedule_algorithm fcfs
  217. innodb_lock_wait_timeout 50
  218. innodb_locking_fake_changes ON
  219. innodb_locks_unsafe_for_binlog OFF
  220. innodb_log_arch_dir .\
  221. innodb_log_arch_expire_sec 0
  222. innodb_log_archive OFF
  223. innodb_log_block_size 512
  224. innodb_log_buffer_size 16777216
  225. innodb_log_checksum_algorithm INNODB
  226. innodb_log_compressed_pages ON
  227. innodb_log_file_size 50331648
  228. innodb_log_files_in_group 2
  229. innodb_log_group_home_dir .\
  230. innodb_lru_scan_depth 1024
  231. innodb_max_bitmap_file_size 104857600
  232. innodb_max_changed_pages 1000000
  233. innodb_max_dirty_pages_pct 75
  234. innodb_max_dirty_pages_pct_lwm 0.001
  235. innodb_max_purge_lag 0
  236. innodb_max_purge_lag_delay 0
  237. innodb_mirrored_log_groups 1
  238. innodb_monitor_disable
  239. innodb_monitor_enable
  240. innodb_monitor_reset
  241. innodb_monitor_reset_all
  242. innodb_mtflush_threads 8
  243. innodb_old_blocks_pct 37
  244. innodb_old_blocks_time 1000
  245. innodb_online_alter_log_max_size 134217728
  246. innodb_open_files 512
  247. innodb_optimize_fulltext_only OFF
  248. innodb_page_size 16384
  249. innodb_prefix_index_cluster_optimization OFF
  250. innodb_print_all_deadlocks OFF
  251. innodb_print_lock_wait_timeout_info OFF
  252. innodb_purge_batch_size 300
  253. innodb_purge_threads 1
  254. innodb_random_read_ahead OFF
  255. innodb_read_ahead_threshold 56
  256. innodb_read_io_threads 64
  257. innodb_read_only OFF
  258. innodb_replication_delay 0
  259. innodb_rollback_on_timeout OFF
  260. innodb_rollback_segments 128
  261. innodb_scrub_log OFF
  262. innodb_scrub_log_speed 256
  263. innodb_show_locks_held 10
  264. innodb_show_verbose_locks 0
  265. innodb_simulate_comp_failures 0
  266. innodb_sort_buffer_size 1048576
  267. innodb_spin_wait_delay 6
  268. innodb_stats_auto_recalc ON
  269. innodb_stats_include_delete_marked OFF
  270. innodb_stats_method nulls_equal
  271. innodb_stats_modified_counter 0
  272. innodb_stats_on_metadata OFF
  273. innodb_stats_persistent ON
  274. innodb_stats_persistent_sample_pages 20
  275. innodb_stats_sample_pages 8
  276. innodb_stats_traditional ON
  277. innodb_stats_transient_sample_pages 8
  278. innodb_status_output OFF
  279. innodb_status_output_locks OFF
  280. innodb_strict_mode OFF
  281. innodb_support_xa ON
  282. innodb_sync_array_size 1
  283. innodb_sync_spin_loops 30
  284. innodb_table_locks ON
  285. innodb_thread_concurrency 0
  286. innodb_thread_sleep_delay 10000
  287. innodb_tmpdir
  288. innodb_track_changed_pages OFF
  289. innodb_undo_directory .
  290. innodb_undo_logs 128
  291. innodb_undo_tablespaces 0
  292. innodb_use_atomic_writes OFF
  293. innodb_use_fallocate OFF
  294. innodb_use_global_flush_log_at_trx_commit ON
  295. innodb_use_mtflush OFF
  296. innodb_use_native_aio ON
  297. innodb_use_stacktrace OFF
  298. innodb_use_sys_malloc ON
  299. innodb_use_trim OFF
  300. innodb_version 5.6.43-84.3
  301. innodb_write_io_threads 64
  302. interactive_timeout 28800
  303. join_buffer_size 262144
  304. Variable_name Value
  305. join_buffer_space_limit 2097152
  306. join_cache_level 2
  307. keep_files_on_create OFF
  308. key_buffer_size 536870912
  309. key_cache_age_threshold 300
  310. key_cache_block_size 1024
  311. key_cache_division_limit 100
  312. key_cache_file_hash_size 512
  313. key_cache_segments 0
  314. large_files_support ON
  315. large_page_size 0
  316. large_pages OFF
  317. lc_messages en_US
  318. lc_messages_dir
  319. lc_time_names en_US
  320. license GPL
  321. local_infile ON
  322. lock_wait_timeout 31536000
  323. log_bin ON
  324. log_bin_basename c:\xampp\mysql\data\mysql-bin
  325. log_bin_index c:\xampp\mysql\data\mysql-bin.index
  326. log_bin_trust_function_creators OFF
  327. log_error
  328. log_output FILE
  329. log_queries_not_using_indexes OFF
  330. log_slave_updates OFF
  331. log_slow_admin_statements OFF
  332. log_slow_filter admin,filesort,filesort_on_disk,full_join,full_sca...
  333. log_slow_rate_limit 1
  334. log_slow_slave_statements OFF
  335. log_slow_verbosity
  336. log_tc_size 24576
  337. log_warnings 1
  338. long_query_time 10
  339. low_priority_updates OFF
  340. lower_case_file_system ON
  341. lower_case_table_names 1
  342. master_verify_checksum OFF
  343. max_allowed_packet 4248576
  344. max_binlog_cache_size 1.84467E+19
  345. max_binlog_size 1073741824
  346. max_binlog_stmt_cache_size 1.84467E+19
  347. max_connect_errors 100
  348. max_connections 5000
  349. max_delayed_threads 20
  350. max_digest_length 1024
  351. max_error_count 64
  352. max_heap_table_size 16777216
  353. max_insert_delayed_threads 20
  354. max_join_size 1.84467E+19
  355. max_length_for_sort_data 1024
  356. max_long_data_size 4248576
  357. max_prepared_stmt_count 16382
  358. max_relay_log_size 1073741824
  359. max_seeks_for_key 4294967295
  360. max_session_mem_used 9.22337E+18
  361. max_sort_length 1024
  362. max_sp_recursion_depth 0
  363. max_statement_time 0
  364. max_tmp_tables 32
  365. max_user_connections 0
  366. max_write_lock_count 4294967295
  367. metadata_locks_cache_size 1024
  368. metadata_locks_hash_instances 8
  369. min_examined_row_limit 0
  370. mrr_buffer_size 262144
  371. multi_range_count 256
  372. myisam_block_size 1024
  373. myisam_data_pointer_size 6
  374. myisam_max_sort_file_size 2146435072
  375. myisam_mmap_size 1.84467E+19
  376. myisam_recover_options DEFAULT
  377. myisam_repair_threads 1
  378. myisam_sort_buffer_size 67108864
  379. myisam_stats_method NULLS_UNEQUAL
  380. myisam_use_mmap OFF
  381. mysql56_temporal_format ON
  382. named_pipe OFF
  383. net_buffer_length 16384
  384. net_read_timeout 30
  385. net_retry_count 10
  386. net_write_timeout 60
  387. old OFF
  388. old_alter_table OFF
  389. old_mode
  390. old_passwords OFF
  391. open_files_limit 27053
  392. optimizer_prune_level 1
  393. optimizer_search_depth 62
  394. optimizer_selectivity_sampling_limit 100
  395. optimizer_switch index_merge=on,index_merge_union=on,index_merge_so...
  396. optimizer_use_condition_selectivity 1
  397. performance_schema OFF
  398. performance_schema_accounts_size -1
  399. performance_schema_digests_size -1
  400. performance_schema_events_stages_history_long_size -1
  401. performance_schema_events_stages_history_size -1
  402. performance_schema_events_statements_history_long_... -1
  403. performance_schema_events_statements_history_size -1
  404. performance_schema_events_waits_history_long_size -1
  405. Variable_name Value
  406. performance_schema_events_waits_history_size -1
  407. performance_schema_hosts_size -1
  408. performance_schema_max_cond_classes 80
  409. performance_schema_max_cond_instances -1
  410. performance_schema_max_digest_length 1024
  411. performance_schema_max_file_classes 50
  412. performance_schema_max_file_handles 32768
  413. performance_schema_max_file_instances -1
  414. performance_schema_max_mutex_classes 200
  415. performance_schema_max_mutex_instances -1
  416. performance_schema_max_rwlock_classes 40
  417. performance_schema_max_rwlock_instances -1
  418. performance_schema_max_socket_classes 10
  419. performance_schema_max_socket_instances -1
  420. performance_schema_max_stage_classes 150
  421. performance_schema_max_statement_classes 178
  422. performance_schema_max_table_handles -1
  423. performance_schema_max_table_instances -1
  424. performance_schema_max_thread_classes 50
  425. performance_schema_max_thread_instances -1
  426. performance_schema_session_connect_attrs_size -1
  427. performance_schema_setup_actors_size 100
  428. performance_schema_setup_objects_size 100
  429. performance_schema_users_size -1
  430. pid_file c:\xampp\mysql\data\WIN-MQSFO0HAO75.pid
  431. plugin_dir c:\xampp\mysql\lib\plugin\
  432. plugin_maturity unknown
  433. port 3306
  434. preload_buffer_size 32768
  435. profiling OFF
  436. profiling_history_size 15
  437. progress_report_time 5
  438. protocol_version 10
  439. query_alloc_block_size 16384
  440. query_cache_limit 1048576
  441. query_cache_min_res_unit 4096
  442. query_cache_size 67108864
  443. query_cache_strip_comments OFF
  444. query_cache_type ON
  445. query_cache_wlock_invalidate OFF
  446. query_prealloc_size 24576
  447. range_alloc_block_size 4096
  448. read_buffer_size 20971520
  449. read_only OFF
  450. read_rnd_buffer_size 8388608
  451. relay_log
  452. relay_log_basename
  453. relay_log_index
  454. relay_log_info_file relay-log.info
  455. relay_log_purge ON
  456. relay_log_recovery OFF
  457. relay_log_space_limit 0
  458. replicate_annotate_row_events OFF
  459. replicate_do_db
  460. replicate_do_table
  461. replicate_events_marked_for_skip REPLICATE
  462. replicate_ignore_db
  463. replicate_ignore_table
  464. replicate_wild_do_table
  465. replicate_wild_ignore_table
  466. report_host
  467. report_password
  468. report_port 3306
  469. report_user
  470. rowid_merge_buff_size 8388608
  471. secure_auth ON
  472. secure_file_priv
  473. server_id 1
  474. shared_memory OFF
  475. shared_memory_base_name MYSQL
  476. skip_external_locking ON
  477. skip_name_resolve OFF
  478. skip_networking OFF
  479. skip_show_database OFF
  480. slave_compressed_protocol OFF
  481. slave_ddl_exec_mode IDEMPOTENT
  482. slave_domain_parallel_threads 0
  483. slave_exec_mode STRICT
  484. slave_load_tmpdir C:\Users\ADMINI~1\AppData\Local\Temp\1
  485. slave_max_allowed_packet 1073741824
  486. slave_net_timeout 3600
  487. slave_parallel_max_queued 131072
  488. slave_parallel_mode conservative
  489. slave_parallel_threads 0
  490. slave_run_triggers_for_rbr NO
  491. slave_skip_errors OFF
  492. slave_sql_verify_checksum ON
  493. slave_transaction_retries 10
  494. slave_type_conversions
  495. slow_launch_time 2
  496. slow_query_log OFF
  497. slow_query_log_file WIN-MQSFO0HAO75-slow.log
  498. socket /tmp/mysql.sock
  499. sort_buffer_size 2097152
  500. sql_auto_is_null OFF
  501. sql_big_selects ON
  502. sql_buffer_result OFF
  503. sql_log_bin ON
  504. sql_log_off OFF
  505. sql_mode NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  506. Variable_name Value
  507. sql_notes ON
  508. sql_quote_show_create ON
  509. sql_safe_updates OFF
  510. sql_select_limit 1.84467E+19
  511. sql_slave_skip_counter 0
  512. sql_warnings OFF
  513. ssl_ca
  514. ssl_capath
  515. ssl_cert
  516. ssl_cipher
  517. ssl_crl
  518. ssl_crlpath
  519. ssl_key
  520. storage_engine InnoDB
  521. stored_program_cache 256
  522. strict_password_validation ON
  523. sync_binlog 0
  524. sync_frm ON
  525. sync_master_info 10000
  526. sync_relay_log 10000
  527. sync_relay_log_info 10000
  528. system_time_zone Asia/Tehran
  529. table_definition_cache 400
  530. table_open_cache 512
  531. thread_cache_size 12
  532. thread_concurrency 12
  533. thread_handling pool-of-threads
  534. thread_pool_max_threads 1000
  535. thread_pool_min_threads 1
  536. thread_stack 299008
  537. time_format %H:%i:%s
  538. time_zone SYSTEM
  539. timed_mutexes OFF
  540. tmp_table_size 16777216
  541. tmpdir C:\Users\ADMINI~1\AppData\Local\Temp\1
  542. transaction_alloc_block_size 8192
  543. transaction_prealloc_size 4096
  544. tx_isolation REPEATABLE-READ
  545. tx_read_only OFF
  546. unique_checks ON
  547. updatable_views_with_limit YES
  548. use_stat_tables NEVER
  549. userstat OFF
  550. version 10.1.39-MariaDB
  551. version_comment mariadb.org binary distribution
  552. version_compile_machine x64
  553. version_compile_os Win64
  554. version_malloc_library system
  555. version_ssl_library YaSSL 2.4.4
  556. 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!