Re: mysql out of memory
Posted by: KAUSHALENDER SHEKHAWAT
Date: November 22, 2019 01:30AM

Show variables
show variables \G;
*************************** 1. row ***************************
Variable_name: auto_increment_increment
Value: 1
*************************** 2. row ***************************
Variable_name: auto_increment_offset
Value: 1
*************************** 3. row ***************************
Variable_name: autocommit
Value: ON
*************************** 4. row ***************************
Variable_name: automatic_sp_privileges
Value: ON
*************************** 5. row ***************************
Variable_name: avoid_temporal_upgrade
Value: OFF
*************************** 6. row ***************************
Variable_name: back_log
Value: 250
*************************** 7. row ***************************
Variable_name: basedir
Value: /usr/local/mysql
*************************** 8. row ***************************
Variable_name: big_tables
Value: OFF
*************************** 9. row ***************************
Variable_name: bind_address
Value: *
*************************** 10. row ***************************
Variable_name: binlog_cache_size
Value: 32768
*************************** 11. row ***************************
Variable_name: binlog_checksum
Value: CRC32
*************************** 12. row ***************************
Variable_name: binlog_direct_non_transactional_updates
Value: OFF
*************************** 13. row ***************************
Variable_name: binlog_error_action
Value: IGNORE_ERROR
*************************** 14. row ***************************
Variable_name: binlog_format
Value: MIXED
*************************** 15. row ***************************
Variable_name: binlog_gtid_simple_recovery
Value: OFF
*************************** 16. row ***************************
Variable_name: binlog_max_flush_queue_time
Value: 0
*************************** 17. row ***************************
Variable_name: binlog_order_commits
Value: ON
*************************** 18. row ***************************
Variable_name: binlog_row_image
Value: FULL
*************************** 19. row ***************************
Variable_name: binlog_rows_query_log_events
Value: OFF
*************************** 20. row ***************************
Variable_name: binlog_stmt_cache_size
Value: 32768
*************************** 21. row ***************************
Variable_name: binlogging_impossible_mode
Value: IGNORE_ERROR
*************************** 22. row ***************************
Variable_name: block_encryption_mode
Value: aes-128-ecb
*************************** 23. row ***************************
Variable_name: bulk_insert_buffer_size
Value: 8388608
*************************** 24. row ***************************
Variable_name: character_set_client
Value: utf8
*************************** 25. row ***************************
Variable_name: character_set_connection
Value: utf8
*************************** 26. row ***************************
Variable_name: character_set_database
Value: latin1
*************************** 27. row ***************************
Variable_name: character_set_filesystem
Value: binary
*************************** 28. row ***************************
Variable_name: character_set_results
Value: utf8
*************************** 29. row ***************************
Variable_name: character_set_server
Value: latin1
*************************** 30. row ***************************
Variable_name: character_set_system
Value: utf8
*************************** 31. row ***************************
Variable_name: character_sets_dir
Value: /usr/local/mysql-advanced-5.6.31-linux-glibc2.5-i686/share/charsets/
*************************** 32. row ***************************
Variable_name: collation_connection
Value: utf8_general_ci
*************************** 33. row ***************************
Variable_name: collation_database
Value: latin1_swedish_ci
*************************** 34. row ***************************
Variable_name: collation_server
Value: latin1_swedish_ci
*************************** 35. row ***************************
Variable_name: completion_type
Value: NO_CHAIN
*************************** 36. row ***************************
Variable_name: concurrent_insert
Value: AUTO
*************************** 37. row ***************************
Variable_name: connect_timeout
Value: 10
*************************** 38. row ***************************
Variable_name: core_file
Value: OFF
*************************** 39. row ***************************
Variable_name: datadir
Value: /usr/local/mysql/data/
*************************** 40. row ***************************
Variable_name: date_format
Value: %Y-%m-%d
*************************** 41. row ***************************
Variable_name: datetime_format
Value: %Y-%m-%d %H:%i:%s
*************************** 42. row ***************************
Variable_name: default_storage_engine
Value: InnoDB
*************************** 43. row ***************************
Variable_name: default_tmp_storage_engine
Value: InnoDB
*************************** 44. row ***************************
Variable_name: default_week_format
Value: 0
*************************** 45. row ***************************
Variable_name: delay_key_write
Value: ON
*************************** 46. row ***************************
Variable_name: delayed_insert_limit
Value: 100
*************************** 47. row ***************************
Variable_name: delayed_insert_timeout
Value: 300
*************************** 48. row ***************************
Variable_name: delayed_queue_size
Value: 1000
*************************** 49. row ***************************
Variable_name: disconnect_on_expired_password
Value: ON
*************************** 50. row ***************************
Variable_name: div_precision_increment
Value: 4
*************************** 51. row ***************************
Variable_name: end_markers_in_json
Value: OFF
*************************** 52. row ***************************
Variable_name: enforce_gtid_consistency
Value: OFF
*************************** 53. row ***************************
Variable_name: eq_range_index_dive_limit
Value: 10
*************************** 54. row ***************************
Variable_name: error_count
Value: 0
*************************** 55. row ***************************
Variable_name: event_scheduler
Value: OFF
*************************** 56. row ***************************
Variable_name: expire_logs_days
Value: 0
*************************** 57. row ***************************
Variable_name: explicit_defaults_for_timestamp
Value: OFF
*************************** 58. row ***************************
Variable_name: external_user
Value:
*************************** 59. row ***************************
Variable_name: flush
Value: OFF
*************************** 60. row ***************************
Variable_name: flush_time
Value: 0
*************************** 61. row ***************************
Variable_name: foreign_key_checks
Value: ON
*************************** 62. row ***************************
Variable_name: ft_boolean_syntax
Value: + -><()~*:""&|
*************************** 63. row ***************************
Variable_name: ft_max_word_len
Value: 84
*************************** 64. row ***************************
Variable_name: ft_min_word_len
Value: 4
*************************** 65. row ***************************
Variable_name: ft_query_expansion_limit
Value: 20
*************************** 66. row ***************************
Variable_name: ft_stopword_file
Value: (built-in)
*************************** 67. row ***************************
Variable_name: general_log
Value: OFF
*************************** 68. row ***************************
Variable_name: general_log_file
Value: /usr/local/mysql/data/crbtapp1.log
*************************** 69. row ***************************
Variable_name: group_concat_max_len
Value: 1024
*************************** 70. row ***************************
Variable_name: gtid_executed
Value:
*************************** 71. row ***************************
Variable_name: gtid_mode
Value: OFF
*************************** 72. row ***************************
Variable_name: gtid_next
Value: AUTOMATIC
*************************** 73. row ***************************
Variable_name: gtid_owned
Value:
*************************** 74. row ***************************
Variable_name: gtid_purged
Value:
*************************** 75. row ***************************
Variable_name: have_compress
Value: YES
*************************** 76. row ***************************
Variable_name: have_crypt
Value: YES
*************************** 77. row ***************************
Variable_name: have_dynamic_loading
Value: YES
*************************** 78. row ***************************
Variable_name: have_geometry
Value: YES
*************************** 79. row ***************************
Variable_name: have_openssl
Value: DISABLED
*************************** 80. row ***************************
Variable_name: have_profiling
Value: YES
*************************** 81. row ***************************
Variable_name: have_query_cache
Value: YES
*************************** 82. row ***************************
Variable_name: have_rtree_keys
Value: YES
*************************** 83. row ***************************
Variable_name: have_ssl
Value: DISABLED
*************************** 84. row ***************************
Variable_name: have_symlink
Value: YES
*************************** 85. row ***************************
Variable_name: host_cache_size
Value: 653
*************************** 86. row ***************************
Variable_name: hostname
Value: crbtapp1
*************************** 87. row ***************************
Variable_name: identity
Value: 0
*************************** 88. row ***************************
Variable_name: ignore_builtin_innodb
Value: OFF
*************************** 89. row ***************************
Variable_name: ignore_db_dirs
Value:
*************************** 90. row ***************************
Variable_name: init_connect
Value:
*************************** 91. row ***************************
Variable_name: init_file
Value:
*************************** 92. row ***************************
Variable_name: init_slave
Value:
*************************** 93. row ***************************
Variable_name: innodb_adaptive_flushing
Value: ON
*************************** 94. row ***************************
Variable_name: innodb_adaptive_flushing_lwm
Value: 10
*************************** 95. row ***************************
Variable_name: innodb_adaptive_hash_index
Value: ON
*************************** 96. row ***************************
Variable_name: innodb_additional_mem_pool_size
Value: 2097152
*************************** 97. row ***************************
Variable_name: innodb_api_bk_commit_interval
Value: 5
*************************** 98. row ***************************
Variable_name: innodb_api_disable_rowlock
Value: OFF
*************************** 99. row ***************************
Variable_name: innodb_api_enable_binlog
Value: OFF
*************************** 100. row ***************************
Variable_name: innodb_api_enable_mdl
Value: OFF
*************************** 101. row ***************************
Variable_name: innodb_api_trx_level
Value: 0
*************************** 102. row ***************************
Variable_name: innodb_autoextend_increment
Value: 64
*************************** 103. row ***************************
Variable_name: innodb_autoinc_lock_mode
Value: 1
*************************** 104. row ***************************
Variable_name: innodb_buffer_pool_dump_at_shutdown
Value: OFF
*************************** 105. row ***************************
Variable_name: innodb_buffer_pool_dump_now
Value: OFF
*************************** 106. row ***************************
Variable_name: innodb_buffer_pool_filename
Value: ib_buffer_pool
*************************** 107. row ***************************
Variable_name: innodb_buffer_pool_instances
Value: 1
*************************** 108. row ***************************
Variable_name: innodb_buffer_pool_load_abort
Value: OFF
*************************** 109. row ***************************
Variable_name: innodb_buffer_pool_load_at_startup
Value: OFF
*************************** 110. row ***************************
Variable_name: innodb_buffer_pool_load_now
Value: OFF
*************************** 111. row ***************************
Variable_name: innodb_buffer_pool_size
Value: 1572864000
*************************** 112. row ***************************
Variable_name: innodb_change_buffer_max_size
Value: 25
*************************** 113. row ***************************
Variable_name: innodb_change_buffering
Value: all
*************************** 114. row ***************************
Variable_name: innodb_checksum_algorithm
Value: innodb
*************************** 115. row ***************************
Variable_name: innodb_checksums
Value: ON
*************************** 116. row ***************************
Variable_name: innodb_cmp_per_index_enabled
Value: OFF
*************************** 117. row ***************************
Variable_name: innodb_commit_concurrency
Value: 0
*************************** 118. row ***************************
Variable_name: innodb_compression_failure_threshold_pct
Value: 5
*************************** 119. row ***************************
Variable_name: innodb_compression_level
Value: 6
*************************** 120. row ***************************
Variable_name: innodb_compression_pad_pct_max
Value: 50
*************************** 121. row ***************************
Variable_name: innodb_concurrency_tickets
Value: 5000
*************************** 122. row ***************************
Variable_name: innodb_data_file_path
Value: ibdata1:10M:autoextend
*************************** 123. row ***************************
Variable_name: innodb_data_home_dir
Value:
*************************** 124. row ***************************
Variable_name: innodb_disable_sort_file_cache
Value: OFF
*************************** 125. row ***************************
Variable_name: innodb_doublewrite
Value: ON
*************************** 126. row ***************************
Variable_name: innodb_fast_shutdown
Value: 1
*************************** 127. row ***************************
Variable_name: innodb_file_format
Value: Antelope
*************************** 128. row ***************************
Variable_name: innodb_file_format_check
Value: ON
*************************** 129. row ***************************
Variable_name: innodb_file_format_max
Value: Antelope
*************************** 130. row ***************************
Variable_name: innodb_file_per_table
Value: ON
*************************** 131. row ***************************
Variable_name: innodb_flush_log_at_timeout
Value: 1
*************************** 132. row ***************************
Variable_name: innodb_flush_log_at_trx_commit
Value: 1
*************************** 133. row ***************************
Variable_name: innodb_flush_method
Value:
*************************** 134. row ***************************
Variable_name: innodb_flush_neighbors
Value: 1
*************************** 135. row ***************************
Variable_name: innodb_flushing_avg_loops
Value: 30
*************************** 136. row ***************************
Variable_name: innodb_force_load_corrupted
Value: OFF
*************************** 137. row ***************************
Variable_name: innodb_force_recovery
Value: 0
*************************** 138. row ***************************
Variable_name: innodb_ft_aux_table
Value:
*************************** 139. row ***************************
Variable_name: innodb_ft_cache_size
Value: 8000000
*************************** 140. row ***************************
Variable_name: innodb_ft_enable_diag_print
Value: OFF
*************************** 141. row ***************************
Variable_name: innodb_ft_enable_stopword
Value: ON
*************************** 142. row ***************************
Variable_name: innodb_ft_max_token_size
Value: 84
*************************** 143. row ***************************
Variable_name: innodb_ft_min_token_size
Value: 3
*************************** 144. row ***************************
Variable_name: innodb_ft_num_word_optimize
Value: 2000
*************************** 145. row ***************************
Variable_name: innodb_ft_result_cache_limit
Value: 2000000000
*************************** 146. row ***************************
Variable_name: innodb_ft_server_stopword_table
Value:
*************************** 147. row ***************************
Variable_name: innodb_ft_sort_pll_degree
Value: 2
*************************** 148. row ***************************
Variable_name: innodb_ft_total_cache_size
Value: 640000000
*************************** 149. row ***************************
Variable_name: innodb_ft_user_stopword_table
Value:
*************************** 150. row ***************************
Variable_name: innodb_io_capacity
Value: 200
*************************** 151. row ***************************
Variable_name: innodb_io_capacity_max
Value: 2000
*************************** 152. row ***************************
Variable_name: innodb_large_prefix
Value: OFF
*************************** 153. row ***************************
Variable_name: innodb_lock_wait_timeout
Value: 50
*************************** 154. row ***************************
Variable_name: innodb_locks_unsafe_for_binlog
Value: OFF
*************************** 155. row ***************************
Variable_name: innodb_log_buffer_size
Value: 8388608
*************************** 156. row ***************************
Variable_name: innodb_log_compressed_pages
Value: ON
*************************** 157. row ***************************
Variable_name: innodb_log_file_size
Value: 68157440
*************************** 158. row ***************************
Variable_name: innodb_log_files_in_group
Value: 2
*************************** 159. row ***************************
Variable_name: innodb_log_group_home_dir
Value: /data/mysql/data
*************************** 160. row ***************************
Variable_name: innodb_lru_scan_depth
Value: 1024
*************************** 161. row ***************************
Variable_name: innodb_max_dirty_pages_pct
Value: 75
*************************** 162. row ***************************
Variable_name: innodb_max_dirty_pages_pct_lwm
Value: 0
*************************** 163. row ***************************
Variable_name: innodb_max_purge_lag
Value: 0
*************************** 164. row ***************************
Variable_name: innodb_max_purge_lag_delay
Value: 0
*************************** 165. row ***************************
Variable_name: innodb_mirrored_log_groups
Value: 1
*************************** 166. row ***************************
Variable_name: innodb_monitor_disable
Value:
*************************** 167. row ***************************
Variable_name: innodb_monitor_enable
Value:
*************************** 168. row ***************************
Variable_name: innodb_monitor_reset
Value:
*************************** 169. row ***************************
Variable_name: innodb_monitor_reset_all
Value:
*************************** 170. row ***************************
Variable_name: innodb_old_blocks_pct
Value: 37
*************************** 171. row ***************************
Variable_name: innodb_old_blocks_time
Value: 1000
*************************** 172. row ***************************
Variable_name: innodb_online_alter_log_max_size
Value: 134217728
*************************** 173. row ***************************
Variable_name: innodb_open_files
Value: 300
*************************** 174. row ***************************
Variable_name: innodb_optimize_fulltext_only
Value: OFF
*************************** 175. row ***************************
Variable_name: innodb_page_size
Value: 16384
*************************** 176. row ***************************
Variable_name: innodb_print_all_deadlocks
Value: OFF
*************************** 177. row ***************************
Variable_name: innodb_purge_batch_size
Value: 300
*************************** 178. row ***************************
Variable_name: innodb_purge_threads
Value: 1
*************************** 179. row ***************************
Variable_name: innodb_random_read_ahead
Value: OFF
*************************** 180. row ***************************
Variable_name: innodb_read_ahead_threshold
Value: 56
*************************** 181. row ***************************
Variable_name: innodb_read_io_threads
Value: 4
*************************** 182. row ***************************
Variable_name: innodb_read_only
Value: OFF
*************************** 183. row ***************************
Variable_name: innodb_replication_delay
Value: 0
*************************** 184. row ***************************
Variable_name: innodb_rollback_on_timeout
Value: OFF
*************************** 185. row ***************************
Variable_name: innodb_rollback_segments
Value: 128
*************************** 186. row ***************************
Variable_name: innodb_sort_buffer_size
Value: 1048576
*************************** 187. row ***************************
Variable_name: innodb_spin_wait_delay
Value: 6
*************************** 188. row ***************************
Variable_name: innodb_stats_auto_recalc
Value: ON
*************************** 189. row ***************************
Variable_name: innodb_stats_method
Value: nulls_equal
*************************** 190. row ***************************
Variable_name: innodb_stats_on_metadata
Value: OFF
*************************** 191. row ***************************
Variable_name: innodb_stats_persistent
Value: ON
*************************** 192. row ***************************
Variable_name: innodb_stats_persistent_sample_pages
Value: 20
*************************** 193. row ***************************
Variable_name: innodb_stats_sample_pages
Value: 8
*************************** 194. row ***************************
Variable_name: innodb_stats_transient_sample_pages
Value: 8
*************************** 195. row ***************************
Variable_name: innodb_status_output
Value: OFF
*************************** 196. row ***************************
Variable_name: innodb_status_output_locks
Value: OFF
*************************** 197. row ***************************
Variable_name: innodb_strict_mode
Value: OFF
*************************** 198. row ***************************
Variable_name: innodb_support_xa
Value: ON
*************************** 199. row ***************************
Variable_name: innodb_sync_array_size
Value: 1
*************************** 200. row ***************************
Variable_name: innodb_sync_spin_loops
Value: 30
*************************** 201. row ***************************
Variable_name: innodb_table_locks
Value: ON
*************************** 202. row ***************************
Variable_name: innodb_thread_concurrency
Value: 0
*************************** 203. row ***************************
Variable_name: innodb_thread_sleep_delay
Value: 10000
*************************** 204. row ***************************
Variable_name: innodb_tmpdir
Value:
*************************** 205. row ***************************
Variable_name: innodb_undo_directory
Value: .
*************************** 206. row ***************************
Variable_name: innodb_undo_logs
Value: 128
*************************** 207. row ***************************
Variable_name: innodb_undo_tablespaces
Value: 0
*************************** 208. row ***************************
Variable_name: innodb_use_native_aio
Value: ON
*************************** 209. row ***************************
Variable_name: innodb_use_sys_malloc
Value: ON
*************************** 210. row ***************************
Variable_name: innodb_version
Value: 5.6.31
*************************** 211. row ***************************
Variable_name: innodb_write_io_threads
Value: 4
*************************** 212. row ***************************
Variable_name: insert_id
Value: 0
*************************** 213. row ***************************
Variable_name: interactive_timeout
Value: 3600
*************************** 214. row ***************************
Variable_name: join_buffer_size
Value: 262144
*************************** 215. row ***************************
Variable_name: keep_files_on_create
Value: OFF
*************************** 216. row ***************************
Variable_name: key_buffer_size
Value: 16384
*************************** 217. row ***************************
Variable_name: key_cache_age_threshold
Value: 300
*************************** 218. row ***************************
Variable_name: key_cache_block_size
Value: 1024
*************************** 219. row ***************************
Variable_name: key_cache_division_limit
Value: 100
*************************** 220. row ***************************
Variable_name: large_files_support
Value: ON
*************************** 221. row ***************************
Variable_name: large_page_size
Value: 0
*************************** 222. row ***************************
Variable_name: large_pages
Value: OFF
*************************** 223. row ***************************
Variable_name: last_insert_id
Value: 0
*************************** 224. row ***************************
Variable_name: lc_messages
Value: en_US
*************************** 225. row ***************************
Variable_name: lc_messages_dir
Value: /usr/local/mysql-advanced-5.6.31-linux-glibc2.5-i686/share/
*************************** 226. row ***************************
Variable_name: lc_time_names
Value: en_US
*************************** 227. row ***************************
Variable_name: license
Value: Commercial
*************************** 228. row ***************************
Variable_name: local_infile
Value: ON
*************************** 229. row ***************************
Variable_name: lock_wait_timeout
Value: 31536000
*************************** 230. row ***************************
Variable_name: locked_in_memory
Value: OFF
*************************** 231. row ***************************
Variable_name: log_bin
Value: ON
*************************** 232. row ***************************
Variable_name: log_bin_basename
Value: /usr/local/mysql/data/mypid-bin
*************************** 233. row ***************************
Variable_name: log_bin_index
Value: /usr/local/mysql/data/mypid-bin.index
*************************** 234. row ***************************
Variable_name: log_bin_trust_function_creators
Value: OFF
*************************** 235. row ***************************
Variable_name: log_bin_use_v1_row_events
Value: OFF
*************************** 236. row ***************************
Variable_name: log_error
Value: /usr/local/mysql/data/crbtapp1.err
*************************** 237. row ***************************
Variable_name: log_output
Value: FILE
*************************** 238. row ***************************
Variable_name: log_queries_not_using_indexes
Value: OFF
*************************** 239. row ***************************
Variable_name: log_slave_updates
Value: OFF
*************************** 240. row ***************************
Variable_name: log_slow_admin_statements
Value: OFF
*************************** 241. row ***************************
Variable_name: log_slow_slave_statements
Value: OFF
*************************** 242. row ***************************
Variable_name: log_throttle_queries_not_using_indexes
Value: 0
*************************** 243. row ***************************
Variable_name: log_warnings
Value: 1
*************************** 244. row ***************************
Variable_name: long_query_time
Value: 10.000000
*************************** 245. row ***************************
Variable_name: low_priority_updates
Value: OFF
*************************** 246. row ***************************
Variable_name: lower_case_file_system
Value: OFF
*************************** 247. row ***************************
Variable_name: lower_case_table_names
Value: 1
*************************** 248. row ***************************
Variable_name: master_info_repository
Value: FILE
*************************** 249. row ***************************
Variable_name: master_verify_checksum
Value: OFF
*************************** 250. row ***************************
Variable_name: max_allowed_packet
Value: 1048576
*************************** 251. row ***************************
Variable_name: max_binlog_cache_size
Value: 18446744073709547520
*************************** 252. row ***************************
Variable_name: max_binlog_size
Value: 1073741824
*************************** 253. row ***************************
Variable_name: max_binlog_stmt_cache_size
Value: 18446744073709547520
*************************** 254. row ***************************
Variable_name: max_connect_errors
Value: 100
*************************** 255. row ***************************
Variable_name: max_connections
Value: 1000
*************************** 256. row ***************************
Variable_name: max_delayed_threads
Value: 20
*************************** 257. row ***************************
Variable_name: max_digest_length
Value: 1024
*************************** 258. row ***************************
Variable_name: max_error_count
Value: 64
*************************** 259. row ***************************
Variable_name: max_heap_table_size
Value: 16777216
*************************** 260. row ***************************
Variable_name: max_insert_delayed_threads
Value: 20
*************************** 261. row ***************************
Variable_name: max_join_size
Value: 18446744073709551615
*************************** 262. row ***************************
Variable_name: max_length_for_sort_data
Value: 1024
*************************** 263. row ***************************
Variable_name: max_prepared_stmt_count
Value: 16382
*************************** 264. row ***************************
Variable_name: max_relay_log_size
Value: 0
*************************** 265. row ***************************
Variable_name: max_seeks_for_key
Value: 4294967295
*************************** 266. row ***************************
Variable_name: max_sort_length
Value: 1024
*************************** 267. row ***************************
Variable_name: max_sp_recursion_depth
Value: 0
*************************** 268. row ***************************
Variable_name: max_tmp_tables
Value: 32
*************************** 269. row ***************************
Variable_name: max_user_connections
Value: 0
*************************** 270. row ***************************
Variable_name: max_write_lock_count
Value: 4294967295
*************************** 271. row ***************************
Variable_name: metadata_locks_cache_size
Value: 1024
*************************** 272. row ***************************
Variable_name: metadata_locks_hash_instances
Value: 8
*************************** 273. row ***************************
Variable_name: min_examined_row_limit
Value: 0
*************************** 274. row ***************************
Variable_name: multi_range_count
Value: 256
*************************** 275. row ***************************
Variable_name: myisam_data_pointer_size
Value: 6
*************************** 276. row ***************************
Variable_name: myisam_max_sort_file_size
Value: 2146435072
*************************** 277. row ***************************
Variable_name: myisam_mmap_size
Value: 4294967295
*************************** 278. row ***************************
Variable_name: myisam_recover_options
Value: OFF
*************************** 279. row ***************************
Variable_name: myisam_repair_threads
Value: 1
*************************** 280. row ***************************
Variable_name: myisam_sort_buffer_size
Value: 8388608
*************************** 281. row ***************************
Variable_name: myisam_stats_method
Value: nulls_unequal
*************************** 282. row ***************************
Variable_name: myisam_use_mmap
Value: OFF
*************************** 283. row ***************************
Variable_name: net_buffer_length
Value: 2048
*************************** 284. row ***************************
Variable_name: net_read_timeout
Value: 30
*************************** 285. row ***************************
Variable_name: net_retry_count
Value: 10
*************************** 286. row ***************************
Variable_name: net_write_timeout
Value: 60
*************************** 287. row ***************************
Variable_name: new
Value: OFF
*************************** 288. row ***************************
Variable_name: old
Value: OFF
*************************** 289. row ***************************
Variable_name: old_alter_table
Value: OFF
*************************** 290. row ***************************
Variable_name: old_passwords
Value: 0
*************************** 291. row ***************************
Variable_name: open_files_limit
Value: 200000
*************************** 292. row ***************************
Variable_name: optimizer_prune_level
Value: 1
*************************** 293. row ***************************
Variable_name: optimizer_search_depth
Value: 62
*************************** 294. row ***************************
Variable_name: optimizer_switch
Value: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on
*************************** 295. row ***************************
Variable_name: optimizer_trace
Value: enabled=off,one_line=off
*************************** 296. row ***************************
Variable_name: optimizer_trace_features
Value: greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
*************************** 297. row ***************************
Variable_name: optimizer_trace_limit
Value: 1
*************************** 298. row ***************************
Variable_name: optimizer_trace_max_mem_size
Value: 16384
*************************** 299. row ***************************
Variable_name: optimizer_trace_offset
Value: -1
*************************** 300. row ***************************
Variable_name: performance_schema
Value: ON
*************************** 301. row ***************************
Variable_name: performance_schema_accounts_size
Value: 100
*************************** 302. row ***************************
Variable_name: performance_schema_digests_size
Value: 10000
*************************** 303. row ***************************
Variable_name: performance_schema_events_stages_history_long_size
Value: 10000
*************************** 304. row ***************************
Variable_name: performance_schema_events_stages_history_size
Value: 10
*************************** 305. row ***************************
Variable_name: performance_schema_events_statements_history_long_size
Value: 10000
*************************** 306. row ***************************
Variable_name: performance_schema_events_statements_history_size
Value: 10
*************************** 307. row ***************************
Variable_name: performance_schema_events_waits_history_long_size
Value: 10000
*************************** 308. row ***************************
Variable_name: performance_schema_events_waits_history_size
Value: 10
*************************** 309. row ***************************
Variable_name: performance_schema_hosts_size
Value: 100
*************************** 310. row ***************************
Variable_name: performance_schema_max_cond_classes
Value: 80
*************************** 311. row ***************************
Variable_name: performance_schema_max_cond_instances
Value: 4904
*************************** 312. row ***************************
Variable_name: performance_schema_max_digest_length
Value: 1024
*************************** 313. row ***************************
Variable_name: performance_schema_max_file_classes
Value: 50
*************************** 314. row ***************************
Variable_name: performance_schema_max_file_handles
Value: 32768
*************************** 315. row ***************************
Variable_name: performance_schema_max_file_instances
Value: 7693
*************************** 316. row ***************************
Variable_name: performance_schema_max_mutex_classes
Value: 200
*************************** 317. row ***************************
Variable_name: performance_schema_max_mutex_instances
Value: 11020
*************************** 318. row ***************************
Variable_name: performance_schema_max_rwlock_classes
Value: 40
*************************** 319. row ***************************
Variable_name: performance_schema_max_rwlock_instances
Value: 4812
*************************** 320. row ***************************
Variable_name: performance_schema_max_socket_classes
Value: 10
*************************** 321. row ***************************
Variable_name: performance_schema_max_socket_instances
Value: 2020
*************************** 322. row ***************************
Variable_name: performance_schema_max_stage_classes
Value: 150
*************************** 323. row ***************************
Variable_name: performance_schema_max_statement_classes
Value: 168
*************************** 324. row ***************************
Variable_name: performance_schema_max_table_handles
Value: 8
*************************** 325. row ***************************
Variable_name: performance_schema_max_table_instances
Value: 12500
*************************** 326. row ***************************
Variable_name: performance_schema_max_thread_classes
Value: 50
*************************** 327. row ***************************
Variable_name: performance_schema_max_thread_instances
Value: 2100
*************************** 328. row ***************************
Variable_name: performance_schema_session_connect_attrs_size
Value: 512
*************************** 329. row ***************************
Variable_name: performance_schema_setup_actors_size
Value: 100
*************************** 330. row ***************************
Variable_name: performance_schema_setup_objects_size
Value: 100
*************************** 331. row ***************************
Variable_name: performance_schema_users_size
Value: 100
*************************** 332. row ***************************
Variable_name: pid_file
Value: /usr/local/mysql/data/crbtapp1.pid
*************************** 333. row ***************************
Variable_name: plugin_dir
Value: /usr/local/mysql/lib/plugin/
*************************** 334. row ***************************
Variable_name: port
Value: 3306
*************************** 335. row ***************************
Variable_name: preload_buffer_size
Value: 32768
*************************** 336. row ***************************
Variable_name: profiling
Value: OFF
*************************** 337. row ***************************
Variable_name: profiling_history_size
Value: 15
*************************** 338. row ***************************
Variable_name: protocol_version
Value: 10
*************************** 339. row ***************************
Variable_name: proxy_user
Value:
*************************** 340. row ***************************
Variable_name: pseudo_slave_mode
Value: OFF
*************************** 341. row ***************************
Variable_name: pseudo_thread_id
Value: 4835163
*************************** 342. row ***************************
Variable_name: query_alloc_block_size
Value: 8192
*************************** 343. row ***************************
Variable_name: query_cache_limit
Value: 1048576
*************************** 344. row ***************************
Variable_name: query_cache_min_res_unit
Value: 4096
*************************** 345. row ***************************
Variable_name: query_cache_size
Value: 1048576
*************************** 346. row ***************************
Variable_name: query_cache_type
Value: OFF
*************************** 347. row ***************************
Variable_name: query_cache_wlock_invalidate
Value: OFF
*************************** 348. row ***************************
Variable_name: query_prealloc_size
Value: 8192
*************************** 349. row ***************************
Variable_name: rand_seed1
Value: 0
*************************** 350. row ***************************
Variable_name: rand_seed2
Value: 0
*************************** 351. row ***************************
Variable_name: range_alloc_block_size
Value: 4096
*************************** 352. row ***************************
Variable_name: read_buffer_size
Value: 262144
*************************** 353. row ***************************
Variable_name: read_only
Value: OFF
*************************** 354. row ***************************
Variable_name: read_rnd_buffer_size
Value: 262144
*************************** 355. row ***************************
Variable_name: relay_log
Value:
*************************** 356. row ***************************
Variable_name: relay_log_basename
Value:
*************************** 357. row ***************************
Variable_name: relay_log_index
Value:
*************************** 358. row ***************************
Variable_name: relay_log_info_file
Value: relay-log.info
*************************** 359. row ***************************
Variable_name: relay_log_info_repository
Value: FILE
*************************** 360. row ***************************
Variable_name: relay_log_purge
Value: ON
*************************** 361. row ***************************
Variable_name: relay_log_recovery
Value: OFF
*************************** 362. row ***************************
Variable_name: relay_log_space_limit
Value: 0
*************************** 363. row ***************************
Variable_name: report_host
Value:
*************************** 364. row ***************************
Variable_name: report_password
Value:
*************************** 365. row ***************************
Variable_name: report_port
Value: 3306
*************************** 366. row ***************************
Variable_name: report_user
Value:
*************************** 367. row ***************************
Variable_name: rpl_stop_slave_timeout
Value: 31536000
*************************** 368. row ***************************
Variable_name: secure_auth
Value: OFF
*************************** 369. row ***************************
Variable_name: secure_file_priv
Value:
*************************** 370. row ***************************
Variable_name: server_id
Value: 2
*************************** 371. row ***************************
Variable_name: server_id_bits
Value: 32
*************************** 372. row ***************************
Variable_name: server_uuid
Value: 9e750793-dbdf-11e8-b748-3c4a92eb97b8
*************************** 373. row ***************************
Variable_name: sha256_password_private_key_path
Value: private_key.pem
*************************** 374. row ***************************
Variable_name: sha256_password_public_key_path
Value: public_key.pem
*************************** 375. row ***************************
Variable_name: show_old_temporals
Value: OFF
*************************** 376. row ***************************
Variable_name: simplified_binlog_gtid_recovery
Value: OFF
*************************** 377. row ***************************
Variable_name: skip_external_locking
Value: ON
*************************** 378. row ***************************
Variable_name: skip_name_resolve
Value: ON
*************************** 379. row ***************************
Variable_name: skip_networking
Value: OFF
*************************** 380. row ***************************
Variable_name: skip_show_database
Value: OFF
*************************** 381. row ***************************
Variable_name: slave_allow_batching
Value: OFF
*************************** 382. row ***************************
Variable_name: slave_checkpoint_group
Value: 512
*************************** 383. row ***************************
Variable_name: slave_checkpoint_period
Value: 300
*************************** 384. row ***************************
Variable_name: slave_compressed_protocol
Value: OFF
*************************** 385. row ***************************
Variable_name: slave_exec_mode
Value: STRICT
*************************** 386. row ***************************
Variable_name: slave_load_tmpdir
Value: /tmp
*************************** 387. row ***************************
Variable_name: slave_max_allowed_packet
Value: 1073741824
*************************** 388. row ***************************
Variable_name: slave_net_timeout
Value: 3600
*************************** 389. row ***************************
Variable_name: slave_parallel_workers
Value: 0
*************************** 390. row ***************************
Variable_name: slave_pending_jobs_size_max
Value: 16777216
*************************** 391. row ***************************
Variable_name: slave_rows_search_algorithms
Value: TABLE_SCAN,INDEX_SCAN
*************************** 392. row ***************************
Variable_name: slave_skip_errors
Value: OFF
*************************** 393. row ***************************
Variable_name: slave_sql_verify_checksum
Value: ON
*************************** 394. row ***************************
Variable_name: slave_transaction_retries
Value: 10
*************************** 395. row ***************************
Variable_name: slave_type_conversions
Value:
*************************** 396. row ***************************
Variable_name: slow_launch_time
Value: 2
*************************** 397. row ***************************
Variable_name: slow_query_log
Value: OFF
*************************** 398. row ***************************
Variable_name: slow_query_log_file
Value: /usr/local/mysql/data/crbtapp1-slow.log
*************************** 399. row ***************************
Variable_name: socket
Value: /tmp/mysql.sock
*************************** 400. row ***************************
Variable_name: sort_buffer_size
Value: 65536
*************************** 401. row ***************************
Variable_name: sql_auto_is_null
Value: OFF
*************************** 402. row ***************************
Variable_name: sql_big_selects
Value: ON
*************************** 403. row ***************************
Variable_name: sql_buffer_result
Value: OFF
*************************** 404. row ***************************
Variable_name: sql_log_bin
Value: ON
*************************** 405. row ***************************
Variable_name: sql_log_off
Value: OFF
*************************** 406. row ***************************
Variable_name: sql_mode
Value: NO_ENGINE_SUBSTITUTION
*************************** 407. row ***************************
Variable_name: sql_notes
Value: ON
*************************** 408. row ***************************
Variable_name: sql_quote_show_create
Value: ON
*************************** 409. row ***************************
Variable_name: sql_safe_updates
Value: OFF
*************************** 410. row ***************************
Variable_name: sql_select_limit
Value: 18446744073709551615
*************************** 411. row ***************************
Variable_name: sql_slave_skip_counter
Value: 0
*************************** 412. row ***************************
Variable_name: sql_warnings
Value: OFF
*************************** 413. row ***************************
Variable_name: ssl_ca
Value:
*************************** 414. row ***************************
Variable_name: ssl_capath
Value:
*************************** 415. row ***************************
Variable_name: ssl_cert
Value:
*************************** 416. row ***************************
Variable_name: ssl_cipher
Value:
*************************** 417. row ***************************
Variable_name: ssl_crl
Value:
*************************** 418. row ***************************
Variable_name: ssl_crlpath
Value:
*************************** 419. row ***************************
Variable_name: ssl_key
Value:
*************************** 420. row ***************************
Variable_name: storage_engine
Value: InnoDB
*************************** 421. row ***************************
Variable_name: stored_program_cache
Value: 256
*************************** 422. row ***************************
Variable_name: sync_binlog
Value: 0
*************************** 423. row ***************************
Variable_name: sync_frm
Value: ON
*************************** 424. row ***************************
Variable_name: sync_master_info
Value: 10000
*************************** 425. row ***************************
Variable_name: sync_relay_log
Value: 10000
*************************** 426. row ***************************
Variable_name: sync_relay_log_info
Value: 10000
*************************** 427. row ***************************
Variable_name: system_time_zone
Value: WAT
*************************** 428. row ***************************
Variable_name: table_definition_cache
Value: 402
*************************** 429. row ***************************
Variable_name: table_open_cache
Value: 4
*************************** 430. row ***************************
Variable_name: table_open_cache_instances
Value: 1
*************************** 431. row ***************************
Variable_name: thread_cache_size
Value: 18
*************************** 432. row ***************************
Variable_name: thread_concurrency
Value: 10
*************************** 433. row ***************************
Variable_name: thread_handling
Value: one-thread-per-connection
*************************** 434. row ***************************
Variable_name: thread_stack
Value: 1310720
*************************** 435. row ***************************
Variable_name: time_format
Value: %H:%i:%s
*************************** 436. row ***************************
Variable_name: time_zone
Value: SYSTEM
*************************** 437. row ***************************
Variable_name: timed_mutexes
Value: OFF
*************************** 438. row ***************************
Variable_name: timestamp
Value: 1574407102.793452
*************************** 439. row ***************************
Variable_name: tmp_table_size
Value: 16777216
*************************** 440. row ***************************
Variable_name: tmpdir
Value: /tmp
*************************** 441. row ***************************
Variable_name: transaction_alloc_block_size
Value: 8192
*************************** 442. row ***************************
Variable_name: transaction_allow_batching
Value: OFF
*************************** 443. row ***************************
Variable_name: transaction_prealloc_size
Value: 4096
*************************** 444. row ***************************
Variable_name: tx_isolation
Value: READ-COMMITTED
*************************** 445. row ***************************
Variable_name: tx_read_only
Value: OFF
*************************** 446. row ***************************
Variable_name: unique_checks
Value: ON
*************************** 447. row ***************************
Variable_name: updatable_views_with_limit
Value: YES
*************************** 448. row ***************************
Variable_name: version
Value: 5.6.31-enterprise-commercial-advanced-log
*************************** 449. row ***************************
Variable_name: version_comment
Value: MySQL Enterprise Server - Advanced Edition (Commercial)
*************************** 450. row ***************************
Variable_name: version_compile_machine
Value: i686
*************************** 451. row ***************************
Variable_name: version_compile_os
Value: linux-glibc2.5
*************************** 452. row ***************************
Variable_name: wait_timeout
Value: 3600
*************************** 453. row ***************************

Options: ReplyQuote


Subject
Written By
Posted
November 21, 2019 01:20AM
November 21, 2019 10:49AM
Re: mysql out of memory
November 22, 2019 01:30AM
November 22, 2019 12:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.