Skip to content

Instantly share code, notes, and snippets.

@amenk

amenk/debug-info.txt Secret

Created October 18, 2019 16:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amenk/424acf3567486f4f94cb3086e6bf3380 to your computer and use it in GitHub Desktop.
Save amenk/424acf3567486f4f94cb3086e6bf3380 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
debug-info.txt
MariaDB [(none)]> show global status\G;
*************************** 1. row ***************************
Variable_name: Aborted_clients
Value: 512
*************************** 2. row ***************************
Variable_name: Aborted_connects
Value: 0
*************************** 3. row ***************************
Variable_name: Access_denied_errors
Value: 0
*************************** 4. row ***************************
Variable_name: Acl_column_grants
Value: 0
*************************** 5. row ***************************
Variable_name: Acl_database_grants
Value: 8
*************************** 6. row ***************************
Variable_name: Acl_function_grants
Value: 0
*************************** 7. row ***************************
Variable_name: Acl_procedure_grants
Value: 0
*************************** 8. row ***************************
Variable_name: Acl_package_spec_grants
Value: 0
*************************** 9. row ***************************
Variable_name: Acl_package_body_grants
Value: 0
*************************** 10. row ***************************
Variable_name: Acl_proxy_users
Value: 1
*************************** 11. row ***************************
Variable_name: Acl_role_grants
Value: 0
*************************** 12. row ***************************
Variable_name: Acl_roles
Value: 0
*************************** 13. row ***************************
Variable_name: Acl_table_grants
Value: 0
*************************** 14. row ***************************
Variable_name: Acl_users
Value: 7
*************************** 15. row ***************************
Variable_name: Aria_pagecache_blocks_not_flushed
Value: 0
*************************** 16. row ***************************
Variable_name: Aria_pagecache_blocks_unused
Value: 15706
*************************** 17. row ***************************
Variable_name: Aria_pagecache_blocks_used
Value: 191
*************************** 18. row ***************************
Variable_name: Aria_pagecache_read_requests
Value: 414261
*************************** 19. row ***************************
Variable_name: Aria_pagecache_reads
Value: 14354
*************************** 20. row ***************************
Variable_name: Aria_pagecache_write_requests
Value: 29666
*************************** 21. row ***************************
Variable_name: Aria_pagecache_writes
Value: 29424
*************************** 22. row ***************************
Variable_name: Aria_transaction_log_syncs
Value: 16
*************************** 23. row ***************************
Variable_name: Binlog_commits
Value: 0
*************************** 24. row ***************************
Variable_name: Binlog_group_commits
Value: 0
*************************** 25. row ***************************
Variable_name: Binlog_group_commit_trigger_count
Value: 0
*************************** 26. row ***************************
Variable_name: Binlog_group_commit_trigger_lock_wait
Value: 0
*************************** 27. row ***************************
Variable_name: Binlog_group_commit_trigger_timeout
Value: 0
*************************** 28. row ***************************
Variable_name: Binlog_snapshot_file
Value:
*************************** 29. row ***************************
Variable_name: Binlog_snapshot_position
Value: 0
*************************** 30. row ***************************
Variable_name: Binlog_bytes_written
Value: 0
*************************** 31. row ***************************
Variable_name: Binlog_cache_disk_use
Value: 0
*************************** 32. row ***************************
Variable_name: Binlog_cache_use
Value: 0
*************************** 33. row ***************************
Variable_name: Binlog_stmt_cache_disk_use
Value: 0
*************************** 34. row ***************************
Variable_name: Binlog_stmt_cache_use
Value: 0
*************************** 35. row ***************************
Variable_name: Busy_time
Value: 0.000000
*************************** 36. row ***************************
Variable_name: Bytes_received
Value: 38620442585
*************************** 37. row ***************************
Variable_name: Bytes_sent
Value: 48939306676
*************************** 38. row ***************************
Variable_name: Column_compressions
Value: 0
*************************** 39. row ***************************
Variable_name: Column_decompressions
Value: 0
*************************** 40. row ***************************
Variable_name: Com_admin_commands
Value: 256
*************************** 41. row ***************************
Variable_name: Com_alter_db
Value: 0
*************************** 42. row ***************************
Variable_name: Com_alter_db_upgrade
Value: 0
*************************** 43. row ***************************
Variable_name: Com_alter_event
Value: 0
*************************** 44. row ***************************
Variable_name: Com_alter_function
Value: 0
*************************** 45. row ***************************
Variable_name: Com_alter_procedure
Value: 0
*************************** 46. row ***************************
Variable_name: Com_alter_server
Value: 0
*************************** 47. row ***************************
Variable_name: Com_alter_sequence
Value: 0
*************************** 48. row ***************************
Variable_name: Com_alter_table
Value: 0
*************************** 49. row ***************************
Variable_name: Com_alter_tablespace
Value: 0
*************************** 50. row ***************************
Variable_name: Com_alter_user
Value: 0
*************************** 51. row ***************************
Variable_name: Com_analyze
Value: 0
*************************** 52. row ***************************
Variable_name: Com_assign_to_keycache
Value: 0
*************************** 53. row ***************************
Variable_name: Com_begin
Value: 232888
*************************** 54. row ***************************
Variable_name: Com_binlog
Value: 0
*************************** 55. row ***************************
Variable_name: Com_call_procedure
Value: 0
*************************** 56. row ***************************
Variable_name: Com_change_db
Value: 16222
*************************** 57. row ***************************
Variable_name: Com_change_master
Value: 0
*************************** 58. row ***************************
Variable_name: Com_check
Value: 0
*************************** 59. row ***************************
Variable_name: Com_checksum
Value: 0
*************************** 60. row ***************************
Variable_name: Com_commit
Value: 232866
*************************** 61. row ***************************
Variable_name: Com_compound_sql
Value: 0
*************************** 62. row ***************************
Variable_name: Com_create_db
Value: 0
*************************** 63. row ***************************
Variable_name: Com_create_event
Value: 0
*************************** 64. row ***************************
Variable_name: Com_create_function
Value: 0
*************************** 65. row ***************************
Variable_name: Com_create_index
Value: 0
*************************** 66. row ***************************
Variable_name: Com_create_package
Value: 0
*************************** 67. row ***************************
Variable_name: Com_create_package_body
Value: 0
*************************** 68. row ***************************
Variable_name: Com_create_procedure
Value: 0
*************************** 69. row ***************************
Variable_name: Com_create_role
Value: 0
*************************** 70. row ***************************
Variable_name: Com_create_sequence
Value: 0
*************************** 71. row ***************************
Variable_name: Com_create_server
Value: 0
*************************** 72. row ***************************
Variable_name: Com_create_table
Value: 1
*************************** 73. row ***************************
Variable_name: Com_create_temporary_table
Value: 127525
*************************** 74. row ***************************
Variable_name: Com_create_trigger
Value: 0
*************************** 75. row ***************************
Variable_name: Com_create_udf
Value: 0
*************************** 76. row ***************************
Variable_name: Com_create_user
Value: 0
*************************** 77. row ***************************
Variable_name: Com_create_view
Value: 0
*************************** 78. row ***************************
Variable_name: Com_dealloc_sql
Value: 0
*************************** 79. row ***************************
Variable_name: Com_delete
Value: 44539
*************************** 80. row ***************************
Variable_name: Com_delete_multi
Value: 3499
*************************** 81. row ***************************
Variable_name: Com_do
Value: 0
*************************** 82. row ***************************
Variable_name: Com_drop_db
Value: 0
*************************** 83. row ***************************
Variable_name: Com_drop_event
Value: 0
*************************** 84. row ***************************
Variable_name: Com_drop_function
Value: 0
*************************** 85. row ***************************
Variable_name: Com_drop_index
Value: 0
*************************** 86. row ***************************
Variable_name: Com_drop_procedure
Value: 0
*************************** 87. row ***************************
Variable_name: Com_drop_package
Value: 0
*************************** 88. row ***************************
Variable_name: Com_drop_package_body
Value: 0
*************************** 89. row ***************************
Variable_name: Com_drop_role
Value: 0
*************************** 90. row ***************************
Variable_name: Com_drop_server
Value: 0
*************************** 91. row ***************************
Variable_name: Com_drop_sequence
Value: 0
*************************** 92. row ***************************
Variable_name: Com_drop_table
Value: 1
*************************** 93. row ***************************
Variable_name: Com_drop_temporary_table
Value: 188
*************************** 94. row ***************************
Variable_name: Com_drop_trigger
Value: 0
*************************** 95. row ***************************
Variable_name: Com_drop_user
Value: 0
*************************** 96. row ***************************
Variable_name: Com_drop_view
Value: 0
*************************** 97. row ***************************
Variable_name: Com_empty_query
Value: 0
*************************** 98. row ***************************
Variable_name: Com_execute_immediate
Value: 0
*************************** 99. row ***************************
Variable_name: Com_execute_sql
Value: 0
*************************** 100. row ***************************
Variable_name: Com_flush
Value: 0
*************************** 101. row ***************************
Variable_name: Com_get_diagnostics
Value: 0
*************************** 102. row ***************************
Variable_name: Com_grant
Value: 0
*************************** 103. row ***************************
Variable_name: Com_grant_role
Value: 0
*************************** 104. row ***************************
Variable_name: Com_ha_close
Value: 0
*************************** 105. row ***************************
Variable_name: Com_ha_open
Value: 0
*************************** 106. row ***************************
Variable_name: Com_ha_read
Value: 0
*************************** 107. row ***************************
Variable_name: Com_help
Value: 0
*************************** 108. row ***************************
Variable_name: Com_insert
Value: 154928
*************************** 109. row ***************************
Variable_name: Com_insert_select
Value: 64351
*************************** 110. row ***************************
Variable_name: Com_install_plugin
Value: 0
*************************** 111. row ***************************
Variable_name: Com_kill
Value: 0
*************************** 112. row ***************************
Variable_name: Com_load
Value: 0
*************************** 113. row ***************************
Variable_name: Com_lock_tables
Value: 6
*************************** 114. row ***************************
Variable_name: Com_multi
Value: 0
*************************** 115. row ***************************
Variable_name: Com_optimize
Value: 0
*************************** 116. row ***************************
Variable_name: Com_preload_keys
Value: 0
*************************** 117. row ***************************
Variable_name: Com_prepare_sql
Value: 0
*************************** 118. row ***************************
Variable_name: Com_purge
Value: 0
*************************** 119. row ***************************
Variable_name: Com_purge_before_date
Value: 0
*************************** 120. row ***************************
Variable_name: Com_release_savepoint
Value: 36
*************************** 121. row ***************************
Variable_name: Com_rename_table
Value: 0
*************************** 122. row ***************************
Variable_name: Com_rename_user
Value: 0
*************************** 123. row ***************************
Variable_name: Com_repair
Value: 0
*************************** 124. row ***************************
Variable_name: Com_replace
Value: 21
*************************** 125. row ***************************
Variable_name: Com_replace_select
Value: 0
*************************** 126. row ***************************
Variable_name: Com_reset
Value: 0
*************************** 127. row ***************************
Variable_name: Com_resignal
Value: 0
*************************** 128. row ***************************
Variable_name: Com_revoke
Value: 0
*************************** 129. row ***************************
Variable_name: Com_revoke_all
Value: 0
*************************** 130. row ***************************
Variable_name: Com_revoke_role
Value: 0
*************************** 131. row ***************************
Variable_name: Com_rollback
Value: 0
*************************** 132. row ***************************
Variable_name: Com_rollback_to_savepoint
Value: 3736
*************************** 133. row ***************************
Variable_name: Com_savepoint
Value: 36
*************************** 134. row ***************************
Variable_name: Com_select
Value: 20011126
*************************** 135. row ***************************
Variable_name: Com_set_option
Value: 181603
*************************** 136. row ***************************
Variable_name: Com_show_authors
Value: 0
*************************** 137. row ***************************
Variable_name: Com_show_binlog_events
Value: 0
*************************** 138. row ***************************
Variable_name: Com_show_binlogs
Value: 1
*************************** 139. row ***************************
Variable_name: Com_show_charsets
Value: 0
*************************** 140. row ***************************
Variable_name: Com_show_collations
Value: 0
*************************** 141. row ***************************
Variable_name: Com_show_contributors
Value: 0
*************************** 142. row ***************************
Variable_name: Com_show_create_db
Value: 22
*************************** 143. row ***************************
Variable_name: Com_show_create_event
Value: 0
*************************** 144. row ***************************
Variable_name: Com_show_create_func
Value: 0
*************************** 145. row ***************************
Variable_name: Com_show_create_package
Value: 0
*************************** 146. row ***************************
Variable_name: Com_show_create_package_body
Value: 0
*************************** 147. row ***************************
Variable_name: Com_show_create_proc
Value: 0
*************************** 148. row ***************************
Variable_name: Com_show_create_table
Value: 6677
*************************** 149. row ***************************
Variable_name: Com_show_create_trigger
Value: 0
*************************** 150. row ***************************
Variable_name: Com_show_create_user
Value: 0
*************************** 151. row ***************************
Variable_name: Com_show_databases
Value: 404
*************************** 152. row ***************************
Variable_name: Com_show_engine_logs
Value: 0
*************************** 153. row ***************************
Variable_name: Com_show_engine_mutex
Value: 0
*************************** 154. row ***************************
Variable_name: Com_show_engine_status
Value: 0
*************************** 155. row ***************************
Variable_name: Com_show_errors
Value: 0
*************************** 156. row ***************************
Variable_name: Com_show_events
Value: 0
*************************** 157. row ***************************
Variable_name: Com_show_explain
Value: 0
*************************** 158. row ***************************
Variable_name: Com_show_fields
Value: 6982
*************************** 159. row ***************************
Variable_name: Com_show_function_status
Value: 0
*************************** 160. row ***************************
Variable_name: Com_show_generic
Value: 0
*************************** 161. row ***************************
Variable_name: Com_show_grants
Value: 1
*************************** 162. row ***************************
Variable_name: Com_show_keys
Value: 392
*************************** 163. row ***************************
Variable_name: Com_show_master_status
Value: 0
*************************** 164. row ***************************
Variable_name: Com_show_open_tables
Value: 0
*************************** 165. row ***************************
Variable_name: Com_show_package_status
Value: 0
*************************** 166. row ***************************
Variable_name: Com_show_package_body_status
Value: 0
*************************** 167. row ***************************
Variable_name: Com_show_plugins
Value: 0
*************************** 168. row ***************************
Variable_name: Com_show_privileges
Value: 0
*************************** 169. row ***************************
Variable_name: Com_show_procedure_status
Value: 0
*************************** 170. row ***************************
Variable_name: Com_show_processlist
Value: 22948
*************************** 171. row ***************************
Variable_name: Com_show_profile
Value: 0
*************************** 172. row ***************************
Variable_name: Com_show_profiles
Value: 0
*************************** 173. row ***************************
Variable_name: Com_show_relaylog_events
Value: 0
*************************** 174. row ***************************
Variable_name: Com_show_slave_hosts
Value: 0
*************************** 175. row ***************************
Variable_name: Com_show_slave_status
Value: 0
*************************** 176. row ***************************
Variable_name: Com_show_status
Value: 2
*************************** 177. row ***************************
Variable_name: Com_show_storage_engines
Value: 0
*************************** 178. row ***************************
Variable_name: Com_show_table_status
Value: 6924
*************************** 179. row ***************************
Variable_name: Com_show_tables
Value: 71
*************************** 180. row ***************************
Variable_name: Com_show_triggers
Value: 0
*************************** 181. row ***************************
Variable_name: Com_show_variables
Value: 12054
*************************** 182. row ***************************
Variable_name: Com_show_warnings
Value: 204
*************************** 183. row ***************************
Variable_name: Com_shutdown
Value: 0
*************************** 184. row ***************************
Variable_name: Com_signal
Value: 0
*************************** 185. row ***************************
Variable_name: Com_start_all_slaves
Value: 0
*************************** 186. row ***************************
Variable_name: Com_start_slave
Value: 0
*************************** 187. row ***************************
Variable_name: Com_stmt_close
Value: 1034695
*************************** 188. row ***************************
Variable_name: Com_stmt_execute
Value: 1034696
*************************** 189. row ***************************
Variable_name: Com_stmt_fetch
Value: 0
*************************** 190. row ***************************
Variable_name: Com_stmt_prepare
Value: 1034696
*************************** 191. row ***************************
Variable_name: Com_stmt_reprepare
Value: 0
*************************** 192. row ***************************
Variable_name: Com_stmt_reset
Value: 0
*************************** 193. row ***************************
Variable_name: Com_stmt_send_long_data
Value: 0
*************************** 194. row ***************************
Variable_name: Com_stop_all_slaves
Value: 0
*************************** 195. row ***************************
Variable_name: Com_stop_slave
Value: 0
*************************** 196. row ***************************
Variable_name: Com_truncate
Value: 4
*************************** 197. row ***************************
Variable_name: Com_uninstall_plugin
Value: 0
*************************** 198. row ***************************
Variable_name: Com_unlock_tables
Value: 28
*************************** 199. row ***************************
Variable_name: Com_update
Value: 189155
*************************** 200. row ***************************
Variable_name: Com_update_multi
Value: 155520
*************************** 201. row ***************************
Variable_name: Com_xa_commit
Value: 0
*************************** 202. row ***************************
Variable_name: Com_xa_end
Value: 0
*************************** 203. row ***************************
Variable_name: Com_xa_prepare
Value: 0
*************************** 204. row ***************************
Variable_name: Com_xa_recover
Value: 0
*************************** 205. row ***************************
Variable_name: Com_xa_rollback
Value: 0
*************************** 206. row ***************************
Variable_name: Com_xa_start
Value: 0
*************************** 207. row ***************************
Variable_name: Compression
Value: OFF
*************************** 208. row ***************************
Variable_name: Connection_errors_accept
Value: 0
*************************** 209. row ***************************
Variable_name: Connection_errors_internal
Value: 0
*************************** 210. row ***************************
Variable_name: Connection_errors_max_connections
Value: 0
*************************** 211. row ***************************
Variable_name: Connection_errors_peer_address
Value: 0
*************************** 212. row ***************************
Variable_name: Connection_errors_select
Value: 0
*************************** 213. row ***************************
Variable_name: Connection_errors_tcpwrap
Value: 0
*************************** 214. row ***************************
Variable_name: Connections
Value: 86824
*************************** 215. row ***************************
Variable_name: Cpu_time
Value: 0.000000
*************************** 216. row ***************************
Variable_name: Created_tmp_disk_tables
Value: 15711
*************************** 217. row ***************************
Variable_name: Created_tmp_files
Value: 3691
*************************** 218. row ***************************
Variable_name: Created_tmp_tables
Value: 8813993
*************************** 219. row ***************************
Variable_name: Delayed_errors
Value: 0
*************************** 220. row ***************************
Variable_name: Delayed_insert_threads
Value: 0
*************************** 221. row ***************************
Variable_name: Delayed_writes
Value: 0
*************************** 222. row ***************************
Variable_name: Delete_scan
Value: 2467
*************************** 223. row ***************************
Variable_name: Empty_queries
Value: 5222450
*************************** 224. row ***************************
Variable_name: Executed_events
Value: 0
*************************** 225. row ***************************
Variable_name: Executed_triggers
Value: 0
*************************** 226. row ***************************
Variable_name: Feature_check_constraint
Value: 0
*************************** 227. row ***************************
Variable_name: Feature_custom_aggregate_functions
Value: 0
*************************** 228. row ***************************
Variable_name: Feature_delay_key_write
Value: 0
*************************** 229. row ***************************
Variable_name: Feature_dynamic_columns
Value: 0
*************************** 230. row ***************************
Variable_name: Feature_fulltext
Value: 9
*************************** 231. row ***************************
Variable_name: Feature_gis
Value: 27
*************************** 232. row ***************************
Variable_name: Feature_invisible_columns
Value: 0
*************************** 233. row ***************************
Variable_name: Feature_json
Value: 0
*************************** 234. row ***************************
Variable_name: Feature_locale
Value: 6
*************************** 235. row ***************************
Variable_name: Feature_subquery
Value: 69757
*************************** 236. row ***************************
Variable_name: Feature_system_versioning
Value: 0
*************************** 237. row ***************************
Variable_name: Feature_timezone
Value: 35046
*************************** 238. row ***************************
Variable_name: Feature_trigger
Value: 0
*************************** 239. row ***************************
Variable_name: Feature_window_functions
Value: 0
*************************** 240. row ***************************
Variable_name: Feature_xml
Value: 0
*************************** 241. row ***************************
Variable_name: Flush_commands
Value: 1
*************************** 242. row ***************************
Variable_name: Handler_commit
Value: 5832151
*************************** 243. row ***************************
Variable_name: Handler_delete
Value: 750602
*************************** 244. row ***************************
Variable_name: Handler_discover
Value: 728
*************************** 245. row ***************************
Variable_name: Handler_external_lock
Value: 0
*************************** 246. row ***************************
Variable_name: Handler_icp_attempts
Value: 113986366
*************************** 247. row ***************************
Variable_name: Handler_icp_match
Value: 24668651
*************************** 248. row ***************************
Variable_name: Handler_mrr_init
Value: 0
*************************** 249. row ***************************
Variable_name: Handler_mrr_key_refills
Value: 0
*************************** 250. row ***************************
Variable_name: Handler_mrr_rowid_refills
Value: 0
*************************** 251. row ***************************
Variable_name: Handler_prepare
Value: 0
*************************** 252. row ***************************
Variable_name: Handler_read_first
Value: 11671
*************************** 253. row ***************************
Variable_name: Handler_read_key
Value: 34023196861
*************************** 254. row ***************************
Variable_name: Handler_read_last
Value: 33
*************************** 255. row ***************************
Variable_name: Handler_read_next
Value: 13583410689
*************************** 256. row ***************************
Variable_name: Handler_read_prev
Value: 131
*************************** 257. row ***************************
Variable_name: Handler_read_retry
Value: 0
*************************** 258. row ***************************
Variable_name: Handler_read_rnd
Value: 798125821
*************************** 259. row ***************************
Variable_name: Handler_read_rnd_deleted
Value: 46709
*************************** 260. row ***************************
Variable_name: Handler_read_rnd_next
Value: 31706164990
*************************** 261. row ***************************
Variable_name: Handler_rollback
Value: 23
*************************** 262. row ***************************
Variable_name: Handler_savepoint
Value: 36
*************************** 263. row ***************************
Variable_name: Handler_savepoint_rollback
Value: 3736
*************************** 264. row ***************************
Variable_name: Handler_tmp_delete
Value: 0
*************************** 265. row ***************************
Variable_name: Handler_tmp_update
Value: 8783496585
*************************** 266. row ***************************
Variable_name: Handler_tmp_write
Value: 17118088270
*************************** 267. row ***************************
Variable_name: Handler_update
Value: 306344
*************************** 268. row ***************************
Variable_name: Handler_write
Value: 1509177730
*************************** 269. row ***************************
Variable_name: Innodb_buffer_pool_dump_status
Value:
*************************** 270. row ***************************
Variable_name: Innodb_buffer_pool_load_status
Value: Buffer pool(s) load completed at 191017 10:12:20
*************************** 271. row ***************************
Variable_name: Innodb_buffer_pool_resize_status
Value:
*************************** 272. row ***************************
Variable_name: Innodb_buffer_pool_load_incomplete
Value: OFF
*************************** 273. row ***************************
Variable_name: Innodb_buffer_pool_pages_data
Value: 25803
*************************** 274. row ***************************
Variable_name: Innodb_buffer_pool_bytes_data
Value: 422756352
*************************** 275. row ***************************
Variable_name: Innodb_buffer_pool_pages_dirty
Value: 0
*************************** 276. row ***************************
Variable_name: Innodb_buffer_pool_bytes_dirty
Value: 0
*************************** 277. row ***************************
Variable_name: Innodb_buffer_pool_pages_flushed
Value: 644629
*************************** 278. row ***************************
Variable_name: Innodb_buffer_pool_pages_free
Value: 2012
*************************** 279. row ***************************
Variable_name: Innodb_buffer_pool_pages_misc
Value: 4953
*************************** 280. row ***************************
Variable_name: Innodb_buffer_pool_pages_total
Value: 32768
*************************** 281. row ***************************
Variable_name: Innodb_buffer_pool_read_ahead_rnd
Value: 0
*************************** 282. row ***************************
Variable_name: Innodb_buffer_pool_read_ahead
Value: 113565
*************************** 283. row ***************************
Variable_name: Innodb_buffer_pool_read_ahead_evicted
Value: 1810
*************************** 284. row ***************************
Variable_name: Innodb_buffer_pool_read_requests
Value: 65150662635
*************************** 285. row ***************************
Variable_name: Innodb_buffer_pool_reads
Value: 575577
*************************** 286. row ***************************
Variable_name: Innodb_buffer_pool_wait_free
Value: 0
*************************** 287. row ***************************
Variable_name: Innodb_buffer_pool_write_requests
Value: 24231064
*************************** 288. row ***************************
Variable_name: Innodb_data_fsyncs
Value: 264323
*************************** 289. row ***************************
Variable_name: Innodb_data_pending_fsyncs
Value: 0
*************************** 290. row ***************************
Variable_name: Innodb_data_pending_reads
Value: 0
*************************** 291. row ***************************
Variable_name: Innodb_data_pending_writes
Value: 0
*************************** 292. row ***************************
Variable_name: Innodb_data_read
Value: 11354212864
*************************** 293. row ***************************
Variable_name: Innodb_data_reads
Value: 693607
*************************** 294. row ***************************
Variable_name: Innodb_data_writes
Value: 1016443
*************************** 295. row ***************************
Variable_name: Innodb_data_written
Value: 22174586368
*************************** 296. row ***************************
Variable_name: Innodb_dblwr_pages_written
Value: 637896
*************************** 297. row ***************************
Variable_name: Innodb_dblwr_writes
Value: 45425
*************************** 298. row ***************************
Variable_name: Innodb_log_waits
Value: 0
*************************** 299. row ***************************
Variable_name: Innodb_log_write_requests
Value: 1974032
*************************** 300. row ***************************
Variable_name: Innodb_log_writes
Value: 281655
*************************** 301. row ***************************
Variable_name: Innodb_os_log_fsyncs
Value: 125802
*************************** 302. row ***************************
Variable_name: Innodb_os_log_pending_fsyncs
Value: 0
*************************** 303. row ***************************
Variable_name: Innodb_os_log_pending_writes
Value: 0
*************************** 304. row ***************************
Variable_name: Innodb_os_log_written
Value: 1140322304
*************************** 305. row ***************************
Variable_name: Innodb_page_size
Value: 16384
*************************** 306. row ***************************
Variable_name: Innodb_pages_created
Value: 19737
*************************** 307. row ***************************
Variable_name: Innodb_pages_read
Value: 693001
*************************** 308. row ***************************
Variable_name: Innodb_pages0_read
Value: 595
*************************** 309. row ***************************
Variable_name: Innodb_pages_written
Value: 644629
*************************** 310. row ***************************
Variable_name: Innodb_row_lock_current_waits
Value: 0
*************************** 311. row ***************************
Variable_name: Innodb_row_lock_time
Value: 1685
*************************** 312. row ***************************
Variable_name: Innodb_row_lock_time_avg
Value: 88
*************************** 313. row ***************************
Variable_name: Innodb_row_lock_time_max
Value: 687
*************************** 314. row ***************************
Variable_name: Innodb_row_lock_waits
Value: 19
*************************** 315. row ***************************
Variable_name: Innodb_rows_deleted
Value: 929366
*************************** 316. row ***************************
Variable_name: Innodb_rows_inserted
Value: 1564064
*************************** 317. row ***************************
Variable_name: Innodb_rows_read
Value: 24587302359
*************************** 318. row ***************************
Variable_name: Innodb_rows_updated
Value: 170419
*************************** 319. row ***************************
Variable_name: Innodb_system_rows_deleted
Value: 0
*************************** 320. row ***************************
Variable_name: Innodb_system_rows_inserted
Value: 0
*************************** 321. row ***************************
Variable_name: Innodb_system_rows_read
Value: 48625
*************************** 322. row ***************************
Variable_name: Innodb_system_rows_updated
Value: 0
*************************** 323. row ***************************
Variable_name: Innodb_num_open_files
Value: 598
*************************** 324. row ***************************
Variable_name: Innodb_truncated_status_writes
Value: 0
*************************** 325. row ***************************
Variable_name: Innodb_available_undo_logs
Value: 128
*************************** 326. row ***************************
Variable_name: Innodb_undo_truncations
Value: 0
*************************** 327. row ***************************
Variable_name: Innodb_page_compression_saved
Value: 0
*************************** 328. row ***************************
Variable_name: Innodb_num_index_pages_written
Value: 0
*************************** 329. row ***************************
Variable_name: Innodb_num_non_index_pages_written
Value: 0
*************************** 330. row ***************************
Variable_name: Innodb_num_pages_page_compressed
Value: 0
*************************** 331. row ***************************
Variable_name: Innodb_num_page_compressed_trim_op
Value: 0
*************************** 332. row ***************************
Variable_name: Innodb_num_pages_page_decompressed
Value: 0
*************************** 333. row ***************************
Variable_name: Innodb_num_pages_page_compression_error
Value: 0
*************************** 334. row ***************************
Variable_name: Innodb_num_pages_encrypted
Value: 0
*************************** 335. row ***************************
Variable_name: Innodb_num_pages_decrypted
Value: 0
*************************** 336. row ***************************
Variable_name: Innodb_have_lz4
Value: OFF
*************************** 337. row ***************************
Variable_name: Innodb_have_lzo
Value: OFF
*************************** 338. row ***************************
Variable_name: Innodb_have_lzma
Value: ON
*************************** 339. row ***************************
Variable_name: Innodb_have_bzip2
Value: OFF
*************************** 340. row ***************************
Variable_name: Innodb_have_snappy
Value: OFF
*************************** 341. row ***************************
Variable_name: Innodb_have_punch_hole
Value: ON
*************************** 342. row ***************************
Variable_name: Innodb_defragment_compression_failures
Value: 0
*************************** 343. row ***************************
Variable_name: Innodb_defragment_failures
Value: 0
*************************** 344. row ***************************
Variable_name: Innodb_defragment_count
Value: 0
*************************** 345. row ***************************
Variable_name: Innodb_instant_alter_column
Value: 0
*************************** 346. row ***************************
Variable_name: Innodb_onlineddl_rowlog_rows
Value: 0
*************************** 347. row ***************************
Variable_name: Innodb_onlineddl_rowlog_pct_used
Value: 0
*************************** 348. row ***************************
Variable_name: Innodb_onlineddl_pct_progress
Value: 0
*************************** 349. row ***************************
Variable_name: Innodb_secondary_index_triggered_cluster_reads
Value: 448715579
*************************** 350. row ***************************
Variable_name: Innodb_secondary_index_triggered_cluster_reads_avoided
Value: 0
*************************** 351. row ***************************
Variable_name: Innodb_encryption_rotation_pages_read_from_cache
Value: 0
*************************** 352. row ***************************
Variable_name: Innodb_encryption_rotation_pages_read_from_disk
Value: 0
*************************** 353. row ***************************
Variable_name: Innodb_encryption_rotation_pages_modified
Value: 0
*************************** 354. row ***************************
Variable_name: Innodb_encryption_rotation_pages_flushed
Value: 0
*************************** 355. row ***************************
Variable_name: Innodb_encryption_rotation_estimated_iops
Value: 0
*************************** 356. row ***************************
Variable_name: Innodb_encryption_key_rotation_list_length
Value: 0
*************************** 357. row ***************************
Variable_name: Innodb_encryption_n_merge_blocks_encrypted
Value: 0
*************************** 358. row ***************************
Variable_name: Innodb_encryption_n_merge_blocks_decrypted
Value: 0
*************************** 359. row ***************************
Variable_name: Innodb_encryption_n_rowlog_blocks_encrypted
Value: 0
*************************** 360. row ***************************
Variable_name: Innodb_encryption_n_rowlog_blocks_decrypted
Value: 0
*************************** 361. row ***************************
Variable_name: Innodb_encryption_n_temp_blocks_encrypted
Value: 0
*************************** 362. row ***************************
Variable_name: Innodb_encryption_n_temp_blocks_decrypted
Value: 0
*************************** 363. row ***************************
Variable_name: Innodb_scrub_background_page_reorganizations
Value: 0
*************************** 364. row ***************************
Variable_name: Innodb_scrub_background_page_splits
Value: 0
*************************** 365. row ***************************
Variable_name: Innodb_scrub_background_page_split_failures_underflow
Value: 0
*************************** 366. row ***************************
Variable_name: Innodb_scrub_background_page_split_failures_out_of_filespace
Value: 0
*************************** 367. row ***************************
Variable_name: Innodb_scrub_background_page_split_failures_missing_index
Value: 0
*************************** 368. row ***************************
Variable_name: Innodb_scrub_background_page_split_failures_unknown
Value: 0
*************************** 369. row ***************************
Variable_name: Innodb_scrub_log
Value: 0
*************************** 370. row ***************************
Variable_name: Innodb_encryption_num_key_requests
Value: 0
*************************** 371. row ***************************
Variable_name: Key_blocks_not_flushed
Value: 0
*************************** 372. row ***************************
Variable_name: Key_blocks_unused
Value: 107161
*************************** 373. row ***************************
Variable_name: Key_blocks_used
Value: 18
*************************** 374. row ***************************
Variable_name: Key_blocks_warm
Value: 0
*************************** 375. row ***************************
Variable_name: Key_read_requests
Value: 347
*************************** 376. row ***************************
Variable_name: Key_reads
Value: 92
*************************** 377. row ***************************
Variable_name: Key_write_requests
Value: 0
*************************** 378. row ***************************
Variable_name: Key_writes
Value: 0
*************************** 379. row ***************************
Variable_name: Last_query_cost
Value: 0.000000
*************************** 380. row ***************************
Variable_name: Master_gtid_wait_count
Value: 0
*************************** 381. row ***************************
Variable_name: Master_gtid_wait_time
Value: 0
*************************** 382. row ***************************
Variable_name: Master_gtid_wait_timeouts
Value: 0
*************************** 383. row ***************************
Variable_name: Max_statement_time_exceeded
Value: 0
*************************** 384. row ***************************
Variable_name: Max_used_connections
Value: 14
*************************** 385. row ***************************
Variable_name: Memory_used
Value: 439615400
*************************** 386. row ***************************
Variable_name: Memory_used_initial
Value: 407167552
*************************** 387. row ***************************
Variable_name: Not_flushed_delayed_rows
Value: 0
*************************** 388. row ***************************
Variable_name: Open_files
Value: 7
*************************** 389. row ***************************
Variable_name: Open_streams
Value: 0
*************************** 390. row ***************************
Variable_name: Open_table_definitions
Value: 539
*************************** 391. row ***************************
Variable_name: Open_tables
Value: 600
*************************** 392. row ***************************
Variable_name: Opened_files
Value: 101854
*************************** 393. row ***************************
Variable_name: Opened_plugin_libraries
Value: 54
*************************** 394. row ***************************
Variable_name: Opened_table_definitions
Value: 277768
*************************** 395. row ***************************
Variable_name: Opened_tables
Value: 147063
*************************** 396. row ***************************
Variable_name: Opened_views
Value: 6507
*************************** 397. row ***************************
Variable_name: Performance_schema_accounts_lost
Value: 0
*************************** 398. row ***************************
Variable_name: Performance_schema_cond_classes_lost
Value: 0
*************************** 399. row ***************************
Variable_name: Performance_schema_cond_instances_lost
Value: 0
*************************** 400. row ***************************
Variable_name: Performance_schema_digest_lost
Value: 0
*************************** 401. row ***************************
Variable_name: Performance_schema_file_classes_lost
Value: 0
*************************** 402. row ***************************
Variable_name: Performance_schema_file_handles_lost
Value: 0
*************************** 403. row ***************************
Variable_name: Performance_schema_file_instances_lost
Value: 0
*************************** 404. row ***************************
Variable_name: Performance_schema_hosts_lost
Value: 0
*************************** 405. row ***************************
Variable_name: Performance_schema_locker_lost
Value: 0
*************************** 406. row ***************************
Variable_name: Performance_schema_mutex_classes_lost
Value: 0
*************************** 407. row ***************************
Variable_name: Performance_schema_mutex_instances_lost
Value: 0
*************************** 408. row ***************************
Variable_name: Performance_schema_rwlock_classes_lost
Value: 0
*************************** 409. row ***************************
Variable_name: Performance_schema_rwlock_instances_lost
Value: 0
*************************** 410. row ***************************
Variable_name: Performance_schema_session_connect_attrs_lost
Value: 0
*************************** 411. row ***************************
Variable_name: Performance_schema_socket_classes_lost
Value: 0
*************************** 412. row ***************************
Variable_name: Performance_schema_socket_instances_lost
Value: 0
*************************** 413. row ***************************
Variable_name: Performance_schema_stage_classes_lost
Value: 0
*************************** 414. row ***************************
Variable_name: Performance_schema_statement_classes_lost
Value: 0
*************************** 415. row ***************************
Variable_name: Performance_schema_table_handles_lost
Value: 0
*************************** 416. row ***************************
Variable_name: Performance_schema_table_instances_lost
Value: 0
*************************** 417. row ***************************
Variable_name: Performance_schema_thread_classes_lost
Value: 0
*************************** 418. row ***************************
Variable_name: Performance_schema_thread_instances_lost
Value: 0
*************************** 419. row ***************************
Variable_name: Performance_schema_users_lost
Value: 0
*************************** 420. row ***************************
Variable_name: Prepared_stmt_count
Value: 0
*************************** 421. row ***************************
Variable_name: Qcache_free_blocks
Value: 2791
*************************** 422. row ***************************
Variable_name: Qcache_free_memory
Value: 47658376
*************************** 423. row ***************************
Variable_name: Qcache_hits
Value: 14872578
*************************** 424. row ***************************
Variable_name: Qcache_inserts
Value: 1506439
*************************** 425. row ***************************
Variable_name: Qcache_lowmem_prunes
Value: 1099532
*************************** 426. row ***************************
Variable_name: Qcache_not_cached
Value: 3625558
*************************** 427. row ***************************
Variable_name: Qcache_queries_in_cache
Value: 31813
*************************** 428. row ***************************
Variable_name: Qcache_total_blocks
Value: 68718
*************************** 429. row ***************************
Variable_name: Queries
Value: 23630651
*************************** 430. row ***************************
Variable_name: Questions
Value: 21561260
*************************** 431. row ***************************
Variable_name: Rows_read
Value: 21927474983
*************************** 432. row ***************************
Variable_name: Rows_sent
Value: 933329954
*************************** 433. row ***************************
Variable_name: Rows_tmp_read
Value: 26673826221
*************************** 434. row ***************************
Variable_name: Rpl_semi_sync_master_clients
Value: 0
*************************** 435. row ***************************
Variable_name: Rpl_semi_sync_master_get_ack
Value: 0
*************************** 436. row ***************************
Variable_name: Rpl_semi_sync_master_net_avg_wait_time
Value: 0
*************************** 437. row ***************************
Variable_name: Rpl_semi_sync_master_net_wait_time
Value: 0
*************************** 438. row ***************************
Variable_name: Rpl_semi_sync_master_net_waits
Value: 0
*************************** 439. row ***************************
Variable_name: Rpl_semi_sync_master_no_times
Value: 0
*************************** 440. row ***************************
Variable_name: Rpl_semi_sync_master_no_tx
Value: 0
*************************** 441. row ***************************
Variable_name: Rpl_semi_sync_master_request_ack
Value: 0
*************************** 442. row ***************************
Variable_name: Rpl_semi_sync_master_status
Value: OFF
*************************** 443. row ***************************
Variable_name: Rpl_semi_sync_master_timefunc_failures
Value: 0
*************************** 444. row ***************************
Variable_name: Rpl_semi_sync_master_tx_avg_wait_time
Value: 0
*************************** 445. row ***************************
Variable_name: Rpl_semi_sync_master_tx_wait_time
Value: 0
*************************** 446. row ***************************
Variable_name: Rpl_semi_sync_master_tx_waits
Value: 0
*************************** 447. row ***************************
Variable_name: Rpl_semi_sync_master_wait_pos_backtraverse
Value: 0
*************************** 448. row ***************************
Variable_name: Rpl_semi_sync_master_wait_sessions
Value: 0
*************************** 449. row ***************************
Variable_name: Rpl_semi_sync_master_yes_tx
Value: 0
*************************** 450. row ***************************
Variable_name: Rpl_semi_sync_slave_send_ack
Value: 0
*************************** 451. row ***************************
Variable_name: Rpl_semi_sync_slave_status
Value: OFF
*************************** 452. row ***************************
Variable_name: Rpl_status
Value: AUTH_MASTER
*************************** 453. row ***************************
Variable_name: Rpl_transactions_multi_engine
Value: 0
*************************** 454. row ***************************
Variable_name: Select_full_join
Value: 30162
*************************** 455. row ***************************
Variable_name: Select_full_range_join
Value: 392
*************************** 456. row ***************************
Variable_name: Select_range
Value: 635063
*************************** 457. row ***************************
Variable_name: Select_range_check
Value: 0
*************************** 458. row ***************************
Variable_name: Select_scan
Value: 4600460
*************************** 459. row ***************************
Variable_name: Slave_connections
Value: 0
*************************** 460. row ***************************
Variable_name: Slave_heartbeat_period
Value: 0.000
*************************** 461. row ***************************
Variable_name: Slave_open_temp_tables
Value: 0
*************************** 462. row ***************************
Variable_name: Slave_received_heartbeats
Value: 0
*************************** 463. row ***************************
Variable_name: Slave_retried_transactions
Value: 0
*************************** 464. row ***************************
Variable_name: Slave_running
Value: OFF
*************************** 465. row ***************************
Variable_name: Slave_skipped_errors
Value: 0
*************************** 466. row ***************************
Variable_name: Slaves_connected
Value: 0
*************************** 467. row ***************************
Variable_name: Slaves_running
Value: 0
*************************** 468. row ***************************
Variable_name: Slow_launch_threads
Value: 0
*************************** 469. row ***************************
Variable_name: Slow_queries
Value: 8
*************************** 470. row ***************************
Variable_name: Sort_merge_passes
Value: 1843
*************************** 471. row ***************************
Variable_name: Sort_priority_queue_sorts
Value: 13133
*************************** 472. row ***************************
Variable_name: Sort_range
Value: 172903
*************************** 473. row ***************************
Variable_name: Sort_rows
Value: 798546595
*************************** 474. row ***************************
Variable_name: Sort_scan
Value: 2993139
*************************** 475. row ***************************
Variable_name: Ssl_accept_renegotiates
Value: 0
*************************** 476. row ***************************
Variable_name: Ssl_accepts
Value: 0
*************************** 477. row ***************************
Variable_name: Ssl_callback_cache_hits
Value: 0
*************************** 478. row ***************************
Variable_name: Ssl_cipher
Value:
*************************** 479. row ***************************
Variable_name: Ssl_cipher_list
Value:
*************************** 480. row ***************************
Variable_name: Ssl_client_connects
Value: 0
*************************** 481. row ***************************
Variable_name: Ssl_connect_renegotiates
Value: 0
*************************** 482. row ***************************
Variable_name: Ssl_ctx_verify_depth
Value: 0
*************************** 483. row ***************************
Variable_name: Ssl_ctx_verify_mode
Value: 0
*************************** 484. row ***************************
Variable_name: Ssl_default_timeout
Value: 0
*************************** 485. row ***************************
Variable_name: Ssl_finished_accepts
Value: 0
*************************** 486. row ***************************
Variable_name: Ssl_finished_connects
Value: 0
*************************** 487. row ***************************
Variable_name: Ssl_server_not_after
Value:
*************************** 488. row ***************************
Variable_name: Ssl_server_not_before
Value:
*************************** 489. row ***************************
Variable_name: Ssl_session_cache_hits
Value: 0
*************************** 490. row ***************************
Variable_name: Ssl_session_cache_misses
Value: 0
*************************** 491. row ***************************
Variable_name: Ssl_session_cache_mode
Value: NONE
*************************** 492. row ***************************
Variable_name: Ssl_session_cache_overflows
Value: 0
*************************** 493. row ***************************
Variable_name: Ssl_session_cache_size
Value: 0
*************************** 494. row ***************************
Variable_name: Ssl_session_cache_timeouts
Value: 0
*************************** 495. row ***************************
Variable_name: Ssl_sessions_reused
Value: 0
*************************** 496. row ***************************
Variable_name: Ssl_used_session_cache_entries
Value: 0
*************************** 497. row ***************************
Variable_name: Ssl_verify_depth
Value: 0
*************************** 498. row ***************************
Variable_name: Ssl_verify_mode
Value: 0
*************************** 499. row ***************************
Variable_name: Ssl_version
Value:
*************************** 500. row ***************************
Variable_name: Subquery_cache_hit
Value: 0
*************************** 501. row ***************************
Variable_name: Subquery_cache_miss
Value: 5368
*************************** 502. row ***************************
Variable_name: Syncs
Value: 112
*************************** 503. row ***************************
Variable_name: Table_locks_immediate
Value: 309
*************************** 504. row ***************************
Variable_name: Table_locks_waited
Value: 0
*************************** 505. row ***************************
Variable_name: Table_open_cache_active_instances
Value: 1
*************************** 506. row ***************************
Variable_name: Table_open_cache_hits
Value: 11957485
*************************** 507. row ***************************
Variable_name: Table_open_cache_misses
Value: 26363
*************************** 508. row ***************************
Variable_name: Table_open_cache_overflows
Value: 19110
*************************** 509. row ***************************
Variable_name: Tc_log_max_pages_used
Value: 0
*************************** 510. row ***************************
Variable_name: Tc_log_page_size
Value: 4096
*************************** 511. row ***************************
Variable_name: Tc_log_page_waits
Value: 0
*************************** 512. row ***************************
Variable_name: Threadpool_idle_threads
Value: 0
*************************** 513. row ***************************
Variable_name: Threadpool_threads
Value: 0
*************************** 514. row ***************************
Variable_name: Threads_cached
Value: 8
*************************** 515. row ***************************
Variable_name: Threads_connected
Value: 6
*************************** 516. row ***************************
Variable_name: Threads_created
Value: 14
*************************** 517. row ***************************
Variable_name: Threads_running
Value: 7
*************************** 518. row ***************************
Variable_name: Transactions_gtid_foreign_engine
Value: 0
*************************** 519. row ***************************
Variable_name: Transactions_multi_engine
Value: 0
*************************** 520. row ***************************
Variable_name: Update_scan
Value: 263
*************************** 521. row ***************************
Variable_name: Uptime
Value: 115055
*************************** 522. row ***************************
Variable_name: Uptime_since_flush_status
Value: 115055
*************************** 523. row ***************************
Variable_name: wsrep_applier_thread_count
Value: 0
*************************** 524. row ***************************
Variable_name: wsrep_cluster_conf_id
Value: 18446744073709551615
*************************** 525. row ***************************
Variable_name: wsrep_cluster_size
Value: 0
*************************** 526. row ***************************
Variable_name: wsrep_cluster_state_uuid
Value:
*************************** 527. row ***************************
Variable_name: wsrep_cluster_status
Value: Disconnected
*************************** 528. row ***************************
Variable_name: wsrep_connected
Value: OFF
*************************** 529. row ***************************
Variable_name: wsrep_local_bf_aborts
Value: 0
*************************** 530. row ***************************
Variable_name: wsrep_local_index
Value: 18446744073709551615
*************************** 531. row ***************************
Variable_name: wsrep_provider_name
Value:
*************************** 532. row ***************************
Variable_name: wsrep_provider_vendor
Value:
*************************** 533. row ***************************
Variable_name: wsrep_provider_version
Value:
*************************** 534. row ***************************
Variable_name: wsrep_ready
Value: OFF
*************************** 535. row ***************************
Variable_name: wsrep_rollbacker_thread_count
Value: 0
*************************** 536. row ***************************
Variable_name: wsrep_thread_count
Value: 0
536 rows in set (0.001 sec)
MariaDB [(none)]> show global variables\G;
*************************** 1. row ***************************
Variable_name: alter_algorithm
Value: DEFAULT
*************************** 2. row ***************************
Variable_name: aria_block_size
Value: 8192
*************************** 3. row ***************************
Variable_name: aria_checkpoint_interval
Value: 30
*************************** 4. row ***************************
Variable_name: aria_checkpoint_log_activity
Value: 1048576
*************************** 5. row ***************************
Variable_name: aria_encrypt_tables
Value: OFF
*************************** 6. row ***************************
Variable_name: aria_force_start_after_recovery_failures
Value: 0
*************************** 7. row ***************************
Variable_name: aria_group_commit
Value: none
*************************** 8. row ***************************
Variable_name: aria_group_commit_interval
Value: 0
*************************** 9. row ***************************
Variable_name: aria_log_file_size
Value: 1073741824
*************************** 10. row ***************************
Variable_name: aria_log_purge_type
Value: immediate
*************************** 11. row ***************************
Variable_name: aria_max_sort_file_size
Value: 9223372036853727232
*************************** 12. row ***************************
Variable_name: aria_page_checksum
Value: ON
*************************** 13. row ***************************
Variable_name: aria_pagecache_age_threshold
Value: 300
*************************** 14. row ***************************
Variable_name: aria_pagecache_buffer_size
Value: 134217728
*************************** 15. row ***************************
Variable_name: aria_pagecache_division_limit
Value: 100
*************************** 16. row ***************************
Variable_name: aria_pagecache_file_hash_size
Value: 512
*************************** 17. row ***************************
Variable_name: aria_recover_options
Value: BACKUP,QUICK
*************************** 18. row ***************************
Variable_name: aria_repair_threads
Value: 1
*************************** 19. row ***************************
Variable_name: aria_sort_buffer_size
Value: 268434432
*************************** 20. row ***************************
Variable_name: aria_stats_method
Value: nulls_unequal
*************************** 21. row ***************************
Variable_name: aria_sync_log_dir
Value: NEWFILE
*************************** 22. row ***************************
Variable_name: aria_used_for_temp_tables
Value: ON
*************************** 23. row ***************************
Variable_name: auto_increment_increment
Value: 1
*************************** 24. row ***************************
Variable_name: auto_increment_offset
Value: 1
*************************** 25. row ***************************
Variable_name: autocommit
Value: ON
*************************** 26. row ***************************
Variable_name: automatic_sp_privileges
Value: ON
*************************** 27. row ***************************
Variable_name: back_log
Value: 250
*************************** 28. row ***************************
Variable_name: basedir
Value: /usr/
*************************** 29. row ***************************
Variable_name: big_tables
Value: OFF
*************************** 30. row ***************************
Variable_name: bind_address
Value:
*************************** 31. row ***************************
Variable_name: binlog_annotate_row_events
Value: ON
*************************** 32. row ***************************
Variable_name: binlog_cache_size
Value: 32768
*************************** 33. row ***************************
Variable_name: binlog_checksum
Value: CRC32
*************************** 34. row ***************************
Variable_name: binlog_commit_wait_count
Value: 0
*************************** 35. row ***************************
Variable_name: binlog_commit_wait_usec
Value: 100000
*************************** 36. row ***************************
Variable_name: binlog_direct_non_transactional_updates
Value: OFF
*************************** 37. row ***************************
Variable_name: binlog_file_cache_size
Value: 16384
*************************** 38. row ***************************
Variable_name: binlog_format
Value: MIXED
*************************** 39. row ***************************
Variable_name: binlog_optimize_thread_scheduling
Value: ON
*************************** 40. row ***************************
Variable_name: binlog_row_image
Value: FULL
*************************** 41. row ***************************
Variable_name: binlog_stmt_cache_size
Value: 32768
*************************** 42. row ***************************
Variable_name: bulk_insert_buffer_size
Value: 8388608
*************************** 43. row ***************************
Variable_name: character_set_client
Value: latin1
*************************** 44. row ***************************
Variable_name: character_set_connection
Value: latin1
*************************** 45. row ***************************
Variable_name: character_set_database
Value: latin1
*************************** 46. row ***************************
Variable_name: character_set_filesystem
Value: binary
*************************** 47. row ***************************
Variable_name: character_set_results
Value: latin1
*************************** 48. row ***************************
Variable_name: character_set_server
Value: latin1
*************************** 49. row ***************************
Variable_name: character_set_system
Value: utf8
*************************** 50. row ***************************
Variable_name: character_sets_dir
Value: /usr/share/mysql/charsets/
*************************** 51. row ***************************
Variable_name: check_constraint_checks
Value: ON
*************************** 52. row ***************************
Variable_name: collation_connection
Value: latin1_swedish_ci
*************************** 53. row ***************************
Variable_name: collation_database
Value: latin1_swedish_ci
*************************** 54. row ***************************
Variable_name: collation_server
Value: latin1_swedish_ci
*************************** 55. row ***************************
Variable_name: column_compression_threshold
Value: 100
*************************** 56. row ***************************
Variable_name: column_compression_zlib_level
Value: 6
*************************** 57. row ***************************
Variable_name: column_compression_zlib_strategy
Value: DEFAULT_STRATEGY
*************************** 58. row ***************************
Variable_name: column_compression_zlib_wrap
Value: OFF
*************************** 59. row ***************************
Variable_name: completion_type
Value: NO_CHAIN
*************************** 60. row ***************************
Variable_name: concurrent_insert
Value: AUTO
*************************** 61. row ***************************
Variable_name: connect_timeout
Value: 10
*************************** 62. row ***************************
Variable_name: core_file
Value: OFF
*************************** 63. row ***************************
Variable_name: datadir
Value: /var/lib/mysql/
*************************** 64. row ***************************
Variable_name: date_format
Value: %Y-%m-%d
*************************** 65. row ***************************
Variable_name: datetime_format
Value: %Y-%m-%d %H:%i:%s
*************************** 66. row ***************************
Variable_name: deadlock_search_depth_long
Value: 15
*************************** 67. row ***************************
Variable_name: deadlock_search_depth_short
Value: 4
*************************** 68. row ***************************
Variable_name: deadlock_timeout_long
Value: 50000000
*************************** 69. row ***************************
Variable_name: deadlock_timeout_short
Value: 10000
*************************** 70. row ***************************
Variable_name: debug_no_thread_alarm
Value: OFF
*************************** 71. row ***************************
Variable_name: default_regex_flags
Value:
*************************** 72. row ***************************
Variable_name: default_storage_engine
Value: InnoDB
*************************** 73. row ***************************
Variable_name: default_tmp_storage_engine
Value:
*************************** 74. row ***************************
Variable_name: default_week_format
Value: 0
*************************** 75. row ***************************
Variable_name: delay_key_write
Value: ON
*************************** 76. row ***************************
Variable_name: delayed_insert_limit
Value: 100
*************************** 77. row ***************************
Variable_name: delayed_insert_timeout
Value: 300
*************************** 78. row ***************************
Variable_name: delayed_queue_size
Value: 1000
*************************** 79. row ***************************
Variable_name: div_precision_increment
Value: 4
*************************** 80. row ***************************
Variable_name: encrypt_binlog
Value: OFF
*************************** 81. row ***************************
Variable_name: encrypt_tmp_disk_tables
Value: OFF
*************************** 82. row ***************************
Variable_name: encrypt_tmp_files
Value: OFF
*************************** 83. row ***************************
Variable_name: enforce_storage_engine
Value:
*************************** 84. row ***************************
Variable_name: eq_range_index_dive_limit
Value: 0
*************************** 85. row ***************************
Variable_name: event_scheduler
Value: OFF
*************************** 86. row ***************************
Variable_name: expensive_subquery_limit
Value: 100
*************************** 87. row ***************************
Variable_name: expire_logs_days
Value: 10
*************************** 88. row ***************************
Variable_name: explicit_defaults_for_timestamp
Value: OFF
*************************** 89. row ***************************
Variable_name: extra_max_connections
Value: 1
*************************** 90. row ***************************
Variable_name: extra_port
Value: 0
*************************** 91. row ***************************
Variable_name: flush
Value: OFF
*************************** 92. row ***************************
Variable_name: flush_time
Value: 0
*************************** 93. row ***************************
Variable_name: foreign_key_checks
Value: ON
*************************** 94. row ***************************
Variable_name: ft_boolean_syntax
Value: + -><()~*:""&|
*************************** 95. row ***************************
Variable_name: ft_max_word_len
Value: 84
*************************** 96. row ***************************
Variable_name: ft_min_word_len
Value: 4
*************************** 97. row ***************************
Variable_name: ft_query_expansion_limit
Value: 20
*************************** 98. row ***************************
Variable_name: ft_stopword_file
Value: (built-in)
*************************** 99. row ***************************
Variable_name: general_log
Value: OFF
*************************** 100. row ***************************
Variable_name: general_log_file
Value: example.log
*************************** 101. row ***************************
Variable_name: group_concat_max_len
Value: 320000
*************************** 102. row ***************************
Variable_name: gtid_binlog_pos
Value:
*************************** 103. row ***************************
Variable_name: gtid_binlog_state
Value:
*************************** 104. row ***************************
Variable_name: gtid_current_pos
Value:
*************************** 105. row ***************************
Variable_name: gtid_domain_id
Value: 0
*************************** 106. row ***************************
Variable_name: gtid_ignore_duplicates
Value: OFF
*************************** 107. row ***************************
Variable_name: gtid_pos_auto_engines
Value:
*************************** 108. row ***************************
Variable_name: gtid_slave_pos
Value:
*************************** 109. row ***************************
Variable_name: gtid_strict_mode
Value: OFF
*************************** 110. row ***************************
Variable_name: have_compress
Value: YES
*************************** 111. row ***************************
Variable_name: have_crypt
Value: YES
*************************** 112. row ***************************
Variable_name: have_dynamic_loading
Value: YES
*************************** 113. row ***************************
Variable_name: have_geometry
Value: YES
*************************** 114. row ***************************
Variable_name: have_openssl
Value: YES
*************************** 115. row ***************************
Variable_name: have_profiling
Value: YES
*************************** 116. row ***************************
Variable_name: have_query_cache
Value: YES
*************************** 117. row ***************************
Variable_name: have_rtree_keys
Value: YES
*************************** 118. row ***************************
Variable_name: have_ssl
Value: DISABLED
*************************** 119. row ***************************
Variable_name: have_symlink
Value: DISABLED
*************************** 120. row ***************************
Variable_name: histogram_size
Value: 0
*************************** 121. row ***************************
Variable_name: histogram_type
Value: SINGLE_PREC_HB
*************************** 122. row ***************************
Variable_name: host_cache_size
Value: 653
*************************** 123. row ***************************
Variable_name: hostname
Value: example.aix-cloud.de
*************************** 124. row ***************************
Variable_name: idle_readonly_transaction_timeout
Value: 0
*************************** 125. row ***************************
Variable_name: idle_transaction_timeout
Value: 0
*************************** 126. row ***************************
Variable_name: idle_write_transaction_timeout
Value: 0
*************************** 127. row ***************************
Variable_name: ignore_builtin_innodb
Value: OFF
*************************** 128. row ***************************
Variable_name: ignore_db_dirs
Value:
*************************** 129. row ***************************
Variable_name: in_predicate_conversion_threshold
Value: 1000
*************************** 130. row ***************************
Variable_name: init_connect
Value:
*************************** 131. row ***************************
Variable_name: init_file
Value:
*************************** 132. row ***************************
Variable_name: init_slave
Value:
*************************** 133. row ***************************
Variable_name: innodb_adaptive_flushing
Value: ON
*************************** 134. row ***************************
Variable_name: innodb_adaptive_flushing_lwm
Value: 10.000000
*************************** 135. row ***************************
Variable_name: innodb_adaptive_hash_index
Value: ON
*************************** 136. row ***************************
Variable_name: innodb_adaptive_hash_index_parts
Value: 8
*************************** 137. row ***************************
Variable_name: innodb_adaptive_max_sleep_delay
Value: 150000
*************************** 138. row ***************************
Variable_name: innodb_autoextend_increment
Value: 64
*************************** 139. row ***************************
Variable_name: innodb_autoinc_lock_mode
Value: 1
*************************** 140. row ***************************
Variable_name: innodb_background_scrub_data_check_interval
Value: 3600
*************************** 141. row ***************************
Variable_name: innodb_background_scrub_data_compressed
Value: OFF
*************************** 142. row ***************************
Variable_name: innodb_background_scrub_data_interval
Value: 604800
*************************** 143. row ***************************
Variable_name: innodb_background_scrub_data_uncompressed
Value: OFF
*************************** 144. row ***************************
Variable_name: innodb_buf_dump_status_frequency
Value: 0
*************************** 145. row ***************************
Variable_name: innodb_buffer_pool_chunk_size
Value: 134217728
*************************** 146. row ***************************
Variable_name: innodb_buffer_pool_dump_at_shutdown
Value: ON
*************************** 147. row ***************************
Variable_name: innodb_buffer_pool_dump_now
Value: OFF
*************************** 148. row ***************************
Variable_name: innodb_buffer_pool_dump_pct
Value: 25
*************************** 149. row ***************************
Variable_name: innodb_buffer_pool_filename
Value: ib_buffer_pool
*************************** 150. row ***************************
Variable_name: innodb_buffer_pool_instances
Value: 1
*************************** 151. row ***************************
Variable_name: innodb_buffer_pool_load_abort
Value: OFF
*************************** 152. row ***************************
Variable_name: innodb_buffer_pool_load_at_startup
Value: ON
*************************** 153. row ***************************
Variable_name: innodb_buffer_pool_load_now
Value: OFF
*************************** 154. row ***************************
Variable_name: innodb_buffer_pool_size
Value: 536870912
*************************** 155. row ***************************
Variable_name: innodb_change_buffer_max_size
Value: 25
*************************** 156. row ***************************
Variable_name: innodb_change_buffering
Value: all
*************************** 157. row ***************************
Variable_name: innodb_checksum_algorithm
Value: crc32
*************************** 158. row ***************************
Variable_name: innodb_checksums
Value: ON
*************************** 159. row ***************************
Variable_name: innodb_cmp_per_index_enabled
Value: OFF
*************************** 160. row ***************************
Variable_name: innodb_commit_concurrency
Value: 0
*************************** 161. row ***************************
Variable_name: innodb_compression_algorithm
Value: zlib
*************************** 162. row ***************************
Variable_name: innodb_compression_default
Value: OFF
*************************** 163. row ***************************
Variable_name: innodb_compression_failure_threshold_pct
Value: 5
*************************** 164. row ***************************
Variable_name: innodb_compression_level
Value: 6
*************************** 165. row ***************************
Variable_name: innodb_compression_pad_pct_max
Value: 50
*************************** 166. row ***************************
Variable_name: innodb_concurrency_tickets
Value: 5000
*************************** 167. row ***************************
Variable_name: innodb_data_file_path
Value: ibdata1:12M:autoextend
*************************** 168. row ***************************
Variable_name: innodb_data_home_dir
Value:
*************************** 169. row ***************************
Variable_name: innodb_deadlock_detect
Value: ON
*************************** 170. row ***************************
Variable_name: innodb_default_encryption_key_id
Value: 1
*************************** 171. row ***************************
Variable_name: innodb_default_row_format
Value: dynamic
*************************** 172. row ***************************
Variable_name: innodb_defragment
Value: OFF
*************************** 173. row ***************************
Variable_name: innodb_defragment_fill_factor
Value: 0.900000
*************************** 174. row ***************************
Variable_name: innodb_defragment_fill_factor_n_recs
Value: 20
*************************** 175. row ***************************
Variable_name: innodb_defragment_frequency
Value: 40
*************************** 176. row ***************************
Variable_name: innodb_defragment_n_pages
Value: 7
*************************** 177. row ***************************
Variable_name: innodb_defragment_stats_accuracy
Value: 0
*************************** 178. row ***************************
Variable_name: innodb_disable_sort_file_cache
Value: OFF
*************************** 179. row ***************************
Variable_name: innodb_disallow_writes
Value: OFF
*************************** 180. row ***************************
Variable_name: innodb_doublewrite
Value: ON
*************************** 181. row ***************************
Variable_name: innodb_encrypt_log
Value: OFF
*************************** 182. row ***************************
Variable_name: innodb_encrypt_tables
Value: OFF
*************************** 183. row ***************************
Variable_name: innodb_encrypt_temporary_tables
Value: OFF
*************************** 184. row ***************************
Variable_name: innodb_encryption_rotate_key_age
Value: 1
*************************** 185. row ***************************
Variable_name: innodb_encryption_rotation_iops
Value: 100
*************************** 186. row ***************************
Variable_name: innodb_encryption_threads
Value: 0
*************************** 187. row ***************************
Variable_name: innodb_fast_shutdown
Value: 1
*************************** 188. row ***************************
Variable_name: innodb_fatal_semaphore_wait_threshold
Value: 600
*************************** 189. row ***************************
Variable_name: innodb_file_format
Value:
*************************** 190. row ***************************
Variable_name: innodb_file_per_table
Value: ON
*************************** 191. row ***************************
Variable_name: innodb_fill_factor
Value: 100
*************************** 192. row ***************************
Variable_name: innodb_flush_log_at_timeout
Value: 1
*************************** 193. row ***************************
Variable_name: innodb_flush_log_at_trx_commit
Value: 2
*************************** 194. row ***************************
Variable_name: innodb_flush_method
Value: fsync
*************************** 195. row ***************************
Variable_name: innodb_flush_neighbors
Value: 1
*************************** 196. row ***************************
Variable_name: innodb_flush_sync
Value: ON
*************************** 197. row ***************************
Variable_name: innodb_flushing_avg_loops
Value: 30
*************************** 198. row ***************************
Variable_name: innodb_force_load_corrupted
Value: OFF
*************************** 199. row ***************************
Variable_name: innodb_force_primary_key
Value: OFF
*************************** 200. row ***************************
Variable_name: innodb_force_recovery
Value: 0
*************************** 201. row ***************************
Variable_name: innodb_ft_aux_table
Value:
*************************** 202. row ***************************
Variable_name: innodb_ft_cache_size
Value: 8000000
*************************** 203. row ***************************
Variable_name: innodb_ft_enable_diag_print
Value: OFF
*************************** 204. row ***************************
Variable_name: innodb_ft_enable_stopword
Value: ON
*************************** 205. row ***************************
Variable_name: innodb_ft_max_token_size
Value: 84
*************************** 206. row ***************************
Variable_name: innodb_ft_min_token_size
Value: 3
*************************** 207. row ***************************
Variable_name: innodb_ft_num_word_optimize
Value: 2000
*************************** 208. row ***************************
Variable_name: innodb_ft_result_cache_limit
Value: 2000000000
*************************** 209. row ***************************
Variable_name: innodb_ft_server_stopword_table
Value:
*************************** 210. row ***************************
Variable_name: innodb_ft_sort_pll_degree
Value: 2
*************************** 211. row ***************************
Variable_name: innodb_ft_total_cache_size
Value: 640000000
*************************** 212. row ***************************
Variable_name: innodb_ft_user_stopword_table
Value:
*************************** 213. row ***************************
Variable_name: innodb_idle_flush_pct
Value: 100
*************************** 214. row ***************************
Variable_name: innodb_immediate_scrub_data_uncompressed
Value: OFF
*************************** 215. row ***************************
Variable_name: innodb_io_capacity
Value: 200
*************************** 216. row ***************************
Variable_name: innodb_io_capacity_max
Value: 2000
*************************** 217. row ***************************
Variable_name: innodb_large_prefix
Value:
*************************** 218. row ***************************
Variable_name: innodb_lock_schedule_algorithm
Value: fcfs
*************************** 219. row ***************************
Variable_name: innodb_lock_wait_timeout
Value: 50
*************************** 220. row ***************************
Variable_name: innodb_locks_unsafe_for_binlog
Value: OFF
*************************** 221. row ***************************
Variable_name: innodb_log_buffer_size
Value: 16777216
*************************** 222. row ***************************
Variable_name: innodb_log_checksums
Value: ON
*************************** 223. row ***************************
Variable_name: innodb_log_compressed_pages
Value: ON
*************************** 224. row ***************************
Variable_name: innodb_log_file_size
Value: 50331648
*************************** 225. row ***************************
Variable_name: innodb_log_files_in_group
Value: 2
*************************** 226. row ***************************
Variable_name: innodb_log_group_home_dir
Value: ./
*************************** 227. row ***************************
Variable_name: innodb_log_optimize_ddl
Value: ON
*************************** 228. row ***************************
Variable_name: innodb_log_write_ahead_size
Value: 8192
*************************** 229. row ***************************
Variable_name: innodb_lru_scan_depth
Value: 1024
*************************** 230. row ***************************
Variable_name: innodb_max_dirty_pages_pct
Value: 75.000000
*************************** 231. row ***************************
Variable_name: innodb_max_dirty_pages_pct_lwm
Value: 0.000000
*************************** 232. row ***************************
Variable_name: innodb_max_purge_lag
Value: 0
*************************** 233. row ***************************
Variable_name: innodb_max_purge_lag_delay
Value: 0
*************************** 234. row ***************************
Variable_name: innodb_max_undo_log_size
Value: 10485760
*************************** 235. row ***************************
Variable_name: innodb_monitor_disable
Value:
*************************** 236. row ***************************
Variable_name: innodb_monitor_enable
Value:
*************************** 237. row ***************************
Variable_name: innodb_monitor_reset
Value:
*************************** 238. row ***************************
Variable_name: innodb_monitor_reset_all
Value:
*************************** 239. row ***************************
Variable_name: innodb_old_blocks_pct
Value: 37
*************************** 240. row ***************************
Variable_name: innodb_old_blocks_time
Value: 1000
*************************** 241. row ***************************
Variable_name: innodb_online_alter_log_max_size
Value: 134217728
*************************** 242. row ***************************
Variable_name: innodb_open_files
Value: 600
*************************** 243. row ***************************
Variable_name: innodb_optimize_fulltext_only
Value: OFF
*************************** 244. row ***************************
Variable_name: innodb_page_cleaners
Value: 1
*************************** 245. row ***************************
Variable_name: innodb_page_size
Value: 16384
*************************** 246. row ***************************
Variable_name: innodb_prefix_index_cluster_optimization
Value: OFF
*************************** 247. row ***************************
Variable_name: innodb_print_all_deadlocks
Value: OFF
*************************** 248. row ***************************
Variable_name: innodb_purge_batch_size
Value: 300
*************************** 249. row ***************************
Variable_name: innodb_purge_rseg_truncate_frequency
Value: 128
*************************** 250. row ***************************
Variable_name: innodb_purge_threads
Value: 4
*************************** 251. row ***************************
Variable_name: innodb_random_read_ahead
Value: OFF
*************************** 252. row ***************************
Variable_name: innodb_read_ahead_threshold
Value: 56
*************************** 253. row ***************************
Variable_name: innodb_read_io_threads
Value: 4
*************************** 254. row ***************************
Variable_name: innodb_read_only
Value: OFF
*************************** 255. row ***************************
Variable_name: innodb_replication_delay
Value: 0
*************************** 256. row ***************************
Variable_name: innodb_rollback_on_timeout
Value: OFF
*************************** 257. row ***************************
Variable_name: innodb_rollback_segments
Value: 128
*************************** 258. row ***************************
Variable_name: innodb_scrub_log
Value: OFF
*************************** 259. row ***************************
Variable_name: innodb_scrub_log_speed
Value: 256
*************************** 260. row ***************************
Variable_name: innodb_sort_buffer_size
Value: 1048576
*************************** 261. row ***************************
Variable_name: innodb_spin_wait_delay
Value: 4
*************************** 262. row ***************************
Variable_name: innodb_stats_auto_recalc
Value: ON
*************************** 263. row ***************************
Variable_name: innodb_stats_include_delete_marked
Value: OFF
*************************** 264. row ***************************
Variable_name: innodb_stats_method
Value: nulls_equal
*************************** 265. row ***************************
Variable_name: innodb_stats_modified_counter
Value: 0
*************************** 266. row ***************************
Variable_name: innodb_stats_on_metadata
Value: OFF
*************************** 267. row ***************************
Variable_name: innodb_stats_persistent
Value: ON
*************************** 268. row ***************************
Variable_name: innodb_stats_persistent_sample_pages
Value: 20
*************************** 269. row ***************************
Variable_name: innodb_stats_sample_pages
Value: 8
*************************** 270. row ***************************
Variable_name: innodb_stats_traditional
Value: ON
*************************** 271. row ***************************
Variable_name: innodb_stats_transient_sample_pages
Value: 8
*************************** 272. row ***************************
Variable_name: innodb_status_output
Value: OFF
*************************** 273. row ***************************
Variable_name: innodb_status_output_locks
Value: OFF
*************************** 274. row ***************************
Variable_name: innodb_strict_mode
Value: ON
*************************** 275. row ***************************
Variable_name: innodb_sync_array_size
Value: 1
*************************** 276. row ***************************
Variable_name: innodb_sync_spin_loops
Value: 30
*************************** 277. row ***************************
Variable_name: innodb_table_locks
Value: ON
*************************** 278. row ***************************
Variable_name: innodb_temp_data_file_path
Value: ibtmp1:12M:autoextend
*************************** 279. row ***************************
Variable_name: innodb_thread_concurrency
Value: 0
*************************** 280. row ***************************
Variable_name: innodb_thread_sleep_delay
Value: 10000
*************************** 281. row ***************************
Variable_name: innodb_tmpdir
Value:
*************************** 282. row ***************************
Variable_name: innodb_undo_directory
Value: ./
*************************** 283. row ***************************
Variable_name: innodb_undo_log_truncate
Value: OFF
*************************** 284. row ***************************
Variable_name: innodb_undo_logs
Value: 128
*************************** 285. row ***************************
Variable_name: innodb_undo_tablespaces
Value: 0
*************************** 286. row ***************************
Variable_name: innodb_use_atomic_writes
Value: ON
*************************** 287. row ***************************
Variable_name: innodb_use_native_aio
Value: ON
*************************** 288. row ***************************
Variable_name: innodb_version
Value: 10.3.18
*************************** 289. row ***************************
Variable_name: innodb_write_io_threads
Value: 4
*************************** 290. row ***************************
Variable_name: interactive_timeout
Value: 28800
*************************** 291. row ***************************
Variable_name: join_buffer_size
Value: 262144
*************************** 292. row ***************************
Variable_name: join_buffer_space_limit
Value: 2097152
*************************** 293. row ***************************
Variable_name: join_cache_level
Value: 2
*************************** 294. row ***************************
Variable_name: keep_files_on_create
Value: OFF
*************************** 295. row ***************************
Variable_name: key_buffer_size
Value: 134217728
*************************** 296. row ***************************
Variable_name: key_cache_age_threshold
Value: 300
*************************** 297. row ***************************
Variable_name: key_cache_block_size
Value: 1024
*************************** 298. row ***************************
Variable_name: key_cache_division_limit
Value: 100
*************************** 299. row ***************************
Variable_name: key_cache_file_hash_size
Value: 512
*************************** 300. row ***************************
Variable_name: key_cache_segments
Value: 0
*************************** 301. row ***************************
Variable_name: large_files_support
Value: ON
*************************** 302. row ***************************
Variable_name: large_page_size
Value: 0
*************************** 303. row ***************************
Variable_name: large_pages
Value: OFF
*************************** 304. row ***************************
Variable_name: lc_messages
Value: en_US
*************************** 305. row ***************************
Variable_name: lc_messages_dir
Value:
*************************** 306. row ***************************
Variable_name: lc_time_names
Value: en_US
*************************** 307. row ***************************
Variable_name: license
Value: GPL
*************************** 308. row ***************************
Variable_name: local_infile
Value: OFF
*************************** 309. row ***************************
Variable_name: lock_wait_timeout
Value: 86400
*************************** 310. row ***************************
Variable_name: locked_in_memory
Value: OFF
*************************** 311. row ***************************
Variable_name: log_bin
Value: OFF
*************************** 312. row ***************************
Variable_name: log_bin_basename
Value:
*************************** 313. row ***************************
Variable_name: log_bin_compress
Value: OFF
*************************** 314. row ***************************
Variable_name: log_bin_compress_min_len
Value: 256
*************************** 315. row ***************************
Variable_name: log_bin_index
Value:
*************************** 316. row ***************************
Variable_name: log_bin_trust_function_creators
Value: OFF
*************************** 317. row ***************************
Variable_name: log_disabled_statements
Value: sp
*************************** 318. row ***************************
Variable_name: log_error
Value: /var/log/mysql.err
*************************** 319. row ***************************
Variable_name: log_output
Value: FILE
*************************** 320. row ***************************
Variable_name: log_queries_not_using_indexes
Value: OFF
*************************** 321. row ***************************
Variable_name: log_slave_updates
Value: OFF
*************************** 322. row ***************************
Variable_name: log_slow_admin_statements
Value: ON
*************************** 323. row ***************************
Variable_name: log_slow_disabled_statements
Value: sp
*************************** 324. row ***************************
Variable_name: log_slow_filter
Value: admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
*************************** 325. row ***************************
Variable_name: log_slow_rate_limit
Value: 1
*************************** 326. row ***************************
Variable_name: log_slow_slave_statements
Value: ON
*************************** 327. row ***************************
Variable_name: log_slow_verbosity
Value:
*************************** 328. row ***************************
Variable_name: log_tc_size
Value: 24576
*************************** 329. row ***************************
Variable_name: log_warnings
Value: 2
*************************** 330. row ***************************
Variable_name: long_query_time
Value: 10.000000
*************************** 331. row ***************************
Variable_name: low_priority_updates
Value: OFF
*************************** 332. row ***************************
Variable_name: lower_case_file_system
Value: OFF
*************************** 333. row ***************************
Variable_name: lower_case_table_names
Value: 0
*************************** 334. row ***************************
Variable_name: master_verify_checksum
Value: OFF
*************************** 335. row ***************************
Variable_name: max_allowed_packet
Value: 104857600
*************************** 336. row ***************************
Variable_name: max_binlog_cache_size
Value: 18446744073709547520
*************************** 337. row ***************************
Variable_name: max_binlog_size
Value: 1073741824
*************************** 338. row ***************************
Variable_name: max_binlog_stmt_cache_size
Value: 18446744073709547520
*************************** 339. row ***************************
Variable_name: max_connect_errors
Value: 100
*************************** 340. row ***************************
Variable_name: max_connections
Value: 1000
*************************** 341. row ***************************
Variable_name: max_delayed_threads
Value: 20
*************************** 342. row ***************************
Variable_name: max_digest_length
Value: 1024
*************************** 343. row ***************************
Variable_name: max_error_count
Value: 64
*************************** 344. row ***************************
Variable_name: max_heap_table_size
Value: 2147483648
*************************** 345. row ***************************
Variable_name: max_insert_delayed_threads
Value: 20
*************************** 346. row ***************************
Variable_name: max_join_size
Value: 18446744073709551615
*************************** 347. row ***************************
Variable_name: max_length_for_sort_data
Value: 1024
*************************** 348. row ***************************
Variable_name: max_long_data_size
Value: 104857600
*************************** 349. row ***************************
Variable_name: max_prepared_stmt_count
Value: 16382
*************************** 350. row ***************************
Variable_name: max_recursive_iterations
Value: 4294967295
*************************** 351. row ***************************
Variable_name: max_relay_log_size
Value: 1073741824
*************************** 352. row ***************************
Variable_name: max_seeks_for_key
Value: 4294967295
*************************** 353. row ***************************
Variable_name: max_session_mem_used
Value: 9223372036854775807
*************************** 354. row ***************************
Variable_name: max_sort_length
Value: 1024
*************************** 355. row ***************************
Variable_name: max_sp_recursion_depth
Value: 0
*************************** 356. row ***************************
Variable_name: max_statement_time
Value: 0.000000
*************************** 357. row ***************************
Variable_name: max_tmp_tables
Value: 32
*************************** 358. row ***************************
Variable_name: max_user_connections
Value: 0
*************************** 359. row ***************************
Variable_name: max_write_lock_count
Value: 4294967295
*************************** 360. row ***************************
Variable_name: metadata_locks_cache_size
Value: 1024
*************************** 361. row ***************************
Variable_name: metadata_locks_hash_instances
Value: 8
*************************** 362. row ***************************
Variable_name: min_examined_row_limit
Value: 0
*************************** 363. row ***************************
Variable_name: mrr_buffer_size
Value: 262144
*************************** 364. row ***************************
Variable_name: multi_range_count
Value: 256
*************************** 365. row ***************************
Variable_name: myisam_block_size
Value: 1024
*************************** 366. row ***************************
Variable_name: myisam_data_pointer_size
Value: 6
*************************** 367. row ***************************
Variable_name: myisam_max_sort_file_size
Value: 9223372036853727232
*************************** 368. row ***************************
Variable_name: myisam_mmap_size
Value: 18446744073709551615
*************************** 369. row ***************************
Variable_name: myisam_recover_options
Value: BACKUP
*************************** 370. row ***************************
Variable_name: myisam_repair_threads
Value: 1
*************************** 371. row ***************************
Variable_name: myisam_sort_buffer_size
Value: 134216704
*************************** 372. row ***************************
Variable_name: myisam_stats_method
Value: NULLS_UNEQUAL
*************************** 373. row ***************************
Variable_name: myisam_use_mmap
Value: OFF
*************************** 374. row ***************************
Variable_name: mysql56_temporal_format
Value: ON
*************************** 375. row ***************************
Variable_name: net_buffer_length
Value: 16384
*************************** 376. row ***************************
Variable_name: net_read_timeout
Value: 30
*************************** 377. row ***************************
Variable_name: net_retry_count
Value: 10
*************************** 378. row ***************************
Variable_name: net_write_timeout
Value: 60
*************************** 379. row ***************************
Variable_name: old
Value: OFF
*************************** 380. row ***************************
Variable_name: old_alter_table
Value: DEFAULT
*************************** 381. row ***************************
Variable_name: old_mode
Value:
*************************** 382. row ***************************
Variable_name: old_passwords
Value: OFF
*************************** 383. row ***************************
Variable_name: open_files_limit
Value: 16364
*************************** 384. row ***************************
Variable_name: optimizer_prune_level
Value: 1
*************************** 385. row ***************************
Variable_name: optimizer_search_depth
Value: 0
*************************** 386. row ***************************
Variable_name: optimizer_selectivity_sampling_limit
Value: 100
*************************** 387. 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,split_materialized=on
*************************** 388. row ***************************
Variable_name: optimizer_use_condition_selectivity
Value: 1
*************************** 389. row ***************************
Variable_name: performance_schema
Value: OFF
*************************** 390. row ***************************
Variable_name: performance_schema_accounts_size
Value: -1
*************************** 391. row ***************************
Variable_name: performance_schema_digests_size
Value: -1
*************************** 392. row ***************************
Variable_name: performance_schema_events_stages_history_long_size
Value: -1
*************************** 393. row ***************************
Variable_name: performance_schema_events_stages_history_size
Value: -1
*************************** 394. row ***************************
Variable_name: performance_schema_events_statements_history_long_size
Value: -1
*************************** 395. row ***************************
Variable_name: performance_schema_events_statements_history_size
Value: -1
*************************** 396. row ***************************
Variable_name: performance_schema_events_waits_history_long_size
Value: -1
*************************** 397. row ***************************
Variable_name: performance_schema_events_waits_history_size
Value: -1
*************************** 398. row ***************************
Variable_name: performance_schema_hosts_size
Value: -1
*************************** 399. row ***************************
Variable_name: performance_schema_max_cond_classes
Value: 80
*************************** 400. row ***************************
Variable_name: performance_schema_max_cond_instances
Value: -1
*************************** 401. row ***************************
Variable_name: performance_schema_max_digest_length
Value: 1024
*************************** 402. row ***************************
Variable_name: performance_schema_max_file_classes
Value: 50
*************************** 403. row ***************************
Variable_name: performance_schema_max_file_handles
Value: 32768
*************************** 404. row ***************************
Variable_name: performance_schema_max_file_instances
Value: -1
*************************** 405. row ***************************
Variable_name: performance_schema_max_mutex_classes
Value: 200
*************************** 406. row ***************************
Variable_name: performance_schema_max_mutex_instances
Value: -1
*************************** 407. row ***************************
Variable_name: performance_schema_max_rwlock_classes
Value: 40
*************************** 408. row ***************************
Variable_name: performance_schema_max_rwlock_instances
Value: -1
*************************** 409. row ***************************
Variable_name: performance_schema_max_socket_classes
Value: 10
*************************** 410. row ***************************
Variable_name: performance_schema_max_socket_instances
Value: -1
*************************** 411. row ***************************
Variable_name: performance_schema_max_stage_classes
Value: 160
*************************** 412. row ***************************
Variable_name: performance_schema_max_statement_classes
Value: 200
*************************** 413. row ***************************
Variable_name: performance_schema_max_table_handles
Value: -1
*************************** 414. row ***************************
Variable_name: performance_schema_max_table_instances
Value: -1
*************************** 415. row ***************************
Variable_name: performance_schema_max_thread_classes
Value: 50
*************************** 416. row ***************************
Variable_name: performance_schema_max_thread_instances
Value: -1
*************************** 417. row ***************************
Variable_name: performance_schema_session_connect_attrs_size
Value: -1
*************************** 418. row ***************************
Variable_name: performance_schema_setup_actors_size
Value: 100
*************************** 419. row ***************************
Variable_name: performance_schema_setup_objects_size
Value: 100
*************************** 420. row ***************************
Variable_name: performance_schema_users_size
Value: -1
*************************** 421. row ***************************
Variable_name: pid_file
Value: /var/lib/mysql/example.pid
*************************** 422. row ***************************
Variable_name: plugin_dir
Value: /usr/lib64/mysql/plugin/
*************************** 423. row ***************************
Variable_name: plugin_maturity
Value: gamma
*************************** 424. row ***************************
Variable_name: port
Value: 3306
*************************** 425. row ***************************
Variable_name: preload_buffer_size
Value: 32768
*************************** 426. row ***************************
Variable_name: profiling
Value: OFF
*************************** 427. row ***************************
Variable_name: profiling_history_size
Value: 15
*************************** 428. row ***************************
Variable_name: progress_report_time
Value: 5
*************************** 429. row ***************************
Variable_name: protocol_version
Value: 10
*************************** 430. row ***************************
Variable_name: proxy_protocol_networks
Value:
*************************** 431. row ***************************
Variable_name: query_alloc_block_size
Value: 16384
*************************** 432. row ***************************
Variable_name: query_cache_limit
Value: 1048576
*************************** 433. row ***************************
Variable_name: query_cache_min_res_unit
Value: 2048
*************************** 434. row ***************************
Variable_name: query_cache_size
Value: 134217728
*************************** 435. row ***************************
Variable_name: query_cache_strip_comments
Value: OFF
*************************** 436. row ***************************
Variable_name: query_cache_type
Value: ON
*************************** 437. row ***************************
Variable_name: query_cache_wlock_invalidate
Value: OFF
*************************** 438. row ***************************
Variable_name: query_prealloc_size
Value: 24576
*************************** 439. row ***************************
Variable_name: range_alloc_block_size
Value: 4096
*************************** 440. row ***************************
Variable_name: read_binlog_speed_limit
Value: 0
*************************** 441. row ***************************
Variable_name: read_buffer_size
Value: 131072
*************************** 442. row ***************************
Variable_name: read_only
Value: OFF
*************************** 443. row ***************************
Variable_name: read_rnd_buffer_size
Value: 262144
*************************** 444. row ***************************
Variable_name: relay_log
Value:
*************************** 445. row ***************************
Variable_name: relay_log_basename
Value:
*************************** 446. row ***************************
Variable_name: relay_log_index
Value:
*************************** 447. row ***************************
Variable_name: relay_log_info_file
Value: relay-log.info
*************************** 448. row ***************************
Variable_name: relay_log_purge
Value: ON
*************************** 449. row ***************************
Variable_name: relay_log_recovery
Value: OFF
*************************** 450. row ***************************
Variable_name: relay_log_space_limit
Value: 0
*************************** 451. row ***************************
Variable_name: replicate_annotate_row_events
Value: ON
*************************** 452. row ***************************
Variable_name: replicate_do_db
Value:
*************************** 453. row ***************************
Variable_name: replicate_do_table
Value:
*************************** 454. row ***************************
Variable_name: replicate_events_marked_for_skip
Value: REPLICATE
*************************** 455. row ***************************
Variable_name: replicate_ignore_db
Value:
*************************** 456. row ***************************
Variable_name: replicate_ignore_table
Value:
*************************** 457. row ***************************
Variable_name: replicate_wild_do_table
Value:
*************************** 458. row ***************************
Variable_name: replicate_wild_ignore_table
Value:
*************************** 459. row ***************************
Variable_name: report_host
Value:
*************************** 460. row ***************************
Variable_name: report_password
Value:
*************************** 461. row ***************************
Variable_name: report_port
Value: 3306
*************************** 462. row ***************************
Variable_name: report_user
Value:
*************************** 463. row ***************************
Variable_name: rowid_merge_buff_size
Value: 8388608
*************************** 464. row ***************************
Variable_name: rpl_semi_sync_master_enabled
Value: OFF
*************************** 465. row ***************************
Variable_name: rpl_semi_sync_master_timeout
Value: 10000
*************************** 466. row ***************************
Variable_name: rpl_semi_sync_master_trace_level
Value: 32
*************************** 467. row ***************************
Variable_name: rpl_semi_sync_master_wait_no_slave
Value: ON
*************************** 468. row ***************************
Variable_name: rpl_semi_sync_master_wait_point
Value: AFTER_COMMIT
*************************** 469. row ***************************
Variable_name: rpl_semi_sync_slave_delay_master
Value: OFF
*************************** 470. row ***************************
Variable_name: rpl_semi_sync_slave_enabled
Value: OFF
*************************** 471. row ***************************
Variable_name: rpl_semi_sync_slave_kill_conn_timeout
Value: 5
*************************** 472. row ***************************
Variable_name: rpl_semi_sync_slave_trace_level
Value: 32
*************************** 473. row ***************************
Variable_name: secure_auth
Value: ON
*************************** 474. row ***************************
Variable_name: secure_file_priv
Value:
*************************** 475. row ***************************
Variable_name: secure_timestamp
Value: NO
*************************** 476. row ***************************
Variable_name: server_id
Value: 1
*************************** 477. row ***************************
Variable_name: session_track_schema
Value: ON
*************************** 478. row ***************************
Variable_name: session_track_state_change
Value: OFF
*************************** 479. row ***************************
Variable_name: session_track_system_variables
Value: autocommit,character_set_client,character_set_connection,character_set_results,time_zone
*************************** 480. row ***************************
Variable_name: session_track_transaction_info
Value: OFF
*************************** 481. row ***************************
Variable_name: skip_external_locking
Value: ON
*************************** 482. row ***************************
Variable_name: skip_name_resolve
Value: ON
*************************** 483. row ***************************
Variable_name: skip_networking
Value: OFF
*************************** 484. row ***************************
Variable_name: skip_show_database
Value: OFF
*************************** 485. row ***************************
Variable_name: slave_compressed_protocol
Value: OFF
*************************** 486. row ***************************
Variable_name: slave_ddl_exec_mode
Value: IDEMPOTENT
*************************** 487. row ***************************
Variable_name: slave_domain_parallel_threads
Value: 0
*************************** 488. row ***************************
Variable_name: slave_exec_mode
Value: STRICT
*************************** 489. row ***************************
Variable_name: slave_load_tmpdir
Value: /tmp
*************************** 490. row ***************************
Variable_name: slave_max_allowed_packet
Value: 1073741824
*************************** 491. row ***************************
Variable_name: slave_net_timeout
Value: 60
*************************** 492. row ***************************
Variable_name: slave_parallel_max_queued
Value: 131072
*************************** 493. row ***************************
Variable_name: slave_parallel_mode
Value: conservative
*************************** 494. row ***************************
Variable_name: slave_parallel_threads
Value: 0
*************************** 495. row ***************************
Variable_name: slave_parallel_workers
Value: 0
*************************** 496. row ***************************
Variable_name: slave_run_triggers_for_rbr
Value: NO
*************************** 497. row ***************************
Variable_name: slave_skip_errors
Value: OFF
*************************** 498. row ***************************
Variable_name: slave_sql_verify_checksum
Value: ON
*************************** 499. row ***************************
Variable_name: slave_transaction_retries
Value: 10
*************************** 500. row ***************************
Variable_name: slave_transaction_retry_errors
Value: 1213,1205
*************************** 501. row ***************************
Variable_name: slave_transaction_retry_interval
Value: 0
*************************** 502. row ***************************
Variable_name: slave_type_conversions
Value:
*************************** 503. row ***************************
Variable_name: slow_launch_time
Value: 2
*************************** 504. row ***************************
Variable_name: slow_query_log
Value: OFF
*************************** 505. row ***************************
Variable_name: slow_query_log_file
Value: example-slow.log
*************************** 506. row ***************************
Variable_name: socket
Value: /var/lib/mysql/mysql.sock
*************************** 507. row ***************************
Variable_name: sort_buffer_size
Value: 2097152
*************************** 508. row ***************************
Variable_name: sql_auto_is_null
Value: OFF
*************************** 509. row ***************************
Variable_name: sql_big_selects
Value: ON
*************************** 510. row ***************************
Variable_name: sql_buffer_result
Value: OFF
*************************** 511. row ***************************
Variable_name: sql_log_bin
Value: ON
*************************** 512. row ***************************
Variable_name: sql_log_off
Value: OFF
*************************** 513. row ***************************
Variable_name: sql_mode
Value: NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
*************************** 514. row ***************************
Variable_name: sql_notes
Value: ON
*************************** 515. row ***************************
Variable_name: sql_quote_show_create
Value: ON
*************************** 516. row ***************************
Variable_name: sql_safe_updates
Value: OFF
*************************** 517. row ***************************
Variable_name: sql_select_limit
Value: 18446744073709551615
*************************** 518. row ***************************
Variable_name: sql_slave_skip_counter
Value: 0
*************************** 519. row ***************************
Variable_name: sql_warnings
Value: OFF
*************************** 520. row ***************************
Variable_name: ssl_ca
Value:
*************************** 521. row ***************************
Variable_name: ssl_capath
Value:
*************************** 522. row ***************************
Variable_name: ssl_cert
Value:
*************************** 523. row ***************************
Variable_name: ssl_cipher
Value:
*************************** 524. row ***************************
Variable_name: ssl_crl
Value:
*************************** 525. row ***************************
Variable_name: ssl_crlpath
Value:
*************************** 526. row ***************************
Variable_name: ssl_key
Value:
*************************** 527. row ***************************
Variable_name: standard_compliant_cte
Value: ON
*************************** 528. row ***************************
Variable_name: storage_engine
Value: InnoDB
*************************** 529. row ***************************
Variable_name: stored_program_cache
Value: 256
*************************** 530. row ***************************
Variable_name: strict_password_validation
Value: ON
*************************** 531. row ***************************
Variable_name: sync_binlog
Value: 2
*************************** 532. row ***************************
Variable_name: sync_frm
Value: ON
*************************** 533. row ***************************
Variable_name: sync_master_info
Value: 10000
*************************** 534. row ***************************
Variable_name: sync_relay_log
Value: 10000
*************************** 535. row ***************************
Variable_name: sync_relay_log_info
Value: 10000
*************************** 536. row ***************************
Variable_name: system_time_zone
Value: CEST
*************************** 537. row ***************************
Variable_name: system_versioning_alter_history
Value: ERROR
*************************** 538. row ***************************
Variable_name: system_versioning_asof
Value: DEFAULT
*************************** 539. row ***************************
Variable_name: table_definition_cache
Value: 400
*************************** 540. row ***************************
Variable_name: table_open_cache
Value: 600
*************************** 541. row ***************************
Variable_name: table_open_cache_instances
Value: 8
*************************** 542. row ***************************
Variable_name: tcp_keepalive_interval
Value: 0
*************************** 543. row ***************************
Variable_name: tcp_keepalive_probes
Value: 0
*************************** 544. row ***************************
Variable_name: tcp_keepalive_time
Value: 0
*************************** 545. row ***************************
Variable_name: thread_cache_size
Value: 256
*************************** 546. row ***************************
Variable_name: thread_concurrency
Value: 10
*************************** 547. row ***************************
Variable_name: thread_handling
Value: one-thread-per-connection
*************************** 548. row ***************************
Variable_name: thread_pool_idle_timeout
Value: 60
*************************** 549. row ***************************
Variable_name: thread_pool_max_threads
Value: 65536
*************************** 550. row ***************************
Variable_name: thread_pool_oversubscribe
Value: 3
*************************** 551. row ***************************
Variable_name: thread_pool_prio_kickup_timer
Value: 1000
*************************** 552. row ***************************
Variable_name: thread_pool_priority
Value: auto
*************************** 553. row ***************************
Variable_name: thread_pool_size
Value: 8
*************************** 554. row ***************************
Variable_name: thread_pool_stall_limit
Value: 500
*************************** 555. row ***************************
Variable_name: thread_stack
Value: 299008
*************************** 556. row ***************************
Variable_name: time_format
Value: %H:%i:%s
*************************** 557. row ***************************
Variable_name: time_zone
Value: SYSTEM
*************************** 558. row ***************************
Variable_name: timed_mutexes
Value: OFF
*************************** 559. row ***************************
Variable_name: tmp_disk_table_size
Value: 18446744073709551615
*************************** 560. row ***************************
Variable_name: tmp_memory_table_size
Value: 2147483648
*************************** 561. row ***************************
Variable_name: tmp_table_size
Value: 2147483648
*************************** 562. row ***************************
Variable_name: tmpdir
Value: /tmp
*************************** 563. row ***************************
Variable_name: transaction_alloc_block_size
Value: 8192
*************************** 564. row ***************************
Variable_name: transaction_prealloc_size
Value: 4096
*************************** 565. row ***************************
Variable_name: tx_isolation
Value: REPEATABLE-READ
*************************** 566. row ***************************
Variable_name: tx_read_only
Value: OFF
*************************** 567. row ***************************
Variable_name: unique_checks
Value: ON
*************************** 568. row ***************************
Variable_name: updatable_views_with_limit
Value: YES
*************************** 569. row ***************************
Variable_name: use_stat_tables
Value: NEVER
*************************** 570. row ***************************
Variable_name: userstat
Value: OFF
*************************** 571. row ***************************
Variable_name: version
Value: 10.3.18-MariaDB
*************************** 572. row ***************************
Variable_name: version_comment
Value: MariaDB Server
*************************** 573. row ***************************
Variable_name: version_compile_machine
Value: x86_64
*************************** 574. row ***************************
Variable_name: version_compile_os
Value: Linux
*************************** 575. row ***************************
Variable_name: version_malloc_library
Value: system
*************************** 576. row ***************************
Variable_name: version_source_revision
Value: 604f80e77c054758aa449064cdc29dfa13a71922
*************************** 577. row ***************************
Variable_name: version_ssl_library
Value: OpenSSL 1.0.2k-fips 26 Jan 2017
*************************** 578. row ***************************
Variable_name: wait_timeout
Value: 28800
*************************** 579. row ***************************
Variable_name: wsrep_osu_method
Value: TOI
*************************** 580. row ***************************
Variable_name: wsrep_auto_increment_control
Value: ON
*************************** 581. row ***************************
Variable_name: wsrep_causal_reads
Value: OFF
*************************** 582. row ***************************
Variable_name: wsrep_certification_rules
Value: strict
*************************** 583. row ***************************
Variable_name: wsrep_certify_nonpk
Value: ON
*************************** 584. row ***************************
Variable_name: wsrep_cluster_address
Value:
*************************** 585. row ***************************
Variable_name: wsrep_cluster_name
Value: my_wsrep_cluster
*************************** 586. row ***************************
Variable_name: wsrep_convert_lock_to_trx
Value: OFF
*************************** 587. row ***************************
Variable_name: wsrep_data_home_dir
Value: /var/lib/mysql/
*************************** 588. row ***************************
Variable_name: wsrep_dbug_option
Value:
*************************** 589. row ***************************
Variable_name: wsrep_debug
Value: OFF
*************************** 590. row ***************************
Variable_name: wsrep_desync
Value: OFF
*************************** 591. row ***************************
Variable_name: wsrep_dirty_reads
Value: OFF
*************************** 592. row ***************************
Variable_name: wsrep_drupal_282555_workaround
Value: OFF
*************************** 593. row ***************************
Variable_name: wsrep_forced_binlog_format
Value: NONE
*************************** 594. row ***************************
Variable_name: wsrep_gtid_domain_id
Value: 0
*************************** 595. row ***************************
Variable_name: wsrep_gtid_mode
Value: OFF
*************************** 596. row ***************************
Variable_name: wsrep_load_data_splitting
Value: ON
*************************** 597. row ***************************
Variable_name: wsrep_log_conflicts
Value: OFF
*************************** 598. row ***************************
Variable_name: wsrep_max_ws_rows
Value: 0
*************************** 599. row ***************************
Variable_name: wsrep_max_ws_size
Value: 2147483647
*************************** 600. row ***************************
Variable_name: wsrep_mysql_replication_bundle
Value: 0
*************************** 601. row ***************************
Variable_name: wsrep_node_address
Value:
*************************** 602. row ***************************
Variable_name: wsrep_node_incoming_address
Value: AUTO
*************************** 603. row ***************************
Variable_name: wsrep_node_name
Value: example.aix-cloud.de
*************************** 604. row ***************************
Variable_name: wsrep_notify_cmd
Value:
*************************** 605. row ***************************
Variable_name: wsrep_on
Value: OFF
*************************** 606. row ***************************
Variable_name: wsrep_patch_version
Value: wsrep_25.24
*************************** 607. row ***************************
Variable_name: wsrep_provider
Value: none
*************************** 608. row ***************************
Variable_name: wsrep_provider_options
Value:
*************************** 609. row ***************************
Variable_name: wsrep_recover
Value: OFF
*************************** 610. row ***************************
Variable_name: wsrep_reject_queries
Value: NONE
*************************** 611. row ***************************
Variable_name: wsrep_replicate_myisam
Value: OFF
*************************** 612. row ***************************
Variable_name: wsrep_restart_slave
Value: OFF
*************************** 613. row ***************************
Variable_name: wsrep_retry_autocommit
Value: 1
*************************** 614. row ***************************
Variable_name: wsrep_slave_fk_checks
Value: ON
*************************** 615. row ***************************
Variable_name: wsrep_slave_uk_checks
Value: OFF
*************************** 616. row ***************************
Variable_name: wsrep_slave_threads
Value: 1
*************************** 617. row ***************************
Variable_name: wsrep_sst_auth
Value:
*************************** 618. row ***************************
Variable_name: wsrep_sst_donor
Value:
*************************** 619. row ***************************
Variable_name: wsrep_sst_donor_rejects_queries
Value: OFF
*************************** 620. row ***************************
Variable_name: wsrep_sst_method
Value: rsync
*************************** 621. row ***************************
Variable_name: wsrep_sst_receive_address
Value: AUTO
*************************** 622. row ***************************
Variable_name: wsrep_start_position
Value: 00000000-0000-0000-0000-000000000000:-1
*************************** 623. row ***************************
Variable_name: wsrep_sync_wait
Value: 0
623 rows in set (0.002 sec)
MariaDB [(none)]> show engine innodb status\G;
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
2019-10-18 18:12:04 0x7f93550a1700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 3 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 42502 srv_active, 0 srv_shutdown, 72528 srv_idle
srv_master_thread log flush and writes: 115028
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 4029896
OS WAIT ARRAY INFO: signal count 6257830
RW-shared spins 0, rounds 7446598, OS waits 3498517
RW-excl spins 0, rounds 15584390, OS waits 427793
RW-sx spins 77313, rounds 993238, OS waits 9911
Spin rounds per wait: 7446598.00 RW-shared, 15584390.00 RW-excl, 12.85 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 28685925
Purge done for trx's n:o < 28685925 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421745748788304, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421745748771440, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421745748758792, ACTIVE 0 sec starting index read
mysql tables in use 2, locked 0
0 lock struct(s), heap size 1136, 0 row lock(s)
MySQL thread id 86905, OS thread handle 140270762723072, query id 23654124 localhost shop_production Sending data
SELECT `main_table`.`value`, count(main_table.value) AS `count` FROM (SELECT DISTINCT `main_table`.`entity_id`, `main_table`.`value` FROM `catalog_product_index_eav` AS `main_table`
INNER JOIN `search_tmp_5da9e4519aaa02_24360989` AS `entities` ON main_table.entity_id = entities.entity_id
INNER JOIN `cataloginventory_stock_status` AS `stock_index` ON main_table.source_id = stock_index.product_id WHERE (main_table.attribute_id = 144) AND (main_table.store_id = '1' ) AND (stock_index.stock_status = 1)) AS `main_table` GROUP BY `value`
Trx read view will not see trx with id >= 28685925, sees < 28685925
---TRANSACTION 421745748763008, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421745748784088, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421745748779872, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421745748775656, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421745748767224, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421745748754576, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
693896 OS file reads, 1017356 OS file writes, 264563 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.67 writes/s, 0.67 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 3663, seg size 3665, 5960 merges
merged operations:
insert 31768, delete mark 494257, delete 131250
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 138401, node heap has 368 buffer(s)
Hash table size 138401, node heap has 269 buffer(s)
Hash table size 138401, node heap has 126 buffer(s)
Hash table size 138401, node heap has 198 buffer(s)
Hash table size 138401, node heap has 2446 buffer(s)
Hash table size 138401, node heap has 274 buffer(s)
Hash table size 138401, node heap has 1689 buffer(s)
Hash table size 138401, node heap has 507 buffer(s)
469131.29 hash searches/s, 247160.61 non-hash searches/s
---
LOG
---
Log sequence number 26220680138
Log flushed up to 26220680138
Pages flushed up to 26220680138
Last checkpoint at 26220680129
0 pending log flushes, 0 pending chkp writes
323812 log i/o's done, 0.67 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 582746112
Dictionary memory allocated 1757664
Buffer pool size 32768
Free buffers 1083
Database pages 25808
Old database pages 9506
Modified db pages 0
Percent of dirty pages(LRU & free pages): 0.000
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1076974, not young 71374732
4.67 youngs/s, 0.00 non-youngs/s
Pages read 693290, created 19741, written 645129
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 25808, unzip_LRU len: 0
I/O sum[270]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
1 read views open inside InnoDB
Process ID=3572812, Main thread ID=140270772037376, state: sleeping
Number of rows inserted 1564117, updated 170605, deleted 929366, read 24620338108
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 677806.06 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 48625
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================
[root@mz-at ~]# ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) 61941
max locked memory (kbytes, -l) 64
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
real-time priority (-r) 0
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 61941
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment