Created
November 20, 2016 17:48
-
-
Save jmi4/9854846f268fcb0d23e62a1d14895b7a to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| MariaDB [(none)]> SHOW VARIABLES\G | |
| *************************** 1. row *************************** | |
| Variable_name: aria_block_size | |
| Value: 8192 | |
| *************************** 2. row *************************** | |
| Variable_name: aria_checkpoint_interval | |
| Value: 30 | |
| *************************** 3. row *************************** | |
| Variable_name: aria_checkpoint_log_activity | |
| Value: 1048576 | |
| *************************** 4. row *************************** | |
| Variable_name: aria_force_start_after_recovery_failures | |
| Value: 0 | |
| *************************** 5. row *************************** | |
| Variable_name: aria_group_commit | |
| Value: none | |
| *************************** 6. row *************************** | |
| Variable_name: aria_group_commit_interval | |
| Value: 0 | |
| *************************** 7. row *************************** | |
| Variable_name: aria_log_file_size | |
| Value: 1073741824 | |
| *************************** 8. row *************************** | |
| Variable_name: aria_log_purge_type | |
| Value: immediate | |
| *************************** 9. row *************************** | |
| Variable_name: aria_max_sort_file_size | |
| Value: 9223372036853727232 | |
| *************************** 10. row *************************** | |
| Variable_name: aria_page_checksum | |
| Value: ON | |
| *************************** 11. row *************************** | |
| Variable_name: aria_pagecache_age_threshold | |
| Value: 300 | |
| *************************** 12. row *************************** | |
| Variable_name: aria_pagecache_buffer_size | |
| Value: 134217728 | |
| *************************** 13. row *************************** | |
| Variable_name: aria_pagecache_division_limit | |
| Value: 100 | |
| *************************** 14. row *************************** | |
| Variable_name: aria_recover | |
| Value: NORMAL | |
| *************************** 15. row *************************** | |
| Variable_name: aria_repair_threads | |
| Value: 1 | |
| *************************** 16. row *************************** | |
| Variable_name: aria_sort_buffer_size | |
| Value: 134217728 | |
| *************************** 17. row *************************** | |
| Variable_name: aria_stats_method | |
| Value: nulls_unequal | |
| *************************** 18. row *************************** | |
| Variable_name: aria_sync_log_dir | |
| Value: NEWFILE | |
| *************************** 19. row *************************** | |
| Variable_name: aria_used_for_temp_tables | |
| Value: ON | |
| *************************** 20. row *************************** | |
| Variable_name: auto_increment_increment | |
| Value: 2 | |
| *************************** 21. row *************************** | |
| Variable_name: auto_increment_offset | |
| Value: 1 | |
| *************************** 22. row *************************** | |
| Variable_name: autocommit | |
| Value: ON | |
| *************************** 23. row *************************** | |
| Variable_name: automatic_sp_privileges | |
| Value: ON | |
| *************************** 24. row *************************** | |
| Variable_name: back_log | |
| Value: 50 | |
| *************************** 25. row *************************** | |
| Variable_name: basedir | |
| Value: /usr | |
| *************************** 26. row *************************** | |
| Variable_name: big_tables | |
| Value: OFF | |
| *************************** 27. row *************************** | |
| Variable_name: binlog_annotate_row_events | |
| Value: OFF | |
| *************************** 28. row *************************** | |
| Variable_name: binlog_cache_size | |
| Value: 4194304 | |
| *************************** 29. row *************************** | |
| Variable_name: binlog_checksum | |
| Value: NONE | |
| *************************** 30. row *************************** | |
| Variable_name: binlog_direct_non_transactional_updates | |
| Value: OFF | |
| *************************** 31. row *************************** | |
| Variable_name: binlog_format | |
| Value: ROW | |
| *************************** 32. row *************************** | |
| Variable_name: binlog_optimize_thread_scheduling | |
| Value: ON | |
| *************************** 33. row *************************** | |
| Variable_name: binlog_stmt_cache_size | |
| Value: 32768 | |
| *************************** 34. row *************************** | |
| Variable_name: bulk_insert_buffer_size | |
| Value: 8388608 | |
| *************************** 35. row *************************** | |
| Variable_name: character_set_client | |
| Value: utf8 | |
| *************************** 36. row *************************** | |
| Variable_name: character_set_connection | |
| Value: utf8 | |
| *************************** 37. row *************************** | |
| Variable_name: character_set_database | |
| Value: latin1 | |
| *************************** 38. row *************************** | |
| Variable_name: character_set_filesystem | |
| Value: binary | |
| *************************** 39. row *************************** | |
| Variable_name: character_set_results | |
| Value: utf8 | |
| *************************** 40. row *************************** | |
| Variable_name: character_set_server | |
| Value: latin1 | |
| *************************** 41. row *************************** | |
| Variable_name: character_set_system | |
| Value: utf8 | |
| *************************** 42. row *************************** | |
| Variable_name: character_sets_dir | |
| Value: /usr/share/mysql/charsets/ | |
| *************************** 43. row *************************** | |
| Variable_name: collation_connection | |
| Value: utf8_general_ci | |
| *************************** 44. row *************************** | |
| Variable_name: collation_database | |
| Value: latin1_swedish_ci | |
| *************************** 45. row *************************** | |
| Variable_name: collation_server | |
| Value: latin1_swedish_ci | |
| *************************** 46. row *************************** | |
| Variable_name: completion_type | |
| Value: NO_CHAIN | |
| *************************** 47. row *************************** | |
| Variable_name: concurrent_insert | |
| Value: AUTO | |
| *************************** 48. row *************************** | |
| Variable_name: connect_timeout | |
| Value: 10 | |
| *************************** 49. row *************************** | |
| Variable_name: datadir | |
| Value: /var/lib/mysql/ | |
| *************************** 50. row *************************** | |
| Variable_name: date_format | |
| Value: %Y-%m-%d | |
| *************************** 51. row *************************** | |
| Variable_name: datetime_format | |
| Value: %Y-%m-%d %H:%i:%s | |
| *************************** 52. row *************************** | |
| Variable_name: deadlock_search_depth_long | |
| Value: 15 | |
| *************************** 53. row *************************** | |
| Variable_name: deadlock_search_depth_short | |
| Value: 4 | |
| *************************** 54. row *************************** | |
| Variable_name: deadlock_timeout_long | |
| Value: 50000000 | |
| *************************** 55. row *************************** | |
| Variable_name: deadlock_timeout_short | |
| Value: 10000 | |
| *************************** 56. row *************************** | |
| Variable_name: debug_no_thread_alarm | |
| Value: OFF | |
| *************************** 57. row *************************** | |
| Variable_name: default_storage_engine | |
| Value: InnoDB | |
| *************************** 58. row *************************** | |
| Variable_name: default_week_format | |
| Value: 0 | |
| *************************** 59. row *************************** | |
| Variable_name: delay_key_write | |
| Value: ON | |
| *************************** 60. row *************************** | |
| Variable_name: delayed_insert_limit | |
| Value: 100 | |
| *************************** 61. row *************************** | |
| Variable_name: delayed_insert_timeout | |
| Value: 300 | |
| *************************** 62. row *************************** | |
| Variable_name: delayed_queue_size | |
| Value: 1000 | |
| *************************** 63. row *************************** | |
| Variable_name: div_precision_increment | |
| Value: 4 | |
| *************************** 64. row *************************** | |
| Variable_name: engine_condition_pushdown | |
| Value: OFF | |
| *************************** 65. row *************************** | |
| Variable_name: error_count | |
| Value: 0 | |
| *************************** 66. row *************************** | |
| Variable_name: event_scheduler | |
| Value: OFF | |
| *************************** 67. row *************************** | |
| Variable_name: expensive_subquery_limit | |
| Value: 100 | |
| *************************** 68. row *************************** | |
| Variable_name: expire_logs_days | |
| Value: 1 | |
| *************************** 69. row *************************** | |
| Variable_name: external_user | |
| Value: | |
| *************************** 70. row *************************** | |
| Variable_name: extra_max_connections | |
| Value: 1 | |
| *************************** 71. row *************************** | |
| Variable_name: extra_port | |
| Value: 0 | |
| *************************** 72. row *************************** | |
| Variable_name: flush | |
| Value: OFF | |
| *************************** 73. row *************************** | |
| Variable_name: flush_time | |
| Value: 0 | |
| *************************** 74. row *************************** | |
| Variable_name: foreign_key_checks | |
| Value: ON | |
| *************************** 75. row *************************** | |
| Variable_name: ft_boolean_syntax | |
| Value: + -><()~*:""&| | |
| *************************** 76. row *************************** | |
| Variable_name: ft_max_word_len | |
| Value: 84 | |
| *************************** 77. row *************************** | |
| Variable_name: ft_min_word_len | |
| Value: 4 | |
| *************************** 78. row *************************** | |
| Variable_name: ft_query_expansion_limit | |
| Value: 20 | |
| *************************** 79. row *************************** | |
| Variable_name: ft_stopword_file | |
| Value: (built-in) | |
| *************************** 80. row *************************** | |
| Variable_name: general_log | |
| Value: OFF | |
| *************************** 81. row *************************** | |
| Variable_name: general_log_file | |
| Value: cernzbxdb202.log | |
| *************************** 82. row *************************** | |
| Variable_name: group_concat_max_len | |
| Value: 1024 | |
| *************************** 83. row *************************** | |
| Variable_name: have_compress | |
| Value: YES | |
| *************************** 84. row *************************** | |
| Variable_name: have_crypt | |
| Value: YES | |
| *************************** 85. row *************************** | |
| Variable_name: have_csv | |
| Value: YES | |
| *************************** 86. row *************************** | |
| Variable_name: have_dynamic_loading | |
| Value: YES | |
| *************************** 87. row *************************** | |
| Variable_name: have_geometry | |
| Value: YES | |
| *************************** 88. row *************************** | |
| Variable_name: have_innodb | |
| Value: YES | |
| *************************** 89. row *************************** | |
| Variable_name: have_ndbcluster | |
| Value: NO | |
| *************************** 90. row *************************** | |
| Variable_name: have_openssl | |
| Value: DISABLED | |
| *************************** 91. row *************************** | |
| Variable_name: have_partitioning | |
| Value: YES | |
| *************************** 92. row *************************** | |
| Variable_name: have_profiling | |
| Value: YES | |
| *************************** 93. row *************************** | |
| Variable_name: have_query_cache | |
| Value: YES | |
| *************************** 94. row *************************** | |
| Variable_name: have_rtree_keys | |
| Value: YES | |
| *************************** 95. row *************************** | |
| Variable_name: have_ssl | |
| Value: DISABLED | |
| *************************** 96. row *************************** | |
| Variable_name: have_symlink | |
| Value: YES | |
| *************************** 97. row *************************** | |
| Variable_name: hostname | |
| Value: ********* | |
| *************************** 98. row *************************** | |
| Variable_name: identity | |
| Value: 0 | |
| *************************** 99. row *************************** | |
| Variable_name: ignore_builtin_innodb | |
| Value: OFF | |
| *************************** 100. row *************************** | |
| Variable_name: ignore_db_dirs | |
| Value: lost+found | |
| *************************** 101. row *************************** | |
| Variable_name: in_transaction | |
| Value: 0 | |
| *************************** 102. row *************************** | |
| Variable_name: init_connect | |
| Value: | |
| *************************** 103. row *************************** | |
| Variable_name: init_file | |
| Value: | |
| *************************** 104. row *************************** | |
| Variable_name: init_slave | |
| Value: | |
| *************************** 105. row *************************** | |
| Variable_name: innodb_adaptive_flushing | |
| Value: ON | |
| *************************** 106. row *************************** | |
| Variable_name: innodb_adaptive_flushing_method | |
| Value: estimate | |
| *************************** 107. row *************************** | |
| Variable_name: innodb_adaptive_hash_index | |
| Value: ON | |
| *************************** 108. row *************************** | |
| Variable_name: innodb_adaptive_hash_index_partitions | |
| Value: 1 | |
| *************************** 109. row *************************** | |
| Variable_name: innodb_additional_mem_pool_size | |
| Value: 8388608 | |
| *************************** 110. row *************************** | |
| Variable_name: innodb_autoextend_increment | |
| Value: 64 | |
| *************************** 111. row *************************** | |
| Variable_name: innodb_autoinc_lock_mode | |
| Value: 2 | |
| *************************** 112. row *************************** | |
| Variable_name: innodb_blocking_buffer_pool_restore | |
| Value: OFF | |
| *************************** 113. row *************************** | |
| Variable_name: innodb_buffer_pool_instances | |
| Value: 64 | |
| *************************** 114. row *************************** | |
| Variable_name: innodb_buffer_pool_populate | |
| Value: OFF | |
| *************************** 115. row *************************** | |
| Variable_name: innodb_buffer_pool_restore_at_startup | |
| Value: 0 | |
| *************************** 116. row *************************** | |
| Variable_name: innodb_buffer_pool_shm_checksum | |
| Value: ON | |
| *************************** 117. row *************************** | |
| Variable_name: innodb_buffer_pool_shm_key | |
| Value: 0 | |
| *************************** 118. row *************************** | |
| Variable_name: innodb_buffer_pool_size | |
| Value: 107374182400 | |
| *************************** 119. row *************************** | |
| Variable_name: innodb_change_buffering | |
| Value: all | |
| *************************** 120. row *************************** | |
| Variable_name: innodb_checkpoint_age_target | |
| Value: 0 | |
| *************************** 121. row *************************** | |
| Variable_name: innodb_checksums | |
| Value: ON | |
| *************************** 122. row *************************** | |
| Variable_name: innodb_commit_concurrency | |
| Value: 0 | |
| *************************** 123. row *************************** | |
| Variable_name: innodb_concurrency_tickets | |
| Value: 5000 | |
| *************************** 124. row *************************** | |
| Variable_name: innodb_corrupt_table_action | |
| Value: assert | |
| *************************** 125. row *************************** | |
| Variable_name: innodb_data_file_path | |
| Value: ibdata1:10M:autoextend | |
| *************************** 126. row *************************** | |
| Variable_name: innodb_data_home_dir | |
| Value: | |
| *************************** 127. row *************************** | |
| Variable_name: innodb_dict_size_limit | |
| Value: 0 | |
| *************************** 128. row *************************** | |
| Variable_name: innodb_disallow_writes | |
| Value: OFF | |
| *************************** 129. row *************************** | |
| Variable_name: innodb_doublewrite | |
| Value: ON | |
| *************************** 130. row *************************** | |
| Variable_name: innodb_doublewrite_file | |
| Value: | |
| *************************** 131. row *************************** | |
| Variable_name: innodb_fake_changes | |
| Value: OFF | |
| *************************** 132. row *************************** | |
| Variable_name: innodb_fast_checksum | |
| Value: OFF | |
| *************************** 133. row *************************** | |
| Variable_name: innodb_fast_shutdown | |
| Value: 1 | |
| *************************** 134. row *************************** | |
| Variable_name: innodb_file_format | |
| Value: Antelope | |
| *************************** 135. row *************************** | |
| Variable_name: innodb_file_format_check | |
| Value: ON | |
| *************************** 136. row *************************** | |
| Variable_name: innodb_file_format_max | |
| Value: Antelope | |
| *************************** 137. row *************************** | |
| Variable_name: innodb_file_per_table | |
| Value: ON | |
| *************************** 138. row *************************** | |
| Variable_name: innodb_flush_log_at_trx_commit | |
| Value: 0 | |
| *************************** 139. row *************************** | |
| Variable_name: innodb_flush_method | |
| Value: O_DIRECT | |
| *************************** 140. row *************************** | |
| Variable_name: innodb_flush_neighbor_pages | |
| Value: cont | |
| *************************** 141. row *************************** | |
| Variable_name: innodb_force_load_corrupted | |
| Value: OFF | |
| *************************** 142. row *************************** | |
| Variable_name: innodb_force_recovery | |
| Value: 0 | |
| *************************** 143. row *************************** | |
| Variable_name: innodb_ibuf_accel_rate | |
| Value: 100 | |
| *************************** 144. row *************************** | |
| Variable_name: innodb_ibuf_active_contract | |
| Value: 1 | |
| *************************** 145. row *************************** | |
| Variable_name: innodb_ibuf_max_size | |
| Value: 53686566912 | |
| *************************** 146. row *************************** | |
| Variable_name: innodb_import_table_from_xtrabackup | |
| Value: 0 | |
| *************************** 147. row *************************** | |
| Variable_name: innodb_io_capacity | |
| Value: 6000 | |
| *************************** 148. row *************************** | |
| Variable_name: innodb_kill_idle_transaction | |
| Value: 0 | |
| *************************** 149. row *************************** | |
| Variable_name: innodb_large_prefix | |
| Value: OFF | |
| *************************** 150. row *************************** | |
| Variable_name: innodb_lazy_drop_table | |
| Value: 0 | |
| *************************** 151. row *************************** | |
| Variable_name: innodb_lock_wait_timeout | |
| Value: 50 | |
| *************************** 152. row *************************** | |
| Variable_name: innodb_locking_fake_changes | |
| Value: ON | |
| *************************** 153. row *************************** | |
| Variable_name: innodb_locks_unsafe_for_binlog | |
| Value: ON | |
| *************************** 154. row *************************** | |
| Variable_name: innodb_log_block_size | |
| Value: 512 | |
| *************************** 155. row *************************** | |
| Variable_name: innodb_log_buffer_size | |
| Value: 134217728 | |
| *************************** 156. row *************************** | |
| Variable_name: innodb_log_file_size | |
| Value: 2097152000 | |
| *************************** 157. row *************************** | |
| Variable_name: innodb_log_files_in_group | |
| Value: 2 | |
| *************************** 158. row *************************** | |
| Variable_name: innodb_log_group_home_dir | |
| Value: ./ | |
| *************************** 159. row *************************** | |
| Variable_name: innodb_max_bitmap_file_size | |
| Value: 104857600 | |
| *************************** 160. row *************************** | |
| Variable_name: innodb_max_changed_pages | |
| Value: 1000000 | |
| *************************** 161. row *************************** | |
| Variable_name: innodb_max_dirty_pages_pct | |
| Value: 30 | |
| *************************** 162. row *************************** | |
| Variable_name: innodb_max_purge_lag | |
| Value: 0 | |
| *************************** 163. row *************************** | |
| Variable_name: innodb_merge_sort_block_size | |
| Value: 1048576 | |
| *************************** 164. row *************************** | |
| Variable_name: innodb_mirrored_log_groups | |
| Value: 1 | |
| *************************** 165. row *************************** | |
| Variable_name: innodb_old_blocks_pct | |
| Value: 37 | |
| *************************** 166. row *************************** | |
| Variable_name: innodb_old_blocks_time | |
| Value: 1000 | |
| *************************** 167. row *************************** | |
| Variable_name: innodb_open_files | |
| Value: 300 | |
| *************************** 168. row *************************** | |
| Variable_name: innodb_page_size | |
| Value: 16384 | |
| *************************** 169. row *************************** | |
| Variable_name: innodb_print_all_deadlocks | |
| Value: OFF | |
| *************************** 170. row *************************** | |
| Variable_name: innodb_purge_batch_size | |
| Value: 20 | |
| *************************** 171. row *************************** | |
| Variable_name: innodb_purge_threads | |
| Value: 1 | |
| *************************** 172. row *************************** | |
| Variable_name: innodb_random_read_ahead | |
| Value: OFF | |
| *************************** 173. row *************************** | |
| Variable_name: innodb_read_ahead | |
| Value: linear | |
| *************************** 174. row *************************** | |
| Variable_name: innodb_read_ahead_threshold | |
| Value: 56 | |
| *************************** 175. row *************************** | |
| Variable_name: innodb_read_io_threads | |
| Value: 4 | |
| *************************** 176. row *************************** | |
| Variable_name: innodb_recovery_stats | |
| Value: OFF | |
| *************************** 177. row *************************** | |
| Variable_name: innodb_recovery_update_relay_log | |
| Value: OFF | |
| *************************** 178. row *************************** | |
| Variable_name: innodb_replication_delay | |
| Value: 0 | |
| *************************** 179. row *************************** | |
| Variable_name: innodb_rollback_on_timeout | |
| Value: OFF | |
| *************************** 180. row *************************** | |
| Variable_name: innodb_rollback_segments | |
| Value: 128 | |
| *************************** 181. row *************************** | |
| Variable_name: innodb_show_locks_held | |
| Value: 10 | |
| *************************** 182. row *************************** | |
| Variable_name: innodb_show_verbose_locks | |
| Value: 0 | |
| *************************** 183. row *************************** | |
| Variable_name: innodb_spin_wait_delay | |
| Value: 6 | |
| *************************** 184. row *************************** | |
| Variable_name: innodb_stats_auto_update | |
| Value: 1 | |
| *************************** 185. row *************************** | |
| Variable_name: innodb_stats_method | |
| Value: nulls_equal | |
| *************************** 186. row *************************** | |
| Variable_name: innodb_stats_on_metadata | |
| Value: OFF | |
| *************************** 187. row *************************** | |
| Variable_name: innodb_stats_sample_pages | |
| Value: 8 | |
| *************************** 188. row *************************** | |
| Variable_name: innodb_stats_update_need_lock | |
| Value: 1 | |
| *************************** 189. row *************************** | |
| Variable_name: innodb_strict_mode | |
| Value: OFF | |
| *************************** 190. row *************************** | |
| Variable_name: innodb_support_xa | |
| Value: ON | |
| *************************** 191. row *************************** | |
| Variable_name: innodb_sync_spin_loops | |
| Value: 30 | |
| *************************** 192. row *************************** | |
| Variable_name: innodb_table_locks | |
| Value: ON | |
| *************************** 193. row *************************** | |
| Variable_name: innodb_thread_concurrency | |
| Value: 0 | |
| *************************** 194. row *************************** | |
| Variable_name: innodb_thread_concurrency_timer_based | |
| Value: OFF | |
| *************************** 195. row *************************** | |
| Variable_name: innodb_thread_sleep_delay | |
| Value: 10000 | |
| *************************** 196. row *************************** | |
| Variable_name: innodb_track_changed_pages | |
| Value: OFF | |
| *************************** 197. row *************************** | |
| Variable_name: innodb_use_atomic_writes | |
| Value: OFF | |
| *************************** 198. row *************************** | |
| Variable_name: innodb_use_fallocate | |
| Value: OFF | |
| *************************** 199. row *************************** | |
| Variable_name: innodb_use_global_flush_log_at_trx_commit | |
| Value: ON | |
| *************************** 200. row *************************** | |
| Variable_name: innodb_use_native_aio | |
| Value: ON | |
| *************************** 201. row *************************** | |
| Variable_name: innodb_use_stacktrace | |
| Value: OFF | |
| *************************** 202. row *************************** | |
| Variable_name: innodb_use_sys_malloc | |
| Value: ON | |
| *************************** 203. row *************************** | |
| Variable_name: innodb_use_sys_stats_table | |
| Value: OFF | |
| *************************** 204. row *************************** | |
| Variable_name: innodb_version | |
| Value: 5.5.37-MariaDB-35.0 | |
| *************************** 205. row *************************** | |
| Variable_name: innodb_write_io_threads | |
| Value: 4 | |
| *************************** 206. row *************************** | |
| Variable_name: insert_id | |
| Value: 0 | |
| *************************** 207. row *************************** | |
| Variable_name: interactive_timeout | |
| Value: 28800 | |
| *************************** 208. row *************************** | |
| Variable_name: join_buffer_size | |
| Value: 1048576 | |
| *************************** 209. row *************************** | |
| Variable_name: join_buffer_space_limit | |
| Value: 2097152 | |
| *************************** 210. row *************************** | |
| Variable_name: join_cache_level | |
| Value: 2 | |
| *************************** 211. row *************************** | |
| Variable_name: keep_files_on_create | |
| Value: OFF | |
| *************************** 212. row *************************** | |
| Variable_name: key_buffer_size | |
| Value: 16777216 | |
| *************************** 213. row *************************** | |
| Variable_name: key_cache_age_threshold | |
| Value: 300 | |
| *************************** 214. row *************************** | |
| Variable_name: key_cache_block_size | |
| Value: 1024 | |
| *************************** 215. row *************************** | |
| Variable_name: key_cache_division_limit | |
| Value: 100 | |
| *************************** 216. row *************************** | |
| Variable_name: key_cache_segments | |
| Value: 0 | |
| *************************** 217. row *************************** | |
| Variable_name: large_files_support | |
| Value: ON | |
| *************************** 218. row *************************** | |
| Variable_name: large_page_size | |
| Value: 2097152 | |
| *************************** 219. row *************************** | |
| Variable_name: large_pages | |
| Value: ON | |
| *************************** 220. row *************************** | |
| Variable_name: last_insert_id | |
| Value: 0 | |
| *************************** 221. row *************************** | |
| Variable_name: lc_messages | |
| Value: en_US | |
| *************************** 222. row *************************** | |
| Variable_name: lc_messages_dir | |
| Value: | |
| *************************** 223. row *************************** | |
| Variable_name: lc_time_names | |
| Value: en_US | |
| *************************** 224. row *************************** | |
| Variable_name: license | |
| Value: GPL | |
| *************************** 225. row *************************** | |
| Variable_name: local_infile | |
| Value: ON | |
| *************************** 226. row *************************** | |
| Variable_name: lock_wait_timeout | |
| Value: 31536000 | |
| *************************** 227. row *************************** | |
| Variable_name: locked_in_memory | |
| Value: OFF | |
| *************************** 228. row *************************** | |
| Variable_name: log | |
| Value: OFF | |
| *************************** 229. row *************************** | |
| Variable_name: log_bin | |
| Value: ON | |
| *************************** 230. row *************************** | |
| Variable_name: log_bin_trust_function_creators | |
| Value: OFF | |
| *************************** 231. row *************************** | |
| Variable_name: log_error | |
| Value: /var/log/mysql/mysqld.log | |
| *************************** 232. row *************************** | |
| Variable_name: log_output | |
| Value: FILE | |
| *************************** 233. row *************************** | |
| Variable_name: log_queries_not_using_indexes | |
| Value: OFF | |
| *************************** 234. row *************************** | |
| Variable_name: log_slave_updates | |
| Value: ON | |
| *************************** 235. row *************************** | |
| Variable_name: log_slow_filter | |
| Value: admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk | |
| *************************** 236. row *************************** | |
| Variable_name: log_slow_queries | |
| Value: OFF | |
| *************************** 237. row *************************** | |
| Variable_name: log_slow_rate_limit | |
| Value: 1 | |
| *************************** 238. row *************************** | |
| Variable_name: log_slow_verbosity | |
| Value: | |
| *************************** 239. row *************************** | |
| Variable_name: log_warnings | |
| Value: 1 | |
| *************************** 240. row *************************** | |
| Variable_name: long_query_time | |
| Value: 10.000000 | |
| *************************** 241. row *************************** | |
| Variable_name: low_priority_updates | |
| Value: OFF | |
| *************************** 242. row *************************** | |
| Variable_name: lower_case_file_system | |
| Value: OFF | |
| *************************** 243. row *************************** | |
| Variable_name: lower_case_table_names | |
| Value: 0 | |
| *************************** 244. row *************************** | |
| Variable_name: master_verify_checksum | |
| Value: OFF | |
| *************************** 245. row *************************** | |
| Variable_name: max_allowed_packet | |
| Value: 67108864 | |
| *************************** 246. row *************************** | |
| Variable_name: max_binlog_cache_size | |
| Value: 18446744073709547520 | |
| *************************** 247. row *************************** | |
| Variable_name: max_binlog_size | |
| Value: 1073741824 | |
| *************************** 248. row *************************** | |
| Variable_name: max_binlog_stmt_cache_size | |
| Value: 18446744073709547520 | |
| *************************** 249. row *************************** | |
| Variable_name: max_connect_errors | |
| Value: 10000 | |
| *************************** 250. row *************************** | |
| Variable_name: max_connections | |
| Value: 1000 | |
| *************************** 251. row *************************** | |
| Variable_name: max_delayed_threads | |
| Value: 20 | |
| *************************** 252. row *************************** | |
| Variable_name: max_error_count | |
| Value: 64 | |
| *************************** 253. row *************************** | |
| Variable_name: max_heap_table_size | |
| Value: 268435456 | |
| *************************** 254. row *************************** | |
| Variable_name: max_insert_delayed_threads | |
| Value: 20 | |
| *************************** 255. row *************************** | |
| Variable_name: max_join_size | |
| Value: 18446744073709551615 | |
| *************************** 256. row *************************** | |
| Variable_name: max_length_for_sort_data | |
| Value: 1024 | |
| *************************** 257. row *************************** | |
| Variable_name: max_long_data_size | |
| Value: 67108864 | |
| *************************** 258. row *************************** | |
| Variable_name: max_prepared_stmt_count | |
| Value: 16382 | |
| *************************** 259. row *************************** | |
| Variable_name: max_relay_log_size | |
| Value: 0 | |
| *************************** 260. row *************************** | |
| Variable_name: max_seeks_for_key | |
| Value: 4294967295 | |
| *************************** 261. row *************************** | |
| Variable_name: max_sort_length | |
| Value: 1024 | |
| *************************** 262. row *************************** | |
| Variable_name: max_sp_recursion_depth | |
| Value: 0 | |
| *************************** 263. row *************************** | |
| Variable_name: max_tmp_tables | |
| Value: 32 | |
| *************************** 264. row *************************** | |
| Variable_name: max_user_connections | |
| Value: 0 | |
| *************************** 265. row *************************** | |
| Variable_name: max_write_lock_count | |
| Value: 4294967295 | |
| *************************** 266. row *************************** | |
| Variable_name: metadata_locks_cache_size | |
| Value: 1024 | |
| *************************** 267. row *************************** | |
| Variable_name: min_examined_row_limit | |
| Value: 0 | |
| *************************** 268. row *************************** | |
| Variable_name: mrr_buffer_size | |
| Value: 262144 | |
| *************************** 269. row *************************** | |
| Variable_name: multi_range_count | |
| Value: 256 | |
| *************************** 270. row *************************** | |
| Variable_name: myisam_block_size | |
| Value: 1024 | |
| *************************** 271. row *************************** | |
| Variable_name: myisam_data_pointer_size | |
| Value: 6 | |
| *************************** 272. row *************************** | |
| Variable_name: myisam_max_sort_file_size | |
| Value: 9223372036853727232 | |
| *************************** 273. row *************************** | |
| Variable_name: myisam_mmap_size | |
| Value: 18446744073709551615 | |
| *************************** 274. row *************************** | |
| Variable_name: myisam_recover_options | |
| Value: DEFAULT | |
| *************************** 275. row *************************** | |
| Variable_name: myisam_repair_threads | |
| Value: 1 | |
| *************************** 276. row *************************** | |
| Variable_name: myisam_sort_buffer_size | |
| Value: 8388608 | |
| *************************** 277. row *************************** | |
| Variable_name: myisam_stats_method | |
| Value: nulls_unequal | |
| *************************** 278. row *************************** | |
| Variable_name: myisam_use_mmap | |
| Value: OFF | |
| *************************** 279. row *************************** | |
| Variable_name: net_buffer_length | |
| Value: 8192 | |
| *************************** 280. row *************************** | |
| Variable_name: net_read_timeout | |
| Value: 30 | |
| *************************** 281. row *************************** | |
| Variable_name: net_retry_count | |
| Value: 10 | |
| *************************** 282. row *************************** | |
| Variable_name: net_write_timeout | |
| Value: 60 | |
| *************************** 283. row *************************** | |
| Variable_name: old | |
| Value: OFF | |
| *************************** 284. row *************************** | |
| Variable_name: old_alter_table | |
| Value: OFF | |
| *************************** 285. row *************************** | |
| Variable_name: old_mode | |
| Value: | |
| *************************** 286. row *************************** | |
| Variable_name: old_passwords | |
| Value: OFF | |
| *************************** 287. row *************************** | |
| Variable_name: open_files_limit | |
| Value: 9203 | |
| *************************** 288. row *************************** | |
| Variable_name: optimizer_prune_level | |
| Value: 1 | |
| *************************** 289. row *************************** | |
| Variable_name: optimizer_search_depth | |
| Value: 62 | |
| *************************** 290. row *************************** | |
| Variable_name: optimizer_switch | |
| Value: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off | |
| *************************** 291. row *************************** | |
| Variable_name: performance_schema | |
| Value: OFF | |
| *************************** 292. row *************************** | |
| Variable_name: performance_schema_events_waits_history_long_size | |
| Value: 10000 | |
| *************************** 293. row *************************** | |
| Variable_name: performance_schema_events_waits_history_size | |
| Value: 10 | |
| *************************** 294. row *************************** | |
| Variable_name: performance_schema_max_cond_classes | |
| Value: 80 | |
| *************************** 295. row *************************** | |
| Variable_name: performance_schema_max_cond_instances | |
| Value: 1000 | |
| *************************** 296. row *************************** | |
| Variable_name: performance_schema_max_file_classes | |
| Value: 50 | |
| *************************** 297. row *************************** | |
| Variable_name: performance_schema_max_file_handles | |
| Value: 32768 | |
| *************************** 298. row *************************** | |
| Variable_name: performance_schema_max_file_instances | |
| Value: 10000 | |
| *************************** 299. row *************************** | |
| Variable_name: performance_schema_max_mutex_classes | |
| Value: 200 | |
| *************************** 300. row *************************** | |
| Variable_name: performance_schema_max_mutex_instances | |
| Value: 1000000 | |
| *************************** 301. row *************************** | |
| Variable_name: performance_schema_max_rwlock_classes | |
| Value: 30 | |
| *************************** 302. row *************************** | |
| Variable_name: performance_schema_max_rwlock_instances | |
| Value: 1000000 | |
| *************************** 303. row *************************** | |
| Variable_name: performance_schema_max_table_handles | |
| Value: 100000 | |
| *************************** 304. row *************************** | |
| Variable_name: performance_schema_max_table_instances | |
| Value: 50000 | |
| *************************** 305. row *************************** | |
| Variable_name: performance_schema_max_thread_classes | |
| Value: 50 | |
| *************************** 306. row *************************** | |
| Variable_name: performance_schema_max_thread_instances | |
| Value: 1000 | |
| *************************** 307. row *************************** | |
| Variable_name: pid_file | |
| Value: /var/run/mysqld/mysqld.pid | |
| *************************** 308. row *************************** | |
| Variable_name: plugin_dir | |
| Value: /usr/lib64/mysql/plugin/ | |
| *************************** 309. row *************************** | |
| Variable_name: plugin_maturity | |
| Value: unknown | |
| *************************** 310. row *************************** | |
| Variable_name: port | |
| Value: 3306 | |
| *************************** 311. row *************************** | |
| Variable_name: preload_buffer_size | |
| Value: 32768 | |
| *************************** 312. row *************************** | |
| Variable_name: profiling | |
| Value: OFF | |
| *************************** 313. row *************************** | |
| Variable_name: profiling_history_size | |
| Value: 15 | |
| *************************** 314. row *************************** | |
| Variable_name: progress_report_time | |
| Value: 5 | |
| *************************** 315. row *************************** | |
| Variable_name: protocol_version | |
| Value: 10 | |
| *************************** 316. row *************************** | |
| Variable_name: proxy_user | |
| Value: | |
| *************************** 317. row *************************** | |
| Variable_name: pseudo_slave_mode | |
| Value: OFF | |
| *************************** 318. row *************************** | |
| Variable_name: pseudo_thread_id | |
| Value: 4313990 | |
| *************************** 319. row *************************** | |
| Variable_name: query_alloc_block_size | |
| Value: 8192 | |
| *************************** 320. row *************************** | |
| Variable_name: query_cache_limit | |
| Value: 1048576 | |
| *************************** 321. row *************************** | |
| Variable_name: query_cache_min_res_unit | |
| Value: 4096 | |
| *************************** 322. row *************************** | |
| Variable_name: query_cache_size | |
| Value: 0 | |
| *************************** 323. row *************************** | |
| Variable_name: query_cache_strip_comments | |
| Value: OFF | |
| *************************** 324. row *************************** | |
| Variable_name: query_cache_type | |
| Value: OFF | |
| *************************** 325. row *************************** | |
| Variable_name: query_cache_wlock_invalidate | |
| Value: OFF | |
| *************************** 326. row *************************** | |
| Variable_name: query_prealloc_size | |
| Value: 8192 | |
| *************************** 327. row *************************** | |
| Variable_name: rand_seed1 | |
| Value: 0 | |
| *************************** 328. row *************************** | |
| Variable_name: rand_seed2 | |
| Value: 0 | |
| *************************** 329. row *************************** | |
| Variable_name: range_alloc_block_size | |
| Value: 4096 | |
| *************************** 330. row *************************** | |
| Variable_name: read_buffer_size | |
| Value: 1048576 | |
| *************************** 331. row *************************** | |
| Variable_name: read_only | |
| Value: OFF | |
| *************************** 332. row *************************** | |
| Variable_name: read_rnd_buffer_size | |
| Value: 16777216 | |
| *************************** 333. row *************************** | |
| Variable_name: relay_log | |
| Value: | |
| *************************** 334. row *************************** | |
| Variable_name: relay_log_index | |
| Value: | |
| *************************** 335. row *************************** | |
| Variable_name: relay_log_info_file | |
| Value: relay-log.info | |
| *************************** 336. row *************************** | |
| Variable_name: relay_log_purge | |
| Value: ON | |
| *************************** 337. row *************************** | |
| Variable_name: relay_log_recovery | |
| Value: ON | |
| *************************** 338. row *************************** | |
| Variable_name: relay_log_space_limit | |
| Value: 2147483648 | |
| *************************** 339. row *************************** | |
| Variable_name: replicate_annotate_row_events | |
| Value: OFF | |
| *************************** 340. row *************************** | |
| Variable_name: replicate_do_db | |
| Value: zabbix | |
| *************************** 341. row *************************** | |
| Variable_name: replicate_do_table | |
| Value: | |
| *************************** 342. row *************************** | |
| Variable_name: replicate_events_marked_for_skip | |
| Value: replicate | |
| *************************** 343. row *************************** | |
| Variable_name: replicate_ignore_db | |
| Value: mysql, performance_schema, lost+found | |
| *************************** 344. row *************************** | |
| Variable_name: replicate_ignore_table | |
| Value: | |
| *************************** 345. row *************************** | |
| Variable_name: replicate_wild_do_table | |
| Value: | |
| *************************** 346. row *************************** | |
| Variable_name: replicate_wild_ignore_table | |
| Value: | |
| *************************** 347. row *************************** | |
| Variable_name: report_host | |
| Value: | |
| *************************** 348. row *************************** | |
| Variable_name: report_password | |
| Value: | |
| *************************** 349. row *************************** | |
| Variable_name: report_port | |
| Value: 3306 | |
| *************************** 350. row *************************** | |
| Variable_name: report_user | |
| Value: | |
| *************************** 351. row *************************** | |
| Variable_name: rowid_merge_buff_size | |
| Value: 8388608 | |
| *************************** 352. row *************************** | |
| Variable_name: rpl_recovery_rank | |
| Value: 0 | |
| *************************** 353. row *************************** | |
| Variable_name: secure_auth | |
| Value: OFF | |
| *************************** 354. row *************************** | |
| Variable_name: secure_file_priv | |
| Value: | |
| *************************** 355. row *************************** | |
| Variable_name: server_id | |
| Value: 3 | |
| *************************** 356. row *************************** | |
| Variable_name: skip_external_locking | |
| Value: ON | |
| *************************** 357. row *************************** | |
| Variable_name: skip_name_resolve | |
| Value: OFF | |
| *************************** 358. row *************************** | |
| Variable_name: skip_networking | |
| Value: OFF | |
| *************************** 359. row *************************** | |
| Variable_name: skip_replication | |
| Value: OFF | |
| *************************** 360. row *************************** | |
| Variable_name: skip_show_database | |
| Value: OFF | |
| *************************** 361. row *************************** | |
| Variable_name: slave_compressed_protocol | |
| Value: OFF | |
| *************************** 362. row *************************** | |
| Variable_name: slave_exec_mode | |
| Value: STRICT | |
| *************************** 363. row *************************** | |
| Variable_name: slave_load_tmpdir | |
| Value: /dev/shm | |
| *************************** 364. row *************************** | |
| Variable_name: slave_max_allowed_packet | |
| Value: 1073741824 | |
| *************************** 365. row *************************** | |
| Variable_name: slave_net_timeout | |
| Value: 3600 | |
| *************************** 366. row *************************** | |
| Variable_name: slave_skip_errors | |
| Value: 1062 | |
| *************************** 367. row *************************** | |
| Variable_name: slave_sql_verify_checksum | |
| Value: ON | |
| *************************** 368. row *************************** | |
| Variable_name: slave_transaction_retries | |
| Value: 10 | |
| *************************** 369. row *************************** | |
| Variable_name: slave_type_conversions | |
| Value: | |
| *************************** 370. row *************************** | |
| Variable_name: slow_launch_time | |
| Value: 2 | |
| *************************** 371. row *************************** | |
| Variable_name: slow_query_log | |
| Value: OFF | |
| *************************** 372. row *************************** | |
| Variable_name: slow_query_log_file | |
| Value: cernzbxdb202-slow.log | |
| *************************** 373. row *************************** | |
| Variable_name: socket | |
| Value: /var/lib/mysql/mysql.sock | |
| *************************** 374. row *************************** | |
| Variable_name: sort_buffer_size | |
| Value: 1048576 | |
| *************************** 375. row *************************** | |
| Variable_name: sql_auto_is_null | |
| Value: OFF | |
| *************************** 376. row *************************** | |
| Variable_name: sql_big_selects | |
| Value: ON | |
| *************************** 377. row *************************** | |
| Variable_name: sql_big_tables | |
| Value: OFF | |
| *************************** 378. row *************************** | |
| Variable_name: sql_buffer_result | |
| Value: OFF | |
| *************************** 379. row *************************** | |
| Variable_name: sql_log_bin | |
| Value: ON | |
| *************************** 380. row *************************** | |
| Variable_name: sql_log_off | |
| Value: OFF | |
| *************************** 381. row *************************** | |
| Variable_name: sql_low_priority_updates | |
| Value: OFF | |
| *************************** 382. row *************************** | |
| Variable_name: sql_max_join_size | |
| Value: 18446744073709551615 | |
| *************************** 383. row *************************** | |
| Variable_name: sql_mode | |
| Value: | |
| *************************** 384. row *************************** | |
| Variable_name: sql_notes | |
| Value: ON | |
| *************************** 385. row *************************** | |
| Variable_name: sql_quote_show_create | |
| Value: ON | |
| *************************** 386. row *************************** | |
| Variable_name: sql_safe_updates | |
| Value: OFF | |
| *************************** 387. row *************************** | |
| Variable_name: sql_select_limit | |
| Value: 18446744073709551615 | |
| *************************** 388. row *************************** | |
| Variable_name: sql_slave_skip_counter | |
| Value: 0 | |
| *************************** 389. row *************************** | |
| Variable_name: sql_warnings | |
| Value: OFF | |
| *************************** 390. row *************************** | |
| Variable_name: ssl_ca | |
| Value: | |
| *************************** 391. row *************************** | |
| Variable_name: ssl_capath | |
| Value: | |
| *************************** 392. row *************************** | |
| Variable_name: ssl_cert | |
| Value: | |
| *************************** 393. row *************************** | |
| Variable_name: ssl_cipher | |
| Value: | |
| *************************** 394. row *************************** | |
| Variable_name: ssl_key | |
| Value: | |
| *************************** 395. row *************************** | |
| Variable_name: storage_engine | |
| Value: InnoDB | |
| *************************** 396. row *************************** | |
| Variable_name: stored_program_cache | |
| Value: 256 | |
| *************************** 397. row *************************** | |
| Variable_name: sync_binlog | |
| Value: 0 | |
| *************************** 398. row *************************** | |
| Variable_name: sync_frm | |
| Value: ON | |
| *************************** 399. row *************************** | |
| Variable_name: sync_master_info | |
| Value: 0 | |
| *************************** 400. row *************************** | |
| Variable_name: sync_relay_log | |
| Value: 0 | |
| *************************** 401. row *************************** | |
| Variable_name: sync_relay_log_info | |
| Value: 0 | |
| *************************** 402. row *************************** | |
| Variable_name: system_time_zone | |
| Value: CST | |
| *************************** 403. row *************************** | |
| Variable_name: table_definition_cache | |
| Value: 400 | |
| *************************** 404. row *************************** | |
| Variable_name: table_open_cache | |
| Value: 4096 | |
| *************************** 405. row *************************** | |
| Variable_name: thread_cache_size | |
| Value: 512 | |
| *************************** 406. row *************************** | |
| Variable_name: thread_concurrency | |
| Value: 24 | |
| *************************** 407. row *************************** | |
| Variable_name: thread_handling | |
| Value: one-thread-per-connection | |
| *************************** 408. row *************************** | |
| Variable_name: thread_pool_idle_timeout | |
| Value: 60 | |
| *************************** 409. row *************************** | |
| Variable_name: thread_pool_max_threads | |
| Value: 500 | |
| *************************** 410. row *************************** | |
| Variable_name: thread_pool_oversubscribe | |
| Value: 3 | |
| *************************** 411. row *************************** | |
| Variable_name: thread_pool_size | |
| Value: 32 | |
| *************************** 412. row *************************** | |
| Variable_name: thread_pool_stall_limit | |
| Value: 500 | |
| *************************** 413. row *************************** | |
| Variable_name: thread_stack | |
| Value: 294912 | |
| *************************** 414. row *************************** | |
| Variable_name: time_format | |
| Value: %H:%i:%s | |
| *************************** 415. row *************************** | |
| Variable_name: time_zone | |
| Value: SYSTEM | |
| *************************** 416. row *************************** | |
| Variable_name: timed_mutexes | |
| Value: OFF | |
| *************************** 417. row *************************** | |
| Variable_name: timestamp | |
| Value: 1479663992.292513 | |
| *************************** 418. row *************************** | |
| Variable_name: tmp_table_size | |
| Value: 1073741824 | |
| *************************** 419. row *************************** | |
| Variable_name: tmpdir | |
| Value: /dev/shm | |
| *************************** 420. row *************************** | |
| Variable_name: transaction_alloc_block_size | |
| Value: 8192 | |
| *************************** 421. row *************************** | |
| Variable_name: transaction_prealloc_size | |
| Value: 4096 | |
| *************************** 422. row *************************** | |
| Variable_name: tx_isolation | |
| Value: REPEATABLE-READ | |
| *************************** 423. row *************************** | |
| Variable_name: unique_checks | |
| Value: ON | |
| *************************** 424. row *************************** | |
| Variable_name: updatable_views_with_limit | |
| Value: YES | |
| *************************** 425. row *************************** | |
| Variable_name: userstat | |
| Value: OFF | |
| *************************** 426. row *************************** | |
| Variable_name: version | |
| Value: 5.5.38-MariaDB-wsrep-log | |
| *************************** 427. row *************************** | |
| Variable_name: version_comment | |
| Value: MariaDB Server, wsrep_25.10.r3997 | |
| *************************** 428. row *************************** | |
| Variable_name: version_compile_machine | |
| Value: x86_64 | |
| *************************** 429. row *************************** | |
| Variable_name: version_compile_os | |
| Value: Linux | |
| *************************** 430. row *************************** | |
| Variable_name: wait_timeout | |
| Value: 28800 | |
| *************************** 431. row *************************** | |
| Variable_name: warning_count | |
| Value: 0 | |
| *************************** 432. row *************************** | |
| Variable_name: wsrep_OSU_method | |
| Value: TOI | |
| *************************** 433. row *************************** | |
| Variable_name: wsrep_auto_increment_control | |
| Value: ON | |
| *************************** 434. row *************************** | |
| Variable_name: wsrep_causal_reads | |
| Value: OFF | |
| *************************** 435. row *************************** | |
| Variable_name: wsrep_certify_nonPK | |
| Value: ON | |
| *************************** 436. row *************************** | |
| Variable_name: wsrep_cluster_address | |
| Value: gcomm:// | |
| *************************** 437. row *************************** | |
| Variable_name: wsrep_cluster_name | |
| Value: galera_cluster | |
| *************************** 438. row *************************** | |
| Variable_name: wsrep_convert_LOCK_to_trx | |
| Value: OFF | |
| *************************** 439. row *************************** | |
| Variable_name: wsrep_data_home_dir | |
| Value: /var/lib/mysql/ | |
| *************************** 440. row *************************** | |
| Variable_name: wsrep_dbug_option | |
| Value: | |
| *************************** 441. row *************************** | |
| Variable_name: wsrep_debug | |
| Value: OFF | |
| *************************** 442. row *************************** | |
| Variable_name: wsrep_desync | |
| Value: OFF | |
| *************************** 443. row *************************** | |
| Variable_name: wsrep_drupal_282555_workaround | |
| Value: OFF | |
| *************************** 444. row *************************** | |
| Variable_name: wsrep_forced_binlog_format | |
| Value: NONE | |
| *************************** 445. row *************************** | |
| Variable_name: wsrep_load_data_splitting | |
| Value: ON | |
| *************************** 446. row *************************** | |
| Variable_name: wsrep_log_conflicts | |
| Value: OFF | |
| *************************** 447. row *************************** | |
| Variable_name: wsrep_max_ws_rows | |
| Value: 131072 | |
| *************************** 448. row *************************** | |
| Variable_name: wsrep_max_ws_size | |
| Value: 1073741824 | |
| *************************** 449. row *************************** | |
| Variable_name: wsrep_mysql_replication_bundle | |
| Value: 0 | |
| *************************** 450. row *************************** | |
| Variable_name: wsrep_node_address | |
| Value: | |
| *************************** 451. row *************************** | |
| Variable_name: wsrep_node_incoming_address | |
| Value: AUTO | |
| *************************** 452. row *************************** | |
| Variable_name: wsrep_node_name | |
| Value: ********** | |
| *************************** 453. row *************************** | |
| Variable_name: wsrep_notify_cmd | |
| Value: | |
| *************************** 454. row *************************** | |
| Variable_name: wsrep_on | |
| Value: ON | |
| *************************** 455. row *************************** | |
| Variable_name: wsrep_provider | |
| Value: /usr/lib64/galera/libgalera_smm.so | |
| *************************** 456. row *************************** | |
| Variable_name: wsrep_provider_options | |
| Value: base_host = 170.71.77.90; base_port = 4567; cert.log_conflicts = no; debug = no; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT15S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 1; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.use_aggregate = true; evs.user_send_window = 2; evs.version = 0; evs.view_forget_timeout = P1D; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 1G; gcache.size = 4G; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.listen_addr = tcp://0.0.0.0:4567; gmcast.mcast_addr = ; gmcast.mcast_ttl = 1; gmcast.peer_timeout = PT3S; gmcast.segment = 0; gmcast.time_wait = PT5S; gmcast.version = 0; ist.recv_addr = 170.71.77.90; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = P30S; pc.weight = 1; protonet.backend = asio; protonet.version = 0; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.max_ws_size = 2147483647; repl.proto_max = 5; socket.checksum = 2; | |
| *************************** 457. row *************************** | |
| Variable_name: wsrep_recover | |
| Value: OFF | |
| *************************** 458. row *************************** | |
| Variable_name: wsrep_replicate_myisam | |
| Value: OFF | |
| *************************** 459. row *************************** | |
| Variable_name: wsrep_restart_slave | |
| Value: OFF | |
| *************************** 460. row *************************** | |
| Variable_name: wsrep_retry_autocommit | |
| Value: 1 | |
| *************************** 461. row *************************** | |
| Variable_name: wsrep_slave_threads | |
| Value: 64 | |
| *************************** 462. row *************************** | |
| Variable_name: wsrep_sst_auth | |
| Value: ******** | |
| *************************** 463. row *************************** | |
| Variable_name: wsrep_sst_donor | |
| Value: | |
| *************************** 464. row *************************** | |
| Variable_name: wsrep_sst_donor_rejects_queries | |
| Value: OFF | |
| *************************** 465. row *************************** | |
| Variable_name: wsrep_sst_method | |
| Value: xtrabackup-v2 | |
| *************************** 466. row *************************** | |
| Variable_name: wsrep_sst_receive_address | |
| Value: AUTO | |
| *************************** 467. row *************************** | |
| Variable_name: wsrep_start_position | |
| Value: 3bf24a64-e806-11e5-8238-ea129650fffe:4122075810 | |
| 467 rows in set (0.01 sec) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment