API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2019
188
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.49 KB | None | 0 0
raw download clone embed print report
  1. activate_all_roles_on_login
  2. OFF
  3. auto_generate_certs
  4. ON
  5. auto_increment_increment
  6. 1
  7. auto_increment_offset
  8. 1
  9. autocommit
  10. ON
  11. automatic_sp_privileges
  12. ON
  13. avoid_temporal_upgrade
  14. OFF
  15. back_log
  16. 80
  17. basedir
  18. C:\Program Files\MySQL\MySQL Server 8.0\
  19. big_tables
  20. OFF
  21. bind_address
  22. *
  23. binlog_cache_size
  24. 32768
  25. binlog_checksum
  26. CRC32
  27. binlog_direct_non_transactional_updates
  28. OFF
  29. binlog_error_action
  30. ABORT_SERVER
  31. binlog_expire_logs_seconds
  32. 2592000
  33. binlog_format
  34. ROW
  35. binlog_group_commit_sync_delay
  36. 0
  37. binlog_group_commit_sync_no_delay_count
  38. 0
  39. binlog_gtid_simple_recovery
  40. ON
  41. binlog_max_flush_queue_time
  42. 0
  43. binlog_order_commits
  44. ON
  45. binlog_row_image
  46. FULL
  47. binlog_row_metadata
  48. MINIMAL
  49. binlog_row_value_options
  50. binlog_rows_query_log_events
  51. OFF
  52. binlog_stmt_cache_size
  53. 32768
  54. binlog_transaction_dependency_history_size
  55. 25000
  56. binlog_transaction_dependency_tracking
  57. COMMIT_ORDER
  58. block_encryption_mode
  59. aes-128-ecb
  60. bulk_insert_buffer_size
  61. 8388608
  62. caching_sha2_password_auto_generate_rsa_keys
  63. ON
  64. caching_sha2_password_private_key_path
  65. private_key.pem
  66. caching_sha2_password_public_key_path
  67. public_key.pem
  68. character_set_client
  69. utf8mb4
  70. character_set_connection
  71. utf8mb4
  72. character_set_database
  73. utf8mb4
  74. character_set_filesystem
  75. binary
  76. character_set_results
  77. utf8mb4
  78. character_set_server
  79. utf8mb4
  80. character_set_system
  81. utf8
  82. character_sets_dir
  83. C:\Program Files\MySQL\MySQL Server 8.0\share\char...
  84. check_proxy_users
  85. OFF
  86. collation_connection
  87. utf8mb4_0900_ai_ci
  88. collation_database
  89. utf8mb4_0900_ai_ci
  90. collation_server
  91. utf8mb4_0900_ai_ci
  92. completion_type
  93. NO_CHAIN
  94. concurrent_insert
  95. AUTO
  96. connect_timeout
  97. 10
  98. core_file
  99. OFF
  100. cte_max_recursion_depth
  101. 1000
  102. datadir
  103. C:\ProgramData\MySQL\MySQL Server 8.0\Data\
  104. default_authentication_plugin
  105. mysql_native_password
  106. default_collation_for_utf8mb4
  107. utf8mb4_0900_ai_ci
  108. default_password_lifetime
  109. 0
  110. default_storage_engine
  111. InnoDB
  112. default_tmp_storage_engine
  113. InnoDB
  114. default_week_format
  115. 0
  116. delay_key_write
  117. ON
  118. delayed_insert_limit
  119. 100
  120. delayed_insert_timeout
  121. 300
  122. delayed_queue_size
  123. 1000
  124. disabled_storage_engines
  125. disconnect_on_expired_password
  126. ON
  127. div_precision_increment
  128. 4
  129. end_markers_in_json
  130. OFF
  131. enforce_gtid_consistency
  132. OFF
  133. eq_range_index_dive_limit
  134. 200
  135. event_scheduler
  136. ON
  137. expire_logs_days
  138. 0
  139. explicit_defaults_for_timestamp
  140. ON
  141. flush
  142. OFF
  143. flush_time
  144. 0
  145. foreign_key_checks
  146. ON
  147. ft_boolean_syntax
  148. + -><()~*:""&|
  149. ft_max_word_len
  150. 84
  151. ft_min_word_len
  152. 4
  153. ft_query_expansion_limit
  154. 20
  155. ft_stopword_file
  156. (built-in)
  157. general_log
  158. OFF
  159. general_log_file
  160. SERVER.log
  161. group_concat_max_len
  162. 1024
  163. gtid_executed
  164. gtid_executed_compression_period
  165. 1000
  166. gtid_mode
  167. OFF
  168. gtid_owned
  169. gtid_purged
  170. have_compress
  171. YES
  172. have_dynamic_loading
  173. YES
  174. have_geometry
  175. YES
  176. have_openssl
  177. YES
  178. have_profiling
  179. YES
  180. have_query_cache
  181. NO
  182. have_rtree_keys
  183. YES
  184. have_ssl
  185. YES
  186. have_statement_timeout
  187. YES
  188. have_symlink
  189. DISABLED
  190. histogram_generation_max_mem_size
  191. 20000000
  192. host_cache_size
  193. 279
  194. hostname
  195. server
  196. Variable_name
  197. Value
  198.  
  199. information_schema_stats_expiry
  200. 86400
  201. init_connect
  202. init_file
  203. init_slave
  204. innodb_adaptive_flushing
  205. ON
  206. innodb_adaptive_flushing_lwm
  207. 10
  208. innodb_adaptive_hash_index
  209. ON
  210. innodb_adaptive_hash_index_parts
  211. 8
  212. innodb_adaptive_max_sleep_delay
  213. 150000
  214. innodb_api_bk_commit_interval
  215. 5
  216. innodb_api_disable_rowlock
  217. OFF
  218. innodb_api_enable_binlog
  219. OFF
  220. innodb_api_enable_mdl
  221. OFF
  222. innodb_api_trx_level
  223. 0
  224. innodb_autoextend_increment
  225. 64
  226. innodb_autoinc_lock_mode
  227. 2
  228. innodb_buffer_pool_chunk_size
  229. 134217728
  230. innodb_buffer_pool_dump_at_shutdown
  231. ON
  232. innodb_buffer_pool_dump_now
  233. OFF
  234. innodb_buffer_pool_dump_pct
  235. 25
  236. innodb_buffer_pool_filename
  237. ib_buffer_pool
  238. innodb_buffer_pool_instances
  239. 1
  240. innodb_buffer_pool_load_abort
  241. OFF
  242. innodb_buffer_pool_load_at_startup
  243. ON
  244. innodb_buffer_pool_load_now
  245. OFF
  246. innodb_buffer_pool_size
  247. 939524096
  248. innodb_change_buffer_max_size
  249. 25
  250. innodb_change_buffering
  251. all
  252. innodb_checksum_algorithm
  253. crc32
  254. innodb_cmp_per_index_enabled
  255. OFF
  256. innodb_commit_concurrency
  257. 0
  258. innodb_compression_failure_threshold_pct
  259. 5
  260. innodb_compression_level
  261. 6
  262. innodb_compression_pad_pct_max
  263. 50
  264. innodb_concurrency_tickets
  265. 5000
  266. innodb_data_file_path
  267. ibdata1:12M:autoextend
  268. innodb_data_home_dir
  269. innodb_deadlock_detect
  270. ON
  271. innodb_dedicated_server
  272. OFF
  273. innodb_default_row_format
  274. dynamic
  275. innodb_directories
  276. innodb_disable_sort_file_cache
  277. OFF
  278. innodb_doublewrite
  279. ON
  280. innodb_fast_shutdown
  281. 1
  282. innodb_file_per_table
  283. ON
  284. innodb_fill_factor
  285. 100
  286. innodb_flush_log_at_timeout
  287. 1
  288. innodb_flush_log_at_trx_commit
  289. 2
  290. innodb_flush_method
  291. unbuffered
  292. innodb_flush_neighbors
  293. 0
  294. innodb_flush_sync
  295. ON
  296. innodb_flushing_avg_loops
  297. 30
  298. innodb_force_load_corrupted
  299. OFF
  300. innodb_force_recovery
  301. 0
  302. innodb_fsync_threshold
  303. 0
  304. innodb_ft_aux_table
  305. innodb_ft_cache_size
  306. 8000000
  307. innodb_ft_enable_diag_print
  308. OFF
  309. innodb_ft_enable_stopword
  310. ON
  311. innodb_ft_max_token_size
  312. 84
  313. innodb_ft_min_token_size
  314. 3
  315. innodb_ft_num_word_optimize
  316. 2000
  317. innodb_ft_result_cache_limit
  318. 2000000000
  319. innodb_ft_server_stopword_table
  320. innodb_ft_sort_pll_degree
  321. 2
  322. innodb_ft_total_cache_size
  323. 640000000
  324. innodb_ft_user_stopword_table
  325. innodb_io_capacity
  326. 200
  327. innodb_io_capacity_max
  328. 2000
  329. innodb_lock_wait_timeout
  330. 50
  331. innodb_log_buffer_size
  332. 4194304
  333. innodb_log_checksums
  334. ON
  335. innodb_log_compressed_pages
  336. ON
  337. innodb_log_file_size
  338. 67108864
  339. innodb_log_files_in_group
  340. 2
  341. innodb_log_group_home_dir
  342. .\
  343. innodb_log_spin_cpu_abs_lwm
  344. 80
  345. innodb_log_spin_cpu_pct_hwm
  346. 50
  347. innodb_log_wait_for_flush_spin_hwm
  348. 400
  349. innodb_log_write_ahead_size
  350. 8192
  351. innodb_lru_scan_depth
  352. 1024
  353. innodb_max_dirty_pages_pct
  354. 90.000000
  355. innodb_max_dirty_pages_pct_lwm
  356. 10.000000
  357. innodb_max_purge_lag
  358. 0
  359. innodb_max_purge_lag_delay
  360. 0
  361. innodb_max_undo_log_size
  362. 1073741824
  363. innodb_monitor_disable
  364. innodb_monitor_enable
  365. innodb_monitor_reset
  366. innodb_monitor_reset_all
  367. innodb_old_blocks_pct
  368. 37
  369. innodb_old_blocks_time
  370. 1000
  371. innodb_online_alter_log_max_size
  372. 134217728
  373. innodb_open_files
  374. 300
  375. innodb_optimize_fulltext_only
  376. OFF
  377. innodb_page_cleaners
  378. 1
  379. innodb_page_size
  380. 16384
  381. innodb_print_all_deadlocks
  382. OFF
  383. innodb_print_ddl_logs
  384. OFF
  385. innodb_purge_batch_size
  386. 300
  387. Variable_name
  388. Value
  389.  
  390. innodb_purge_rseg_truncate_frequency
  391. 128
  392. innodb_purge_threads
  393. 4
  394. innodb_random_read_ahead
  395. OFF
  396. innodb_read_ahead_threshold
  397. 56
  398. innodb_read_io_threads
  399. 4
  400. innodb_read_only
  401. OFF
  402. innodb_redo_log_encrypt
  403. OFF
  404. innodb_replication_delay
  405. 0
  406. innodb_rollback_on_timeout
  407. OFF
  408. innodb_rollback_segments
  409. 128
  410. innodb_sort_buffer_size
  411. 1048576
  412. innodb_spin_wait_delay
  413. 6
  414. innodb_stats_auto_recalc
  415. ON
  416. innodb_stats_include_delete_marked
  417. OFF
  418. innodb_stats_method
  419. nulls_equal
  420. innodb_stats_on_metadata
  421. OFF
  422. innodb_stats_persistent
  423. ON
  424. innodb_stats_persistent_sample_pages
  425. 20
  426. innodb_stats_transient_sample_pages
  427. 8
  428. innodb_status_output
  429. OFF
  430. innodb_status_output_locks
  431. OFF
  432. innodb_strict_mode
  433. ON
  434. innodb_sync_array_size
  435. 1
  436. innodb_sync_spin_loops
  437. 30
  438. innodb_table_locks
  439. ON
  440. innodb_temp_data_file_path
  441. ibtmp1:12M:autoextend
  442. innodb_temp_tablespaces_dir
  443. .\#innodb_temp\
  444. innodb_thread_concurrency
  445. 8
  446. innodb_thread_sleep_delay
  447. 0
  448. innodb_tmpdir
  449. innodb_undo_directory
  450. .\
  451. innodb_undo_log_encrypt
  452. OFF
  453. innodb_undo_log_truncate
  454. ON
  455. innodb_undo_tablespaces
  456. 2
  457. innodb_use_native_aio
  458. ON
  459. innodb_version
  460. 8.0.13
  461. innodb_write_io_threads
  462. 4
  463. interactive_timeout
  464. 28800
  465. internal_tmp_disk_storage_engine
  466. InnoDB
  467. internal_tmp_mem_storage_engine
  468. TempTable
  469. join_buffer_size
  470. 262144
  471. keep_files_on_create
  472. OFF
  473. key_buffer_size
  474. 67108864
  475. key_cache_age_threshold
  476. 300
  477. key_cache_block_size
  478. 1024
  479. key_cache_division_limit
  480. 100
  481. keyring_operations
  482. ON
  483. large_files_support
  484. ON
  485. large_page_size
  486. 0
  487. large_pages
  488. OFF
  489. lc_messages
  490. en_US
  491. lc_messages_dir
  492. C:\Program Files\MySQL\MySQL Server 8.0\share\
  493. lc_time_names
  494. en_US
  495. license
  496. GPL
  497. local_infile
  498. OFF
  499. lock_wait_timeout
  500. 31536000
  501. log_bin
  502. ON
  503. log_bin_basename
  504. C:\ProgramData\MySQL\MySQL Server 8.0\Data\SERVER-...
  505. log_bin_index
  506. C:\ProgramData\MySQL\MySQL Server 8.0\Data\SERVER-...
  507. log_bin_trust_function_creators
  508. OFF
  509. log_bin_use_v1_row_events
  510. OFF
  511. log_error
  512. .\SERVER.err
  513. log_error_services
  514. log_filter_internal; log_sink_internal
  515. log_error_suppression_list
  516. log_error_verbosity
  517. 2
  518. log_output
  519. FILE
  520. log_queries_not_using_indexes
  521. OFF
  522. log_slave_updates
  523. ON
  524. log_slow_admin_statements
  525. OFF
  526. log_slow_slave_statements
  527. OFF
  528. log_statements_unsafe_for_binlog
  529. ON
  530. log_throttle_queries_not_using_indexes
  531. 0
  532. log_timestamps
  533. UTC
  534. long_query_time
  535. 10.000000
  536. low_priority_updates
  537. OFF
  538. lower_case_file_system
  539. ON
  540. lower_case_table_names
  541. 1
  542. mandatory_roles
  543. master_info_repository
  544. TABLE
  545. master_verify_checksum
  546. OFF
  547. max_allowed_packet
  548. 16777216
  549. max_binlog_cache_size
  550. 18446744073709547520
  551. max_binlog_size
  552. 1073741824
  553. max_binlog_stmt_cache_size
  554. 18446744073709547520
  555. max_connect_errors
  556. 100
  557. max_connections
  558. 151
  559. max_delayed_threads
  560. 20
  561. max_digest_length
  562. 1024
  563. max_error_count
  564. 1024
  565. max_execution_time
  566. 0
  567. max_heap_table_size
  568. 16777216
  569. max_insert_delayed_threads
  570. 20
  571. max_join_size
  572. 18446744073709551615
  573. max_length_for_sort_data
  574. 4096
  575. max_points_in_geometry
  576. 65536
  577. max_prepared_stmt_count
  578. 16382
  579. max_relay_log_size
  580. 0
  581. max_seeks_for_key
  582. 4294967295
  583. max_sort_length
  584. 1024
  585. max_sp_recursion_depth
  586. 0
  587. Variable_name
  588. Value
  589.  
  590. max_user_connections
  591. 0
  592. max_write_lock_count
  593. 4294967295
  594. min_examined_row_limit
  595. 0
  596. myisam_data_pointer_size
  597. 6
  598. myisam_max_sort_file_size
  599. 107374182400
  600. myisam_mmap_size
  601. 18446744073709551615
  602. myisam_recover_options
  603. OFF
  604. myisam_repair_threads
  605. 1
  606. myisam_sort_buffer_size
  607. 120586240
  608. myisam_stats_method
  609. nulls_unequal
  610. myisam_use_mmap
  611. OFF
  612. mysql_native_password_proxy_users
  613. OFF
  614. mysqlx_bind_address
  615. *
  616. mysqlx_connect_timeout
  617. 30
  618. mysqlx_document_id_unique_prefix
  619. 0
  620. mysqlx_idle_worker_thread_timeout
  621. 60
  622. mysqlx_interactive_timeout
  623. 28800
  624. mysqlx_max_allowed_packet
  625. 67108864
  626. mysqlx_max_connections
  627. 100
  628. mysqlx_min_worker_threads
  629. 2
  630. mysqlx_port
  631. 33060
  632. mysqlx_port_open_timeout
  633. 0
  634. mysqlx_read_timeout
  635. 30
  636. mysqlx_socket
  637. /tmp/mysqlx.sock
  638. mysqlx_ssl_ca
  639. mysqlx_ssl_capath
  640. mysqlx_ssl_cert
  641. mysqlx_ssl_cipher
  642. mysqlx_ssl_crl
  643. mysqlx_ssl_crlpath
  644. mysqlx_ssl_key
  645. mysqlx_wait_timeout
  646. 28800
  647. mysqlx_write_timeout
  648. 60
  649. named_pipe
  650. ON
  651. net_buffer_length
  652. 16384
  653. net_read_timeout
  654. 30
  655. net_retry_count
  656. 10
  657. net_write_timeout
  658. 60
  659. new
  660. OFF
  661. ngram_token_size
  662. 2
  663. offline_mode
  664. OFF
  665. old
  666. OFF
  667. old_alter_table
  668. OFF
  669. open_files_limit
  670. 6209
  671. optimizer_prune_level
  672. 1
  673. optimizer_search_depth
  674. 62
  675. optimizer_switch
  676. index_merge=on,index_merge_union=on,index_merge_so...
  677. optimizer_trace
  678. enabled=off,one_line=off
  679. optimizer_trace_features
  680. greedy_search=on,range_optimizer=on,dynamic_range=...
  681. optimizer_trace_limit
  682. 1
  683. optimizer_trace_max_mem_size
  684. 1048576
  685. optimizer_trace_offset
  686. -1
  687. parser_max_mem_size
  688. 18446744073709551615
  689. password_history
  690. 0
  691. password_require_current
  692. OFF
  693. password_reuse_interval
  694. 0
  695. performance_schema
  696. ON
  697. performance_schema_accounts_size
  698. -1
  699. performance_schema_digests_size
  700. 10000
  701. performance_schema_error_size
  702. 4468
  703. performance_schema_events_stages_history_long_size
  704. 10000
  705. performance_schema_events_stages_history_size
  706. 10
  707. performance_schema_events_statements_history_long_...
  708. 10000
  709. performance_schema_events_statements_history_size
  710. 10
  711. performance_schema_events_transactions_history_lon...
  712. 10000
  713. performance_schema_events_transactions_history_siz...
  714. 10
  715. performance_schema_events_waits_history_long_size
  716. 10000
  717. performance_schema_events_waits_history_size
  718. 10
  719. performance_schema_hosts_size
  720. -1
  721. performance_schema_max_cond_classes
  722. 100
  723. performance_schema_max_cond_instances
  724. -1
  725. performance_schema_max_digest_length
  726. 1024
  727. performance_schema_max_digest_sample_age
  728. 60
  729. performance_schema_max_file_classes
  730. 80
  731. performance_schema_max_file_handles
  732. 32768
  733. performance_schema_max_file_instances
  734. -1
  735. performance_schema_max_index_stat
  736. -1
  737. performance_schema_max_memory_classes
  738. 450
  739. performance_schema_max_metadata_locks
  740. -1
  741. performance_schema_max_mutex_classes
  742. 300
  743. performance_schema_max_mutex_instances
  744. -1
  745. performance_schema_max_prepared_statements_instanc...
  746. -1
  747. performance_schema_max_program_instances
  748. -1
  749. performance_schema_max_rwlock_classes
  750. 60
  751. performance_schema_max_rwlock_instances
  752. -1
  753. performance_schema_max_socket_classes
  754. 10
  755. performance_schema_max_socket_instances
  756. -1
  757. performance_schema_max_sql_text_length
  758. 1024
  759. performance_schema_max_stage_classes
  760. 175
  761. performance_schema_max_statement_classes
  762. 212
  763. performance_schema_max_statement_stack
  764. 10
  765. performance_schema_max_table_handles
  766. -1
  767. performance_schema_max_table_instances
  768. -1
  769. performance_schema_max_table_lock_stat
  770. -1
  771. performance_schema_max_thread_classes
  772. 100
  773. performance_schema_max_thread_instances
  774. -1
  775. performance_schema_session_connect_attrs_size
  776. 512
  777. performance_schema_setup_actors_size
  778. -1
  779. performance_schema_setup_objects_size
  780. -1
  781. performance_schema_users_size
  782. -1
  783. Variable_name
  784. Value
  785.  
  786. persisted_globals_load
  787. ON
  788. pid_file
  789. C:\ProgramData\MySQL\MySQL Server 8.0\Data\server....
  790. plugin_dir
  791. C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin...
  792. port
  793. 3306
  794. preload_buffer_size
  795. 32768
  796. profiling
  797. OFF
  798. profiling_history_size
  799. 15
  800. protocol_version
  801. 10
  802. query_alloc_block_size
  803. 8192
  804. query_prealloc_size
  805. 8192
  806. range_alloc_block_size
  807. 4096
  808. range_optimizer_max_mem_size
  809. 8388608
  810. rbr_exec_mode
  811. STRICT
  812. read_buffer_size
  813. 65536
  814. read_only
  815. OFF
  816. read_rnd_buffer_size
  817. 262144
  818. regexp_stack_limit
  819. 8000000
  820. regexp_time_limit
  821. 32
  822. relay_log
  823. server-relay-bin
  824. relay_log_basename
  825. C:\ProgramData\MySQL\MySQL Server 8.0\Data\server-...
  826. relay_log_index
  827. C:\ProgramData\MySQL\MySQL Server 8.0\Data\server-...
  828. relay_log_info_file
  829. relay-log.info
  830. relay_log_info_repository
  831. TABLE
  832. relay_log_purge
  833. ON
  834. relay_log_recovery
  835. OFF
  836. relay_log_space_limit
  837. 0
  838. report_host
  839. report_password
  840. report_port
  841. 3306
  842. report_user
  843. require_secure_transport
  844. OFF
  845. rpl_read_size
  846. 8192
  847. rpl_stop_slave_timeout
  848. 31536000
  849. schema_definition_cache
  850. 256
  851. secure_file_priv
  852. C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\
  853. server_id
  854. 1
  855. server_id_bits
  856. 32
  857. server_uuid
  858. 6ee5b0bc-ee5d-11e8-9737-00163c357cce
  859. session_track_gtids
  860. OFF
  861. session_track_schema
  862. ON
  863. session_track_state_change
  864. OFF
  865. session_track_system_variables
  866. time_zone,autocommit,character_set_client,characte...
  867. session_track_transaction_info
  868. OFF
  869. sha256_password_auto_generate_rsa_keys
  870. ON
  871. sha256_password_private_key_path
  872. private_key.pem
  873. sha256_password_proxy_users
  874. OFF
  875. sha256_password_public_key_path
  876. public_key.pem
  877. shared_memory
  878. ON
  879. shared_memory_base_name
  880. MYSQL
  881. show_create_table_verbosity
  882. OFF
  883. show_old_temporals
  884. OFF
  885. skip_external_locking
  886. ON
  887. skip_name_resolve
  888. OFF
  889. skip_networking
  890. OFF
  891. skip_show_database
  892. OFF
  893. slave_allow_batching
  894. OFF
  895. slave_checkpoint_group
  896. 512
  897. slave_checkpoint_period
  898. 300
  899. slave_compressed_protocol
  900. OFF
  901. slave_exec_mode
  902. STRICT
  903. slave_load_tmpdir
  904. C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp
  905. slave_max_allowed_packet
  906. 1073741824
  907. slave_net_timeout
  908. 60
  909. slave_parallel_type
  910. DATABASE
  911. slave_parallel_workers
  912. 0
  913. slave_pending_jobs_size_max
  914. 134217728
  915. slave_preserve_commit_order
  916. OFF
  917. slave_rows_search_algorithms
  918. INDEX_SCAN,HASH_SCAN
  919. slave_skip_errors
  920. OFF
  921. slave_sql_verify_checksum
  922. ON
  923. slave_transaction_retries
  924. 10
  925. slave_type_conversions
  926. slow_launch_time
  927. 2
  928. slow_query_log
  929. ON
  930. slow_query_log_file
  931. SERVER-slow.log
  932. socket
  933. MYSQL
  934. sort_buffer_size
  935. 262144
  936. sql_auto_is_null
  937. OFF
  938. sql_big_selects
  939. ON
  940. sql_buffer_result
  941. OFF
  942. sql_log_off
  943. OFF
  944. sql_mode
  945. STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
  946. sql_notes
  947. ON
  948. sql_quote_show_create
  949. ON
  950. sql_require_primary_key
  951. OFF
  952. sql_safe_updates
  953. OFF
  954. sql_select_limit
  955. 18446744073709551615
  956. sql_slave_skip_counter
  957. 0
  958. sql_warnings
  959. OFF
  960. ssl_ca
  961. ca.pem
  962. ssl_capath
  963. ssl_cert
  964. server-cert.pem
  965. ssl_cipher
  966. ssl_crl
  967. ssl_crlpath
  968. ssl_fips_mode
  969. OFF
  970. ssl_key
  971. server-key.pem
  972. stored_program_cache
  973. 256
  974. stored_program_definition_cache
  975. 256
  976. super_read_only
  977. OFF
  978. Variable_name
  979. Value
  980.  
  981. sync_binlog
  982. 1
  983. sync_master_info
  984. 10000
  985. sync_relay_log
  986. 10000
  987. sync_relay_log_info
  988. 10000
  989. system_time_zone
  990. FLE Standard Time
  991. table_definition_cache
  992. 1400
  993. table_open_cache
  994. 2000
  995. table_open_cache_instances
  996. 16
  997. tablespace_definition_cache
  998. 256
  999. temptable_max_ram
  1000. 1073741824
  1001. thread_cache_size
  1002. 10
  1003. thread_handling
  1004. one-thread-per-connection
  1005. thread_stack
  1006. 286720
  1007. time_zone
  1008. SYSTEM
  1009. tls_version
  1010. TLSv1,TLSv1.1,TLSv1.2
  1011. tmp_table_size
  1012. 65011712
  1013. tmpdir
  1014. C:\Windows\SERVIC~2\NETWOR~1\AppData\Local\Temp
  1015. transaction_alloc_block_size
  1016. 8192
  1017. transaction_isolation
  1018. REPEATABLE-READ
  1019. transaction_prealloc_size
  1020. 4096
  1021. transaction_read_only
  1022. OFF
  1023. transaction_write_set_extraction
  1024. XXHASH64
  1025. unique_checks
  1026. ON
  1027. updatable_views_with_limit
  1028. YES
  1029. version
  1030. 8.0.13
  1031. version_comment
  1032. MySQL Community Server - GPL
  1033. version_compile_machine
  1034. x86_64
  1035. version_compile_os
  1036. Win64
  1037. version_compile_zlib
  1038. 1.2.11
  1039. wait_timeout
  1040. 28800
  1041. windowing_use_high_precision
  1042. ON
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!