Advertisement
Guest User

Untitled

a guest
Feb 24th, 2020
213
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 53.82 KB | None | 0 0
  1. mysql> SHOW GLOBAL VARIABLES\G;
  2. *************************** 1. row ***************************
  3. Variable_name: auto_increment_increment
  4. Value: 1
  5. *************************** 2. row ***************************
  6. Variable_name: auto_increment_offset
  7. Value: 1
  8. *************************** 3. row ***************************
  9. Variable_name: autocommit
  10. Value: ON
  11. *************************** 4. row ***************************
  12. Variable_name: automatic_sp_privileges
  13. Value: ON
  14. *************************** 5. row ***************************
  15. Variable_name: avoid_temporal_upgrade
  16. Value: OFF
  17. *************************** 6. row ***************************
  18. Variable_name: back_log
  19. Value: 664
  20. *************************** 7. row ***************************
  21. Variable_name: basedir
  22. Value: /usr
  23. *************************** 8. row ***************************
  24. Variable_name: big_tables
  25. Value: OFF
  26. *************************** 9. row ***************************
  27. Variable_name: bind_address
  28. Value: *
  29. *************************** 10. row ***************************
  30. Variable_name: binlog_cache_size
  31. Value: 32768
  32. *************************** 11. row ***************************
  33. Variable_name: binlog_checksum
  34. Value: CRC32
  35. *************************** 12. row ***************************
  36. Variable_name: binlog_direct_non_transactional_updates
  37. Value: OFF
  38. *************************** 13. row ***************************
  39. Variable_name: binlog_error_action
  40. Value: IGNORE_ERROR
  41. *************************** 14. row ***************************
  42. Variable_name: binlog_format
  43. Value: MIXED
  44. *************************** 15. row ***************************
  45. Variable_name: binlog_gtid_simple_recovery
  46. Value: OFF
  47. *************************** 16. row ***************************
  48. Variable_name: binlog_max_flush_queue_time
  49. Value: 0
  50. *************************** 17. row ***************************
  51. Variable_name: binlog_order_commits
  52. Value: ON
  53. *************************** 18. row ***************************
  54. Variable_name: binlog_row_image
  55. Value: FULL
  56. *************************** 19. row ***************************
  57. Variable_name: binlog_rows_query_log_events
  58. Value: OFF
  59. *************************** 20. row ***************************
  60. Variable_name: binlog_stmt_cache_size
  61. Value: 32768
  62. *************************** 21. row ***************************
  63. Variable_name: binlogging_impossible_mode
  64. Value: IGNORE_ERROR
  65. *************************** 22. row ***************************
  66. Variable_name: block_encryption_mode
  67. Value: aes-128-ecb
  68. *************************** 23. row ***************************
  69. Variable_name: bulk_insert_buffer_size
  70. Value: 8388608
  71. *************************** 24. row ***************************
  72. Variable_name: character_set_client
  73. Value: latin1
  74. *************************** 25. row ***************************
  75. Variable_name: character_set_connection
  76. Value: latin1
  77. *************************** 26. row ***************************
  78. Variable_name: character_set_database
  79. Value: latin1
  80. *************************** 27. row ***************************
  81. Variable_name: character_set_filesystem
  82. Value: binary
  83. *************************** 28. row ***************************
  84. Variable_name: character_set_results
  85. Value: latin1
  86. *************************** 29. row ***************************
  87. Variable_name: character_set_server
  88. Value: latin1
  89. *************************** 30. row ***************************
  90. Variable_name: character_set_system
  91. Value: utf8
  92. *************************** 31. row ***************************
  93. Variable_name: character_sets_dir
  94. Value: /usr/share/mysql/charsets/
  95. *************************** 32. row ***************************
  96. Variable_name: collation_connection
  97. Value: latin1_swedish_ci
  98. *************************** 33. row ***************************
  99. Variable_name: collation_database
  100. Value: latin1_swedish_ci
  101. *************************** 34. row ***************************
  102. Variable_name: collation_server
  103. Value: latin1_swedish_ci
  104. *************************** 35. row ***************************
  105. Variable_name: completion_type
  106. Value: NO_CHAIN
  107. *************************** 36. row ***************************
  108. Variable_name: concurrent_insert
  109. Value: AUTO
  110. *************************** 37. row ***************************
  111. Variable_name: connect_timeout
  112. Value: 8
  113. *************************** 38. row ***************************
  114. Variable_name: core_file
  115. Value: OFF
  116. *************************** 39. row ***************************
  117. Variable_name: datadir
  118. Value: /var/lib/mysql/
  119. *************************** 40. row ***************************
  120. Variable_name: date_format
  121. Value: %Y-%m-%d
  122. *************************** 41. row ***************************
  123. Variable_name: datetime_format
  124. Value: %Y-%m-%d %H:%i:%s
  125. *************************** 42. row ***************************
  126. Variable_name: default_storage_engine
  127. Value: InnoDB
  128. *************************** 43. row ***************************
  129. Variable_name: default_tmp_storage_engine
  130. Value: InnoDB
  131. *************************** 44. row ***************************
  132. Variable_name: default_week_format
  133. Value: 0
  134. *************************** 45. row ***************************
  135. Variable_name: delay_key_write
  136. Value: ON
  137. *************************** 46. row ***************************
  138. Variable_name: delayed_insert_limit
  139. Value: 100
  140. *************************** 47. row ***************************
  141. Variable_name: delayed_insert_timeout
  142. Value: 8
  143. *************************** 48. row ***************************
  144. Variable_name: delayed_queue_size
  145. Value: 1000
  146. *************************** 49. row ***************************
  147. Variable_name: disconnect_on_expired_password
  148. Value: ON
  149. *************************** 50. row ***************************
  150. Variable_name: div_precision_increment
  151. Value: 4
  152. *************************** 51. row ***************************
  153. Variable_name: end_markers_in_json
  154. Value: OFF
  155. *************************** 52. row ***************************
  156. Variable_name: enforce_gtid_consistency
  157. Value: OFF
  158. *************************** 53. row ***************************
  159. Variable_name: eq_range_index_dive_limit
  160. Value: 10
  161. *************************** 54. row ***************************
  162. Variable_name: event_scheduler
  163. Value: OFF
  164. *************************** 55. row ***************************
  165. Variable_name: expire_logs_days
  166. Value: 5
  167. *************************** 56. row ***************************
  168. Variable_name: explicit_defaults_for_timestamp
  169. Value: ON
  170. *************************** 57. row ***************************
  171. Variable_name: flush
  172. Value: OFF
  173. *************************** 58. row ***************************
  174. Variable_name: flush_time
  175. Value: 0
  176. *************************** 59. row ***************************
  177. Variable_name: foreign_key_checks
  178. Value: ON
  179. *************************** 60. row ***************************
  180. Variable_name: ft_boolean_syntax
  181. Value: + -><()~*:""&|
  182. *************************** 61. row ***************************
  183. Variable_name: ft_max_word_len
  184. Value: 84
  185. *************************** 62. row ***************************
  186. Variable_name: ft_min_word_len
  187. Value: 4
  188. *************************** 63. row ***************************
  189. Variable_name: ft_query_expansion_limit
  190. Value: 20
  191. *************************** 64. row ***************************
  192. Variable_name: ft_stopword_file
  193. Value: (built-in)
  194. *************************** 65. row ***************************
  195. Variable_name: general_log
  196. Value: OFF
  197. *************************** 66. row ***************************
  198. Variable_name: general_log_file
  199. Value: /var/lib/mysql/vm4521.log
  200. *************************** 67. row ***************************
  201. Variable_name: group_concat_max_len
  202. Value: 1024
  203. *************************** 68. row ***************************
  204. Variable_name: gtid_executed
  205. Value:
  206. *************************** 69. row ***************************
  207. Variable_name: gtid_mode
  208. Value: OFF
  209. *************************** 70. row ***************************
  210. Variable_name: gtid_owned
  211. Value:
  212. *************************** 71. row ***************************
  213. Variable_name: gtid_purged
  214. Value:
  215. *************************** 72. row ***************************
  216. Variable_name: have_compress
  217. Value: YES
  218. *************************** 73. row ***************************
  219. Variable_name: have_crypt
  220. Value: YES
  221. *************************** 74. row ***************************
  222. Variable_name: have_dynamic_loading
  223. Value: YES
  224. *************************** 75. row ***************************
  225. Variable_name: have_geometry
  226. Value: YES
  227. *************************** 76. row ***************************
  228. Variable_name: have_openssl
  229. Value: DISABLED
  230. *************************** 77. row ***************************
  231. Variable_name: have_profiling
  232. Value: YES
  233. *************************** 78. row ***************************
  234. Variable_name: have_query_cache
  235. Value: YES
  236. *************************** 79. row ***************************
  237. Variable_name: have_rtree_keys
  238. Value: YES
  239. *************************** 80. row ***************************
  240. Variable_name: have_ssl
  241. Value: DISABLED
  242. *************************** 81. row ***************************
  243. Variable_name: have_symlink
  244. Value: DISABLED
  245. *************************** 82. row ***************************
  246. Variable_name: host_cache_size
  247. Value: 756
  248. *************************** 83. row ***************************
  249. Variable_name: hostname
  250. Value: vm4521.cloud.seeweb.it
  251. *************************** 84. row ***************************
  252. Variable_name: ignore_builtin_innodb
  253. Value: OFF
  254. *************************** 85. row ***************************
  255. Variable_name: ignore_db_dirs
  256. Value: lost+found
  257. *************************** 86. row ***************************
  258. Variable_name: init_connect
  259. Value:
  260. *************************** 87. row ***************************
  261. Variable_name: init_file
  262. Value:
  263. *************************** 88. row ***************************
  264. Variable_name: init_slave
  265. Value:
  266. *************************** 89. row ***************************
  267. Variable_name: innodb_adaptive_flushing
  268. Value: ON
  269. *************************** 90. row ***************************
  270. Variable_name: innodb_adaptive_flushing_lwm
  271. Value: 10
  272. *************************** 91. row ***************************
  273. Variable_name: innodb_adaptive_hash_index
  274. Value: ON
  275. *************************** 92. row ***************************
  276. Variable_name: innodb_adaptive_max_sleep_delay
  277. Value: 150000
  278. *************************** 93. row ***************************
  279. Variable_name: innodb_additional_mem_pool_size
  280. Value: 8388608
  281. *************************** 94. row ***************************
  282. Variable_name: innodb_api_bk_commit_interval
  283. Value: 5
  284. *************************** 95. row ***************************
  285. Variable_name: innodb_api_disable_rowlock
  286. Value: OFF
  287. *************************** 96. row ***************************
  288. Variable_name: innodb_api_enable_binlog
  289. Value: OFF
  290. *************************** 97. row ***************************
  291. Variable_name: innodb_api_enable_mdl
  292. Value: OFF
  293. *************************** 98. row ***************************
  294. Variable_name: innodb_api_trx_level
  295. Value: 0
  296. *************************** 99. row ***************************
  297. Variable_name: innodb_autoextend_increment
  298. Value: 64
  299. *************************** 100. row ***************************
  300. Variable_name: innodb_autoinc_lock_mode
  301. Value: 1
  302. *************************** 101. row ***************************
  303. Variable_name: innodb_buffer_pool_dump_at_shutdown
  304. Value: OFF
  305. *************************** 102. row ***************************
  306. Variable_name: innodb_buffer_pool_dump_now
  307. Value: OFF
  308. *************************** 103. row ***************************
  309. Variable_name: innodb_buffer_pool_filename
  310. Value: ib_buffer_pool
  311. *************************** 104. row ***************************
  312. Variable_name: innodb_buffer_pool_instances
  313. Value: 8
  314. *************************** 105. row ***************************
  315. Variable_name: innodb_buffer_pool_load_abort
  316. Value: OFF
  317. *************************** 106. row ***************************
  318. Variable_name: innodb_buffer_pool_load_at_startup
  319. Value: OFF
  320. *************************** 107. row ***************************
  321. Variable_name: innodb_buffer_pool_load_now
  322. Value: OFF
  323. *************************** 108. row ***************************
  324. Variable_name: innodb_buffer_pool_size
  325. Value: 25769803776
  326. *************************** 109. row ***************************
  327. Variable_name: innodb_change_buffer_max_size
  328. Value: 25
  329. *************************** 110. row ***************************
  330. Variable_name: innodb_change_buffering
  331. Value: all
  332. *************************** 111. row ***************************
  333. Variable_name: innodb_checksum_algorithm
  334. Value: innodb
  335. *************************** 112. row ***************************
  336. Variable_name: innodb_checksums
  337. Value: ON
  338. *************************** 113. row ***************************
  339. Variable_name: innodb_cmp_per_index_enabled
  340. Value: OFF
  341. *************************** 114. row ***************************
  342. Variable_name: innodb_commit_concurrency
  343. Value: 0
  344. *************************** 115. row ***************************
  345. Variable_name: innodb_compression_failure_threshold_pct
  346. Value: 5
  347. *************************** 116. row ***************************
  348. Variable_name: innodb_compression_level
  349. Value: 6
  350. *************************** 117. row ***************************
  351. Variable_name: innodb_compression_pad_pct_max
  352. Value: 50
  353. *************************** 118. row ***************************
  354. Variable_name: innodb_concurrency_tickets
  355. Value: 5000
  356. *************************** 119. row ***************************
  357. Variable_name: innodb_data_file_path
  358. Value: ibdata1:12M:autoextend
  359. *************************** 120. row ***************************
  360. Variable_name: innodb_data_home_dir
  361. Value:
  362. *************************** 121. row ***************************
  363. Variable_name: innodb_disable_sort_file_cache
  364. Value: OFF
  365. *************************** 122. row ***************************
  366. Variable_name: innodb_doublewrite
  367. Value: ON
  368. *************************** 123. row ***************************
  369. Variable_name: innodb_fast_shutdown
  370. Value: 1
  371. *************************** 124. row ***************************
  372. Variable_name: innodb_file_format
  373. Value: Antelope
  374. *************************** 125. row ***************************
  375. Variable_name: innodb_file_format_check
  376. Value: ON
  377. *************************** 126. row ***************************
  378. Variable_name: innodb_file_format_max
  379. Value: Antelope
  380. *************************** 127. row ***************************
  381. Variable_name: innodb_file_per_table
  382. Value: ON
  383. *************************** 128. row ***************************
  384. Variable_name: innodb_flush_log_at_timeout
  385. Value: 1
  386. *************************** 129. row ***************************
  387. Variable_name: innodb_flush_log_at_trx_commit
  388. Value: 1
  389. *************************** 130. row ***************************
  390. Variable_name: innodb_flush_method
  391. Value: O_DIRECT
  392. *************************** 131. row ***************************
  393. Variable_name: innodb_flush_neighbors
  394. Value: 1
  395. *************************** 132. row ***************************
  396. Variable_name: innodb_flushing_avg_loops
  397. Value: 30
  398. *************************** 133. row ***************************
  399. Variable_name: innodb_force_load_corrupted
  400. Value: OFF
  401. *************************** 134. row ***************************
  402. Variable_name: innodb_force_recovery
  403. Value: 0
  404. *************************** 135. row ***************************
  405. Variable_name: innodb_ft_aux_table
  406. Value:
  407. *************************** 136. row ***************************
  408. Variable_name: innodb_ft_cache_size
  409. Value: 8000000
  410. *************************** 137. row ***************************
  411. Variable_name: innodb_ft_enable_diag_print
  412. Value: OFF
  413. *************************** 138. row ***************************
  414. Variable_name: innodb_ft_enable_stopword
  415. Value: ON
  416. *************************** 139. row ***************************
  417. Variable_name: innodb_ft_max_token_size
  418. Value: 84
  419. *************************** 140. row ***************************
  420. Variable_name: innodb_ft_min_token_size
  421. Value: 3
  422. *************************** 141. row ***************************
  423. Variable_name: innodb_ft_num_word_optimize
  424. Value: 2000
  425. *************************** 142. row ***************************
  426. Variable_name: innodb_ft_result_cache_limit
  427. Value: 2000000000
  428. *************************** 143. row ***************************
  429. Variable_name: innodb_ft_server_stopword_table
  430. Value:
  431. *************************** 144. row ***************************
  432. Variable_name: innodb_ft_sort_pll_degree
  433. Value: 2
  434. *************************** 145. row ***************************
  435. Variable_name: innodb_ft_total_cache_size
  436. Value: 640000000
  437. *************************** 146. row ***************************
  438. Variable_name: innodb_ft_user_stopword_table
  439. Value:
  440. *************************** 147. row ***************************
  441. Variable_name: innodb_io_capacity
  442. Value: 200
  443. *************************** 148. row ***************************
  444. Variable_name: innodb_io_capacity_max
  445. Value: 2000
  446. *************************** 149. row ***************************
  447. Variable_name: innodb_large_prefix
  448. Value: OFF
  449. *************************** 150. row ***************************
  450. Variable_name: innodb_lock_wait_timeout
  451. Value: 120
  452. *************************** 151. row ***************************
  453. Variable_name: innodb_locks_unsafe_for_binlog
  454. Value: OFF
  455. *************************** 152. row ***************************
  456. Variable_name: innodb_log_buffer_size
  457. Value: 134217728
  458. *************************** 153. row ***************************
  459. Variable_name: innodb_log_compressed_pages
  460. Value: ON
  461. *************************** 154. row ***************************
  462. Variable_name: innodb_log_file_size
  463. Value: 268435456
  464. *************************** 155. row ***************************
  465. Variable_name: innodb_log_files_in_group
  466. Value: 2
  467. *************************** 156. row ***************************
  468. Variable_name: innodb_log_group_home_dir
  469. Value: ./
  470. *************************** 157. row ***************************
  471. Variable_name: innodb_lru_scan_depth
  472. Value: 1024
  473. *************************** 158. row ***************************
  474. Variable_name: innodb_max_dirty_pages_pct
  475. Value: 75
  476. *************************** 159. row ***************************
  477. Variable_name: innodb_max_dirty_pages_pct_lwm
  478. Value: 0
  479. *************************** 160. row ***************************
  480. Variable_name: innodb_max_purge_lag
  481. Value: 0
  482. *************************** 161. row ***************************
  483. Variable_name: innodb_max_purge_lag_delay
  484. Value: 0
  485. *************************** 162. row ***************************
  486. Variable_name: innodb_mirrored_log_groups
  487. Value: 1
  488. *************************** 163. row ***************************
  489. Variable_name: innodb_monitor_disable
  490. Value:
  491. *************************** 164. row ***************************
  492. Variable_name: innodb_monitor_enable
  493. Value:
  494. *************************** 165. row ***************************
  495. Variable_name: innodb_monitor_reset
  496. Value:
  497. *************************** 166. row ***************************
  498. Variable_name: innodb_monitor_reset_all
  499. Value:
  500. *************************** 167. row ***************************
  501. Variable_name: innodb_old_blocks_pct
  502. Value: 37
  503. *************************** 168. row ***************************
  504. Variable_name: innodb_old_blocks_time
  505. Value: 1000
  506. *************************** 169. row ***************************
  507. Variable_name: innodb_online_alter_log_max_size
  508. Value: 134217728
  509. *************************** 170. row ***************************
  510. Variable_name: innodb_open_files
  511. Value: 2000
  512. *************************** 171. row ***************************
  513. Variable_name: innodb_optimize_fulltext_only
  514. Value: OFF
  515. *************************** 172. row ***************************
  516. Variable_name: innodb_page_size
  517. Value: 16384
  518. *************************** 173. row ***************************
  519. Variable_name: innodb_print_all_deadlocks
  520. Value: OFF
  521. *************************** 174. row ***************************
  522. Variable_name: innodb_purge_batch_size
  523. Value: 300
  524. *************************** 175. row ***************************
  525. Variable_name: innodb_purge_threads
  526. Value: 1
  527. *************************** 176. row ***************************
  528. Variable_name: innodb_random_read_ahead
  529. Value: OFF
  530. *************************** 177. row ***************************
  531. Variable_name: innodb_read_ahead_threshold
  532. Value: 56
  533. *************************** 178. row ***************************
  534. Variable_name: innodb_read_io_threads
  535. Value: 4
  536. *************************** 179. row ***************************
  537. Variable_name: innodb_read_only
  538. Value: OFF
  539. *************************** 180. row ***************************
  540. Variable_name: innodb_replication_delay
  541. Value: 0
  542. *************************** 181. row ***************************
  543. Variable_name: innodb_rollback_on_timeout
  544. Value: OFF
  545. *************************** 182. row ***************************
  546. Variable_name: innodb_rollback_segments
  547. Value: 128
  548. *************************** 183. row ***************************
  549. Variable_name: innodb_sort_buffer_size
  550. Value: 1048576
  551. *************************** 184. row ***************************
  552. Variable_name: innodb_spin_wait_delay
  553. Value: 6
  554. *************************** 185. row ***************************
  555. Variable_name: innodb_stats_auto_recalc
  556. Value: ON
  557. *************************** 186. row ***************************
  558. Variable_name: innodb_stats_method
  559. Value: nulls_equal
  560. *************************** 187. row ***************************
  561. Variable_name: innodb_stats_on_metadata
  562. Value: OFF
  563. *************************** 188. row ***************************
  564. Variable_name: innodb_stats_persistent
  565. Value: ON
  566. *************************** 189. row ***************************
  567. Variable_name: innodb_stats_persistent_sample_pages
  568. Value: 20
  569. *************************** 190. row ***************************
  570. Variable_name: innodb_stats_sample_pages
  571. Value: 8
  572. *************************** 191. row ***************************
  573. Variable_name: innodb_stats_transient_sample_pages
  574. Value: 8
  575. *************************** 192. row ***************************
  576. Variable_name: innodb_status_output
  577. Value: OFF
  578. *************************** 193. row ***************************
  579. Variable_name: innodb_status_output_locks
  580. Value: OFF
  581. *************************** 194. row ***************************
  582. Variable_name: innodb_strict_mode
  583. Value: OFF
  584. *************************** 195. row ***************************
  585. Variable_name: innodb_support_xa
  586. Value: ON
  587. *************************** 196. row ***************************
  588. Variable_name: innodb_sync_array_size
  589. Value: 1
  590. *************************** 197. row ***************************
  591. Variable_name: innodb_sync_spin_loops
  592. Value: 30
  593. *************************** 198. row ***************************
  594. Variable_name: innodb_table_locks
  595. Value: ON
  596. *************************** 199. row ***************************
  597. Variable_name: innodb_thread_concurrency
  598. Value: 0
  599. *************************** 200. row ***************************
  600. Variable_name: innodb_thread_sleep_delay
  601. Value: 10000
  602. *************************** 201. row ***************************
  603. Variable_name: innodb_undo_directory
  604. Value: .
  605. *************************** 202. row ***************************
  606. Variable_name: innodb_undo_logs
  607. Value: 128
  608. *************************** 203. row ***************************
  609. Variable_name: innodb_undo_tablespaces
  610. Value: 0
  611. *************************** 204. row ***************************
  612. Variable_name: innodb_use_native_aio
  613. Value: ON
  614. *************************** 205. row ***************************
  615. Variable_name: innodb_use_sys_malloc
  616. Value: ON
  617. *************************** 206. row ***************************
  618. Variable_name: innodb_version
  619. Value: 5.6.26
  620. *************************** 207. row ***************************
  621. Variable_name: innodb_write_io_threads
  622. Value: 4
  623. *************************** 208. row ***************************
  624. Variable_name: interactive_timeout
  625. Value: 720
  626. *************************** 209. row ***************************
  627. Variable_name: join_buffer_size
  628. Value: 33554432
  629. *************************** 210. row ***************************
  630. Variable_name: keep_files_on_create
  631. Value: OFF
  632. *************************** 211. row ***************************
  633. Variable_name: key_buffer_size
  634. Value: 1073741824
  635. *************************** 212. row ***************************
  636. Variable_name: key_cache_age_threshold
  637. Value: 300
  638. *************************** 213. row ***************************
  639. Variable_name: key_cache_block_size
  640. Value: 1024
  641. *************************** 214. row ***************************
  642. Variable_name: key_cache_division_limit
  643. Value: 100
  644. *************************** 215. row ***************************
  645. Variable_name: large_files_support
  646. Value: ON
  647. *************************** 216. row ***************************
  648. Variable_name: large_page_size
  649. Value: 0
  650. *************************** 217. row ***************************
  651. Variable_name: large_pages
  652. Value: OFF
  653. *************************** 218. row ***************************
  654. Variable_name: lc_messages
  655. Value: en_US
  656. *************************** 219. row ***************************
  657. Variable_name: lc_messages_dir
  658. Value: /usr/share/mysql/
  659. *************************** 220. row ***************************
  660. Variable_name: lc_time_names
  661. Value: en_US
  662. *************************** 221. row ***************************
  663. Variable_name: license
  664. Value: GPL
  665. *************************** 222. row ***************************
  666. Variable_name: local_infile
  667. Value: ON
  668. *************************** 223. row ***************************
  669. Variable_name: lock_wait_timeout
  670. Value: 31536000
  671. *************************** 224. row ***************************
  672. Variable_name: locked_in_memory
  673. Value: OFF
  674. *************************** 225. row ***************************
  675. Variable_name: log_bin
  676. Value: ON
  677. *************************** 226. row ***************************
  678. Variable_name: log_bin_basename
  679. Value: /var/lib/mysql/mysql-bin
  680. *************************** 227. row ***************************
  681. Variable_name: log_bin_index
  682. Value: /var/lib/mysql/mysql-bin.index
  683. *************************** 228. row ***************************
  684. Variable_name: log_bin_trust_function_creators
  685. Value: OFF
  686. *************************** 229. row ***************************
  687. Variable_name: log_bin_use_v1_row_events
  688. Value: OFF
  689. *************************** 230. row ***************************
  690. Variable_name: log_error
  691. Value: /var/log/mysql/error.log
  692. *************************** 231. row ***************************
  693. Variable_name: log_output
  694. Value: FILE
  695. *************************** 232. row ***************************
  696. Variable_name: log_queries_not_using_indexes
  697. Value: ON
  698. *************************** 233. row ***************************
  699. Variable_name: log_slave_updates
  700. Value: OFF
  701. *************************** 234. row ***************************
  702. Variable_name: log_slow_admin_statements
  703. Value: OFF
  704. *************************** 235. row ***************************
  705. Variable_name: log_slow_slave_statements
  706. Value: OFF
  707. *************************** 236. row ***************************
  708. Variable_name: log_throttle_queries_not_using_indexes
  709. Value: 0
  710. *************************** 237. row ***************************
  711. Variable_name: log_warnings
  712. Value: 1
  713. *************************** 238. row ***************************
  714. Variable_name: long_query_time
  715. Value: 10.000000
  716. *************************** 239. row ***************************
  717. Variable_name: low_priority_updates
  718. Value: OFF
  719. *************************** 240. row ***************************
  720. Variable_name: lower_case_file_system
  721. Value: OFF
  722. *************************** 241. row ***************************
  723. Variable_name: lower_case_table_names
  724. Value: 0
  725. *************************** 242. row ***************************
  726. Variable_name: master_info_repository
  727. Value: FILE
  728. *************************** 243. row ***************************
  729. Variable_name: master_verify_checksum
  730. Value: OFF
  731. *************************** 244. row ***************************
  732. Variable_name: max_allowed_packet
  733. Value: 4194304
  734. *************************** 245. row ***************************
  735. Variable_name: max_binlog_cache_size
  736. Value: 18446744073709547520
  737. *************************** 246. row ***************************
  738. Variable_name: max_binlog_size
  739. Value: 1073741824
  740. *************************** 247. row ***************************
  741. Variable_name: max_binlog_stmt_cache_size
  742. Value: 18446744073709547520
  743. *************************** 248. row ***************************
  744. Variable_name: max_connect_errors
  745. Value: 100
  746. *************************** 249. row ***************************
  747. Variable_name: max_connections
  748. Value: 3072
  749. *************************** 250. row ***************************
  750. Variable_name: max_delayed_threads
  751. Value: 20
  752. *************************** 251. row ***************************
  753. Variable_name: max_digest_length
  754. Value: 1024
  755. *************************** 252. row ***************************
  756. Variable_name: max_error_count
  757. Value: 64
  758. *************************** 253. row ***************************
  759. Variable_name: max_heap_table_size
  760. Value: 201326592
  761. *************************** 254. row ***************************
  762. Variable_name: max_insert_delayed_threads
  763. Value: 20
  764. *************************** 255. row ***************************
  765. Variable_name: max_join_size
  766. Value: 18446744073709551615
  767. *************************** 256. row ***************************
  768. Variable_name: max_length_for_sort_data
  769. Value: 1024
  770. *************************** 257. row ***************************
  771. Variable_name: max_prepared_stmt_count
  772. Value: 16382
  773. *************************** 258. row ***************************
  774. Variable_name: max_relay_log_size
  775. Value: 0
  776. *************************** 259. row ***************************
  777. Variable_name: max_seeks_for_key
  778. Value: 18446744073709551615
  779. *************************** 260. row ***************************
  780. Variable_name: max_sort_length
  781. Value: 1024
  782. *************************** 261. row ***************************
  783. Variable_name: max_sp_recursion_depth
  784. Value: 0
  785. *************************** 262. row ***************************
  786. Variable_name: max_tmp_tables
  787. Value: 32
  788. *************************** 263. row ***************************
  789. Variable_name: max_user_connections
  790. Value: 3072
  791. *************************** 264. row ***************************
  792. Variable_name: max_write_lock_count
  793. Value: 18446744073709551615
  794. *************************** 265. row ***************************
  795. Variable_name: metadata_locks_cache_size
  796. Value: 1024
  797. *************************** 266. row ***************************
  798. Variable_name: metadata_locks_hash_instances
  799. Value: 8
  800. *************************** 267. row ***************************
  801. Variable_name: min_examined_row_limit
  802. Value: 0
  803. *************************** 268. row ***************************
  804. Variable_name: multi_range_count
  805. Value: 256
  806. *************************** 269. row ***************************
  807. Variable_name: myisam_data_pointer_size
  808. Value: 6
  809. *************************** 270. row ***************************
  810. Variable_name: myisam_max_sort_file_size
  811. Value: 9223372036853727232
  812. *************************** 271. row ***************************
  813. Variable_name: myisam_mmap_size
  814. Value: 18446744073709551615
  815. *************************** 272. row ***************************
  816. Variable_name: myisam_recover_options
  817. Value: OFF
  818. *************************** 273. row ***************************
  819. Variable_name: myisam_repair_threads
  820. Value: 1
  821. *************************** 274. row ***************************
  822. Variable_name: myisam_sort_buffer_size
  823. Value: 8388608
  824. *************************** 275. row ***************************
  825. Variable_name: myisam_stats_method
  826. Value: nulls_unequal
  827. *************************** 276. row ***************************
  828. Variable_name: myisam_use_mmap
  829. Value: OFF
  830. *************************** 277. row ***************************
  831. Variable_name: net_buffer_length
  832. Value: 262144
  833. *************************** 278. row ***************************
  834. Variable_name: net_read_timeout
  835. Value: 30
  836. *************************** 279. row ***************************
  837. Variable_name: net_retry_count
  838. Value: 10
  839. *************************** 280. row ***************************
  840. Variable_name: net_write_timeout
  841. Value: 60
  842. *************************** 281. row ***************************
  843. Variable_name: new
  844. Value: OFF
  845. *************************** 282. row ***************************
  846. Variable_name: old
  847. Value: OFF
  848. *************************** 283. row ***************************
  849. Variable_name: old_alter_table
  850. Value: OFF
  851. *************************** 284. row ***************************
  852. Variable_name: old_passwords
  853. Value: 0
  854. *************************** 285. row ***************************
  855. Variable_name: open_files_limit
  856. Value: 1024000
  857. *************************** 286. row ***************************
  858. Variable_name: optimizer_prune_level
  859. Value: 1
  860. *************************** 287. row ***************************
  861. Variable_name: optimizer_search_depth
  862. Value: 62
  863. *************************** 288. row ***************************
  864. Variable_name: optimizer_switch
  865. Value: 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,subquery_materialization_cost_based=on,use_index_extensions=on
  866. *************************** 289. row ***************************
  867. Variable_name: optimizer_trace
  868. Value: enabled=off,one_line=off
  869. *************************** 290. row ***************************
  870. Variable_name: optimizer_trace_features
  871. Value: greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  872. *************************** 291. row ***************************
  873. Variable_name: optimizer_trace_limit
  874. Value: 1
  875. *************************** 292. row ***************************
  876. Variable_name: optimizer_trace_max_mem_size
  877. Value: 16384
  878. *************************** 293. row ***************************
  879. Variable_name: optimizer_trace_offset
  880. Value: -1
  881. *************************** 294. row ***************************
  882. Variable_name: performance_schema
  883. Value: ON
  884. *************************** 295. row ***************************
  885. Variable_name: performance_schema_accounts_size
  886. Value: 100
  887. *************************** 296. row ***************************
  888. Variable_name: performance_schema_digests_size
  889. Value: 10000
  890. *************************** 297. row ***************************
  891. Variable_name: performance_schema_events_stages_history_long_size
  892. Value: 10000
  893. *************************** 298. row ***************************
  894. Variable_name: performance_schema_events_stages_history_size
  895. Value: 10
  896. *************************** 299. row ***************************
  897. Variable_name: performance_schema_events_statements_history_long_size
  898. Value: 10000
  899. *************************** 300. row ***************************
  900. Variable_name: performance_schema_events_statements_history_size
  901. Value: 10
  902. *************************** 301. row ***************************
  903. Variable_name: performance_schema_events_waits_history_long_size
  904. Value: 10000
  905. *************************** 302. row ***************************
  906. Variable_name: performance_schema_events_waits_history_size
  907. Value: 10
  908. *************************** 303. row ***************************
  909. Variable_name: performance_schema_hosts_size
  910. Value: 100
  911. *************************** 304. row ***************************
  912. Variable_name: performance_schema_max_cond_classes
  913. Value: 80
  914. *************************** 305. row ***************************
  915. Variable_name: performance_schema_max_cond_instances
  916. Value: 15188
  917. *************************** 306. row ***************************
  918. Variable_name: performance_schema_max_digest_length
  919. Value: 1024
  920. *************************** 307. row ***************************
  921. Variable_name: performance_schema_max_file_classes
  922. Value: 50
  923. *************************** 308. row ***************************
  924. Variable_name: performance_schema_max_file_handles
  925. Value: 32768
  926. *************************** 309. row ***************************
  927. Variable_name: performance_schema_max_file_instances
  928. Value: 31508
  929. *************************** 310. row ***************************
  930. Variable_name: performance_schema_max_mutex_classes
  931. Value: 200
  932. *************************** 311. row ***************************
  933. Variable_name: performance_schema_max_mutex_instances
  934. Value: 33432
  935. *************************** 312. row ***************************
  936. Variable_name: performance_schema_max_rwlock_classes
  937. Value: 40
  938. *************************** 313. row ***************************
  939. Variable_name: performance_schema_max_rwlock_instances
  940. Value: 14944
  941. *************************** 314. row ***************************
  942. Variable_name: performance_schema_max_socket_classes
  943. Value: 10
  944. *************************** 315. row ***************************
  945. Variable_name: performance_schema_max_socket_instances
  946. Value: 6164
  947. *************************** 316. row ***************************
  948. Variable_name: performance_schema_max_stage_classes
  949. Value: 150
  950. *************************** 317. row ***************************
  951. Variable_name: performance_schema_max_statement_classes
  952. Value: 168
  953. *************************** 318. row ***************************
  954. Variable_name: performance_schema_max_table_handles
  955. Value: 4000
  956. *************************** 319. row ***************************
  957. Variable_name: performance_schema_max_table_instances
  958. Value: 12500
  959. *************************** 320. row ***************************
  960. Variable_name: performance_schema_max_thread_classes
  961. Value: 50
  962. *************************** 321. row ***************************
  963. Variable_name: performance_schema_max_thread_instances
  964. Value: 6244
  965. *************************** 322. row ***************************
  966. Variable_name: performance_schema_session_connect_attrs_size
  967. Value: 512
  968. *************************** 323. row ***************************
  969. Variable_name: performance_schema_setup_actors_size
  970. Value: 100
  971. *************************** 324. row ***************************
  972. Variable_name: performance_schema_setup_objects_size
  973. Value: 100
  974. *************************** 325. row ***************************
  975. Variable_name: performance_schema_users_size
  976. Value: 100
  977. *************************** 326. row ***************************
  978. Variable_name: pid_file
  979. Value: /var/run/mysqld/mysqld.pid
  980. *************************** 327. row ***************************
  981. Variable_name: plugin_dir
  982. Value: /usr/lib/mysql/plugin/
  983. *************************** 328. row ***************************
  984. Variable_name: port
  985. Value: 3306
  986. *************************** 329. row ***************************
  987. Variable_name: preload_buffer_size
  988. Value: 32768
  989. *************************** 330. row ***************************
  990. Variable_name: profiling
  991. Value: OFF
  992. *************************** 331. row ***************************
  993. Variable_name: profiling_history_size
  994. Value: 15
  995. *************************** 332. row ***************************
  996. Variable_name: protocol_version
  997. Value: 10
  998. *************************** 333. row ***************************
  999. Variable_name: query_alloc_block_size
  1000. Value: 8192
  1001. *************************** 334. row ***************************
  1002. Variable_name: query_cache_limit
  1003. Value: 2097152
  1004. *************************** 335. row ***************************
  1005. Variable_name: query_cache_min_res_unit
  1006. Value: 4096
  1007. *************************** 336. row ***************************
  1008. Variable_name: query_cache_size
  1009. Value: 201326592
  1010. *************************** 337. row ***************************
  1011. Variable_name: query_cache_type
  1012. Value: OFF
  1013. *************************** 338. row ***************************
  1014. Variable_name: query_cache_wlock_invalidate
  1015. Value: OFF
  1016. *************************** 339. row ***************************
  1017. Variable_name: query_prealloc_size
  1018. Value: 8192
  1019. *************************** 340. row ***************************
  1020. Variable_name: range_alloc_block_size
  1021. Value: 4096
  1022. *************************** 341. row ***************************
  1023. Variable_name: read_buffer_size
  1024. Value: 2097152
  1025. *************************** 342. row ***************************
  1026. Variable_name: read_only
  1027. Value: ON
  1028. *************************** 343. row ***************************
  1029. Variable_name: read_rnd_buffer_size
  1030. Value: 2097152
  1031. *************************** 344. row ***************************
  1032. Variable_name: relay_log
  1033. Value:
  1034. *************************** 345. row ***************************
  1035. Variable_name: relay_log_basename
  1036. Value:
  1037. *************************** 346. row ***************************
  1038. Variable_name: relay_log_index
  1039. Value:
  1040. *************************** 347. row ***************************
  1041. Variable_name: relay_log_info_file
  1042. Value: relay-log.info
  1043. *************************** 348. row ***************************
  1044. Variable_name: relay_log_info_repository
  1045. Value: FILE
  1046. *************************** 349. row ***************************
  1047. Variable_name: relay_log_purge
  1048. Value: ON
  1049. *************************** 350. row ***************************
  1050. Variable_name: relay_log_recovery
  1051. Value: OFF
  1052. *************************** 351. row ***************************
  1053. Variable_name: relay_log_space_limit
  1054. Value: 0
  1055. *************************** 352. row ***************************
  1056. Variable_name: report_host
  1057. Value:
  1058. *************************** 353. row ***************************
  1059. Variable_name: report_password
  1060. Value:
  1061. *************************** 354. row ***************************
  1062. Variable_name: report_port
  1063. Value: 3306
  1064. *************************** 355. row ***************************
  1065. Variable_name: report_user
  1066. Value:
  1067. *************************** 356. row ***************************
  1068. Variable_name: rpl_stop_slave_timeout
  1069. Value: 31536000
  1070. *************************** 357. row ***************************
  1071. Variable_name: secure_auth
  1072. Value: ON
  1073. *************************** 358. row ***************************
  1074. Variable_name: secure_file_priv
  1075. Value:
  1076. *************************** 359. row ***************************
  1077. Variable_name: server_id
  1078. Value: 1
  1079. *************************** 360. row ***************************
  1080. Variable_name: server_id_bits
  1081. Value: 32
  1082. *************************** 361. row ***************************
  1083. Variable_name: server_uuid
  1084. Value: 29954b68-ac1e-11e8-bfd7-525400dffdd7
  1085. *************************** 362. row ***************************
  1086. Variable_name: show_old_temporals
  1087. Value: OFF
  1088. *************************** 363. row ***************************
  1089. Variable_name: simplified_binlog_gtid_recovery
  1090. Value: OFF
  1091. *************************** 364. row ***************************
  1092. Variable_name: skip_external_locking
  1093. Value: ON
  1094. *************************** 365. row ***************************
  1095. Variable_name: skip_name_resolve
  1096. Value: OFF
  1097. *************************** 366. row ***************************
  1098. Variable_name: skip_networking
  1099. Value: OFF
  1100. *************************** 367. row ***************************
  1101. Variable_name: skip_show_database
  1102. Value: OFF
  1103. *************************** 368. row ***************************
  1104. Variable_name: slave_allow_batching
  1105. Value: OFF
  1106. *************************** 369. row ***************************
  1107. Variable_name: slave_checkpoint_group
  1108. Value: 512
  1109. *************************** 370. row ***************************
  1110. Variable_name: slave_checkpoint_period
  1111. Value: 300
  1112. *************************** 371. row ***************************
  1113. Variable_name: slave_compressed_protocol
  1114. Value: OFF
  1115. *************************** 372. row ***************************
  1116. Variable_name: slave_exec_mode
  1117. Value: STRICT
  1118. *************************** 373. row ***************************
  1119. Variable_name: slave_load_tmpdir
  1120. Value: /run/shm
  1121. *************************** 374. row ***************************
  1122. Variable_name: slave_max_allowed_packet
  1123. Value: 1073741824
  1124. *************************** 375. row ***************************
  1125. Variable_name: slave_net_timeout
  1126. Value: 3600
  1127. *************************** 376. row ***************************
  1128. Variable_name: slave_parallel_workers
  1129. Value: 0
  1130. *************************** 377. row ***************************
  1131. Variable_name: slave_pending_jobs_size_max
  1132. Value: 16777216
  1133. *************************** 378. row ***************************
  1134. Variable_name: slave_rows_search_algorithms
  1135. Value: TABLE_SCAN,INDEX_SCAN
  1136. *************************** 379. row ***************************
  1137. Variable_name: slave_skip_errors
  1138. Value: OFF
  1139. *************************** 380. row ***************************
  1140. Variable_name: slave_sql_verify_checksum
  1141. Value: ON
  1142. *************************** 381. row ***************************
  1143. Variable_name: slave_transaction_retries
  1144. Value: 10
  1145. *************************** 382. row ***************************
  1146. Variable_name: slave_type_conversions
  1147. Value:
  1148. *************************** 383. row ***************************
  1149. Variable_name: slow_launch_time
  1150. Value: 2
  1151. *************************** 384. row ***************************
  1152. Variable_name: slow_query_log
  1153. Value: OFF
  1154. *************************** 385. row ***************************
  1155. Variable_name: slow_query_log_file
  1156. Value: /var/log/mysql/slow.log
  1157. *************************** 386. row ***************************
  1158. Variable_name: socket
  1159. Value: /var/run/mysqld/mysqld.sock
  1160. *************************** 387. row ***************************
  1161. Variable_name: sort_buffer_size
  1162. Value: 4194304
  1163. *************************** 388. row ***************************
  1164. Variable_name: sql_auto_is_null
  1165. Value: OFF
  1166. *************************** 389. row ***************************
  1167. Variable_name: sql_big_selects
  1168. Value: ON
  1169. *************************** 390. row ***************************
  1170. Variable_name: sql_buffer_result
  1171. Value: OFF
  1172. *************************** 391. row ***************************
  1173. Variable_name: sql_log_bin
  1174. Value: ON
  1175. *************************** 392. row ***************************
  1176. Variable_name: sql_log_off
  1177. Value: OFF
  1178. *************************** 393. row ***************************
  1179. Variable_name: sql_mode
  1180. Value: NO_ENGINE_SUBSTITUTION
  1181. *************************** 394. row ***************************
  1182. Variable_name: sql_notes
  1183. Value: ON
  1184. *************************** 395. row ***************************
  1185. Variable_name: sql_quote_show_create
  1186. Value: ON
  1187. *************************** 396. row ***************************
  1188. Variable_name: sql_safe_updates
  1189. Value: OFF
  1190. *************************** 397. row ***************************
  1191. Variable_name: sql_select_limit
  1192. Value: 18446744073709551615
  1193. *************************** 398. row ***************************
  1194. Variable_name: sql_slave_skip_counter
  1195. Value: 0
  1196. *************************** 399. row ***************************
  1197. Variable_name: sql_warnings
  1198. Value: OFF
  1199. *************************** 400. row ***************************
  1200. Variable_name: ssl_ca
  1201. Value:
  1202. *************************** 401. row ***************************
  1203. Variable_name: ssl_capath
  1204. Value:
  1205. *************************** 402. row ***************************
  1206. Variable_name: ssl_cert
  1207. Value:
  1208. *************************** 403. row ***************************
  1209. Variable_name: ssl_cipher
  1210. Value:
  1211. *************************** 404. row ***************************
  1212. Variable_name: ssl_crl
  1213. Value:
  1214. *************************** 405. row ***************************
  1215. Variable_name: ssl_crlpath
  1216. Value:
  1217. *************************** 406. row ***************************
  1218. Variable_name: ssl_key
  1219. Value:
  1220. *************************** 407. row ***************************
  1221. Variable_name: storage_engine
  1222. Value: InnoDB
  1223. *************************** 408. row ***************************
  1224. Variable_name: stored_program_cache
  1225. Value: 256
  1226. *************************** 409. row ***************************
  1227. Variable_name: sync_binlog
  1228. Value: 1
  1229. *************************** 410. row ***************************
  1230. Variable_name: sync_frm
  1231. Value: ON
  1232. *************************** 411. row ***************************
  1233. Variable_name: sync_master_info
  1234. Value: 10000
  1235. *************************** 412. row ***************************
  1236. Variable_name: sync_relay_log
  1237. Value: 10000
  1238. *************************** 413. row ***************************
  1239. Variable_name: sync_relay_log_info
  1240. Value: 10000
  1241. *************************** 414. row ***************************
  1242. Variable_name: system_time_zone
  1243. Value: CET
  1244. *************************** 415. row ***************************
  1245. Variable_name: table_definition_cache
  1246. Value: 1400
  1247. *************************** 416. row ***************************
  1248. Variable_name: table_open_cache
  1249. Value: 2000
  1250. *************************** 417. row ***************************
  1251. Variable_name: table_open_cache_instances
  1252. Value: 1
  1253. *************************** 418. row ***************************
  1254. Variable_name: thread_cache_size
  1255. Value: 96
  1256. *************************** 419. row ***************************
  1257. Variable_name: thread_concurrency
  1258. Value: 12
  1259. *************************** 420. row ***************************
  1260. Variable_name: thread_handling
  1261. Value: one-thread-per-connection
  1262. *************************** 421. row ***************************
  1263. Variable_name: thread_stack
  1264. Value: 262144
  1265. *************************** 422. row ***************************
  1266. Variable_name: time_format
  1267. Value: %H:%i:%s
  1268. *************************** 423. row ***************************
  1269. Variable_name: time_zone
  1270. Value: SYSTEM
  1271. *************************** 424. row ***************************
  1272. Variable_name: timed_mutexes
  1273. Value: OFF
  1274. *************************** 425. row ***************************
  1275. Variable_name: tmp_table_size
  1276. Value: 201326592
  1277. *************************** 426. row ***************************
  1278. Variable_name: tmpdir
  1279. Value: /run/shm
  1280. *************************** 427. row ***************************
  1281. Variable_name: transaction_alloc_block_size
  1282. Value: 8192
  1283. *************************** 428. row ***************************
  1284. Variable_name: transaction_prealloc_size
  1285. Value: 4096
  1286. *************************** 429. row ***************************
  1287. Variable_name: tx_isolation
  1288. Value: REPEATABLE-READ
  1289. *************************** 430. row ***************************
  1290. Variable_name: tx_read_only
  1291. Value: OFF
  1292. *************************** 431. row ***************************
  1293. Variable_name: unique_checks
  1294. Value: ON
  1295. *************************** 432. row ***************************
  1296. Variable_name: updatable_views_with_limit
  1297. Value: YES
  1298. *************************** 433. row ***************************
  1299. Variable_name: version
  1300. Value: 5.6.26-log
  1301. *************************** 434. row ***************************
  1302. Variable_name: version_comment
  1303. Value: MySQL Community Server (GPL)
  1304. *************************** 435. row ***************************
  1305. Variable_name: version_compile_machine
  1306. Value: x86_64
  1307. *************************** 436. row ***************************
  1308. Variable_name: version_compile_os
  1309. Value: Linux
  1310. *************************** 437. row ***************************
  1311. Variable_name: wait_timeout
  1312. Value: 720
  1313. 437 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement