Hi Elena,
Could you please test the below? The changed code may affect
- queries that use GROUP BY/ORDER BY/DISTINCT, or a combination of those.
- correlated/uncorrelated subqueries. The subquery should remain a separate
SELECT, i.e. it should not be converted into semi-join or optimized away.
- combination of the above.
The code adds a cleanup, so I expect a possible problem to be where we cleaned
up something we shouldn't have. Most likely effects are either crash or wrong
result. I don't think this patch has a chance of introducing a memory leak.
----- Forwarded message from "Sergei Petrunia (JIRA)"
memory leak in 5.5.32-MariaDB-1~wheezy-log ------------------------------------------
Key: MDEV-4974 URL: https://mariadb.atlassian.net/browse/MDEV-4974 Project: MariaDB Development Issue Type: Bug Affects Versions: 5.5.32 Environment: Debian Wheezy x86_64 Linux greeneggs.lentz.com.au 3.9.3-x86_64-linode33 #1 SMP Mon May 20 10:22:57 EDT 2013 x86_64 GNU/Linux Reporter: Daniel Black Assignee: Sergei Petrunia Priority: Critical Fix For: 5.5.35
Attachments: allqueries.sql, catinthehat_memory-day_no_indexmerge.png, drupal.sql, green-eggs-mysql_connections-day.png, greeneggs-memory-day.png, greeneggs-memory-week.png, greeneggs-mysql_bin_relay_log-day.png, greeneggs-mysql_commands-day.png, greeneggs-mysql_files_tables-day.png, greeneggs-mysql_innodb_bpool-day.png, greeneggs-mysql_innodb_semaphores-day.png, greeneggs-mysql_innodb_tnx-day.png, greeneggs-mysql_myisam_indexes-day.png, greeneggs-mysql_qcache-day.png, greeneggs-mysql_select_types-day.png, greeneggs-mysql_sorts-day.png, greeneggs-mysql_table_locks-day.png, greeneggs-mysql_tmp_tables-day.png, leaks-track-allqueries.sql, leaks-track.sql, psergey-fix-mdev4954.diff, psergey-mdev4974-xpl1.diff, valgrind.mysqld.27336
After running mariadb-5.5.32 in a multimaster for a few days its almost out of memory on the active master (the one getting all the reads). The replication slave (same version) doesn't suffer the memory leak (with or without the replication filters defined). Disabling the query cache on the active master may (was slightly off peak) have slowed the memory leak however it wasn't stopped. In the graph attached the query cache was disabled from Wed 5:30 to Thursday 03:00 For greeneggs-mysql_commands-day.png the first drop is when query cache was turned back on. At the end I moved the active master to the other server. Other graphs are for this same time interval. Memory usage calculation: From http://dev.mysql.com/doc/refman/5.5/en/memory-use.html per connection: @read_buffer_size + @read_rnd_buffer_size + @sort_buffer_size + @join_buffer_size + @binlog_cache_size + @thread_stack + @@tmp_table_size = 19070976 Max_used_connections 15 Static component: @key_buffer_size + @query_cache_size + @innodb_buffer_pool_size + @innodb_additional_mem_pool_size + @@innodb_log_buffer_size 322961408 select 15 * 19070976 + 322961408; = 609026048 609M max From top: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 4532 mysql 20 0 1999m 1.4g 6072 S 4.0 71.9 1017:21 mysqld I've still got the server running if more status is required. show engine innodb status ===================================== 130830 0:46:23 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 17 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 372124 1_second, 372076 sleeps, 37113 10_second, 1716 background, 1715 flush srv_master_thread log flush and writes: 350597 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 999301, signal count 1149136 Mutex spin waits 3647275, rounds 12020660, OS waits 198769 RW-shared spins 896419, rounds 19893071, OS waits 574516 RW-excl spins 68006, rounds 6887165, OS waits 204958 Spin rounds per wait: 3.30 mutex, 22.19 RW-shared, 101.27 RW-excl -------- 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 (write thread) I/O thread 5 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0] , aio writes: 0 [0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 7906118 OS file reads, 39186717 OS file writes, 23493355 OS fsyncs 0.65 reads/s, 16384 avg bytes/read, 66.29 writes/s, 29.06 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 287, seg size 289, 111478 merges merged operations: insert 106175, delete mark 100854, delete 13481 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 553229, node heap has 584 buffer(s) 244.87 hash searches/s, 22.53 non-hash searches/s --- LOG --- Log sequence number 1981376581482 Log flushed up to 1981376581482 Last checkpoint at 1981376562791 Max checkpoint age 84223550 Checkpoint age target 81591565 Modified age 18691 Checkpoint age 18691 0 pending log writes, 0 pending chkp writes 22419510 log i/o's done, 26.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 275644416; in additional pool allocated 0 Total memory allocated by read views 136 Internal hash tables (constant factor + variable factor) Adaptive hash index 13998304 (4425832 + 9572472) Page hash 277432 (buffer pool 0 only) Dictionary cache 10287074 (1107952 + 9179122) File system 648160 (82672 + 565488) Lock system 665688 (664936 + 752) Recovery system 0 (0 + 0) Dictionary memory allocated 9179122 Buffer pool size 16383 Buffer pool size, bytes 268419072 Free buffers 1 Database pages 15798 Old database pages 5811 Modified db pages 97 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 10760065, not young 0 0.53 youngs/s, 0.00 non-youngs/s Pages read 7903370, created 882751, written 16452888 0.65 reads/s, 0.00 creates/s, 39.47 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: 15798, unzip_LRU len: 0 I/O sum[1550]:cur[322], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB 0 transactions active inside InnoDB 0 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 7D2D2F07 Read view up limit trx id 7D2D2F07 Read view low limit trx id 7D2D2F07 Read view individually stored trx ids: ----------------- Main thread process no. 4532, id 140201824495360, state: sleeping Number of rows inserted 1308400, updated 9736429, deleted 1227755, read 34888786828 1.00 inserts/s, 11.71 updates/s, 0.00 deletes/s, 249.22 reads/s ------------------------ LATEST DETECTED DEADLOCK ------------------------ 130830 0:27:15 *** (1) TRANSACTION: TRANSACTION 7D2C63D3, ACTIVE 0 sec starting index read | Variable_name | Value | | Aborted_clients | 57 | | Aborted_connects | 0 | | Access_denied_errors | 0 | | Aria_pagecache_blocks_not_flushed | 0 | | Aria_pagecache_blocks_unused | 15737 | | Aria_pagecache_blocks_used | 3127 | | Aria_pagecache_read_requests | 262055553 | | Aria_pagecache_reads | 107163 | | Aria_pagecache_write_requests | 69866678 | | Aria_pagecache_writes | 0 | | Aria_transaction_log_syncs | 0 | | Binlog_commits | 12529081 | | Binlog_group_commits | 12486299 | | Binlog_snapshot_file | mariadb-bin.001408 | | Binlog_snapshot_position | 57228334 | | Binlog_bytes_written | 43273655871 | | Binlog_cache_disk_use | 768128 | | Binlog_cache_use | 12510967 | | Binlog_stmt_cache_disk_use | 24 | | Binlog_stmt_cache_use | 18077 | | Busy_time | 0.000000 | | Bytes_received | 60129853267 | | Bytes_sent | 691695773018 | | Com_admin_commands | 3809 | | Com_assign_to_keycache | 0 | | Com_alter_db | 0 | | Com_alter_db_upgrade | 0 | | Com_alter_event | 0 | | Com_alter_function | 0 | | Com_alter_procedure | 0 | | Com_alter_server | 0 | | Com_alter_table | 114 | | Com_alter_tablespace | 0 | | Com_analyze | 0 | | Com_begin | 62278 | | Com_binlog | 0 | | Com_call_procedure | 0 | | Com_change_db | 69728 | | Com_change_master | 0 | | Com_check | 1426 | | Com_checksum | 0 | | Com_commit | 45717 | | Com_create_db | 1 | | Com_create_event | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_procedure | 1 | | Com_create_server | 0 | | Com_create_table | 42 | | Com_create_trigger | 0 | | Com_create_udf | 0 | | Com_create_user | 0 | | Com_create_view | 0 | | Com_dealloc_sql | 24 | | Com_delete | 388136 | | Com_delete_multi | 5 | | Com_do | 0 | | Com_drop_db | 1 | | Com_drop_event | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_procedure | 2 | | Com_drop_server | 0 | | Com_drop_table | 1 | | Com_drop_trigger | 0 | | Com_drop_user | 0 | | Com_drop_view | 0 | | Com_empty_query | 0 | | Com_execute_sql | 24 | | Com_flush | 6 | | Com_grant | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 2 | | Com_insert | 847948 | | Com_insert_select | 551 | | Com_install_plugin | 0 | | Com_kill | 50 | | Com_load | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 24 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_release_savepoint | 0 | | Com_rename_table | 0 | | Com_rename_user | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_resignal | 0 | | Com_revoke | 0 | | Com_revoke_all | 0 | | Com_rollback | 3 | | Com_rollback_to_savepoint | 0 | | Com_savepoint | 0 | | Com_select | 47174988 | | Com_set_option | 1189075 | | Com_signal | 0 | | Com_show_authors | 0 | | Com_show_binlog_events | 3 | | Com_show_binlogs | 1166 | | Com_show_charsets | 0 | | Com_show_client_statistics | 0 | | Com_show_collations | 0 | | Com_show_contributors | 0 | | Com_show_create_db | 115 | | Com_show_create_event | 0 | | Com_show_create_func | 0 | | Com_show_create_proc | 0 | | Com_show_create_table | 4387 | | Com_show_create_trigger | 0 | | Com_show_databases | 7 | | Com_show_engine_logs | 0 | | Com_show_engine_mutex | 0 | | Com_show_engine_status | 1167 | | Com_show_events | 0 | | Com_show_errors | 0 | | Com_show_fields | 5721 | | Com_show_function_status | 0 | | Com_show_grants | 0 | | Com_show_keys | 0 | | Com_show_index_statistics | 0 | | Com_show_master_status | 1 | | Com_show_open_tables | 0 | | Com_show_plugins | 0 | | Com_show_privileges | 0 | | Com_show_procedure_status | 0 | | Com_show_processlist | 1039 | | Com_show_profile | 0 | | Com_show_profiles | 0 | | Com_show_relaylog_events | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 140780 | | Com_show_status | 12670 | | Com_show_storage_engines | 0 | | Com_show_table_statistics | 0 | | Com_show_table_status | 4287 | | Com_show_tables | 6794 | | Com_show_triggers | 4280 | | Com_show_user_statistics | 0 | | Com_show_variables | 2175 | | Com_show_warnings | 0 | | Com_slave_start | 10 | | Com_slave_stop | 4 | | Com_stmt_close | 24 | | Com_stmt_execute | 24 | | Com_stmt_fetch | 0 | | Com_stmt_prepare | 24 | | Com_stmt_reprepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_truncate | 0 | | Com_uninstall_plugin | 0 | | Com_unlock_tables | 2 | | Com_update | 7082015 | | Com_update_multi | 1 | | Com_xa_commit | 0 | | Com_xa_end | 0 | | Com_xa_prepare | 0 | | Com_xa_recover | 0 | | Com_xa_rollback | 0 | | Com_xa_start | 0 | | Compression | OFF | | Connections | 1164212 | | Cpu_time | 0.000000 | | Created_tmp_disk_tables | 2202858 | | Created_tmp_files | 420678 | | Created_tmp_tables | 5264753 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Empty_queries | 14900340 | | Executed_events | 0 | | Executed_triggers | 0 | | Feature_dynamic_columns | 0 | | Feature_fulltext | 2 | | Feature_gis | 28 | | Feature_locale | 0 | | Feature_subquery | 135848 | | Feature_timezone | 6850 | | Feature_trigger | 586 | | Feature_xml | 0 | | Flush_commands | 4 | | Handler_commit | 63318523 | | Handler_delete | 748245 | | Handler_discover | 0 | | Handler_icp_attempts | 71118314 | | Handler_icp_match | 71108704 | | Handler_mrr_init | 0 | | Handler_mrr_key_refills | 0 | | Handler_mrr_rowid_refills | 0 | | Handler_prepare | 14968970 | | Handler_read_first | 1155850 | | Handler_read_key | 466199920 | | Handler_read_last | 55346 | | Handler_read_next | 27258307498 | | Handler_read_prev | 8491322 | | Handler_read_rnd | 66364460 | | Handler_read_rnd_deleted | 1194 | | Handler_read_rnd_next | 8174479457 | | Handler_rollback | 21990 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_tmp_update | 15018397 | | Handler_tmp_write | 515819305 | | Handler_update | 6481729 | | Handler_write | 849123 | | Innodb_adaptive_hash_cells | 553229 | | Innodb_adaptive_hash_heap_buffers | 581 | | Innodb_adaptive_hash_hash_searches | 1107671046 | | Innodb_adaptive_hash_non_hash_searches | 249488632 | | Innodb_background_log_sync | 350697 | | Innodb_buffer_pool_pages_data | 15800 | | Innodb_buffer_pool_bytes_data | 258867200 | | Innodb_buffer_pool_pages_dirty | 295 | | Innodb_buffer_pool_bytes_dirty | 4833280 | | Innodb_buffer_pool_pages_flushed | 16456234 | | Innodb_buffer_pool_pages_LRU_flushed | 48422 | | Innodb_buffer_pool_pages_free | 1 | | Innodb_buffer_pool_pages_made_not_young | 0 | | Innodb_buffer_pool_pages_made_young | 10760117 | | Innodb_buffer_pool_pages_misc | 582 | | Innodb_buffer_pool_pages_old | 5812 | | Innodb_buffer_pool_pages_total | 16383 | | Innodb_buffer_pool_read_ahead_rnd | 0 | | Innodb_buffer_pool_read_ahead | 2072088 | | Innodb_buffer_pool_read_ahead_evicted | 91126 | | Innodb_buffer_pool_read_requests | 10973288017 | | Innodb_buffer_pool_reads | 5715842 | | Innodb_buffer_pool_wait_free | 9 | | Innodb_buffer_pool_write_requests | 132620870 | | Innodb_checkpoint_age | 88015 | | Innodb_checkpoint_max_age | 84223550 | | Innodb_checkpoint_target_age | 81591565 | | Innodb_data_fsyncs | 23497491 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 129493962752 | | Innodb_data_reads | 7906173 | | Innodb_data_writes | 39194030 | | Innodb_data_written | 586483447808 | | Innodb_dblwr_pages_written | 16456234 | | Innodb_dblwr_writes | 182242 | | Innodb_deadlocks | 432 | | Innodb_dict_tables | 1315 | | Innodb_have_atomic_builtins | ON | | Innodb_history_list_length | 3523 | | Innodb_ibuf_discarded_delete_marks | 0 | | Innodb_ibuf_discarded_deletes | 0 | | Innodb_ibuf_discarded_inserts | 0 | | Innodb_ibuf_free_list | 287 | | Innodb_ibuf_merged_delete_marks | 100855 | | Innodb_ibuf_merged_deletes | 13481 | | Innodb_ibuf_merged_inserts | 106192 | | Innodb_ibuf_merges | 111495 | | Innodb_ibuf_segment_size | 289 | | Innodb_ibuf_size | 1 | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 73751900 | | Innodb_log_writes | 22385577 | | Innodb_lsn_current | 1981377626218 | | Innodb_lsn_flushed | 1981377626218 | | Innodb_lsn_last_checkpoint | 1981377538203 | | Innodb_master_thread_1_second_loops | 372239 | | Innodb_master_thread_10_second_loops | 37124 | | Innodb_master_thread_background_loops | 1716 | | Innodb_master_thread_main_flush_loops | 1715 | | Innodb_master_thread_sleeps | 372191 | | Innodb_max_trx_id | 2100117045 | | Innodb_mem_adaptive_hash | 13965536 | | Innodb_mem_dictionary | 10287074 | | Innodb_mem_total | 275644416 | | Innodb_mutex_os_waits | 198788 | | Innodb_mutex_spin_rounds | 12021403 | | Innodb_mutex_spin_waits | 3647342 | | Innodb_oldest_view_low_limit_trx_id | 2100116933 | | Innodb_os_log_fsyncs | 22425791 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 47227117568 | | Innodb_page_size | 16384 | | Innodb_pages_created | 882752 | | Innodb_pages_read | 7903425 | | Innodb_pages_written | 16456234 | | Innodb_purge_trx_id | 2100116933 | | Innodb_purge_undo_no | 0 | | Innodb_row_lock_current_waits | 0 | | Innodb_current_row_locks | 0 | | Innodb_row_lock_time | 3209772 | | Innodb_row_lock_time_avg | 74 | | Innodb_row_lock_time_max | 31935 | | Innodb_row_lock_waits | 43208 | | Innodb_rows_deleted | 1227755 | | Innodb_rows_inserted | 1308502 | | Innodb_rows_read | 34888819968 | | Innodb_rows_updated | 9738262 | | Innodb_read_views_memory | 136 | | Innodb_descriptors_memory | 8000 | | Innodb_s_lock_os_waits | 574527 | | Innodb_s_lock_spin_rounds | 19893402 | | Innodb_s_lock_spin_waits | 896432 | | Innodb_truncated_status_writes | 0 | | Innodb_x_lock_os_waits | 204987 | | Innodb_x_lock_spin_rounds | 6888035 | | Innodb_x_lock_spin_waits | 68006 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 5353 | | Key_blocks_used | 4170 | | Key_blocks_warm | 141 | | Key_read_requests | 6295929 | | Key_reads | 9626 | | Key_write_requests | 21159 | | Key_writes | 10962 | | Last_query_cost | 0.000000 | | Max_used_connections | 15 | | Not_flushed_delayed_rows | 0 | | Open_files | 142 | | Open_streams | 0 | | Open_table_definitions | 397 | | Open_tables | 595 | | Opened_files | 9756380 | | Opened_table_definitions | 6425 | | Opened_tables | 8666 | | Opened_views | 0 | | Performance_schema_cond_classes_lost | 0 | | Performance_schema_cond_instances_lost | 0 | | Performance_schema_file_classes_lost | 0 | | Performance_schema_file_handles_lost | 0 | | Performance_schema_file_instances_lost | 0 | | Performance_schema_locker_lost | 0 | | Performance_schema_mutex_classes_lost | 0 | | Performance_schema_mutex_instances_lost | 0 | | Performance_schema_rwlock_classes_lost | 0 | | Performance_schema_rwlock_instances_lost | 0 | | Performance_schema_table_handles_lost | 0 | | Performance_schema_table_instances_lost | 0 | | Performance_schema_thread_classes_lost | 0 | | Performance_schema_thread_instances_lost | 0 | | Prepared_stmt_count | 0 | | Qcache_free_blocks | 6616 | | Qcache_free_memory | 18486664 | | Qcache_hits | 75724207 | | Qcache_inserts | 8304484 | | Qcache_lowmem_prunes | 1719071 | | Qcache_not_cached | 2443705 | | Qcache_queries_in_cache | 8992 | | Qcache_total_blocks | 24978 | | Queries | 142821923 | | Questions | 133827961 | | Rows_read | 35275818740 | | Rows_sent | 1787826753 | | Rows_tmp_read | 592687087 | | Rpl_status | AUTH_MASTER | | Select_full_join | 268533 | | Select_full_range_join | 6393 | | Select_range | 6218451 | | Select_range_check | 0 | | Select_scan | 3587397 | | Slave_heartbeat_period | 1800.000 | | Slave_open_temp_tables | 0 | | Slave_received_heartbeats | 0 | | Slave_retried_transactions | 0 | | Slave_running | ON | | Slow_launch_threads | 0 | | Slow_queries | 3796864 | | Sort_merge_passes | 269513 | | Sort_range | 170798 | | Sort_rows | 1870364969 | | Sort_scan | 4917255 | | Sphinx_error | | | Sphinx_time | | | Sphinx_total | | | Sphinx_total_found | | | Sphinx_word_count | | | Sphinx_words | | | Ssl_accept_renegotiates | 0 | | Ssl_accepts | 0 | | Ssl_callback_cache_hits | 0 | | Ssl_cipher | | | Ssl_cipher_list | | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_ctx_verify_depth | 0 | | Ssl_ctx_verify_mode | 0 | | Ssl_default_timeout | 0 | | Ssl_finished_accepts | 0 | | Ssl_finished_connects | 0 | | Ssl_session_cache_hits | 0 | | Ssl_session_cache_misses | 0 | | Ssl_session_cache_mode | NONE | | Ssl_session_cache_overflows | 0 | | Ssl_session_cache_size | 0 | | Ssl_session_cache_timeouts | 0 | | Ssl_sessions_reused | 0 | | Ssl_used_session_cache_entries | 0 | | Ssl_verify_depth | 0 | | Ssl_verify_mode | 0 | | Ssl_version | | | Subquery_cache_hit | 4512 | | Subquery_cache_miss | 3930 | | Syncs | 4171361 | | Table_locks_immediate | 85865730 | | Table_locks_waited | 15 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 46 | | Threadpool_idle_threads | 0 | | Threadpool_threads | 0 | | Threads_cached | 13 | | Threads_connected | 2 | | Threads_created | 15 | | Threads_running | 2 | | Uptime | 349494 | | Uptime_since_flush_status | 349494 | | Variable_name | Value | | aria_block_size | 8192 | | aria_checkpoint_interval | 30 | | aria_checkpoint_log_activity | 1048576 | | aria_force_start_after_recovery_failures | 0 | | aria_group_commit | none | | aria_group_commit_interval | 0 | | aria_log_file_size | 1073741824 | | aria_log_purge_type | immediate | | aria_max_sort_file_size | 9223372036853727232 | | aria_page_checksum | ON | | aria_pagecache_age_threshold | 300 | | aria_pagecache_buffer_size | 134217728 | | aria_pagecache_division_limit | 100 | | aria_recover | NORMAL | | aria_repair_threads | 1 | | aria_sort_buffer_size | 134217728 | | aria_stats_method | nulls_unequal | | aria_sync_log_dir | NEWFILE | | aria_used_for_temp_tables | ON | | auto_increment_increment | 2 | | auto_increment_offset | 2 | | autocommit | ON | | automatic_sp_privileges | ON | | back_log | 50 | | basedir | /usr | | big_tables | OFF | | binlog_annotate_row_events | OFF | | binlog_cache_size | 32768 | | binlog_checksum | NONE | | binlog_direct_non_transactional_updates | OFF | | binlog_format | MIXED | | binlog_optimize_thread_scheduling | ON | | binlog_stmt_cache_size | 32768 | | bulk_insert_buffer_size | 1048576 | | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | | completion_type | NO_CHAIN | | concurrent_insert | ALWAYS | | connect_timeout | 5 | | datadir | /var/lib/mysql/ | | date_format | %Y-%m-%d | | datetime_format | %Y-%m-%d %H:%i:%s | | deadlock_search_depth_long | 15 | | deadlock_search_depth_short | 4 | | deadlock_timeout_long | 50000000 | | deadlock_timeout_short | 10000 | | debug_no_thread_alarm | OFF | | default_storage_engine | InnoDB | | default_week_format | 0 | | delay_key_write | ON | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | div_precision_increment | 4 | | engine_condition_pushdown | OFF | | event_scheduler | OFF | | expensive_subquery_limit | 100 | | expire_logs_days | 3 | | extra_max_connections | 1 | | extra_port | 0 | | flush | OFF | | flush_time | 0 | | foreign_key_checks | ON | | ft_boolean_syntax | + -><()~*:""&| | | ft_max_word_len | 84 | | ft_min_word_len | 4 | | ft_query_expansion_limit | 20 | | ft_stopword_file | (built-in) | | general_log | OFF | | general_log_file | greeneggs.log | | group_concat_max_len | 1024 | | have_compress | YES | | have_crypt | YES | | have_csv | YES | | have_dynamic_loading | YES | | have_geometry | YES | | have_innodb | YES | | have_ndbcluster | NO | | have_openssl | DISABLED | | have_partitioning | YES | | have_profiling | YES | | have_query_cache | YES | | have_rtree_keys | YES | | have_ssl | DISABLED | | have_symlink | YES | | hostname | greeneggs.lentz.com.au | | ignore_builtin_innodb | OFF | | ignore_db_dirs | | | init_connect | | | init_file | | | init_slave | | | innodb_adaptive_flushing | ON | | innodb_adaptive_flushing_method | estimate | | innodb_adaptive_hash_index | ON | | innodb_adaptive_hash_index_partitions | 1 | | innodb_additional_mem_pool_size | 8388608 | | innodb_autoextend_increment | 8 | | innodb_autoinc_lock_mode | 1 | | innodb_blocking_buffer_pool_restore | OFF | | innodb_buffer_pool_instances | 1 | | innodb_buffer_pool_populate | OFF | | innodb_buffer_pool_restore_at_startup | 600 | | innodb_buffer_pool_shm_checksum | ON | | innodb_buffer_pool_shm_key | 0 | | innodb_buffer_pool_size | 268435456 | | innodb_change_buffering | all | | innodb_checkpoint_age_target | 0 | | innodb_checksums | ON | | innodb_commit_concurrency | 0 | | innodb_concurrency_tickets | 500 | | innodb_corrupt_table_action | assert | | innodb_data_file_path | ibdata1:10M:autoextend | | innodb_data_home_dir | | | innodb_dict_size_limit | 0 | | innodb_doublewrite | ON | | innodb_doublewrite_file | | | innodb_fake_changes | OFF | | innodb_fast_checksum | OFF | | innodb_fast_shutdown | 1 | | innodb_file_format | Antelope | | innodb_file_format_check | ON | | innodb_file_format_max | Antelope | | innodb_file_per_table | ON | | innodb_flush_log_at_trx_commit | 1 | | innodb_flush_method | O_DIRECT | | innodb_flush_neighbor_pages | area | | innodb_force_load_corrupted | OFF | | innodb_force_recovery | 0 | | innodb_ibuf_accel_rate | 100 | | innodb_ibuf_active_contract | 1 | | innodb_ibuf_max_size | 134201344 | | innodb_import_table_from_xtrabackup | 0 | | innodb_io_capacity | 1000 | | innodb_kill_idle_transaction | 0 | | innodb_large_prefix | OFF | | innodb_lazy_drop_table | 0 | | innodb_lock_wait_timeout | 50 | | innodb_locking_fake_changes | ON | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_block_size | 512 | | innodb_log_buffer_size | 4194304 | | innodb_log_file_size | 52428800 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir | ./ | | innodb_max_bitmap_file_size | 104857600 | | innodb_max_changed_pages | 1000000 | | innodb_max_dirty_pages_pct | 75 | | innodb_max_purge_lag | 0 | | innodb_merge_sort_block_size | 1048576 | | innodb_mirrored_log_groups | 1 | | innodb_old_blocks_pct | 37 | | innodb_old_blocks_time | 0 | | innodb_open_files | 400 | | innodb_page_size | 16384 | | innodb_print_all_deadlocks | OFF | | innodb_purge_batch_size | 20 | | innodb_purge_threads | 1 | | innodb_random_read_ahead | OFF | | innodb_read_ahead | linear | | innodb_read_ahead_threshold | 56 | | innodb_read_io_threads | 2 | | innodb_recovery_stats | OFF | | innodb_recovery_update_relay_log | OFF | | innodb_replication_delay | 0 | | innodb_rollback_on_timeout | OFF | | innodb_rollback_segments | 128 | | innodb_show_locks_held | 10 | | innodb_show_verbose_locks | 0 | | innodb_spin_wait_delay | 6 | | innodb_stats_auto_update | 1 | | innodb_stats_method | nulls_equal | | innodb_stats_on_metadata | ON | | innodb_stats_sample_pages | 8 | | innodb_stats_update_need_lock | 1 | | innodb_strict_mode | OFF | | innodb_support_xa | ON | | innodb_sync_spin_loops | 30 | | innodb_table_locks | ON | | innodb_thread_concurrency | 0 | | innodb_thread_concurrency_timer_based | OFF | | innodb_thread_sleep_delay | 10000 | | innodb_track_changed_pages | OFF | | innodb_use_atomic_writes | OFF | | innodb_use_fallocate | OFF | | innodb_use_global_flush_log_at_trx_commit | ON | | innodb_use_native_aio | ON | | innodb_use_sys_malloc | ON | | innodb_use_sys_stats_table | OFF | | innodb_version | 5.5.32-MariaDB-30.2 | | innodb_write_io_threads | 2 | | interactive_timeout | 28800 | | join_buffer_size | 131072 | | join_buffer_space_limit | 2097152 | | join_cache_level | 2 | | keep_files_on_create | OFF | | key_buffer_size | 8388608 | | key_cache_age_threshold | 300 | | key_cache_block_size | 1024 | | key_cache_division_limit | 100 | | key_cache_segments | 0 | | large_files_support | ON | | large_page_size | 0 | | large_pages | OFF | | lc_messages | en_US | | lc_messages_dir | /usr/share/mysql | | lc_time_names | en_US | | license | GPL | | local_infile | ON | | lock_wait_timeout | 31536000 | | locked_in_memory | OFF | | log | OFF | | log_bin | ON | | log_bin_trust_function_creators | OFF | | log_error | | | log_output | FILE | | log_queries_not_using_indexes | ON | | log_slave_updates | ON | | log_slow_filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk | | log_slow_queries | ON | | log_slow_rate_limit | 1 | | log_slow_verbosity | query_plan | | log_warnings | 2 | | long_query_time | 3.000000 | | low_priority_updates | OFF | | lower_case_file_system | OFF | | lower_case_table_names | 0 | | master_verify_checksum | OFF | | max_allowed_packet | 16777216 | | max_binlog_cache_size | 18446744073709547520 | | max_binlog_size | 104857600 | | max_binlog_stmt_cache_size | 18446744073709547520 | | max_connect_errors | 10 | | max_connections | 100 | | max_delayed_threads | 20 | | max_error_count | 64 | | max_heap_table_size | 16777216 | | max_insert_delayed_threads | 20 | | max_join_size | 18446744073709551615 | | max_length_for_sort_data | 1024 | | max_long_data_size | 16777216 | | max_prepared_stmt_count | 16382 | | max_relay_log_size | 0 | | max_seeks_for_key | 4294967295 | | max_sort_length | 1024 | | max_sp_recursion_depth | 0 | | max_tmp_tables | 32 | | max_user_connections | 0 | | max_write_lock_count | 4294967295 | | metadata_locks_cache_size | 1024 | | min_examined_row_limit | 0 | | mrr_buffer_size | 262144 | | multi_range_count | 256 | | myisam_block_size | 1024 | | myisam_data_pointer_size | 6 | | myisam_max_sort_file_size | 9223372036853727232 | | myisam_mmap_size | 18446744073709551615 | | myisam_recover_options | BACKUP,QUICK | | myisam_repair_threads | 1 | | myisam_sort_buffer_size | 536870912 | | myisam_stats_method | nulls_unequal | | myisam_use_mmap | OFF | | net_buffer_length | 16384 | | net_read_timeout | 30 | | net_retry_count | 10 | | net_write_timeout | 60 | | old | OFF | | old_alter_table | OFF | | old_passwords | OFF | | open_files_limit | 2159 | | optimizer_prune_level | 1 | | optimizer_search_depth | 62 | | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=off | | performance_schema | OFF | | performance_schema_events_waits_history_long_size | 10000 | | performance_schema_events_waits_history_size | 10 | | performance_schema_max_cond_classes | 80 | | performance_schema_max_cond_instances | 1000 | | performance_schema_max_file_classes | 50 | | performance_schema_max_file_handles | 32768 | | performance_schema_max_file_instances | 10000 | | performance_schema_max_mutex_classes | 200 | | performance_schema_max_mutex_instances | 1000000 | | performance_schema_max_rwlock_classes | 30 | | performance_schema_max_rwlock_instances | 1000000 | | performance_schema_max_table_handles | 100000 | | performance_schema_max_table_instances | 50000 | | performance_schema_max_thread_classes | 50 | | performance_schema_max_thread_instances | 1000 | | pid_file | /var/run/mysqld/mysqld.pid | | plugin_dir | /usr/lib/mysql/plugin/ | | plugin_maturity | unknown | | port | 3306 | | preload_buffer_size | 32768 | | profiling | OFF | | profiling_history_size | 15 | | progress_report_time | 56 | | protocol_version | 10 | | query_alloc_block_size | 8192 | | query_cache_limit | 131072 | | query_cache_min_res_unit | 4096 | | query_cache_size | 33554432 | | query_cache_strip_comments | OFF | | query_cache_type | ON | | query_cache_wlock_invalidate | OFF | | query_prealloc_size | 8192 | | range_alloc_block_size | 4096 | | read_buffer_size | 1048576 | | read_only | ON | | read_rnd_buffer_size | 524288 | | relay_log | | | relay_log_index | | | relay_log_info_file | relay-log.info | | relay_log_purge | ON | | relay_log_recovery | OFF | | relay_log_space_limit | 0 | | replicate_annotate_row_events | OFF | | replicate_do_db | | | replicate_do_table | | | replicate_events_marked_for_skip | replicate | | replicate_ignore_db | | | replicate_ignore_table | peoplesforum.cache | | replicate_wild_do_table | | | replicate_wild_ignore_table | peoplesforum.cache% | | report_host | greeneggs | | report_password | | | report_port | 3306 | | report_user | | | rowid_merge_buff_size | 8388608 | | rpl_recovery_rank | 0 | | secure_auth | OFF | | secure_file_priv | | | server_id | 12302 | | skip_external_locking | ON | | skip_name_resolve | ON | | skip_networking | OFF | | skip_show_database | OFF | | slave_compressed_protocol | OFF | | slave_exec_mode | STRICT | | slave_load_tmpdir | /tmp | | slave_max_allowed_packet | 1073741824 | | slave_net_timeout | 3600 | | slave_skip_errors | 1062 | | slave_sql_verify_checksum | ON | | slave_transaction_retries | 10 | | slave_type_conversions | | | slow_launch_time | 2 | | slow_query_log | ON | | slow_query_log_file | /var/log/mysql/mariadb-slow.log | | socket | /var/run/mysqld/mysqld.sock | | sort_buffer_size | 262144 | | sql_auto_is_null | OFF | | sql_big_selects | ON | | sql_big_tables | OFF | | sql_buffer_result | OFF | | sql_log_bin | ON | | sql_log_off | OFF | | sql_low_priority_updates | OFF | | sql_max_join_size | 18446744073709551615 | | sql_mode | NO_ENGINE_SUBSTITUTION | | sql_notes | ON | | sql_quote_show_create | ON | | sql_safe_updates | OFF | | sql_select_limit | 18446744073709551615 | | sql_slave_skip_counter | 0 | | sql_warnings | OFF | | ssl_ca | | | ssl_capath | | | ssl_cert | | | ssl_cipher | | | ssl_key | | | storage_engine | InnoDB | | stored_program_cache | 256 | | sync_binlog | 3 | | sync_frm | ON | | sync_master_info | 0 | | sync_relay_log | 0 | | sync_relay_log_info | 0 | | system_time_zone | UTC | | table_definition_cache | 400 | | table_open_cache | 1024 | | thread_cache_size | 128 | | thread_concurrency | 10 | | thread_handling | one-thread-per-connection | | thread_pool_idle_timeout | 60 | | thread_pool_max_threads | 500 | | thread_pool_oversubscribe | 3 | | thread_pool_size | 8 | | thread_pool_stall_limit | 500 | | thread_stack | 294912 | | time_format | %H:%i:%s | | time_zone | SYSTEM | | timed_mutexes | OFF | | tmp_table_size | 16777216 | | tmpdir | /tmp | | transaction_alloc_block_size | 8192 | | transaction_prealloc_size | 4096 | | tx_isolation | REPEATABLE-READ | | unique_checks | ON | | updatable_views_with_limit | YES | | userstat | OFF | | version | 5.5.32-MariaDB-1~wheezy-log | | version_comment | mariadb.org binary distribution | | version_compile_machine | x86_64 | | version_compile_os | debian-linux-gnu | | wait_timeout | 600 | I'm planning on doing a debug build from MDEV-572 and maybe try to get valgrind to narrow it down (if that doesn't bring the server to a total halt). Better suggestions welcome.
-- This message was sent by Atlassian JIRA (v6.2-OD-05-4#6207) ----- End forwarded message -----