API tools faq
paste
mahmoodn

mysql-var

mahmoodn
Jul 10th, 2020
394
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.54 KB | None | 0 0
raw download clone embed print report
  1. Variable_name Value
  2. auto_generate_certs ON
  3. auto_increment_increment 1
  4. auto_increment_offset 1
  5. autocommit ON
  6. automatic_sp_privileges ON
  7. avoid_temporal_upgrade OFF
  8. back_log 80
  9. basedir /usr/
  10. big_tables OFF
  11. bind_address 127.0.0.1
  12. binlog_cache_size 32768
  13. binlog_checksum CRC32
  14. binlog_direct_non_transactional_updates OFF
  15. binlog_error_action ABORT_SERVER
  16. binlog_format ROW
  17. binlog_group_commit_sync_delay 0
  18. binlog_group_commit_sync_no_delay_count 0
  19. binlog_gtid_simple_recovery ON
  20. binlog_max_flush_queue_time 0
  21. binlog_order_commits ON
  22. binlog_row_image FULL
  23. binlog_rows_query_log_events OFF
  24. binlog_stmt_cache_size 32768
  25. binlog_transaction_dependency_history_size 25000
  26. binlog_transaction_dependency_tracking COMMIT_ORDER
  27. block_encryption_mode aes-128-ecb
  28. bulk_insert_buffer_size 8388608
  29. character_set_client utf8
  30. character_set_connection utf8
  31. character_set_database latin1
  32. character_set_filesystem binary
  33. character_set_results utf8
  34. character_set_server latin1
  35. character_set_system utf8
  36. character_sets_dir /usr/share/mysql/charsets/
  37. check_proxy_users OFF
  38. collation_connection utf8_general_ci
  39. collation_database latin1_swedish_ci
  40. collation_server latin1_swedish_ci
  41. completion_type NO_CHAIN
  42. concurrent_insert AUTO
  43. connect_timeout 10
  44. core_file OFF
  45. datadir /var/lib/mysql/
  46. date_format %Y-%m-%d
  47. datetime_format %Y-%m-%d %H:%i:%s
  48. default_authentication_plugin mysql_native_password
  49. default_password_lifetime 0
  50. default_storage_engine InnoDB
  51. default_tmp_storage_engine InnoDB
  52. default_week_format 0
  53. delay_key_write ON
  54. delayed_insert_limit 100
  55. delayed_insert_timeout 300
  56. delayed_queue_size 1000
  57. disabled_storage_engines
  58. disconnect_on_expired_password ON
  59. div_precision_increment 4
  60. end_markers_in_json OFF
  61. enforce_gtid_consistency OFF
  62. eq_range_index_dive_limit 200
  63. error_count 0
  64. event_scheduler OFF
  65. expire_logs_days 10
  66. explicit_defaults_for_timestamp OFF
  67. external_user root
  68. flush OFF
  69. flush_time 0
  70. foreign_key_checks ON
  71. ft_boolean_syntax + -><()~*:""&|
  72. ft_max_word_len 84
  73. ft_min_word_len 4
  74. ft_query_expansion_limit 20
  75. ft_stopword_file (built-in)
  76. general_log OFF
  77. general_log_file /var/lib/mysql/courseware.log
  78. group_concat_max_len 1024
  79. gtid_executed_compression_period 1000
  80. gtid_mode OFF
  81. gtid_next AUTOMATIC
  82. gtid_owned
  83. gtid_purged
  84. have_compress YES
  85. have_crypt YES
  86. have_dynamic_loading YES
  87. have_geometry YES
  88. have_openssl YES
  89. have_profiling YES
  90. have_query_cache YES
  91. have_rtree_keys YES
  92. have_ssl YES
  93. have_statement_timeout YES
  94. have_symlink YES
  95. host_cache_size 279
  96. hostname courseware
  97. identity 0
  98. ignore_builtin_innodb OFF
  99. ignore_db_dirs
  100. init_connect
  101. init_file
  102. init_slave
  103. innodb_adaptive_flushing ON
  104. innodb_adaptive_flushing_lwm 10
  105. innodb_adaptive_hash_index ON
  106. innodb_adaptive_hash_index_parts 8
  107. innodb_adaptive_max_sleep_delay 150000
  108. innodb_api_bk_commit_interval 5
  109. innodb_api_disable_rowlock OFF
  110. innodb_api_enable_binlog OFF
  111. innodb_api_enable_mdl OFF
  112. innodb_api_trx_level 0
  113. innodb_autoextend_increment 64
  114. innodb_autoinc_lock_mode 1
  115. innodb_buffer_pool_chunk_size 134217728
  116. innodb_buffer_pool_dump_at_shutdown ON
  117. innodb_buffer_pool_dump_now OFF
  118. innodb_buffer_pool_dump_pct 25
  119. innodb_buffer_pool_filename ib_buffer_pool
  120. innodb_buffer_pool_instances 8
  121. innodb_buffer_pool_load_abort OFF
  122. innodb_buffer_pool_load_at_startup ON
  123. innodb_buffer_pool_load_now OFF
  124. innodb_buffer_pool_size 8589934592
  125. innodb_change_buffer_max_size 25
  126. innodb_change_buffering all
  127. innodb_checksum_algorithm crc32
  128. innodb_checksums ON
  129. innodb_cmp_per_index_enabled OFF
  130. innodb_commit_concurrency 0
  131. innodb_compression_failure_threshold_pct 5
  132. innodb_compression_level 6
  133. innodb_compression_pad_pct_max 50
  134. innodb_concurrency_tickets 5000
  135. innodb_data_file_path ibdata1:12M:autoextend
  136. innodb_data_home_dir
  137. innodb_deadlock_detect ON
  138. innodb_default_row_format dynamic
  139. innodb_disable_sort_file_cache OFF
  140. innodb_doublewrite ON
  141. innodb_fast_shutdown 1
  142. innodb_file_format Barracuda
  143. innodb_file_format_check ON
  144. innodb_file_format_max Barracuda
  145. innodb_file_per_table ON
  146. innodb_fill_factor 100
  147. innodb_flush_log_at_timeout 1
  148. innodb_flush_log_at_trx_commit 1
  149. innodb_flush_method
  150. innodb_flush_neighbors 1
  151. innodb_flush_sync ON
  152. innodb_flushing_avg_loops 30
  153. innodb_force_load_corrupted OFF
  154. innodb_force_recovery 0
  155. innodb_ft_aux_table
  156. innodb_ft_cache_size 8000000
  157. innodb_ft_enable_diag_print OFF
  158. innodb_ft_enable_stopword ON
  159. innodb_ft_max_token_size 84
  160. innodb_ft_min_token_size 3
  161. innodb_ft_num_word_optimize 2000
  162. innodb_ft_result_cache_limit 2000000000
  163. innodb_ft_server_stopword_table
  164. innodb_ft_sort_pll_degree 2
  165. innodb_ft_total_cache_size 640000000
  166. innodb_ft_user_stopword_table
  167. innodb_io_capacity 200
  168. innodb_io_capacity_max 2000
  169. innodb_large_prefix ON
  170. innodb_lock_wait_timeout 50
  171. innodb_locks_unsafe_for_binlog OFF
  172. innodb_log_buffer_size 16777216
  173. innodb_log_checksums ON
  174. innodb_log_compressed_pages ON
  175. innodb_log_file_size 50331648
  176. innodb_log_files_in_group 2
  177. innodb_log_group_home_dir ./
  178. innodb_log_write_ahead_size 8192
  179. innodb_lru_scan_depth 1024
  180. innodb_max_dirty_pages_pct 75.000000
  181. innodb_max_dirty_pages_pct_lwm 0.000000
  182. innodb_max_purge_lag 0
  183. innodb_max_purge_lag_delay 0
  184. innodb_max_undo_log_size 1073741824
  185. innodb_monitor_disable
  186. innodb_monitor_enable
  187. innodb_monitor_reset
  188. innodb_monitor_reset_all
  189. innodb_numa_interleave OFF
  190. innodb_old_blocks_pct 37
  191. innodb_old_blocks_time 1000
  192. innodb_online_alter_log_max_size 134217728
  193. innodb_open_files 2000
  194. innodb_optimize_fulltext_only OFF
  195. innodb_page_cleaners 4
  196. innodb_page_size 16384
  197. innodb_print_all_deadlocks OFF
  198. innodb_purge_batch_size 300
  199. innodb_purge_rseg_truncate_frequency 128
  200. innodb_purge_threads 4
  201. innodb_random_read_ahead OFF
  202. innodb_read_ahead_threshold 56
  203. innodb_read_io_threads 4
  204. innodb_read_only OFF
  205. innodb_replication_delay 0
  206. innodb_rollback_on_timeout OFF
  207. innodb_rollback_segments 128
  208. innodb_sort_buffer_size 1048576
  209. innodb_spin_wait_delay 6
  210. innodb_stats_auto_recalc ON
  211. innodb_stats_include_delete_marked OFF
  212. innodb_stats_method nulls_equal
  213. innodb_stats_on_metadata OFF
  214. innodb_stats_persistent ON
  215. innodb_stats_persistent_sample_pages 20
  216. innodb_stats_sample_pages 8
  217. innodb_stats_transient_sample_pages 8
  218. innodb_status_output OFF
  219. innodb_status_output_locks OFF
  220. innodb_strict_mode ON
  221. innodb_support_xa ON
  222. innodb_sync_array_size 1
  223. innodb_sync_spin_loops 30
  224. innodb_table_locks ON
  225. innodb_temp_data_file_path ibtmp1:12M:autoextend
  226. innodb_thread_concurrency 0
  227. innodb_thread_sleep_delay 10000
  228. innodb_tmpdir
  229. innodb_undo_directory ./
  230. innodb_undo_log_truncate OFF
  231. innodb_undo_logs 128
  232. innodb_undo_tablespaces 0
  233. innodb_use_native_aio ON
  234. innodb_version 5.7.30
  235. innodb_write_io_threads 4
  236. insert_id 0
  237. interactive_timeout 28800
  238. internal_tmp_disk_storage_engine InnoDB
  239. join_buffer_size 262144
  240. keep_files_on_create OFF
  241. key_buffer_size 16777216
  242. key_cache_age_threshold 300
  243. key_cache_block_size 1024
  244. key_cache_division_limit 100
  245. keyring_operations ON
  246. large_files_support ON
  247. large_page_size 0
  248. large_pages OFF
  249. last_insert_id 0
  250. lc_messages en_US
  251. lc_messages_dir /usr/share/mysql/
  252. lc_time_names en_US
  253. license GPL
  254. local_infile ON
  255. lock_wait_timeout 31536000
  256. locked_in_memory OFF
  257. log_bin OFF
  258. log_bin_basename
  259. log_bin_index
  260. log_bin_trust_function_creators OFF
  261. log_bin_use_v1_row_events OFF
  262. log_builtin_as_identified_by_password OFF
  263. log_error /var/log/mysql/error.log
  264. log_error_verbosity 3
  265. log_output FILE
  266. log_queries_not_using_indexes OFF
  267. log_slave_updates OFF
  268. log_slow_admin_statements OFF
  269. log_slow_slave_statements OFF
  270. log_statements_unsafe_for_binlog ON
  271. log_syslog OFF
  272. log_syslog_facility daemon
  273. log_syslog_include_pid ON
  274. log_syslog_tag
  275. log_throttle_queries_not_using_indexes 0
  276. log_timestamps UTC
  277. log_warnings 2
  278. long_query_time 10.000000
  279. low_priority_updates OFF
  280. lower_case_file_system OFF
  281. lower_case_table_names 0
  282. master_info_repository FILE
  283. master_verify_checksum OFF
  284. max_allowed_packet 16777216
  285. max_binlog_cache_size 18446744073709547520
  286. max_binlog_size 104857600
  287. max_binlog_stmt_cache_size 18446744073709547520
  288. max_connect_errors 100
  289. max_connections 151
  290. max_delayed_threads 20
  291. max_digest_length 1024
  292. max_error_count 64
  293. max_execution_time 0
  294. max_heap_table_size 16777216
  295. max_insert_delayed_threads 20
  296. max_join_size 18446744073709551615
  297. max_length_for_sort_data 1024
  298. max_points_in_geometry 65536
  299. max_prepared_stmt_count 16382
  300. max_relay_log_size 0
  301. max_seeks_for_key 18446744073709551615
  302. max_sort_length 1024
  303. max_sp_recursion_depth 0
  304. max_tmp_tables 32
  305. max_user_connections 0
  306. max_write_lock_count 18446744073709551615
  307. metadata_locks_cache_size 1024
  308. metadata_locks_hash_instances 8
  309. min_examined_row_limit 0
  310. multi_range_count 256
  311. myisam_data_pointer_size 6
  312. myisam_max_sort_file_size 9223372036853727232
  313. myisam_mmap_size 18446744073709551615
  314. myisam_recover_options BACKUP
  315. myisam_repair_threads 1
  316. myisam_sort_buffer_size 8388608
  317. myisam_stats_method nulls_unequal
  318. myisam_use_mmap OFF
  319. mysql_native_password_proxy_users OFF
  320. net_buffer_length 16384
  321. net_read_timeout 30
  322. net_retry_count 10
  323. net_write_timeout 60
  324. new OFF
  325. ngram_token_size 2
  326. offline_mode OFF
  327. old OFF
  328. old_alter_table OFF
  329. old_passwords 0
  330. open_files_limit 5000
  331. optimizer_prune_level 1
  332. optimizer_search_depth 62
  333. 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,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on
  334. optimizer_trace enabled=off,one_line=off
  335. optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  336. optimizer_trace_limit 1
  337. optimizer_trace_max_mem_size 16384
  338. optimizer_trace_offset -1
  339. parser_max_mem_size 18446744073709551615
  340. performance_schema ON
  341. performance_schema_accounts_size -1
  342. performance_schema_digests_size 10000
  343. performance_schema_events_stages_history_long_size 10000
  344. performance_schema_events_stages_history_size 10
  345. performance_schema_events_statements_history_long_size 10000
  346. performance_schema_events_statements_history_size 10
  347. performance_schema_events_transactions_history_long_size 10000
  348. performance_schema_events_transactions_history_size 10
  349. performance_schema_events_waits_history_long_size 10000
  350. performance_schema_events_waits_history_size 10
  351. performance_schema_hosts_size -1
  352. performance_schema_max_cond_classes 80
  353. performance_schema_max_cond_instances -1
  354. performance_schema_max_digest_length 1024
  355. performance_schema_max_file_classes 80
  356. performance_schema_max_file_handles 32768
  357. performance_schema_max_file_instances -1
  358. performance_schema_max_index_stat -1
  359. performance_schema_max_memory_classes 320
  360. performance_schema_max_metadata_locks -1
  361. performance_schema_max_mutex_classes 210
  362. performance_schema_max_mutex_instances -1
  363. performance_schema_max_prepared_statements_instances -1
  364. performance_schema_max_program_instances -1
  365. performance_schema_max_rwlock_classes 50
  366. performance_schema_max_rwlock_instances -1
  367. performance_schema_max_socket_classes 10
  368. performance_schema_max_socket_instances -1
  369. performance_schema_max_sql_text_length 1024
  370. performance_schema_max_stage_classes 150
  371. performance_schema_max_statement_classes 193
  372. performance_schema_max_statement_stack 10
  373. performance_schema_max_table_handles -1
  374. performance_schema_max_table_instances -1
  375. performance_schema_max_table_lock_stat -1
  376. performance_schema_max_thread_classes 50
  377. performance_schema_max_thread_instances -1
  378. performance_schema_session_connect_attrs_size 512
  379. performance_schema_setup_actors_size -1
  380. performance_schema_setup_objects_size -1
  381. performance_schema_users_size -1
  382. pid_file /run/mysqld/mysqld.pid
  383. plugin_dir /usr/lib/mysql/plugin/
  384. port 3306
  385. preload_buffer_size 32768
  386. profiling OFF
  387. profiling_history_size 15
  388. protocol_version 10
  389. proxy_user
  390. pseudo_slave_mode OFF
  391. pseudo_thread_id 911557
  392. query_alloc_block_size 8192
  393. query_cache_limit 1048576
  394. query_cache_min_res_unit 4096
  395. query_cache_size 16777216
  396. query_cache_type ON
  397. query_cache_wlock_invalidate OFF
  398. query_prealloc_size 8192
  399. rand_seed1 0
  400. rand_seed2 0
  401. range_alloc_block_size 4096
  402. range_optimizer_max_mem_size 8388608
  403. rbr_exec_mode STRICT
  404. read_buffer_size 131072
  405. read_only OFF
  406. read_rnd_buffer_size 262144
  407. relay_log
  408. relay_log_basename /var/lib/mysql/courseware-relay-bin
  409. relay_log_index /var/lib/mysql/courseware-relay-bin.index
  410. relay_log_info_file relay-log.info
  411. relay_log_info_repository FILE
  412. relay_log_purge ON
  413. relay_log_recovery OFF
  414. relay_log_space_limit 0
  415. report_host
  416. report_password
  417. report_port 3306
  418. report_user
  419. require_secure_transport OFF
  420. rpl_stop_slave_timeout 31536000
  421. secure_auth ON
  422. secure_file_priv /var/lib/mysql-files/
  423. server_id 0
  424. server_id_bits 32
  425. server_uuid d651acc2-5a57-11ea-9bdd-005056bd2d49
  426. session_track_gtids OFF
  427. session_track_schema ON
  428. session_track_state_change OFF
  429. session_track_system_variables time_zone,autocommit,character_set_client,character_set_results,character_set_connection
  430. session_track_transaction_info OFF
  431. sha256_password_auto_generate_rsa_keys ON
  432. sha256_password_private_key_path private_key.pem
  433. sha256_password_proxy_users OFF
  434. sha256_password_public_key_path public_key.pem
  435. show_compatibility_56 OFF
  436. show_create_table_verbosity OFF
  437. show_old_temporals OFF
  438. skip_external_locking ON
  439. skip_name_resolve OFF
  440. skip_networking OFF
  441. skip_show_database OFF
  442. slave_allow_batching OFF
  443. slave_checkpoint_group 512
  444. slave_checkpoint_period 300
  445. slave_compressed_protocol OFF
  446. slave_exec_mode STRICT
  447. slave_load_tmpdir /tmp
  448. slave_max_allowed_packet 1073741824
  449. slave_net_timeout 60
  450. slave_parallel_type DATABASE
  451. slave_parallel_workers 0
  452. slave_pending_jobs_size_max 16777216
  453. slave_preserve_commit_order OFF
  454. slave_rows_search_algorithms TABLE_SCAN,INDEX_SCAN
  455. slave_skip_errors OFF
  456. slave_sql_verify_checksum ON
  457. slave_transaction_retries 10
  458. slave_type_conversions
  459. slow_launch_time 2
  460. slow_query_log OFF
  461. slow_query_log_file /var/lib/mysql/courseware-slow.log
  462. socket /var/run/mysqld/mysqld.sock
  463. sort_buffer_size 262144
  464. sql_auto_is_null OFF
  465. sql_big_selects ON
  466. sql_buffer_result OFF
  467. sql_log_bin ON
  468. sql_log_off OFF
  469. sql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  470. sql_notes ON
  471. sql_quote_show_create ON
  472. sql_safe_updates OFF
  473. sql_select_limit 18446744073709551615
  474. sql_slave_skip_counter 0
  475. sql_warnings OFF
  476. ssl_ca ca.pem
  477. ssl_capath
  478. ssl_cert server-cert.pem
  479. ssl_cipher
  480. ssl_crl
  481. ssl_crlpath
  482. ssl_key server-key.pem
  483. stored_program_cache 256
  484. super_read_only OFF
  485. sync_binlog 1
  486. sync_frm ON
  487. sync_master_info 10000
  488. sync_relay_log 10000
  489. sync_relay_log_info 10000
  490. system_time_zone +0430
  491. table_definition_cache 1400
  492. table_open_cache 2000
  493. table_open_cache_instances 16
  494. thread_cache_size 8
  495. thread_handling one-thread-per-connection
  496. thread_stack 196608
  497. time_format %H:%i:%s
  498. time_zone SYSTEM
  499. timestamp 1594364099.157777
  500. tls_version TLSv1,TLSv1.1,TLSv1.2
  501. tmp_table_size 16777216
  502. tmpdir /tmp
  503. transaction_alloc_block_size 8192
  504. transaction_allow_batching OFF
  505. transaction_isolation REPEATABLE-READ
  506. transaction_prealloc_size 4096
  507. transaction_read_only OFF
  508. transaction_write_set_extraction OFF
  509. tx_isolation REPEATABLE-READ
  510. tx_read_only OFF
  511. unique_checks ON
  512. updatable_views_with_limit YES
  513. validate_password_check_user_name OFF
  514. validate_password_dictionary_file
  515. validate_password_length 8
  516. validate_password_mixed_case_count 1
  517. validate_password_number_count 1
  518. validate_password_policy MEDIUM
  519. validate_password_special_char_count 1
  520. version 5.7.30-0ubuntu0.18.04.1
  521. version_comment (Ubuntu)
  522. version_compile_machine x86_64
  523. version_compile_os Linux
  524. wait_timeout 28800
  525. warning_count 0
Add Comment
Please, Sign In to add comment
Public Pastes
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!