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_encrypt_tables Value: OFF *************************** 5. row *************************** Variable_name: aria_force_start_after_recovery_failures Value: 0 *************************** 6. row *************************** Variable_name: aria_group_commit Value: none *************************** 7. row *************************** Variable_name: aria_group_commit_interval Value: 0 *************************** 8. row *************************** Variable_name: aria_log_file_size Value: 1073741824 *************************** 9. row *************************** Variable_name: aria_log_purge_type Value: immediate *************************** 10. row *************************** Variable_name: aria_max_sort_file_size Value: 9223372036853727232 *************************** 11. row *************************** Variable_name: aria_page_checksum Value: ON *************************** 12. row *************************** Variable_name: aria_pagecache_age_threshold Value: 300 *************************** 13. row *************************** Variable_name: aria_pagecache_buffer_size Value: 134217728 *************************** 14. row *************************** Variable_name: aria_pagecache_division_limit Value: 100 *************************** 15. row *************************** Variable_name: aria_pagecache_file_hash_size Value: 512 *************************** 16. row *************************** Variable_name: aria_recover_options Value: BACKUP,QUICK *************************** 17. row *************************** Variable_name: aria_repair_threads Value: 1 *************************** 18. row *************************** Variable_name: aria_sort_buffer_size Value: 268434432 *************************** 19. row *************************** Variable_name: aria_stats_method Value: nulls_unequal *************************** 20. row *************************** Variable_name: aria_sync_log_dir Value: NEWFILE *************************** 21. row *************************** Variable_name: aria_used_for_temp_tables Value: ON *************************** 22. row *************************** Variable_name: auto_increment_increment Value: 3 *************************** 23. row *************************** Variable_name: auto_increment_offset Value: 1 *************************** 24. row *************************** Variable_name: autocommit Value: ON *************************** 25. row *************************** Variable_name: automatic_sp_privileges Value: ON *************************** 26. row *************************** Variable_name: back_log Value: 90 *************************** 27. row *************************** Variable_name: basedir Value: /usr *************************** 28. row *************************** Variable_name: big_tables Value: OFF *************************** 29. row *************************** Variable_name: binlog_annotate_row_events Value: ON *************************** 30. row *************************** Variable_name: binlog_cache_size Value: 32768 *************************** 31. row *************************** Variable_name: binlog_checksum Value: CRC32 *************************** 32. row *************************** Variable_name: binlog_commit_wait_count Value: 0 *************************** 33. row *************************** Variable_name: binlog_commit_wait_usec Value: 100000 *************************** 34. row *************************** Variable_name: binlog_direct_non_transactional_updates Value: OFF *************************** 35. row *************************** Variable_name: binlog_format Value: ROW *************************** 36. row *************************** Variable_name: binlog_optimize_thread_scheduling Value: ON *************************** 37. row *************************** Variable_name: binlog_row_image Value: FULL *************************** 38. row *************************** Variable_name: binlog_stmt_cache_size Value: 32768 *************************** 39. row *************************** Variable_name: bulk_insert_buffer_size Value: 8388608 *************************** 40. row *************************** Variable_name: character_set_client Value: utf8 *************************** 41. row *************************** Variable_name: character_set_connection Value: utf8 *************************** 42. row *************************** Variable_name: character_set_database Value: latin1 *************************** 43. row *************************** Variable_name: character_set_filesystem Value: binary *************************** 44. row *************************** Variable_name: character_set_results Value: utf8 *************************** 45. row *************************** Variable_name: character_set_server Value: latin1 *************************** 46. row *************************** Variable_name: character_set_system Value: utf8 *************************** 47. row *************************** Variable_name: character_sets_dir Value: /usr/share/mysql/charsets/ *************************** 48. row *************************** Variable_name: check_constraint_checks Value: ON *************************** 49. row *************************** Variable_name: collation_connection Value: utf8_general_ci *************************** 50. row *************************** Variable_name: collation_database Value: latin1_swedish_ci *************************** 51. row *************************** Variable_name: collation_server Value: latin1_swedish_ci *************************** 52. row *************************** Variable_name: completion_type Value: NO_CHAIN *************************** 53. row *************************** Variable_name: concurrent_insert Value: AUTO *************************** 54. row *************************** Variable_name: connect_timeout Value: 10 *************************** 55. row *************************** Variable_name: core_file Value: OFF *************************** 56. row *************************** Variable_name: datadir Value: /var/lib/mysql/ *************************** 57. row *************************** Variable_name: date_format Value: %Y-%m-%d *************************** 58. row *************************** Variable_name: datetime_format Value: %Y-%m-%d %H:%i:%s *************************** 59. row *************************** Variable_name: deadlock_search_depth_long Value: 15 *************************** 60. row *************************** Variable_name: deadlock_search_depth_short Value: 4 *************************** 61. row *************************** Variable_name: deadlock_timeout_long Value: 50000000 *************************** 62. row *************************** Variable_name: deadlock_timeout_short Value: 10000 *************************** 63. row *************************** Variable_name: debug_no_thread_alarm Value: OFF *************************** 64. row *************************** Variable_name: default_master_connection Value: *************************** 65. row *************************** Variable_name: default_regex_flags Value: *************************** 66. row *************************** Variable_name: default_storage_engine Value: InnoDB *************************** 67. row *************************** Variable_name: default_tmp_storage_engine Value: *************************** 68. row *************************** Variable_name: default_week_format Value: 0 *************************** 69. row *************************** Variable_name: delay_key_write Value: ON *************************** 70. row *************************** Variable_name: delayed_insert_limit Value: 100 *************************** 71. row *************************** Variable_name: delayed_insert_timeout Value: 300 *************************** 72. row *************************** Variable_name: delayed_queue_size Value: 1000 *************************** 73. row *************************** Variable_name: div_precision_increment Value: 4 *************************** 74. row *************************** Variable_name: encrypt_binlog Value: OFF *************************** 75. row *************************** Variable_name: encrypt_tmp_disk_tables Value: OFF *************************** 76. row *************************** Variable_name: encrypt_tmp_files Value: OFF *************************** 77. row *************************** Variable_name: enforce_storage_engine Value: InnoDB *************************** 78. row *************************** Variable_name: eq_range_index_dive_limit Value: 0 *************************** 79. row *************************** Variable_name: error_count Value: 0 *************************** 80. row *************************** Variable_name: event_scheduler Value: OFF *************************** 81. row *************************** Variable_name: expensive_subquery_limit Value: 100 *************************** 82. row *************************** Variable_name: expire_logs_days Value: 10 *************************** 83. row *************************** Variable_name: explicit_defaults_for_timestamp Value: OFF *************************** 84. row *************************** Variable_name: external_user Value: *************************** 85. row *************************** Variable_name: extra_max_connections Value: 1 *************************** 86. row *************************** Variable_name: extra_port Value: 0 *************************** 87. row *************************** Variable_name: flush Value: OFF *************************** 88. row *************************** Variable_name: flush_time Value: 0 *************************** 89. row *************************** Variable_name: foreign_key_checks Value: ON *************************** 90. row *************************** Variable_name: ft_boolean_syntax Value: + -><()~*:""&| *************************** 91. row *************************** Variable_name: ft_max_word_len Value: 84 *************************** 92. row *************************** Variable_name: ft_min_word_len Value: 4 *************************** 93. row *************************** Variable_name: ft_query_expansion_limit Value: 20 *************************** 94. row *************************** Variable_name: ft_stopword_file Value: (built-in) *************************** 95. row *************************** Variable_name: general_log Value: OFF *************************** 96. row *************************** Variable_name: general_log_file Value: n02c01.log *************************** 97. row *************************** Variable_name: group_concat_max_len Value: 1048576 *************************** 98. row *************************** Variable_name: gtid_binlog_pos Value: *************************** 99. row *************************** Variable_name: gtid_binlog_state Value: *************************** 100. row *************************** Variable_name: gtid_current_pos Value: *************************** 101. row *************************** Variable_name: gtid_domain_id Value: 0 *************************** 102. row *************************** Variable_name: gtid_ignore_duplicates Value: OFF *************************** 103. row *************************** Variable_name: gtid_seq_no Value: 0 *************************** 104. row *************************** Variable_name: gtid_slave_pos Value: *************************** 105. row *************************** Variable_name: gtid_strict_mode Value: OFF *************************** 106. row *************************** Variable_name: have_compress Value: YES *************************** 107. row *************************** Variable_name: have_crypt Value: YES *************************** 108. row *************************** Variable_name: have_dynamic_loading Value: YES *************************** 109. row *************************** Variable_name: have_geometry Value: YES *************************** 110. row *************************** Variable_name: have_openssl Value: YES *************************** 111. row *************************** Variable_name: have_profiling Value: YES *************************** 112. row *************************** Variable_name: have_query_cache Value: YES *************************** 113. row *************************** Variable_name: have_rtree_keys Value: YES *************************** 114. row *************************** Variable_name: have_ssl Value: DISABLED *************************** 115. row *************************** Variable_name: have_symlink Value: YES *************************** 116. row *************************** Variable_name: histogram_size Value: 0 *************************** 117. row *************************** Variable_name: histogram_type Value: SINGLE_PREC_HB *************************** 118. row *************************** Variable_name: host_cache_size Value: 328 *************************** 119. row *************************** Variable_name: hostname Value: n02c01 *************************** 120. row *************************** Variable_name: identity Value: 0 *************************** 121. row *************************** Variable_name: ignore_builtin_innodb Value: OFF *************************** 122. row *************************** Variable_name: ignore_db_dirs Value: *************************** 123. row *************************** Variable_name: in_transaction Value: 0 *************************** 124. row *************************** Variable_name: init_connect Value: *************************** 125. row *************************** Variable_name: init_file Value: *************************** 126. row *************************** Variable_name: init_slave Value: *************************** 127. row *************************** Variable_name: innodb_adaptive_flushing Value: ON *************************** 128. row *************************** Variable_name: innodb_adaptive_flushing_lwm Value: 10.000000 *************************** 129. row *************************** Variable_name: innodb_adaptive_hash_index Value: ON *************************** 130. row *************************** Variable_name: innodb_adaptive_hash_index_partitions Value: 8 *************************** 131. row *************************** Variable_name: innodb_adaptive_hash_index_parts Value: 8 *************************** 132. row *************************** Variable_name: innodb_adaptive_max_sleep_delay Value: 150000 *************************** 133. row *************************** Variable_name: innodb_autoextend_increment Value: 64 *************************** 134. row *************************** Variable_name: innodb_autoinc_lock_mode Value: 2 *************************** 135. row *************************** Variable_name: innodb_background_scrub_data_check_interval Value: 3600 *************************** 136. row *************************** Variable_name: innodb_background_scrub_data_compressed Value: OFF *************************** 137. row *************************** Variable_name: innodb_background_scrub_data_interval Value: 604800 *************************** 138. row *************************** Variable_name: innodb_background_scrub_data_uncompressed Value: OFF *************************** 139. row *************************** Variable_name: innodb_buf_dump_status_frequency Value: 0 *************************** 140. row *************************** Variable_name: innodb_buffer_pool_chunk_size Value: 134217728 *************************** 141. row *************************** Variable_name: innodb_buffer_pool_dump_at_shutdown Value: ON *************************** 142. row *************************** Variable_name: innodb_buffer_pool_dump_now Value: OFF *************************** 143. row *************************** Variable_name: innodb_buffer_pool_dump_pct Value: 25 *************************** 144. row *************************** Variable_name: innodb_buffer_pool_filename Value: ib_buffer_pool *************************** 145. row *************************** Variable_name: innodb_buffer_pool_instances Value: 3 *************************** 146. row *************************** Variable_name: innodb_buffer_pool_load_abort Value: OFF *************************** 147. row *************************** Variable_name: innodb_buffer_pool_load_at_startup Value: ON *************************** 148. row *************************** Variable_name: innodb_buffer_pool_load_now Value: OFF *************************** 149. row *************************** Variable_name: innodb_buffer_pool_populate Value: OFF *************************** 150. row *************************** Variable_name: innodb_buffer_pool_size Value: 4429185024 *************************** 151. row *************************** Variable_name: innodb_change_buffer_max_size Value: 25 *************************** 152. row *************************** Variable_name: innodb_change_buffering Value: all *************************** 153. row *************************** Variable_name: innodb_checksum_algorithm Value: crc32 *************************** 154. row *************************** Variable_name: innodb_checksums Value: ON *************************** 155. row *************************** Variable_name: innodb_cleaner_lsn_age_factor Value: DEPRECATED *************************** 156. row *************************** Variable_name: innodb_cmp_per_index_enabled Value: OFF *************************** 157. row *************************** Variable_name: innodb_commit_concurrency Value: 0 *************************** 158. row *************************** Variable_name: innodb_compression_algorithm Value: zlib *************************** 159. row *************************** Variable_name: innodb_compression_default Value: OFF *************************** 160. row *************************** Variable_name: innodb_compression_failure_threshold_pct Value: 5 *************************** 161. row *************************** Variable_name: innodb_compression_level Value: 6 *************************** 162. row *************************** Variable_name: innodb_compression_pad_pct_max Value: 50 *************************** 163. row *************************** Variable_name: innodb_concurrency_tickets Value: 5000 *************************** 164. row *************************** Variable_name: innodb_corrupt_table_action Value: deprecated *************************** 165. row *************************** Variable_name: innodb_data_file_path Value: ibdata1:12M:autoextend *************************** 166. row *************************** Variable_name: innodb_data_home_dir Value: *************************** 167. row *************************** Variable_name: innodb_deadlock_detect Value: ON *************************** 168. row *************************** Variable_name: innodb_default_encryption_key_id Value: 1 *************************** 169. row *************************** Variable_name: innodb_default_row_format Value: dynamic *************************** 170. row *************************** Variable_name: innodb_defragment Value: OFF *************************** 171. row *************************** Variable_name: innodb_defragment_fill_factor Value: 0.900000 *************************** 172. row *************************** Variable_name: innodb_defragment_fill_factor_n_recs Value: 20 *************************** 173. row *************************** Variable_name: innodb_defragment_frequency Value: 40 *************************** 174. row *************************** Variable_name: innodb_defragment_n_pages Value: 7 *************************** 175. row *************************** Variable_name: innodb_defragment_stats_accuracy Value: 0 *************************** 176. row *************************** Variable_name: innodb_disable_sort_file_cache Value: OFF *************************** 177. row *************************** Variable_name: innodb_disallow_writes Value: OFF *************************** 178. row *************************** Variable_name: innodb_doublewrite Value: ON *************************** 179. row *************************** Variable_name: innodb_empty_free_list_algorithm Value: DEPRECATED *************************** 180. row *************************** Variable_name: innodb_encrypt_log Value: OFF *************************** 181. row *************************** Variable_name: innodb_encrypt_tables Value: OFF *************************** 182. row *************************** Variable_name: innodb_encryption_rotate_key_age Value: 1 *************************** 183. row *************************** Variable_name: innodb_encryption_rotation_iops Value: 100 *************************** 184. row *************************** Variable_name: innodb_encryption_threads Value: 0 *************************** 185. row *************************** Variable_name: innodb_fake_changes Value: OFF *************************** 186. row *************************** Variable_name: innodb_fast_shutdown Value: 1 *************************** 187. row *************************** Variable_name: innodb_fatal_semaphore_wait_threshold Value: 600 *************************** 188. row *************************** Variable_name: innodb_file_format Value: Barracuda *************************** 189. row *************************** Variable_name: innodb_file_format_check Value: ON *************************** 190. row *************************** Variable_name: innodb_file_format_max Value: Barracuda *************************** 191. row *************************** Variable_name: innodb_file_per_table Value: ON *************************** 192. row *************************** Variable_name: innodb_fill_factor Value: 100 *************************** 193. row *************************** Variable_name: innodb_flush_log_at_timeout Value: 1 *************************** 194. row *************************** Variable_name: innodb_flush_log_at_trx_commit Value: 0 *************************** 195. row *************************** Variable_name: innodb_flush_method Value: O_DIRECT *************************** 196. row *************************** Variable_name: innodb_flush_neighbors Value: 1 *************************** 197. row *************************** Variable_name: innodb_flush_sync Value: ON *************************** 198. row *************************** Variable_name: innodb_flushing_avg_loops Value: 30 *************************** 199. row *************************** Variable_name: innodb_force_load_corrupted Value: OFF *************************** 200. row *************************** Variable_name: innodb_force_primary_key Value: OFF *************************** 201. row *************************** Variable_name: innodb_force_recovery Value: 0 *************************** 202. row *************************** Variable_name: innodb_foreground_preflush Value: DEPRECATED *************************** 203. row *************************** Variable_name: innodb_ft_aux_table Value: *************************** 204. row *************************** Variable_name: innodb_ft_cache_size Value: 8000000 *************************** 205. row *************************** Variable_name: innodb_ft_enable_diag_print Value: OFF *************************** 206. row *************************** Variable_name: innodb_ft_enable_stopword Value: ON *************************** 207. row *************************** Variable_name: innodb_ft_max_token_size Value: 84 *************************** 208. row *************************** Variable_name: innodb_ft_min_token_size Value: 3 *************************** 209. row *************************** Variable_name: innodb_ft_num_word_optimize Value: 2000 *************************** 210. row *************************** Variable_name: innodb_ft_result_cache_limit Value: 2000000000 *************************** 211. row *************************** Variable_name: innodb_ft_server_stopword_table Value: *************************** 212. row *************************** Variable_name: innodb_ft_sort_pll_degree Value: 2 *************************** 213. row *************************** Variable_name: innodb_ft_total_cache_size Value: 640000000 *************************** 214. row *************************** Variable_name: innodb_ft_user_stopword_table Value: *************************** 215. row *************************** Variable_name: innodb_idle_flush_pct Value: 100 *************************** 216. row *************************** Variable_name: innodb_immediate_scrub_data_uncompressed Value: OFF *************************** 217. row *************************** Variable_name: innodb_instrument_semaphores Value: OFF *************************** 218. row *************************** Variable_name: innodb_io_capacity Value: 4000 *************************** 219. row *************************** Variable_name: innodb_io_capacity_max Value: 8000 *************************** 220. row *************************** Variable_name: innodb_kill_idle_transaction Value: 0 *************************** 221. row *************************** Variable_name: innodb_large_prefix Value: ON *************************** 222. row *************************** Variable_name: innodb_lock_schedule_algorithm Value: fcfs *************************** 223. row *************************** Variable_name: innodb_lock_wait_timeout Value: 50 *************************** 224. row *************************** Variable_name: innodb_locking_fake_changes Value: OFF *************************** 225. row *************************** Variable_name: innodb_locks_unsafe_for_binlog Value: OFF *************************** 226. row *************************** Variable_name: innodb_log_arch_dir Value: *************************** 227. row *************************** Variable_name: innodb_log_arch_expire_sec Value: 0 *************************** 228. row *************************** Variable_name: innodb_log_archive Value: OFF *************************** 229. row *************************** Variable_name: innodb_log_block_size Value: 0 *************************** 230. row *************************** Variable_name: innodb_log_buffer_size Value: 16777216 *************************** 231. row *************************** Variable_name: innodb_log_checksum_algorithm Value: DEPRECATED *************************** 232. row *************************** Variable_name: innodb_log_checksums Value: ON *************************** 233. row *************************** Variable_name: innodb_log_compressed_pages Value: ON *************************** 234. row *************************** Variable_name: innodb_log_file_size Value: 536870912 *************************** 235. row *************************** Variable_name: innodb_log_files_in_group Value: 2 *************************** 236. row *************************** Variable_name: innodb_log_group_home_dir Value: ./ *************************** 237. row *************************** Variable_name: innodb_log_optimize_ddl Value: ON *************************** 238. row *************************** Variable_name: innodb_log_write_ahead_size Value: 8192 *************************** 239. row *************************** Variable_name: innodb_lru_scan_depth Value: 1024 *************************** 240. row *************************** Variable_name: innodb_max_bitmap_file_size Value: 0 *************************** 241. row *************************** Variable_name: innodb_max_changed_pages Value: 0 *************************** 242. row *************************** Variable_name: innodb_max_dirty_pages_pct Value: 75.000000 *************************** 243. row *************************** Variable_name: innodb_max_dirty_pages_pct_lwm Value: 0.000000 *************************** 244. row *************************** Variable_name: innodb_max_purge_lag Value: 0 *************************** 245. row *************************** Variable_name: innodb_max_purge_lag_delay Value: 0 *************************** 246. row *************************** Variable_name: innodb_max_undo_log_size Value: 10485760 *************************** 247. row *************************** Variable_name: innodb_mirrored_log_groups Value: 0 *************************** 248. row *************************** Variable_name: innodb_monitor_disable Value: *************************** 249. row *************************** Variable_name: innodb_monitor_enable Value: *************************** 250. row *************************** Variable_name: innodb_monitor_reset Value: *************************** 251. row *************************** Variable_name: innodb_monitor_reset_all Value: *************************** 252. row *************************** Variable_name: innodb_mtflush_threads Value: 8 *************************** 253. row *************************** Variable_name: innodb_numa_interleave Value: OFF *************************** 254. row *************************** Variable_name: innodb_old_blocks_pct Value: 37 *************************** 255. row *************************** Variable_name: innodb_old_blocks_time Value: 1000 *************************** 256. row *************************** Variable_name: innodb_online_alter_log_max_size Value: 134217728 *************************** 257. row *************************** Variable_name: innodb_open_files Value: 2000 *************************** 258. row *************************** Variable_name: innodb_optimize_fulltext_only Value: OFF *************************** 259. row *************************** Variable_name: innodb_page_cleaners Value: 3 *************************** 260. row *************************** Variable_name: innodb_page_size Value: 16384 *************************** 261. row *************************** Variable_name: innodb_prefix_index_cluster_optimization Value: OFF *************************** 262. row *************************** Variable_name: innodb_print_all_deadlocks Value: ON *************************** 263. row *************************** Variable_name: innodb_purge_batch_size Value: 300 *************************** 264. row *************************** Variable_name: innodb_purge_rseg_truncate_frequency Value: 128 *************************** 265. row *************************** Variable_name: innodb_purge_threads Value: 4 *************************** 266. row *************************** Variable_name: innodb_random_read_ahead Value: OFF *************************** 267. row *************************** Variable_name: innodb_read_ahead_threshold Value: 56 *************************** 268. row *************************** Variable_name: innodb_read_io_threads Value: 4 *************************** 269. row *************************** Variable_name: innodb_read_only Value: OFF *************************** 270. row *************************** Variable_name: innodb_replication_delay Value: 0 *************************** 271. row *************************** Variable_name: innodb_rollback_on_timeout Value: OFF *************************** 272. row *************************** Variable_name: innodb_rollback_segments Value: 128 *************************** 273. row *************************** Variable_name: innodb_safe_truncate Value: ON *************************** 274. row *************************** Variable_name: innodb_sched_priority_cleaner Value: 0 *************************** 275. row *************************** Variable_name: innodb_scrub_log Value: OFF *************************** 276. row *************************** Variable_name: innodb_scrub_log_speed Value: 256 *************************** 277. row *************************** Variable_name: innodb_show_locks_held Value: 0 *************************** 278. row *************************** Variable_name: innodb_show_verbose_locks Value: 0 *************************** 279. row *************************** Variable_name: innodb_sort_buffer_size Value: 1048576 *************************** 280. row *************************** Variable_name: innodb_spin_wait_delay Value: 6 *************************** 281. row *************************** Variable_name: innodb_stats_auto_recalc Value: ON *************************** 282. row *************************** Variable_name: innodb_stats_include_delete_marked Value: OFF *************************** 283. row *************************** Variable_name: innodb_stats_method Value: nulls_equal *************************** 284. row *************************** Variable_name: innodb_stats_modified_counter Value: 0 *************************** 285. row *************************** Variable_name: innodb_stats_on_metadata Value: OFF *************************** 286. row *************************** Variable_name: innodb_stats_persistent Value: ON *************************** 287. row *************************** Variable_name: innodb_stats_persistent_sample_pages Value: 20 *************************** 288. row *************************** Variable_name: innodb_stats_sample_pages Value: 8 *************************** 289. row *************************** Variable_name: innodb_stats_traditional Value: ON *************************** 290. row *************************** Variable_name: innodb_stats_transient_sample_pages Value: 8 *************************** 291. row *************************** Variable_name: innodb_status_output Value: OFF *************************** 292. row *************************** Variable_name: innodb_status_output_locks Value: OFF *************************** 293. row *************************** Variable_name: innodb_strict_mode Value: ON *************************** 294. row *************************** Variable_name: innodb_support_xa Value: ON *************************** 295. row *************************** Variable_name: innodb_sync_array_size Value: 1 *************************** 296. row *************************** Variable_name: innodb_sync_spin_loops Value: 30 *************************** 297. row *************************** Variable_name: innodb_table_locks Value: ON *************************** 298. row *************************** Variable_name: innodb_temp_data_file_path Value: ibtmp1:12M:autoextend *************************** 299. row *************************** Variable_name: innodb_thread_concurrency Value: 0 *************************** 300. row *************************** Variable_name: innodb_thread_sleep_delay Value: 10000 *************************** 301. row *************************** Variable_name: innodb_tmpdir Value: *************************** 302. row *************************** Variable_name: innodb_track_changed_pages Value: OFF *************************** 303. row *************************** Variable_name: innodb_track_redo_log_now Value: OFF *************************** 304. row *************************** Variable_name: innodb_undo_directory Value: ./ *************************** 305. row *************************** Variable_name: innodb_undo_log_truncate Value: OFF *************************** 306. row *************************** Variable_name: innodb_undo_logs Value: 128 *************************** 307. row *************************** Variable_name: innodb_undo_tablespaces Value: 0 *************************** 308. row *************************** Variable_name: innodb_use_atomic_writes Value: ON *************************** 309. row *************************** Variable_name: innodb_use_fallocate Value: OFF *************************** 310. row *************************** Variable_name: innodb_use_global_flush_log_at_trx_commit Value: OFF *************************** 311. row *************************** Variable_name: innodb_use_mtflush Value: OFF *************************** 312. row *************************** Variable_name: innodb_use_native_aio Value: ON *************************** 313. row *************************** Variable_name: innodb_use_stacktrace Value: OFF *************************** 314. row *************************** Variable_name: innodb_use_trim Value: ON *************************** 315. row *************************** Variable_name: innodb_version Value: 5.7.24 *************************** 316. row *************************** Variable_name: innodb_write_io_threads Value: 4 *************************** 317. row *************************** Variable_name: insert_id Value: 0 *************************** 318. row *************************** Variable_name: interactive_timeout Value: 900 *************************** 319. row *************************** Variable_name: join_buffer_size Value: 262144 *************************** 320. row *************************** Variable_name: join_buffer_space_limit Value: 2097152 *************************** 321. row *************************** Variable_name: join_cache_level Value: 2 *************************** 322. row *************************** Variable_name: keep_files_on_create Value: OFF *************************** 323. row *************************** Variable_name: key_buffer_size Value: 268435456 *************************** 324. row *************************** Variable_name: key_cache_age_threshold Value: 300 *************************** 325. row *************************** Variable_name: key_cache_block_size Value: 1024 *************************** 326. row *************************** Variable_name: key_cache_division_limit Value: 100 *************************** 327. row *************************** Variable_name: key_cache_file_hash_size Value: 512 *************************** 328. row *************************** Variable_name: key_cache_segments Value: 0 *************************** 329. row *************************** Variable_name: large_files_support Value: ON *************************** 330. row *************************** Variable_name: large_page_size Value: 0 *************************** 331. row *************************** Variable_name: large_pages Value: OFF *************************** 332. row *************************** Variable_name: last_gtid Value: *************************** 333. row *************************** Variable_name: last_insert_id Value: 0 *************************** 334. row *************************** Variable_name: lc_messages Value: en_US *************************** 335. row *************************** Variable_name: lc_messages_dir Value: /usr/share/mysql *************************** 336. row *************************** Variable_name: lc_time_names Value: en_US *************************** 337. row *************************** Variable_name: license Value: GPL *************************** 338. row *************************** Variable_name: local_infile Value: ON *************************** 339. row *************************** Variable_name: lock_wait_timeout Value: 86400 *************************** 340. row *************************** Variable_name: locked_in_memory Value: OFF *************************** 341. row *************************** Variable_name: log_bin Value: OFF *************************** 342. row *************************** Variable_name: log_bin_basename Value: *************************** 343. row *************************** Variable_name: log_bin_compress Value: OFF *************************** 344. row *************************** Variable_name: log_bin_compress_min_len Value: 256 *************************** 345. row *************************** Variable_name: log_bin_index Value: *************************** 346. row *************************** Variable_name: log_bin_trust_function_creators Value: OFF *************************** 347. row *************************** Variable_name: log_error Value: *************************** 348. row *************************** Variable_name: log_output Value: FILE *************************** 349. row *************************** Variable_name: log_queries_not_using_indexes Value: OFF *************************** 350. row *************************** Variable_name: log_slave_updates Value: OFF *************************** 351. row *************************** Variable_name: log_slow_admin_statements Value: ON *************************** 352. 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 *************************** 353. row *************************** Variable_name: log_slow_rate_limit Value: 1 *************************** 354. row *************************** Variable_name: log_slow_slave_statements Value: ON *************************** 355. row *************************** Variable_name: log_slow_verbosity Value: *************************** 356. row *************************** Variable_name: log_tc_size Value: 24576 *************************** 357. row *************************** Variable_name: log_warnings Value: 2 *************************** 358. row *************************** Variable_name: long_query_time Value: 10.000000 *************************** 359. row *************************** Variable_name: low_priority_updates Value: OFF *************************** 360. row *************************** Variable_name: lower_case_file_system Value: OFF *************************** 361. row *************************** Variable_name: lower_case_table_names Value: 0 *************************** 362. row *************************** Variable_name: master_verify_checksum Value: OFF *************************** 363. row *************************** Variable_name: max_allowed_packet Value: 67108864 *************************** 364. row *************************** Variable_name: max_binlog_cache_size Value: 18446744073709547520 *************************** 365. row *************************** Variable_name: max_binlog_size Value: 104857600 *************************** 366. row *************************** Variable_name: max_binlog_stmt_cache_size Value: 18446744073709547520 *************************** 367. row *************************** Variable_name: max_connect_errors Value: 100 *************************** 368. row *************************** Variable_name: max_connections Value: 200 *************************** 369. row *************************** Variable_name: max_delayed_threads Value: 20 *************************** 370. row *************************** Variable_name: max_digest_length Value: 1024 *************************** 371. row *************************** Variable_name: max_error_count Value: 64 *************************** 372. row *************************** Variable_name: max_heap_table_size Value: 67108864 *************************** 373. row *************************** Variable_name: max_insert_delayed_threads Value: 20 *************************** 374. row *************************** Variable_name: max_join_size Value: 18446744073709551615 *************************** 375. row *************************** Variable_name: max_length_for_sort_data Value: 1024 *************************** 376. row *************************** Variable_name: max_long_data_size Value: 67108864 *************************** 377. row *************************** Variable_name: max_prepared_stmt_count Value: 16382 *************************** 378. row *************************** Variable_name: max_recursive_iterations Value: 4294967295 *************************** 379. row *************************** Variable_name: max_relay_log_size Value: 104857600 *************************** 380. row *************************** Variable_name: max_seeks_for_key Value: 4294967295 *************************** 381. row *************************** Variable_name: max_session_mem_used Value: 9223372036854775807 *************************** 382. row *************************** Variable_name: max_sort_length Value: 1024 *************************** 383. row *************************** Variable_name: max_sp_recursion_depth Value: 0 *************************** 384. row *************************** Variable_name: max_statement_time Value: 0.000000 *************************** 385. row *************************** Variable_name: max_tmp_tables Value: 32 *************************** 386. row *************************** Variable_name: max_user_connections Value: 0 *************************** 387. row *************************** Variable_name: max_write_lock_count Value: 4294967295 *************************** 388. row *************************** Variable_name: metadata_locks_cache_size Value: 1024 *************************** 389. row *************************** Variable_name: metadata_locks_hash_instances Value: 8 *************************** 390. row *************************** Variable_name: min_examined_row_limit Value: 0 *************************** 391. row *************************** Variable_name: mrr_buffer_size Value: 262144 *************************** 392. row *************************** Variable_name: multi_range_count Value: 256 *************************** 393. row *************************** Variable_name: myisam_block_size Value: 1024 *************************** 394. row *************************** Variable_name: myisam_data_pointer_size Value: 6 *************************** 395. row *************************** Variable_name: myisam_max_sort_file_size Value: 9223372036853727232 *************************** 396. row *************************** Variable_name: myisam_mmap_size Value: 18446744073709551615 *************************** 397. row *************************** Variable_name: myisam_recover_options Value: BACKUP,FORCE *************************** 398. row *************************** Variable_name: myisam_repair_threads Value: 1 *************************** 399. row *************************** Variable_name: myisam_sort_buffer_size Value: 33554432 *************************** 400. row *************************** Variable_name: myisam_stats_method Value: NULLS_UNEQUAL *************************** 401. row *************************** Variable_name: myisam_use_mmap Value: OFF *************************** 402. row *************************** Variable_name: mysql56_temporal_format Value: ON *************************** 403. row *************************** Variable_name: net_buffer_length Value: 16384 *************************** 404. row *************************** Variable_name: net_read_timeout Value: 30 *************************** 405. row *************************** Variable_name: net_retry_count Value: 10 *************************** 406. row *************************** Variable_name: net_write_timeout Value: 60 *************************** 407. row *************************** Variable_name: old Value: OFF *************************** 408. row *************************** Variable_name: old_alter_table Value: OFF *************************** 409. row *************************** Variable_name: old_mode Value: *************************** 410. row *************************** Variable_name: old_passwords Value: OFF *************************** 411. row *************************** Variable_name: open_files_limit Value: 65536 *************************** 412. row *************************** Variable_name: optimizer_prune_level Value: 1 *************************** 413. row *************************** Variable_name: optimizer_search_depth Value: 62 *************************** 414. row *************************** Variable_name: optimizer_selectivity_sampling_limit Value: 100 *************************** 415. 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=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on *************************** 416. row *************************** Variable_name: optimizer_use_condition_selectivity Value: 1 *************************** 417. row *************************** Variable_name: performance_schema Value: OFF *************************** 418. row *************************** Variable_name: performance_schema_accounts_size Value: -1 *************************** 419. row *************************** Variable_name: performance_schema_digests_size Value: -1 *************************** 420. row *************************** Variable_name: performance_schema_events_stages_history_long_size Value: -1 *************************** 421. row *************************** Variable_name: performance_schema_events_stages_history_size Value: -1 *************************** 422. row *************************** Variable_name: performance_schema_events_statements_history_long_size Value: -1 *************************** 423. row *************************** Variable_name: performance_schema_events_statements_history_size Value: -1 *************************** 424. row *************************** Variable_name: performance_schema_events_waits_history_long_size Value: -1 *************************** 425. row *************************** Variable_name: performance_schema_events_waits_history_size Value: -1 *************************** 426. row *************************** Variable_name: performance_schema_hosts_size Value: -1 *************************** 427. row *************************** Variable_name: performance_schema_max_cond_classes Value: 80 *************************** 428. row *************************** Variable_name: performance_schema_max_cond_instances Value: -1 *************************** 429. row *************************** Variable_name: performance_schema_max_digest_length Value: 1024 *************************** 430. row *************************** Variable_name: performance_schema_max_file_classes Value: 50 *************************** 431. row *************************** Variable_name: performance_schema_max_file_handles Value: 32768 *************************** 432. row *************************** Variable_name: performance_schema_max_file_instances Value: -1 *************************** 433. row *************************** Variable_name: performance_schema_max_mutex_classes Value: 200 *************************** 434. row *************************** Variable_name: performance_schema_max_mutex_instances Value: -1 *************************** 435. row *************************** Variable_name: performance_schema_max_rwlock_classes Value: 40 *************************** 436. row *************************** Variable_name: performance_schema_max_rwlock_instances Value: -1 *************************** 437. row *************************** Variable_name: performance_schema_max_socket_classes Value: 10 *************************** 438. row *************************** Variable_name: performance_schema_max_socket_instances Value: -1 *************************** 439. row *************************** Variable_name: performance_schema_max_stage_classes Value: 150 *************************** 440. row *************************** Variable_name: performance_schema_max_statement_classes Value: 188 *************************** 441. row *************************** Variable_name: performance_schema_max_table_handles Value: -1 *************************** 442. row *************************** Variable_name: performance_schema_max_table_instances Value: -1 *************************** 443. row *************************** Variable_name: performance_schema_max_thread_classes Value: 50 *************************** 444. row *************************** Variable_name: performance_schema_max_thread_instances Value: -1 *************************** 445. row *************************** Variable_name: performance_schema_session_connect_attrs_size Value: -1 *************************** 446. row *************************** Variable_name: performance_schema_setup_actors_size Value: 100 *************************** 447. row *************************** Variable_name: performance_schema_setup_objects_size Value: 100 *************************** 448. row *************************** Variable_name: performance_schema_users_size Value: -1 *************************** 449. row *************************** Variable_name: pid_file Value: /var/run/mysqld/mysqld.pid *************************** 450. row *************************** Variable_name: plugin_dir Value: /usr/lib/mysql/plugin/ *************************** 451. row *************************** Variable_name: plugin_maturity Value: unknown *************************** 452. row *************************** Variable_name: port Value: 3306 *************************** 453. row *************************** Variable_name: preload_buffer_size Value: 32768 *************************** 454. row *************************** Variable_name: profiling Value: OFF *************************** 455. row *************************** Variable_name: profiling_history_size Value: 15 *************************** 456. row *************************** Variable_name: progress_report_time Value: 5 *************************** 457. row *************************** Variable_name: protocol_version Value: 10 *************************** 458. row *************************** Variable_name: proxy_user Value: *************************** 459. row *************************** Variable_name: pseudo_slave_mode Value: OFF *************************** 460. row *************************** Variable_name: pseudo_thread_id Value: 910002 *************************** 461. row *************************** Variable_name: query_alloc_block_size Value: 16384 *************************** 462. row *************************** Variable_name: query_cache_limit Value: 1048576 *************************** 463. row *************************** Variable_name: query_cache_min_res_unit Value: 4096 *************************** 464. row *************************** Variable_name: query_cache_size Value: 134217728 *************************** 465. row *************************** Variable_name: query_cache_strip_comments Value: OFF *************************** 466. row *************************** Variable_name: query_cache_type Value: ON *************************** 467. row *************************** Variable_name: query_cache_wlock_invalidate Value: OFF *************************** 468. row *************************** Variable_name: query_prealloc_size Value: 24576 *************************** 469. row *************************** Variable_name: rand_seed1 Value: 139222311 *************************** 470. row *************************** Variable_name: rand_seed2 Value: 677350206 *************************** 471. row *************************** Variable_name: range_alloc_block_size Value: 4096 *************************** 472. row *************************** Variable_name: read_binlog_speed_limit Value: 0 *************************** 473. row *************************** Variable_name: read_buffer_size Value: 131072 *************************** 474. row *************************** Variable_name: read_only Value: OFF *************************** 475. row *************************** Variable_name: read_rnd_buffer_size Value: 262144 *************************** 476. row *************************** Variable_name: relay_log Value: *************************** 477. row *************************** Variable_name: relay_log_basename Value: *************************** 478. row *************************** Variable_name: relay_log_index Value: *************************** 479. row *************************** Variable_name: relay_log_info_file Value: relay-log.info *************************** 480. row *************************** Variable_name: relay_log_purge Value: ON *************************** 481. row *************************** Variable_name: relay_log_recovery Value: OFF *************************** 482. row *************************** Variable_name: relay_log_space_limit Value: 0 *************************** 483. row *************************** Variable_name: replicate_annotate_row_events Value: ON *************************** 484. row *************************** Variable_name: replicate_do_db Value: *************************** 485. row *************************** Variable_name: replicate_do_table Value: *************************** 486. row *************************** Variable_name: replicate_events_marked_for_skip Value: REPLICATE *************************** 487. row *************************** Variable_name: replicate_ignore_db Value: *************************** 488. row *************************** Variable_name: replicate_ignore_table Value: *************************** 489. row *************************** Variable_name: replicate_wild_do_table Value: *************************** 490. row *************************** Variable_name: replicate_wild_ignore_table Value: *************************** 491. row *************************** Variable_name: report_host Value: *************************** 492. row *************************** Variable_name: report_password Value: *************************** 493. row *************************** Variable_name: report_port Value: 3306 *************************** 494. row *************************** Variable_name: report_user Value: *************************** 495. row *************************** Variable_name: rowid_merge_buff_size Value: 8388608 *************************** 496. row *************************** Variable_name: secure_auth Value: ON *************************** 497. row *************************** Variable_name: secure_file_priv Value: *************************** 498. row *************************** Variable_name: server_id Value: 1 *************************** 499. row *************************** Variable_name: session_track_schema Value: ON *************************** 500. row *************************** Variable_name: session_track_state_change Value: OFF *************************** 501. row *************************** Variable_name: session_track_system_variables Value: *************************** 502. row *************************** Variable_name: session_track_transaction_info Value: OFF *************************** 503. row *************************** Variable_name: skip_external_locking Value: ON *************************** 504. row *************************** Variable_name: skip_name_resolve Value: ON *************************** 505. row *************************** Variable_name: skip_networking Value: OFF *************************** 506. row *************************** Variable_name: skip_parallel_replication Value: OFF *************************** 507. row *************************** Variable_name: skip_replication Value: OFF *************************** 508. row *************************** Variable_name: skip_show_database Value: OFF *************************** 509. row *************************** Variable_name: slave_compressed_protocol Value: OFF *************************** 510. row *************************** Variable_name: slave_ddl_exec_mode Value: IDEMPOTENT *************************** 511. row *************************** Variable_name: slave_domain_parallel_threads Value: 0 *************************** 512. row *************************** Variable_name: slave_exec_mode Value: STRICT *************************** 513. row *************************** Variable_name: slave_load_tmpdir Value: /tmp *************************** 514. row *************************** Variable_name: slave_max_allowed_packet Value: 1073741824 *************************** 515. row *************************** Variable_name: slave_net_timeout Value: 60 *************************** 516. row *************************** Variable_name: slave_parallel_max_queued Value: 131072 *************************** 517. row *************************** Variable_name: slave_parallel_mode Value: conservative *************************** 518. row *************************** Variable_name: slave_parallel_threads Value: 0 *************************** 519. row *************************** Variable_name: slave_parallel_workers Value: 0 *************************** 520. row *************************** Variable_name: slave_run_triggers_for_rbr Value: NO *************************** 521. row *************************** Variable_name: slave_skip_errors Value: OFF *************************** 522. row *************************** Variable_name: slave_sql_verify_checksum Value: ON *************************** 523. row *************************** Variable_name: slave_transaction_retries Value: 10 *************************** 524. row *************************** Variable_name: slave_type_conversions Value: *************************** 525. row *************************** Variable_name: slow_launch_time Value: 2 *************************** 526. row *************************** Variable_name: slow_query_log Value: OFF *************************** 527. row *************************** Variable_name: slow_query_log_file Value: n02c01-slow.log *************************** 528. row *************************** Variable_name: socket Value: /var/run/mysqld/mysqld.sock *************************** 529. row *************************** Variable_name: sort_buffer_size Value: 262144 *************************** 530. row *************************** Variable_name: sql_auto_is_null Value: OFF *************************** 531. row *************************** Variable_name: sql_big_selects Value: ON *************************** 532. row *************************** Variable_name: sql_buffer_result Value: OFF *************************** 533. row *************************** Variable_name: sql_log_bin Value: ON *************************** 534. row *************************** Variable_name: sql_log_off Value: OFF *************************** 535. row *************************** Variable_name: sql_mode Value: NO_AUTO_CREATE_USER *************************** 536. row *************************** Variable_name: sql_notes Value: ON *************************** 537. row *************************** Variable_name: sql_quote_show_create Value: ON *************************** 538. row *************************** Variable_name: sql_safe_updates Value: OFF *************************** 539. row *************************** Variable_name: sql_select_limit Value: 18446744073709551615 *************************** 540. row *************************** Variable_name: sql_slave_skip_counter Value: 0 *************************** 541. row *************************** Variable_name: sql_warnings Value: OFF *************************** 542. row *************************** Variable_name: ssl_ca Value: *************************** 543. row *************************** Variable_name: ssl_capath Value: *************************** 544. row *************************** Variable_name: ssl_cert Value: *************************** 545. row *************************** Variable_name: ssl_cipher Value: *************************** 546. row *************************** Variable_name: ssl_crl Value: *************************** 547. row *************************** Variable_name: ssl_crlpath Value: *************************** 548. row *************************** Variable_name: ssl_key Value: *************************** 549. row *************************** Variable_name: standard_compliant_cte Value: ON *************************** 550. row *************************** Variable_name: storage_engine Value: InnoDB *************************** 551. row *************************** Variable_name: stored_program_cache Value: 256 *************************** 552. row *************************** Variable_name: strict_password_validation Value: ON *************************** 553. row *************************** Variable_name: sync_binlog Value: 0 *************************** 554. row *************************** Variable_name: sync_frm Value: ON *************************** 555. row *************************** Variable_name: sync_master_info Value: 10000 *************************** 556. row *************************** Variable_name: sync_relay_log Value: 10000 *************************** 557. row *************************** Variable_name: sync_relay_log_info Value: 10000 *************************** 558. row *************************** Variable_name: system_time_zone Value: CET *************************** 559. row *************************** Variable_name: table_definition_cache Value: 400 *************************** 560. row *************************** Variable_name: table_open_cache Value: 2000 *************************** 561. row *************************** Variable_name: table_open_cache_instances Value: 8 *************************** 562. row *************************** Variable_name: thread_cache_size Value: 200 *************************** 563. row *************************** Variable_name: thread_concurrency Value: 10 *************************** 564. row *************************** Variable_name: thread_handling Value: one-thread-per-connection *************************** 565. row *************************** Variable_name: thread_pool_idle_timeout Value: 60 *************************** 566. row *************************** Variable_name: thread_pool_max_threads Value: 65536 *************************** 567. row *************************** Variable_name: thread_pool_oversubscribe Value: 3 *************************** 568. row *************************** Variable_name: thread_pool_prio_kickup_timer Value: 1000 *************************** 569. row *************************** Variable_name: thread_pool_priority Value: auto *************************** 570. row *************************** Variable_name: thread_pool_size Value: 4 *************************** 571. row *************************** Variable_name: thread_pool_stall_limit Value: 500 *************************** 572. row *************************** Variable_name: thread_stack Value: 196608 *************************** 573. row *************************** Variable_name: time_format Value: %H:%i:%s *************************** 574. row *************************** Variable_name: time_zone Value: SYSTEM *************************** 575. row *************************** Variable_name: timed_mutexes Value: OFF *************************** 576. row *************************** Variable_name: timestamp Value: 1547468610.846804 *************************** 577. row *************************** Variable_name: tmp_disk_table_size Value: 18446744073709551615 *************************** 578. row *************************** Variable_name: tmp_memory_table_size Value: 67108864 *************************** 579. row *************************** Variable_name: tmp_table_size Value: 67108864 *************************** 580. row *************************** Variable_name: tmpdir Value: /tmp *************************** 581. row *************************** Variable_name: transaction_alloc_block_size Value: 8192 *************************** 582. row *************************** Variable_name: transaction_prealloc_size Value: 4096 *************************** 583. row *************************** Variable_name: tx_isolation Value: REPEATABLE-READ *************************** 584. row *************************** Variable_name: tx_read_only Value: OFF *************************** 585. row *************************** Variable_name: unique_checks Value: ON *************************** 586. row *************************** Variable_name: updatable_views_with_limit Value: YES *************************** 587. row *************************** Variable_name: use_stat_tables Value: NEVER *************************** 588. row *************************** Variable_name: userstat Value: OFF *************************** 589. row *************************** Variable_name: version Value: 10.2.21-MariaDB-10.2.21+maria~jessie *************************** 590. row *************************** Variable_name: version_comment Value: mariadb.org binary distribution *************************** 591. row *************************** Variable_name: version_compile_machine Value: x86_64 *************************** 592. row *************************** Variable_name: version_compile_os Value: debian-linux-gnu *************************** 593. row *************************** Variable_name: version_malloc_library Value: system *************************** 594. row *************************** Variable_name: version_ssl_library Value: OpenSSL 1.0.1t 3 May 2016 *************************** 595. row *************************** Variable_name: wait_timeout Value: 900 *************************** 596. row *************************** Variable_name: warning_count Value: 0 *************************** 597. row *************************** Variable_name: wsrep_osu_method Value: TOI *************************** 598. row *************************** Variable_name: wsrep_auto_increment_control Value: ON *************************** 599. row *************************** Variable_name: wsrep_causal_reads Value: OFF *************************** 600. row *************************** Variable_name: wsrep_certify_nonpk Value: ON *************************** 601. row *************************** Variable_name: wsrep_cluster_address Value: gcomm:// *************************** 602. row *************************** Variable_name: wsrep_cluster_name Value: galera_cluster01 *************************** 603. row *************************** Variable_name: wsrep_convert_lock_to_trx Value: OFF *************************** 604. row *************************** Variable_name: wsrep_data_home_dir Value: /var/lib/mysql/ *************************** 605. row *************************** Variable_name: wsrep_dbug_option Value: *************************** 606. row *************************** Variable_name: wsrep_debug Value: OFF *************************** 607. row *************************** Variable_name: wsrep_desync Value: OFF *************************** 608. row *************************** Variable_name: wsrep_dirty_reads Value: OFF *************************** 609. row *************************** Variable_name: wsrep_drupal_282555_workaround Value: OFF *************************** 610. row *************************** Variable_name: wsrep_forced_binlog_format Value: NONE *************************** 611. row *************************** Variable_name: wsrep_gtid_domain_id Value: 0 *************************** 612. row *************************** Variable_name: wsrep_gtid_mode Value: OFF *************************** 613. row *************************** Variable_name: wsrep_load_data_splitting Value: ON *************************** 614. row *************************** Variable_name: wsrep_log_conflicts Value: OFF *************************** 615. row *************************** Variable_name: wsrep_max_ws_rows Value: 0 *************************** 616. row *************************** Variable_name: wsrep_max_ws_size Value: 2147483647 *************************** 617. row *************************** Variable_name: wsrep_mysql_replication_bundle Value: 0 *************************** 618. row *************************** Variable_name: wsrep_node_address Value: *************************** 619. row *************************** Variable_name: wsrep_node_incoming_address Value: AUTO *************************** 620. row *************************** Variable_name: wsrep_node_name Value: n02c01 *************************** 621. row *************************** Variable_name: wsrep_notify_cmd Value: *************************** 622. row *************************** Variable_name: wsrep_on Value: ON *************************** 623. row *************************** Variable_name: wsrep_patch_version Value: wsrep_25.23 *************************** 624. row *************************** Variable_name: wsrep_provider Value: /usr/lib/galera/libgalera_smm.so *************************** 625. row *************************** Variable_name: wsrep_provider_options Value: base_dir = /var/lib/mysql/; base_host = ; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.causal_keepalive_period = PT1S; evs.debug_log_mask = 0x1; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.info_log_mask = 0; evs.install_timeout = PT7.5S; evs.join_retrans_period = PT1S; evs.keepalive_period = PT1S; evs.max_install_timeouts = 3; 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 = 128M; gcache.recover = no; gcache.size = 5G; gcomm.thread_prio = ; 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 = ; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc.linger = PT20S; pc.npvo = false; pc.recovery = true; pc.version = 0; pc.wait_prim = true; pc.wait_prim_timeout = PT30S; 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 = 9; socket.checksum = 2; socket.recv_buf_size = 212992; *************************** 626. row *************************** Variable_name: wsrep_recover Value: OFF *************************** 627. row *************************** Variable_name: wsrep_reject_queries Value: NONE *************************** 628. row *************************** Variable_name: wsrep_replicate_myisam Value: OFF *************************** 629. row *************************** Variable_name: wsrep_restart_slave Value: OFF *************************** 630. row *************************** Variable_name: wsrep_retry_autocommit Value: 4 *************************** 631. row *************************** Variable_name: wsrep_slave_fk_checks Value: ON *************************** 632. row *************************** Variable_name: wsrep_slave_uk_checks Value: OFF *************************** 633. row *************************** Variable_name: wsrep_slave_threads Value: 8 *************************** 634. row *************************** Variable_name: wsrep_sst_auth Value: ******** *************************** 635. row *************************** Variable_name: wsrep_sst_donor Value: *************************** 636. row *************************** Variable_name: wsrep_sst_donor_rejects_queries Value: OFF *************************** 637. row *************************** Variable_name: wsrep_sst_method Value: mariabackup *************************** 638. row *************************** Variable_name: wsrep_sst_receive_address Value: AUTO *************************** 639. row *************************** Variable_name: wsrep_start_position Value: becd8177-15a6-11e9-8211-03057ad47201:84 *************************** 640. row *************************** Variable_name: wsrep_sync_wait Value: 0