SHARE
TWEET

SHOW VARIABLES

a guest Jan 15th, 2018 52 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
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
 
Top