API tools faq
paste
Advertisement
ianhuet

SHOW GLOBAL VARIABLES;

ianhuet
Nov 19th, 2018
318
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 269.77 KB | None | 0 0
raw download clone embed print report
  1. SHOW GLOBAL VARIABLES;
  2. +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  3. | Variable_name | Value |
  4. +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  5. | aria_block_size | 8192 |
  6. | aria_checkpoint_interval | 30 |
  7. | aria_checkpoint_log_activity | 1048576 |
  8. | aria_force_start_after_recovery_failures | 0 |
  9. | aria_group_commit | none |
  10. | aria_group_commit_interval | 0 |
  11. | aria_log_file_size | 1073741824 |
  12. | aria_log_purge_type | immediate |
  13. | aria_max_sort_file_size | 9223372036853727232 |
  14. | aria_page_checksum | ON |
  15. | aria_pagecache_age_threshold | 300 |
  16. | aria_pagecache_buffer_size | 134217728 |
  17. | aria_pagecache_division_limit | 100 |
  18. | aria_recover | NORMAL |
  19. | aria_repair_threads | 1 |
  20. | aria_sort_buffer_size | 134217728 |
  21. | aria_stats_method | nulls_unequal |
  22. | aria_sync_log_dir | NEWFILE |
  23. | aria_used_for_temp_tables | ON |
  24. | auto_increment_increment | 1 |
  25. | auto_increment_offset | 1 |
  26. | autocommit | ON |
  27. | automatic_sp_privileges | ON |
  28. | back_log | 50 |
  29. | basedir | /usr |
  30. | big_tables | OFF |
  31. | binlog_annotate_row_events | OFF |
  32. | binlog_cache_size | 32768 |
  33. | binlog_checksum | NONE |
  34. | binlog_direct_non_transactional_updates | OFF |
  35. | binlog_format | STATEMENT |
  36. | binlog_optimize_thread_scheduling | ON |
  37. | binlog_stmt_cache_size | 32768 |
  38. | bulk_insert_buffer_size | 8388608 |
  39. | character_set_client | latin1 |
  40. | character_set_connection | latin1 |
  41. | character_set_database | latin1 |
  42. | character_set_filesystem | binary |
  43. | character_set_results | latin1 |
  44. | character_set_server | latin1 |
  45. | character_set_system | utf8 |
  46. | character_sets_dir | /usr/share/mysql/charsets/ |
  47. | collation_connection | latin1_swedish_ci |
  48. | collation_database | latin1_swedish_ci |
  49. | collation_server | latin1_swedish_ci |
  50. | completion_type | NO_CHAIN |
  51. | concurrent_insert | AUTO |
  52. | connect_timeout | 10 |
  53. | datadir | /var/lib/mysql/ |
  54. | date_format | %Y-%m-%d |
  55. | datetime_format | %Y-%m-%d %H:%i:%s |
  56. | deadlock_search_depth_long | 15 |
  57. | deadlock_search_depth_short | 4 |
  58. | deadlock_timeout_long | 50000000 |
  59. | deadlock_timeout_short | 10000 |
  60. | debug_no_thread_alarm | OFF |
  61. | default_storage_engine | MyISAM |
  62. | default_week_format | 0 |
  63. | delay_key_write | ON |
  64. | delayed_insert_limit | 100 |
  65. | delayed_insert_timeout | 300 |
  66. | delayed_queue_size | 1000 |
  67. | div_precision_increment | 4 |
  68. | engine_condition_pushdown | OFF |
  69. | event_scheduler | OFF |
  70. | expensive_subquery_limit | 100 |
  71. | expire_logs_days | 0 |
  72. | extra_max_connections | 1 |
  73. | extra_port | 0 |
  74. | flush | OFF |
  75. | flush_time | 0 |
  76. | foreign_key_checks | ON |
  77. | ft_boolean_syntax | + -><()~*:""&| |
  78. | ft_max_word_len | 84 |
  79. | ft_min_word_len | 4 |
  80. | ft_query_expansion_limit | 20 |
  81. | ft_stopword_file | (built-in) |
  82. | general_log | OFF |
  83. | general_log_file | server.log |
  84. | group_concat_max_len | 1024 |
  85. | have_compress | YES |
  86. | have_crypt | YES |
  87. | have_csv | YES |
  88. | have_dynamic_loading | YES |
  89. | have_geometry | YES |
  90. | have_innodb | YES |
  91. | have_ndbcluster | NO |
  92. | have_openssl | DISABLED |
  93. | have_partitioning | YES |
  94. | have_profiling | YES |
  95. | have_query_cache | YES |
  96. | have_rtree_keys | YES |
  97. | have_ssl | DISABLED |
  98. | have_symlink | DISABLED |
  99. | hostname | server.propertyweek.ie |
  100. | ignore_builtin_innodb | OFF |
  101. | ignore_db_dirs | |
  102. | init_connect | |
  103. | init_file | |
  104. | init_slave | |
  105. | innodb_adaptive_flushing | ON |
  106. | innodb_adaptive_flushing_method | estimate |
  107. | innodb_adaptive_hash_index | ON |
  108. | innodb_adaptive_hash_index_partitions | 1 |
  109. | innodb_additional_mem_pool_size | 8388608 |
  110. | innodb_autoextend_increment | 8 |
  111. | innodb_autoinc_lock_mode | 1 |
  112. | innodb_blocking_buffer_pool_restore | OFF |
  113. | innodb_buffer_pool_instances | 1 |
  114. | innodb_buffer_pool_populate | OFF |
  115. | innodb_buffer_pool_restore_at_startup | 0 |
  116. | innodb_buffer_pool_shm_checksum | ON |
  117. | innodb_buffer_pool_shm_key | 0 |
  118. | innodb_buffer_pool_size | 792723456 |
  119. | innodb_change_buffering | all |
  120. | innodb_checkpoint_age_target | 0 |
  121. | innodb_checksums | ON |
  122. | innodb_commit_concurrency | 0 |
  123. | innodb_concurrency_tickets | 500 |
  124. | innodb_corrupt_table_action | assert |
  125. | innodb_data_file_path | ibdata1:10M:autoextend |
  126. | innodb_data_home_dir | |
  127. | innodb_dict_size_limit | 0 |
  128. | innodb_doublewrite | ON |
  129. | innodb_doublewrite_file | |
  130. | innodb_fake_changes | OFF |
  131. | innodb_fast_checksum | OFF |
  132. | innodb_fast_shutdown | 1 |
  133. | innodb_file_format | Antelope |
  134. | innodb_file_format_check | ON |
  135. | innodb_file_format_max | Antelope |
  136. | innodb_file_per_table | OFF |
  137. | innodb_flush_log_at_trx_commit | 1 |
  138. | innodb_flush_method | |
  139. | innodb_flush_neighbor_pages | area |
  140. | innodb_force_load_corrupted | OFF |
  141. | innodb_force_recovery | 0 |
  142. | innodb_ibuf_accel_rate | 100 |
  143. | innodb_ibuf_active_contract | 1 |
  144. | innodb_ibuf_max_size | 396345344 |
  145. | innodb_import_table_from_xtrabackup | 0 |
  146. | innodb_io_capacity | 200 |
  147. | innodb_kill_idle_transaction | 0 |
  148. | innodb_large_prefix | OFF |
  149. | innodb_lazy_drop_table | 0 |
  150. | innodb_lock_wait_timeout | 50 |
  151. | innodb_locking_fake_changes | ON |
  152. | innodb_locks_unsafe_for_binlog | OFF |
  153. | innodb_log_block_size | 512 |
  154. | innodb_log_buffer_size | 8388608 |
  155. | innodb_log_file_size | 5242880 |
  156. | innodb_log_files_in_group | 2 |
  157. | innodb_log_group_home_dir | ./ |
  158. | innodb_max_bitmap_file_size | 104857600 |
  159. | innodb_max_changed_pages | 1000000 |
  160. | innodb_max_dirty_pages_pct | 75 |
  161. | innodb_max_purge_lag | 0 |
  162. | innodb_merge_sort_block_size | 1048576 |
  163. | innodb_mirrored_log_groups | 1 |
  164. | innodb_old_blocks_pct | 37 |
  165. | innodb_old_blocks_time | 0 |
  166. | innodb_open_files | 300 |
  167. | innodb_page_size | 16384 |
  168. | innodb_print_all_deadlocks | OFF |
  169. | innodb_purge_batch_size | 20 |
  170. | innodb_purge_threads | 1 |
  171. | innodb_random_read_ahead | OFF |
  172. | innodb_read_ahead | linear |
  173. | innodb_read_ahead_threshold | 56 |
  174. | innodb_read_io_threads | 4 |
  175. | innodb_recovery_stats | OFF |
  176. | innodb_recovery_update_relay_log | OFF |
  177. | innodb_replication_delay | 0 |
  178. | innodb_rollback_on_timeout | OFF |
  179. | innodb_rollback_segments | 128 |
  180. | innodb_show_locks_held | 10 |
  181. | innodb_show_verbose_locks | 0 |
  182. | innodb_simulate_comp_failures | 0 |
  183. | innodb_spin_wait_delay | 6 |
  184. | innodb_stats_auto_update | 1 |
  185. | innodb_stats_method | nulls_equal |
  186. | innodb_stats_modified_counter | 0 |
  187. | innodb_stats_on_metadata | ON |
  188. | innodb_stats_sample_pages | 8 |
  189. | innodb_stats_traditional | ON |
  190. | innodb_stats_update_need_lock | 1 |
  191. | innodb_strict_mode | OFF |
  192. | innodb_support_xa | ON |
  193. | innodb_sync_spin_loops | 30 |
  194. | innodb_table_locks | ON |
  195. | innodb_thread_concurrency | 0 |
  196. | innodb_thread_concurrency_timer_based | OFF |
  197. | innodb_thread_sleep_delay | 10000 |
  198. | innodb_track_changed_pages | OFF |
  199. | innodb_use_atomic_writes | OFF |
  200. | innodb_use_fallocate | OFF |
  201. | innodb_use_global_flush_log_at_trx_commit | ON |
  202. | innodb_use_native_aio | ON |
  203. | innodb_use_stacktrace | OFF |
  204. | innodb_use_sys_malloc | ON |
  205. | innodb_use_sys_stats_table | OFF |
  206. | innodb_version | 5.5.59-MariaDB-38.11 |
  207. | innodb_write_io_threads | 4 |
  208. | interactive_timeout | 28800 |
  209. | join_buffer_size | 131072 |
  210. | join_buffer_space_limit | 2097152 |
  211. | join_cache_level | 2 |
  212. | keep_files_on_create | OFF |
  213. | key_buffer_size | 33554432 |
  214. | key_cache_age_threshold | 300 |
  215. | key_cache_block_size | 1024 |
  216. | key_cache_division_limit | 100 |
  217. | key_cache_segments | 0 |
  218. | large_files_support | ON |
  219. | large_page_size | 0 |
  220. | large_pages | OFF |
  221. | lc_messages | en_US |
  222. | lc_messages_dir | |
  223. | lc_time_names | en_US |
  224. | license | GPL |
  225. | local_infile | OFF |
  226. | lock_wait_timeout | 31536000 |
  227. | locked_in_memory | OFF |
  228. | log | OFF |
  229. | log_bin | OFF |
  230. | log_bin_trust_function_creators | OFF |
  231. | log_error | /var/log/mariadb/mariadb.log |
  232. | log_output | FILE |
  233. | log_queries_not_using_indexes | OFF |
  234. | log_slave_updates | OFF |
  235. | log_slow_filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk |
  236. | log_slow_queries | OFF |
  237. | log_slow_rate_limit | 1 |
  238. | log_slow_verbosity | |
  239. | log_warnings | 1 |
  240. | long_query_time | 10.000000 |
  241. | low_priority_updates | OFF |
  242. | lower_case_file_system | OFF |
  243. | lower_case_table_names | 0 |
  244. | master_verify_checksum | OFF |
  245. | max_allowed_packet | 1048576 |
  246. | max_binlog_cache_size | 18446744073709547520 |
  247. | max_binlog_size | 1073741824 |
  248. | max_binlog_stmt_cache_size | 18446744073709547520 |
  249. | max_connect_errors | 10 |
  250. | max_connections | 151 |
  251. | max_delayed_threads | 20 |
  252. | max_error_count | 64 |
  253. | max_heap_table_size | 16777216 |
  254. | max_insert_delayed_threads | 20 |
  255. | max_join_size | 18446744073709551615 |
  256. | max_length_for_sort_data | 1024 |
  257. | max_long_data_size | 1048576 |
  258. | max_prepared_stmt_count | 16382 |
  259. | max_relay_log_size | 0 |
  260. | max_seeks_for_key | 4294967295 |
  261. | max_sort_length | 1024 |
  262. | max_sp_recursion_depth | 0 |
  263. | max_tmp_tables | 32 |
  264. | max_user_connections | 0 |
  265. | max_write_lock_count | 4294967295 |
  266. | metadata_locks_cache_size | 1024 |
  267. | min_examined_row_limit | 0 |
  268. | mrr_buffer_size | 262144 |
  269. | multi_range_count | 256 |
  270. | myisam_block_size | 1024 |
  271. | myisam_data_pointer_size | 6 |
  272. | myisam_max_sort_file_size | 9223372036853727232 |
  273. | myisam_mmap_size | 18446744073709551615 |
  274. | myisam_recover_options | DEFAULT |
  275. | myisam_repair_threads | 1 |
  276. | myisam_sort_buffer_size | 8388608 |
  277. | myisam_stats_method | nulls_unequal |
  278. | myisam_use_mmap | OFF |
  279. | net_buffer_length | 16384 |
  280. | net_read_timeout | 30 |
  281. | net_retry_count | 10 |
  282. | net_write_timeout | 60 |
  283. | old | OFF |
  284. | old_alter_table | OFF |
  285. | old_mode | |
  286. | old_passwords | OFF |
  287. | open_files_limit | 1024 |
  288. | optimizer_prune_level | 1 |
  289. | optimizer_search_depth | 62 |
  290. | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off |
  291. | performance_schema | OFF |
  292. | performance_schema_events_waits_history_long_size | 10000 |
  293. | performance_schema_events_waits_history_size | 10 |
  294. | performance_schema_max_cond_classes | 80 |
  295. | performance_schema_max_cond_instances | 1000 |
  296. | performance_schema_max_file_classes | 50 |
  297. | performance_schema_max_file_handles | 32768 |
  298. | performance_schema_max_file_instances | 10000 |
  299. | performance_schema_max_mutex_classes | 200 |
  300. | performance_schema_max_mutex_instances | 1000000 |
  301. | performance_schema_max_rwlock_classes | 30 |
  302. | performance_schema_max_rwlock_instances | 1000000 |
  303. | performance_schema_max_table_handles | 100000 |
  304. | performance_schema_max_table_instances | 50000 |
  305. | performance_schema_max_thread_classes | 50 |
  306. | performance_schema_max_thread_instances | 1000 |
  307. | pid_file | /var/run/mariadb/mariadb.pid |
  308. | plugin_dir | /usr/lib64/mysql/plugin/ |
  309. | plugin_maturity | unknown |
  310. | port | 3306 |
  311. | preload_buffer_size | 32768 |
  312. | profiling | OFF |
  313. | profiling_history_size | 15 |
  314. | progress_report_time | 5 |
  315. | protocol_version | 10 |
  316. | query_alloc_block_size | 8192 |
  317. | query_cache_limit | 2097152 |
  318. | query_cache_min_res_unit | 4096 |
  319. | query_cache_size | 268435456 |
  320. | query_cache_strip_comments | ON |
  321. | query_cache_type | ON |
  322. | query_cache_wlock_invalidate | OFF |
  323. | query_prealloc_size | 8192 |
  324. | range_alloc_block_size | 4096 |
  325. | read_buffer_size | 131072 |
  326. | read_only | OFF |
  327. | read_rnd_buffer_size | 262144 |
  328. | relay_log | |
  329. | relay_log_index | |
  330. | relay_log_info_file | relay-log.info |
  331. | relay_log_purge | ON |
  332. | relay_log_recovery | OFF |
  333. | relay_log_space_limit | 0 |
  334. | replicate_annotate_row_events | OFF |
  335. | replicate_do_db | |
  336. | replicate_do_table | |
  337. | replicate_events_marked_for_skip | replicate |
  338. | replicate_ignore_db | |
  339. | replicate_ignore_table | |
  340. | replicate_wild_do_table | |
  341. | replicate_wild_ignore_table | |
  342. | report_host | |
  343. | report_password | |
  344. | report_port | 3306 |
  345. | report_user | |
  346. | rowid_merge_buff_size | 8388608 |
  347. | rpl_recovery_rank | 0 |
  348. | secure_auth | OFF |
  349. | secure_file_priv | |
  350. | server_id | 0 |
  351. | skip_external_locking | ON |
  352. | skip_name_resolve | OFF |
  353. | skip_networking | OFF |
  354. | skip_show_database | OFF |
  355. | slave_compressed_protocol | OFF |
  356. | slave_exec_mode | STRICT |
  357. | slave_load_tmpdir | /var/tmp |
  358. | slave_max_allowed_packet | 1073741824 |
  359. | slave_net_timeout | 3600 |
  360. | slave_skip_errors | OFF |
  361. | slave_sql_verify_checksum | ON |
  362. | slave_transaction_retries | 10 |
  363. | slave_type_conversions | |
  364. | slow_launch_time | 2 |
  365. | slow_query_log | OFF |
  366. | slow_query_log_file | server-slow.log |
  367. | socket | /var/lib/mysql/mysql.sock |
  368. | sort_buffer_size | 2097152 |
  369. | sql_auto_is_null | OFF |
  370. | sql_big_selects | ON |
  371. | sql_big_tables | OFF |
  372. | sql_buffer_result | OFF |
  373. | sql_log_bin | ON |
  374. | sql_log_off | OFF |
  375. | sql_low_priority_updates | OFF |
  376. | sql_max_join_size | 18446744073709551615 |
  377. | sql_mode | |
  378. | sql_notes | ON |
  379. | sql_quote_show_create | ON |
  380. | sql_safe_updates | OFF |
  381. | sql_select_limit | 18446744073709551615 |
  382. | sql_slave_skip_counter | 0 |
  383. | sql_warnings | OFF |
  384. | ssl_ca | |
  385. | ssl_capath | |
  386. | ssl_cert | |
  387. | ssl_cipher | |
  388. | ssl_key | |
  389. | storage_engine | MyISAM |
  390. | stored_program_cache | 256 |
  391. | sync_binlog | 0 |
  392. | sync_frm | ON |
  393. | sync_master_info | 0 |
  394. | sync_relay_log | 0 |
  395. | sync_relay_log_info | 0 |
  396. | system_time_zone | GMT |
  397. | table_definition_cache | 400 |
  398. | table_open_cache | 400 |
  399. | thread_cache_size | 4 |
  400. | thread_concurrency | 10 |
  401. | thread_handling | one-thread-per-connection |
  402. | thread_pool_idle_timeout | 60 |
  403. | thread_pool_max_threads | 500 |
  404. | thread_pool_oversubscribe | 3 |
  405. | thread_pool_size | 2 |
  406. | thread_pool_stall_limit | 500 |
  407. | thread_stack | 294912 |
  408. | time_format | %H:%i:%s |
  409. | time_zone | SYSTEM |
  410. | timed_mutexes | OFF |
  411. | tmp_table_size | 16777216 |
  412. | tmpdir | /var/tmp |
  413. | transaction_alloc_block_size | 8192 |
  414. | transaction_prealloc_size | 4096 |
  415. | tx_isolation | REPEATABLE-READ |
  416. | unique_checks | ON |
  417. | updatable_views_with_limit | YES |
  418. | userstat | OFF |
  419. | version | 5.5.60-MariaDB |
  420. | version_comment | MariaDB Server |
  421. | version_compile_machine | x86_64 |
  422. | version_compile_os | Linux |
  423. | wait_timeout | 28800 |
  424. +---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
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!