API tools faq
paste
Advertisement
Guest User

SHOW VARIABLES

a guest
Jan 15th, 2018
463
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.09 KB | None | 0 0
raw download clone embed print report
  1. auto_increment_increment;1
  2. auto_increment_offset;1
  3. autocommit;ON
  4. automatic_sp_privileges;ON
  5. avoid_temporal_upgrade;OFF
  6. back_log;190
  7. basedir;/usr/
  8. big_tables;OFF
  9. bind_address;*
  10. binlog_cache_size;32768
  11. binlog_checksum;CRC32
  12. binlog_direct_non_transactional_updates;OFF
  13. binlog_error_action;ABORT_SERVER
  14. binlog_format;ROW
  15. binlog_group_commit_sync_delay;0
  16. binlog_group_commit_sync_no_delay_count;0
  17. binlog_gtid_simple_recovery;ON
  18. binlog_max_flush_queue_time;0
  19. binlog_order_commits;ON
  20. binlog_row_image;FULL
  21. binlog_rows_query_log_events;OFF
  22. binlog_stmt_cache_size;32768
  23. block_encryption_mode;aes-128-ecb
  24. bulk_insert_buffer_size;8388608
  25. character_set_client;utf8mb4
  26. character_set_connection;utf8mb4
  27. character_set_database;utf8
  28. character_set_filesystem;binary
  29. character_set_results;utf8mb4
  30. character_set_server;latin1
  31. character_set_system;utf8
  32. character_sets_dir;/usr/share/mysql/charsets/
  33. check_proxy_users;OFF
  34. collation_connection;utf8mb4_general_ci
  35. collation_database;utf8_general_ci
  36. collation_server;latin1_swedish_ci
  37. completion_type;NO_CHAIN
  38. concurrent_insert;AUTO
  39. connect_timeout;10
  40. core_file;OFF
  41. datadir;/opt/mysql-data/
  42. date_format;%Y-%m-%d
  43. datetime_format;%Y-%m-%d %H:%i:%s
  44. default_authentication_plugin;mysql_native_password
  45. default_password_lifetime;0
  46. default_storage_engine;InnoDB
  47. default_tmp_storage_engine;InnoDB
  48. default_week_format;0
  49. delay_key_write;ON
  50. delayed_insert_limit;100
  51. delayed_insert_timeout;300
  52. delayed_queue_size;1000
  53. disabled_storage_engines;
  54. disconnect_on_expired_password;ON
  55. div_precision_increment;4
  56. end_markers_in_json;OFF
  57. enforce_gtid_consistency;ON
  58. eq_range_index_dive_limit;200
  59. error_count;0
  60. event_scheduler;OFF
  61. expire_logs_days;7
  62. explicit_defaults_for_timestamp;ON
  63. external_user;
  64. flush;OFF
  65. flush_time;0
  66. foreign_key_checks;ON
  67. ft_boolean_syntax;+ -><()~*:""&|
  68. ft_max_word_len;84
  69. ft_min_word_len;4
  70. ft_query_expansion_limit;20
  71. ft_stopword_file;(built-in)
  72. general_log;OFF
  73. general_log_file;/opt/mysql-log/general.log
  74. group_concat_max_len;1024
  75. gtid_executed_compression_period;1000
  76. gtid_mode;ON
  77. gtid_next;AUTOMATIC
  78. gtid_owned;
  79. gtid_purged;uuid1:1-37,
  80. uuid2:1-65,
  81. uuid3:1-355296672,
  82. uuid4:46087274-46107505,
  83. uuid5:1-579181,
  84. uuid6:1-78015204
  85. have_compress;YES
  86. have_crypt;YES
  87. have_dynamic_loading;YES
  88. have_geometry;YES
  89. have_openssl;YES
  90. have_profiling;YES
  91. have_query_cache;YES
  92. have_rtree_keys;YES
  93. have_ssl;YES
  94. have_statement_timeout;YES
  95. have_symlink;DISABLED
  96. host_cache_size;638
  97. hostname;
  98. identity;0
  99. ignore_builtin_innodb;OFF
  100. ignore_db_dirs;
  101. init_connect;
  102. init_file;
  103. init_slave;
  104. innodb_adaptive_flushing;ON
  105. innodb_adaptive_flushing_lwm;10
  106. innodb_adaptive_hash_index;ON
  107. innodb_adaptive_hash_index_parts;8
  108. innodb_adaptive_max_sleep_delay;150000
  109. innodb_api_bk_commit_interval;5
  110. innodb_api_disable_rowlock;OFF
  111. innodb_api_enable_binlog;OFF
  112. innodb_api_enable_mdl;OFF
  113. innodb_api_trx_level;0
  114. innodb_autoextend_increment;64
  115. innodb_autoinc_lock_mode;1
  116. innodb_buffer_pool_chunk_size;134217728
  117. innodb_buffer_pool_dump_at_shutdown;ON
  118. innodb_buffer_pool_dump_now;OFF
  119. innodb_buffer_pool_dump_pct;25
  120. innodb_buffer_pool_filename;ib_buffer_pool
  121. innodb_buffer_pool_instances;28
  122. innodb_buffer_pool_load_abort;OFF
  123. innodb_buffer_pool_load_at_startup;ON
  124. innodb_buffer_pool_load_now;OFF
  125. innodb_buffer_pool_size;593779228672
  126. innodb_change_buffer_max_size;25
  127. innodb_change_buffering;all
  128. innodb_checksum_algorithm;crc32
  129. innodb_checksums;ON
  130. innodb_cmp_per_index_enabled;OFF
  131. innodb_commit_concurrency;0
  132. innodb_compression_failure_threshold_pct;5
  133. innodb_compression_level;6
  134. innodb_compression_pad_pct_max;50
  135. innodb_concurrency_tickets;5000
  136. innodb_data_file_path;ibdata1:12M:autoextend
  137. innodb_data_home_dir;
  138. innodb_deadlock_detect;ON
  139. innodb_default_row_format;dynamic
  140. innodb_disable_sort_file_cache;OFF
  141. innodb_doublewrite;ON
  142. innodb_fast_shutdown;1
  143. innodb_file_format;Barracuda
  144. innodb_file_format_check;ON
  145. innodb_file_format_max;Barracuda
  146. innodb_file_per_table;ON
  147. innodb_fill_factor;100
  148. innodb_flush_log_at_timeout;1
  149. innodb_flush_log_at_trx_commit;1
  150. innodb_flush_method;O_DIRECT
  151. innodb_flush_neighbors;1
  152. innodb_flush_sync;ON
  153. innodb_flushing_avg_loops;30
  154. innodb_force_load_corrupted;OFF
  155. innodb_force_recovery;0
  156. innodb_ft_aux_table;
  157. innodb_ft_cache_size;8000000
  158. innodb_ft_enable_diag_print;OFF
  159. innodb_ft_enable_stopword;ON
  160. innodb_ft_max_token_size;84
  161. innodb_ft_min_token_size;3
  162. innodb_ft_num_word_optimize;2000
  163. innodb_ft_result_cache_limit;2000000000
  164. innodb_ft_server_stopword_table;
  165. innodb_ft_sort_pll_degree;2
  166. innodb_ft_total_cache_size;640000000
  167. innodb_ft_user_stopword_table;
  168. innodb_io_capacity;600
  169. innodb_io_capacity_max;2000
  170. innodb_large_prefix;ON
  171. innodb_lock_wait_timeout;50
  172. innodb_locks_unsafe_for_binlog;OFF
  173. innodb_log_buffer_size;16777216
  174. innodb_log_checksums;ON
  175. innodb_log_compressed_pages;ON
  176. innodb_log_file_size;16106127360
  177. innodb_log_files_in_group;2
  178. innodb_log_group_home_dir;./
  179. innodb_log_write_ahead_size;8192
  180. innodb_lru_scan_depth;256
  181. innodb_max_dirty_pages_pct;75.000000
  182. innodb_max_dirty_pages_pct_lwm;0.000000
  183. innodb_max_purge_lag;0
  184. innodb_max_purge_lag_delay;0
  185. innodb_max_undo_log_size;1073741824
  186. innodb_monitor_disable;
  187. innodb_monitor_enable;
  188. innodb_monitor_reset;
  189. innodb_monitor_reset_all;
  190. innodb_numa_interleave;OFF
  191. innodb_old_blocks_pct;37
  192. innodb_old_blocks_time;1000
  193. innodb_online_alter_log_max_size;134217728
  194. innodb_open_files;8000
  195. innodb_optimize_fulltext_only;OFF
  196. innodb_page_cleaners;4
  197. innodb_page_size;16384
  198. innodb_print_all_deadlocks;OFF
  199. innodb_purge_batch_size;300
  200. innodb_purge_rseg_truncate_frequency;128
  201. innodb_purge_threads;4
  202. innodb_random_read_ahead;OFF
  203. innodb_read_ahead_threshold;56
  204. innodb_read_io_threads;4
  205. innodb_read_only;OFF
  206. innodb_replication_delay;0
  207. innodb_rollback_on_timeout;OFF
  208. innodb_rollback_segments;128
  209. innodb_sort_buffer_size;1048576
  210. innodb_spin_wait_delay;6
  211. innodb_stats_auto_recalc;ON
  212. innodb_stats_include_delete_marked;OFF
  213. innodb_stats_method;nulls_equal
  214. innodb_stats_on_metadata;OFF
  215. innodb_stats_persistent;ON
  216. innodb_stats_persistent_sample_pages;20
  217. innodb_stats_sample_pages;8
  218. innodb_stats_transient_sample_pages;8
  219. innodb_status_output;OFF
  220. innodb_status_output_locks;OFF
  221. innodb_strict_mode;ON
  222. innodb_support_xa;ON
  223. innodb_sync_array_size;1
  224. innodb_sync_spin_loops;30
  225. innodb_table_locks;ON
  226. innodb_temp_data_file_path;ibtmp1:12M:autoextend:max:30G
  227. innodb_thread_concurrency;56
  228. innodb_thread_sleep_delay;16925
  229. innodb_tmpdir;
  230. innodb_undo_directory;./
  231. innodb_undo_log_truncate;OFF
  232. innodb_undo_logs;128
  233. innodb_undo_tablespaces;0
  234. innodb_use_native_aio;ON
  235. innodb_version;5.7.20
  236. innodb_write_io_threads;4
  237. insert_id;0
  238. interactive_timeout;28800
  239. internal_tmp_disk_storage_engine;InnoDB
  240. join_buffer_size;1048576
  241. keep_files_on_create;OFF
  242. key_buffer_size;8388608
  243. key_cache_age_threshold;300
  244. key_cache_block_size;1024
  245. key_cache_division_limit;100
  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;ON
  258. log_bin_basename;/opt/mysql-log/mysql-bin
  259. log_bin_index;/opt/mysql-log/mysql-bin.index
  260. log_bin_trust_function_creators;ON
  261. log_bin_use_v1_row_events;OFF
  262. log_builtin_as_identified_by_password;OFF
  263. log_error;/opt/mysql-log/error.log
  264. log_error_verbosity;3
  265. log_output;FILE
  266. log_queries_not_using_indexes;OFF
  267. log_slave_updates;ON
  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;3.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;1073741824
  287. max_binlog_stmt_cache_size;18446744073709547520
  288. max_connect_errors;100
  289. max_connections;700
  290. max_delayed_threads;20
  291. max_digest_length;1024
  292. max_error_count;64
  293. max_execution_time;200000
  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;OFF
  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;32000
  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;40
  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;/var/run/mysqld/mysqld.pid
  383. plugin_dir;/usr/lib/mysql/plugin/
  384. port;3306
  385. preload_buffer_size;32768
  386. profiling;ON
  387. profiling_history_size;15
  388. protocol_version;10
  389. proxy_user;
  390. pseudo_slave_mode;OFF
  391. pseudo_thread_id;612259
  392. query_alloc_block_size;8192
  393. query_cache_limit;1048576
  394. query_cache_min_res_unit;4096
  395. query_cache_size;0
  396. query_cache_type;OFF
  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;/opt/mysql-log/mysql-relay-bin
  408. relay_log_basename;/opt/mysql-log/mysql-relay-bin
  409. relay_log_index;/opt/mysql-log/mysql-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;76
  424. server_id_bits;32
  425. server_uuid;server_uuid
  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_proxy_users;OFF
  432. show_compatibility_56;OFF
  433. show_old_temporals;OFF
  434. skip_external_locking;ON
  435. skip_name_resolve;ON
  436. skip_networking;OFF
  437. skip_show_database;OFF
  438. slave_allow_batching;OFF
  439. slave_checkpoint_group;512
  440. slave_checkpoint_period;300
  441. slave_compressed_protocol;OFF
  442. slave_exec_mode;STRICT
  443. slave_load_tmpdir;/tmp
  444. slave_max_allowed_packet;1073741824
  445. slave_net_timeout;60
  446. slave_parallel_type;DATABASE
  447. slave_parallel_workers;0
  448. slave_pending_jobs_size_max;16777216
  449. slave_preserve_commit_order;OFF
  450. slave_rows_search_algorithms;TABLE_SCAN,INDEX_SCAN
  451. slave_skip_errors;OFF
  452. slave_sql_verify_checksum;ON
  453. slave_transaction_retries;10
  454. slave_type_conversions;
  455. slow_launch_time;2
  456. slow_query_log;ON
  457. slow_query_log_file;/opt/mysql-log/slow.log
  458. socket;/var/run/mysqld/mysqld.sock
  459. sort_buffer_size;2097152
  460. sql_auto_is_null;OFF
  461. sql_big_selects;ON
  462. sql_buffer_result;OFF
  463. sql_log_bin;ON
  464. sql_log_off;OFF
  465. sql_mode;STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  466. sql_notes;ON
  467. sql_quote_show_create;ON
  468. sql_safe_updates;OFF
  469. sql_select_limit;18446744073709551615
  470. sql_slave_skip_counter;0
  471. sql_warnings;OFF
  472. ssl_ca;ca.pem
  473. ssl_capath;
  474. ssl_cert;server-cert.pem
  475. ssl_cipher;
  476. ssl_crl;
  477. ssl_crlpath;
  478. ssl_key;server-key.pem
  479. stored_program_cache;256
  480. super_read_only;OFF
  481. sync_binlog;1
  482. sync_frm;ON
  483. sync_master_info;10000
  484. sync_relay_log;10000
  485. sync_relay_log_info;10000
  486. system_time_zone;MSK
  487. table_definition_cache;2000
  488. table_open_cache;10000
  489. table_open_cache_instances;16
  490. thread_cache_size;128
  491. thread_handling;one-thread-per-connection
  492. thread_stack;262144
  493. time_format;%H:%i:%s
  494. time_zone;SYSTEM
  495. timestamp;1516003189.069855
  496. tls_version;TLSv1,TLSv1.1
  497. tmp_table_size;134217728
  498. tmpdir;/tmp
  499. transaction_alloc_block_size;8192
  500. transaction_allow_batching;OFF
  501. transaction_isolation;REPEATABLE-READ
  502. transaction_prealloc_size;4096
  503. transaction_read_only;OFF
  504. transaction_write_set_extraction;OFF
  505. tx_isolation;REPEATABLE-READ
  506. tx_read_only;OFF
  507. unique_checks;ON
  508. updatable_views_with_limit;YES
  509. version;5.7.20-log
  510. version_comment;MySQL Community Server (GPL)
  511. version_compile_machine;x86_64
  512. version_compile_os;Linux
  513. wait_timeout;28800
  514. warning_count;0
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!