[MDEV-4703] Memory leak in MariaDB 5.5.31 Created: 2013-06-24  Updated: 2013-07-18  Due: 2013-07-25  Resolved: 2013-07-18

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.31
Fix Version/s: 5.5.32

Type: Bug Priority: Major
Reporter: Ilan Shemes Assignee: Unassigned
Resolution: Fixed Votes: 3
Labels: None
Environment:

Debian 7.1

Issue Links:
Blocks
is blocked by MDEV-4763 5.5.32 merge Closed
Relates
relates to MDEV-4754 Memory leak on MariaDB 5.5.31 Closed

 Description   

I think I found a memory leak in MariabDB 5.5.31 built for Debian Wheezy. I have been using MariaDB 5.3 for a few months (I do not remember the exact build) without any problems. But while upgrading the machine to Wheezy I decided to upgrade to MariaDB 5.5.31. Since the upgrade the server is slowing down after a few days because there is no memory left for the filesystem cache. It even starts to swap out memory to disk. When I let it get this far it takes almost an hour to do a /etc/init.d/mysql restart but then I have an immediate 28GB of free memory back. This has happened three times in the last month.

MariaDB 5.3 didn't ever use more than 10GB of memory using the exact same configuration file.

The database is doing mostly processing of data, with 4 to 20 connections. On average the database performs 4500 qps. 79% selects, 12% inserts, 9% updates. It has a mix of MyISAM, InnoDB and Merge tables. Doing a 'FLUSH TABLES' does not help to lower the memory.

I do not know what information I can give to find out what the problem is. I just restarted MariaDB again so in a few days I should have the same situation again. Here is some information about the server:

  • 1 Intel quad core Xeon processor
  • 32GB memory
  • 2TB of filesystem space

$ uname -a
 
Linux travis 3.2.0-4-amd64 #1 SMP Debian 3.2.41-2+deb7u2 x86_64 GNU/Linux
 
 
 
$ mysql -V
 
mysql  Ver 15.1 Distrib 5.5.31-MariaDB, for debian-linux-gnu (x86_64) using readline 5.1

my.cnf file:

[client]
 
port            = 3306
 
socket          = /var/run/mysqld/mysqld.sock
 
 
 
# Here is entries for some specific programs
 
# The following values assume you have at least 32M ram
 
 
 
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
 
[mysqld_safe]
 
socket          = /var/run/mysqld/mysqld.sock
 
nice            = 0
 
 
 
[mysqld]
 
#
 
# * Basic Settings
 
#
 
user            = mysql
 
pid-file        = /var/run/mysqld/mysqld.pid
 
socket          = /var/run/mysqld/mysqld.sock
 
port            = 3306
 
basedir         = /usr
 
datadir         = /var/lib/mysql
 
tmpdir          = /tmp
 
language        = /usr/share/mysql/english
 
skip-external-locking
 
bind-address    = 127.0.0.1
 
 
 
#
 
# * Fine Tuning
 
#
 
key_buffer              = 2G
 
max_allowed_packet      = 64M
 
thread_stack            = 192K
 
thread_cache_size       = 64
 
sort_buffer_size        = 1M
 
read_buffer_size        = 1M
 
read_rnd_buffer_size    = 8M
 
join_buffer_size        = 1M
 
back_log                = 100
 
max_connect_errors      = 10000
 
open-files              = 20000
 
interactive_timeout     = 600
 
wait_timeout            = 600
 
max_connections         = 100
 
myisam_sort_buffer_size = 64M
 
concurrent_insert       = 1
 
 
 
innodb_file_per_table           = 1
 
innodb_buffer_pool_size         = 6G
 
innodb_log_file_size            = 2000M
 
innodb_log_buffer_size          = 4M
 
innodb_flush_log_at_trx_commit  = 2
 
innodb_thread_concurrency       = 8
 
innodb_flush_method             = O_DIRECT
 
 
 
# This replaces the startup script and checks MyISAM tables if needed
 
# the first time they are touched
 
myisam-recover         = BACKUP
 
table_cache            = 16K
 
thread_concurrency     = 16
 
 
 
max_allowed_packet      = 16M
 
tmp_table_size          = 64M
 
max_heap_table_size     = 64M
 
 
 
#
 
# * Query Cache Configuration
 
#
 
query_cache_limit       = 1M
 
query_cache_size        = 16M
 
 
 
# _____________________________
 
#< Replication/Backup Settings >
 
# -----------------------------
 
log_bin = mysql-bin
 
server_id = 1001
 
expire_logs_days        = 10
 
max_binlog_size         = 1G
 
 
 
# Enable this to make replication more resilient against server
 
# crashes and restarts, but can cause higher I/O on the server.
 
sync_binlog=1
 
 
 
[mysqldump]
 
quick
 
quote-names
 
max_allowed_packet      = 16M
 
 
 
[mysql]
 
#no-auto-rehash # faster start of mysql but no tab completition
 
 
 
[isamchk]
 
key_buffer              = 16M
 
 
 
#
 
# * IMPORTANT: Additional settings that can override those from this file!
 
#   The files must end with '.cnf', otherwise they'll be ignored.
 
#
 
!includedir /etc/mysql/conf.d/



 Comments   
Comment by Elena Stepanova [ 2013-06-24 ]

Hi,

Would it be possible for you to

  • take a data dump from your database;
  • enable general log;
  • let it running until you notice definite memory overuse again;
  • upload both the dump and the general log to our FTP at ftp.askmonty.org?

In any case (whether you can do the above or not), please run SHOW ENGINE INNODB STATUS when you observe the evident problem, and paste its output.

Thanks.

Comment by Ilan Shemes [ 2013-06-25 ]

This is a live database with over 750 million records. Total size is about 600GB. So a data dump is out of the question. I will however enable the general log and do a show engine innodb status next time I notice over usage of memory and post it back here. I just hope the general log won't show data that is being sent to the database, because there is a lot of sensitive data in there.

Am I the only person who reported this problem?

Comment by Elena Stepanova [ 2013-06-25 ]

The general log will show all queries as they are, including inserted values and such, in the plain text. So if there is a privacy concern, the general log is apparently out of question also.

Please do run show engine innodb status though. It shouldn't show anything sensitive, and even if it does, the output is not big, you'll be able to obfuscate sensitive data manually.
Better still, run one when the instance is still all right, and another one when it's gone bad, so we could compare.

There is a way to enable innodb status printing to the error log on the regular basis, so that you wouldn't need to worry about catching the right moment, but I'm not 100% certain that it won't affect your system in some way (e.g. performance-wise). This manual page explains how to enable the monitor should you want to try it (you would need the general one, "just" the monitor): http://dev.mysql.com/doc/refman/5.5/en/innodb-monitors.html

And yes, as far as I can see, it is the only open report of such kind at the moment, which of course does not necessarily mean that nobody else experienced it, only that nobody else reported it.

Please also run SHOW GLOBAL STATUS and SHOW GLOBAL VARIABLES when you hit the problem again, just in case we can see something suspicious there (which is unlikely, but it's free, so...).

Comment by Ilan Shemes [ 2013-06-25 ]

I just noticed the same problem on one of our other servers that was upgraded. I ran some queries per your request:

> SHOW ENGINE INNODB STATUS;

+--------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
| Type   | Name | Status                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
 
+--------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
| InnoDB |      | 
=====================================
 
130625 12:19:11 INNODB MONITOR OUTPUT
 
=====================================
 
Per second averages calculated from the last 61 seconds
 
-----------------
 
BACKGROUND THREAD
 
-----------------
 
srv_master_thread loops: 1312696 1_second, 1312450 sleeps, 131253 10_second, 8118 background, 8118 flush
 
srv_master_thread log flush and writes: 247669
 
----------
 
SEMAPHORES
 
----------
 
OS WAIT ARRAY INFO: reservation count 4111065, signal count 20179669
 
Mutex spin waits 23292497, rounds 84882806, OS waits 1852775
 
RW-shared spins 15116757, rounds 130721204, OS waits 2026158
 
RW-excl spins 1952867, rounds 35064135, OS waits 163179
 
Spin rounds per wait: 3.64 mutex, 8.65 RW-shared, 17.96 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 (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, 0] , aio writes: 0 [0, 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
 
165 OS file reads, 229386815 OS file writes, 1225075 OS fsyncs
 
0 pending preads, 1 pending pwrites
 
0.00 reads/s, 0 avg bytes/read, 484.68 writes/s, 1.39 fsyncs/s
 
-------------------------------------
 
INSERT BUFFER AND ADAPTIVE HASH INDEX
 
-------------------------------------
 
Ibuf: size 1, free list len 875, seg size 877, 0 merges
 
merged operations:
 
 insert 0, delete mark 0, delete 0
 
discarded operations:
 
 insert 0, delete mark 0, delete 0
 
Hash table size 17700827, node heap has 7695 buffer(s)
 
563.61 hash searches/s, 3966.30 non-hash searches/s
 
---
 
LOG
 
---
 
Log sequence number 21235942692637
 
Log flushed up to   21235942626448
 
Last checkpoint at  21235906304678
 
Max checkpoint age    3396203275
 
Checkpoint age target 3290071923
 
Modified age          36387959
 
Checkpoint age        36387959
 
0 pending log writes, 0 pending chkp writes
 
219251356 log i/o's done, 481.86 log i/o's/second
 
----------------------
 
BUFFER POOL AND MEMORY
 
----------------------
 
Total memory allocated 8820621312; in additional pool allocated 0
 
Internal hash tables (constant factor + variable factor)
 
    Adaptive hash index 267685712 	(141606616 + 126079096)
 
    Page hash           8851208 (buffer pool 0 only)
 
    Dictionary cache    35462861 	(35403184 + 59677)
 
    File system         84832 	(82672 + 2160)
 
    Lock system         21251320 	(21250568 + 752)
 
    Recovery system     0 	(0 + 0)
 
Dictionary memory allocated 59677
 
Buffer pool size        524287
 
Buffer pool size, bytes 8589918208
 
Free buffers            113862
 
Database pages          402730
 
Old database pages      148644
 
Modified db pages       2219
 
Pending reads 0
 
Pending writes: LRU 0, flush list 0, single page 0
 
Pages made young 26301, not young 0
 
0.07 youngs/s, 0.00 non-youngs/s
 
Pages read 154, created 403282, written 9705703
 
0.00 reads/s, 0.00 creates/s, 2.69 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: 402730, unzip_LRU len: 0
 
I/O sum[143]:cur[0], unzip sum[0]:cur[0]
 
--------------
 
ROW OPERATIONS
 
--------------
 
0 queries inside InnoDB, 0 queries in queue
 
1 read views open inside InnoDB
 
---OLDEST VIEW---
 
Normal read view
 
Read view low limit trx n:o 9619816D6
 
Read view up limit trx id 9619816D6
 
Read view low limit trx id 9619816D6
 
Read view individually stored trx ids:
 
-----------------
 
Main thread process no. 8088, id 140045262620416, state: sleeping
 
Number of rows inserted 208949244, updated 3558578, deleted 198638889, read 2670916014
 
480.84 inserts/s, 0.00 updates/s, 0.00 deletes/s, 2102.72 reads/s
 
------------
 
TRANSACTIONS
 
------------
 
Trx id counter 96198C537
 
Purge done for trx's n:o < 96196AB6B undo n:o < 0
 
History list length 2196
 
LIST OF TRANSACTIONS FOR EACH SESSION:
 
---TRANSACTION 0, not started
 
MySQL thread id 4620, OS thread handle 0x7f61f7fbe700, query id 876450186 localhost root
 
show engine innodb status
 
---TRANSACTION 96198C536, not started
 
MySQL thread id 3742, OS thread handle 0x7f5ed24d6700, query id 876450304 localhost 127.0.0.1 indexer
 
----------------------------
 
END OF INNODB MONITOR OUTPUT
 
============================
 
 |
 
+--------+------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
1 row in set (0.11 sec)

> SHOW GLOBAL STATUS;

+------------------------------------------+----------------+
 
| Variable_name                            | Value          |
 
+------------------------------------------+----------------+
 
| Aborted_clients                          | 15             |
 
| Aborted_connects                         | 4              |
 
| Access_denied_errors                     | 4              |
 
| Aria_pagecache_blocks_not_flushed        | 0              |
 
| Aria_pagecache_blocks_unused             | 15737          |
 
| Aria_pagecache_blocks_used               | 2928           |
 
| Aria_pagecache_read_requests             | 191782         |
 
| Aria_pagecache_reads                     | 195            |
 
| Aria_pagecache_write_requests            | 3314           |
 
| Aria_pagecache_writes                    | 0              |
 
| Aria_transaction_log_syncs               | 0              |
 
| Binlog_commits                           | 0              |
 
| Binlog_group_commits                     | 0              |
 
| Binlog_snapshot_file                     |                |
 
| Binlog_snapshot_position                 | 0              |
 
| Binlog_bytes_written                     | 0              |
 
| Binlog_cache_disk_use                    | 0              |
 
| Binlog_cache_use                         | 0              |
 
| Binlog_stmt_cache_disk_use               | 0              |
 
| Binlog_stmt_cache_use                    | 0              |
 
| Busy_time                                | 0.000000       |
 
| Bytes_received                           | 187354395866   |
 
| Bytes_sent                               | 153599446829   |
 
| Com_admin_commands                       | 876719083      |
 
| 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                          | 8              |
 
| Com_alter_tablespace                     | 0              |
 
| Com_analyze                              | 0              |
 
| Com_begin                                | 3              |
 
| Com_binlog                               | 0              |
 
| Com_call_procedure                       | 0              |
 
| Com_change_db                            | 860            |
 
| Com_change_master                        | 0              |
 
| Com_check                                | 0              |
 
| Com_checksum                             | 0              |
 
| Com_commit                               | 0              |
 
| Com_create_db                            | 0              |
 
| Com_create_event                         | 0              |
 
| Com_create_function                      | 0              |
 
| Com_create_index                         | 0              |
 
| Com_create_procedure                     | 0              |
 
| Com_create_server                        | 0              |
 
| Com_create_table                         | 28             |
 
| Com_create_trigger                       | 0              |
 
| Com_create_udf                           | 0              |
 
| Com_create_user                          | 0              |
 
| Com_create_view                          | 0              |
 
| Com_dealloc_sql                          | 0              |
 
| Com_delete                               | 7532952        |
 
| Com_delete_multi                         | 0              |
 
| Com_do                                   | 0              |
 
| Com_drop_db                              | 0              |
 
| Com_drop_event                           | 0              |
 
| Com_drop_function                        | 0              |
 
| Com_drop_index                           | 0              |
 
| Com_drop_procedure                       | 0              |
 
| Com_drop_server                          | 0              |
 
| Com_drop_table                           | 0              |
 
| Com_drop_trigger                         | 0              |
 
| Com_drop_user                            | 0              |
 
| Com_drop_view                            | 0              |
 
| Com_empty_query                          | 0              |
 
| Com_execute_sql                          | 0              |
 
| Com_flush                                | 14             |
 
| Com_grant                                | 0              |
 
| Com_ha_close                             | 0              |
 
| Com_ha_open                              | 0              |
 
| Com_ha_read                              | 0              |
 
| Com_help                                 | 0              |
 
| Com_insert                               | 214735331      |
 
| Com_insert_select                        | 0              |
 
| Com_install_plugin                       | 0              |
 
| Com_kill                                 | 1              |
 
| Com_load                                 | 0              |
 
| Com_lock_tables                          | 29052          |
 
| Com_optimize                             | 0              |
 
| Com_preload_keys                         | 0              |
 
| Com_prepare_sql                          | 0              |
 
| 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                              | 215153964      |
 
| Com_replace_select                       | 0              |
 
| Com_reset                                | 0              |
 
| Com_resignal                             | 0              |
 
| Com_revoke                               | 0              |
 
| Com_revoke_all                           | 0              |
 
| Com_rollback                             | 0              |
 
| Com_rollback_to_savepoint                | 0              |
 
| Com_savepoint                            | 0              |
 
| Com_select                               | 246371292      |
 
| Com_set_option                           | 1309           |
 
| Com_signal                               | 0              |
 
| Com_show_authors                         | 0              |
 
| Com_show_binlog_events                   | 0              |
 
| Com_show_binlogs                         | 10             |
 
| Com_show_charsets                        | 0              |
 
| Com_show_client_statistics               | 0              |
 
| Com_show_collations                      | 0              |
 
| Com_show_contributors                    | 0              |
 
| Com_show_create_db                       | 0              |
 
| Com_show_create_event                    | 0              |
 
| Com_show_create_func                     | 0              |
 
| Com_show_create_proc                     | 0              |
 
| Com_show_create_table                    | 123            |
 
| Com_show_create_trigger                  | 0              |
 
| Com_show_databases                       | 51             |
 
| Com_show_engine_logs                     | 0              |
 
| Com_show_engine_mutex                    | 0              |
 
| Com_show_engine_status                   | 1              |
 
| Com_show_events                          | 0              |
 
| Com_show_errors                          | 0              |
 
| Com_show_fields                          | 181            |
 
| Com_show_function_status                 | 0              |
 
| Com_show_grants                          | 8              |
 
| Com_show_keys                            | 96             |
 
| Com_show_index_statistics                | 0              |
 
| Com_show_master_status                   | 70             |
 
| Com_show_open_tables                     | 74             |
 
| Com_show_plugins                         | 2              |
 
| Com_show_privileges                      | 0              |
 
| Com_show_procedure_status                | 0              |
 
| Com_show_processlist                     | 38996          |
 
| Com_show_profile                         | 0              |
 
| Com_show_profiles                        | 0              |
 
| Com_show_relaylog_events                 | 0              |
 
| Com_show_slave_hosts                     | 0              |
 
| Com_show_slave_status                    | 39064          |
 
| Com_show_status                          | 42743          |
 
| Com_show_storage_engines                 | 4              |
 
| Com_show_table_statistics                | 0              |
 
| Com_show_table_status                    | 918            |
 
| Com_show_tables                          | 149            |
 
| Com_show_triggers                        | 1              |
 
| Com_show_user_statistics                 | 0              |
 
| Com_show_variables                       | 39161          |
 
| Com_show_warnings                        | 12             |
 
| Com_slave_start                          | 0              |
 
| Com_slave_stop                           | 0              |
 
| Com_stmt_close                           | 0              |
 
| Com_stmt_execute                         | 0              |
 
| Com_stmt_fetch                           | 0              |
 
| Com_stmt_prepare                         | 0              |
 
| Com_stmt_reprepare                       | 0              |
 
| Com_stmt_reset                           | 0              |
 
| Com_stmt_send_long_data                  | 0              |
 
| Com_truncate                             | 5              |
 
| Com_uninstall_plugin                     | 0              |
 
| Com_unlock_tables                        | 29054          |
 
| Com_update                               | 10240977       |
 
| Com_update_multi                         | 0              |
 
| 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                              | 4622           |
 
| Cpu_time                                 | 0.000000       |
 
| Created_tmp_disk_tables                  | 205            |
 
| Created_tmp_files                        | 30284          |
 
| Created_tmp_tables                       | 79996          |
 
| Delayed_errors                           | 0              |
 
| Delayed_insert_threads                   | 0              |
 
| Delayed_writes                           | 0              |
 
| Empty_queries                            | 5822865        |
 
| Executed_events                          | 0              |
 
| Executed_triggers                        | 0              |
 
| Feature_dynamic_columns                  | 0              |
 
| Feature_fulltext                         | 0              |
 
| Feature_gis                              | 0              |
 
| Feature_locale                           | 0              |
 
| Feature_subquery                         | 9              |
 
| Feature_timezone                         | 4              |
 
| Feature_trigger                          | 0              |
 
| Feature_xml                              | 0              |
 
| Flush_commands                           | 3              |
 
| Handler_commit                           | 438517032      |
 
| Handler_delete                           | 198638927      |
 
| Handler_discover                         | 0              |
 
| Handler_icp_attempts                     | 46702          |
 
| Handler_icp_match                        | 46702          |
 
| Handler_mrr_init                         | 0              |
 
| Handler_mrr_key_refills                  | 0              |
 
| Handler_mrr_rowid_refills                | 0              |
 
| Handler_prepare                          | 0              |
 
| Handler_read_first                       | 66             |
 
| Handler_read_key                         | 263821535      |
 
| Handler_read_last                        | 18             |
 
| Handler_read_next                        | 2678459099     |
 
| Handler_read_prev                        | 1782           |
 
| Handler_read_rnd                         | 207563811      |
 
| Handler_read_rnd_deleted                 | 0              |
 
| Handler_read_rnd_next                    | 61225062693    |
 
| Handler_rollback                         | 3              |
 
| Handler_savepoint                        | 0              |
 
| Handler_savepoint_rollback               | 0              |
 
| Handler_tmp_update                       | 0              |
 
| Handler_tmp_write                        | 16969120       |
 
| Handler_update                           | 217462978      |
 
| Handler_write                            | 430848566      |
 
| Innodb_adaptive_hash_cells               | 17700827       |
 
| Innodb_adaptive_hash_heap_buffers        | 7733           |
 
| Innodb_adaptive_hash_hash_searches       | 1335855401     |
 
| Innodb_adaptive_hash_non_hash_searches   | 1599080998     |
 
| Innodb_background_log_sync               | 247902         |
 
| Innodb_buffer_pool_pages_data            | 402730         |
 
| Innodb_buffer_pool_bytes_data            | 6598328320     |
 
| Innodb_buffer_pool_pages_dirty           | 4821           |
 
| Innodb_buffer_pool_bytes_dirty           | 78987264       |
 
| Innodb_buffer_pool_pages_flushed         | 9706374        |
 
| Innodb_buffer_pool_pages_LRU_flushed     | 0              |
 
| Innodb_buffer_pool_pages_free            | 113823         |
 
| Innodb_buffer_pool_pages_made_not_young  | 0              |
 
| Innodb_buffer_pool_pages_made_young      | 26378          |
 
| Innodb_buffer_pool_pages_misc            | 7734           |
 
| Innodb_buffer_pool_pages_old             | 148644         |
 
| Innodb_buffer_pool_pages_total           | 524287         |
 
| Innodb_buffer_pool_read_ahead_rnd        | 0              |
 
| Innodb_buffer_pool_read_ahead            | 0              |
 
| Innodb_buffer_pool_read_ahead_evicted    | 0              |
 
| Innodb_buffer_pool_read_requests         | 10857941779    |
 
| Innodb_buffer_pool_reads                 | 155            |
 
| Innodb_buffer_pool_wait_free             | 0              |
 
| Innodb_buffer_pool_write_requests        | 2832854993     |
 
| Innodb_checkpoint_age                    | 86259938       |
 
| Innodb_checkpoint_max_age                | 3396203275     |
 
| Innodb_checkpoint_target_age             | 3290071923     |
 
| Innodb_data_fsyncs                       | 1225409        |
 
| Innodb_data_pending_fsyncs               | 0              |
 
| Innodb_data_pending_reads                | 0              |
 
| Innodb_data_pending_writes               | 1              |
 
| Innodb_data_read                         | 4722688        |
 
| Innodb_data_reads                        | 165            |
 
| Innodb_data_writes                       | 229495393      |
 
| Innodb_data_written                      | 655595904000   |
 
| Innodb_dblwr_pages_written               | 9706374        |
 
| Innodb_dblwr_writes                      | 376951         |
 
| Innodb_deadlocks                         | 0              |
 
| Innodb_dict_tables                       | 11             |
 
| Innodb_have_atomic_builtins              | ON             |
 
| Innodb_history_list_length               | 2196           |
 
| Innodb_ibuf_discarded_delete_marks       | 0              |
 
| Innodb_ibuf_discarded_deletes            | 0              |
 
| Innodb_ibuf_discarded_inserts            | 0              |
 
| Innodb_ibuf_free_list                    | 875            |
 
| Innodb_ibuf_merged_delete_marks          | 0              |
 
| Innodb_ibuf_merged_deletes               | 0              |
 
| Innodb_ibuf_merged_inserts               | 0              |
 
| Innodb_ibuf_merges                       | 0              |
 
| Innodb_ibuf_segment_size                 | 877            |
 
| Innodb_ibuf_size                         | 1              |
 
| Innodb_log_waits                         | 17             |
 
| Innodb_log_write_requests                | 480698793      |
 
| Innodb_log_writes                        | 219220068      |
 
| Innodb_lsn_current                       | 21235992688160 |
 
| Innodb_lsn_flushed                       | 21235992545676 |
 
| Innodb_lsn_last_checkpoint               | 21235906428222 |
 
| Innodb_master_thread_1_second_loops      | 1313009        |
 
| Innodb_master_thread_10_second_loops     | 131285         |
 
| Innodb_master_thread_background_loops    | 8118           |
 
| Innodb_master_thread_main_flush_loops    | 8118           |
 
| Innodb_master_thread_sleeps              | 1312763        |
 
| Innodb_max_trx_id                        | 40292322775    |
 
| Innodb_mem_adaptive_hash                 | 268324688      |
 
| Innodb_mem_dictionary                    | 35462861       |
 
| Innodb_mem_total                         | 8820621312     |
 
| Innodb_mutex_os_waits                    | 1852839        |
 
| Innodb_mutex_spin_rounds                 | 84885215       |
 
| Innodb_mutex_spin_waits                  | 23292603       |
 
| Innodb_oldest_view_low_limit_trx_id      | 40292062934    |
 
| Innodb_os_log_fsyncs                     | 448077         |
 
| Innodb_os_log_pending_fsyncs             | 0              |
 
| Innodb_os_log_pending_writes             | 1              |
 
| Innodb_os_log_written                    | 337466952704   |
 
| Innodb_page_size                         | 16384          |
 
| Innodb_pages_created                     | 403282         |
 
| Innodb_pages_read                        | 154            |
 
| Innodb_pages_written                     | 9706374        |
 
| Innodb_purge_trx_id                      | 40291969899    |
 
| Innodb_purge_undo_no                     | 0              |
 
| Innodb_row_lock_current_waits            | 0              |
 
| Innodb_current_row_locks                 | 0              |
 
| Innodb_row_lock_time                     | 3              |
 
| Innodb_row_lock_time_avg                 | 0              |
 
| Innodb_row_lock_time_max                 | 1              |
 
| Innodb_row_lock_waits                    | 4              |
 
| Innodb_rows_deleted                      | 198638889      |
 
| Innodb_rows_inserted                     | 209056847      |
 
| Innodb_rows_read                         | 2673472930     |
 
| Innodb_rows_updated                      | 3558578        |
 
| Innodb_s_lock_os_waits                   | 2026190        |
 
| Innodb_s_lock_spin_rounds                | 130722164      |
 
| Innodb_s_lock_spin_waits                 | 15116789       |
 
| Innodb_truncated_status_writes           | 0              |
 
| Innodb_x_lock_os_waits                   | 163184         |
 
| Innodb_x_lock_spin_rounds                | 35064285       |
 
| Innodb_x_lock_spin_waits                 | 1952867        |
 
| Key_blocks_not_flushed                   | 855            |
 
| Key_blocks_unused                        | 3428399        |
 
| Key_blocks_used                          | 845843         |
 
| Key_blocks_warm                          | 0              |
 
| Key_read_requests                        | 2788868483     |
 
| Key_reads                                | 526            |
 
| Key_write_requests                       | 108838660      |
 
| Key_writes                               | 870420         |
 
| Last_query_cost                          | 0.000000       |
 
| Max_used_connections                     | 5              |
 
| Not_flushed_delayed_rows                 | 0              |
 
| Open_files                               | 11             |
 
| Open_streams                             | 0              |
 
| Open_table_definitions                   | 7              |
 
| Open_tables                              | 7              |
 
| Opened_files                             | 825971         |
 
| Opened_table_definitions                 | 388907         |
 
| Opened_tables                            | 389097         |
 
| 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                       | 2              |
 
| Qcache_free_memory                       | 16750744       |
 
| Qcache_hits                              | 182627641      |
 
| Qcache_inserts                           | 243327969      |
 
| Qcache_lowmem_prunes                     | 325255         |
 
| Qcache_not_cached                        | 3025178        |
 
| Qcache_queries_in_cache                  | 6              |
 
| Qcache_total_blocks                      | 18             |
 
| Queries                                  | 876885012      |
 
| Questions                                | 876885015      |
 
| Rows_read                                | 64114298397    |
 
| Rows_sent                                | 763350981      |
 
| Rows_tmp_read                            | 16969116       |
 
| Rpl_status                               | AUTH_MASTER    |
 
| Select_full_join                         | 9              |
 
| Select_full_range_join                   | 0              |
 
| Select_range                             | 6              |
 
| Select_range_check                       | 0              |
 
| Select_scan                              | 257594         |
 
| Slave_heartbeat_period                   | 0.000          |
 
| Slave_open_temp_tables                   | 0              |
 
| Slave_received_heartbeats                | 0              |
 
| Slave_retried_transactions               | 0              |
 
| Slave_running                            | OFF            |
 
| Slow_launch_threads                      | 0              |
 
| Slow_queries                             | 2181           |
 
| Sort_merge_passes                        | 314312         |
 
| Sort_range                               | 7651694        |
 
| Sort_rows                                | 202534333      |
 
| Sort_scan                                | 16             |
 
| 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                       | 0              |
 
| Subquery_cache_miss                      | 0              |
 
| Syncs                                    | 62             |
 
| Table_locks_immediate                    | 692645277      |
 
| Table_locks_waited                       | 1246647        |
 
| Tc_log_max_pages_used                    | 0              |
 
| Tc_log_page_size                         | 0              |
 
| Tc_log_page_waits                        | 0              |
 
| Threadpool_idle_threads                  | 0              |
 
| Threadpool_threads                       | 0              |
 
| Threads_cached                           | 2              |
 
| Threads_connected                        | 3              |
 
| Threads_created                          | 5              |
 
| Threads_running                          | 2              |
 
| Uptime                                   | 1123947        |
 
| Uptime_since_flush_status                | 1123947        |
 
+------------------------------------------+----------------+
 
417 rows in set (0.07 sec)

> SHOW GLOBAL VARIABLES;

+---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
| 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                          | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| auto_increment_offset                             | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| autocommit                                        | ON                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| automatic_sp_privileges                           | ON                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| back_log                                          | 100                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| 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                                     | STATEMENT                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
 
| binlog_optimize_thread_scheduling                 | ON                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| binlog_stmt_cache_size                            | 32768                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
 
| bulk_insert_buffer_size                           | 8388608                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
 
| 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                                   | 10                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| 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                                  | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| 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                                  | malcolm.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                                          | malcolm                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
 
| 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             | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| innodb_buffer_pool_shm_checksum                   | ON                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| innodb_buffer_pool_shm_key                        | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| innodb_buffer_pool_size                           | 8589934592                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
 
| 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                    | 2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| 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                              | 4294950912                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
 
| innodb_import_table_from_xtrabackup               | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| innodb_io_capacity                                | 200                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| 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                              | 2097152000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
 
| 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                                 | 300                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| 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                            | 4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| 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                          | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| 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                         | 8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| 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.31-MariaDB-30.2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| innodb_write_io_threads                           | 4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| interactive_timeout                               | 600                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| join_buffer_size                                  | 1048576                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
 
| join_buffer_space_limit                           | 2097152                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
 
| join_cache_level                                  | 2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| keep_files_on_create                              | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| key_buffer_size                                   | 4294967296                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
 
| 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                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| lc_time_names                                     | en_US                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
 
| license                                           | GPL                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| local_infile                                      | ON                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| lock_wait_timeout                                 | 31536000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
 
| locked_in_memory                                  | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| log                                               | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| log_bin                                           | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| log_bin_trust_function_creators                   | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| log_error                                         |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| log_output                                        | FILE                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
 
| log_queries_not_using_indexes                     | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| log_slave_updates                                 | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| 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                                  | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| log_slow_rate_limit                               | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| log_slow_verbosity                                |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| log_warnings                                      | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| long_query_time                                   | 10.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                                   | 1073741824                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
 
| max_binlog_stmt_cache_size                        | 18446744073709547520                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
 
| max_connect_errors                                | 10000                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
 
| max_connections                                   | 100                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| max_delayed_threads                               | 20                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| max_error_count                                   | 64                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| max_heap_table_size                               | 67108864                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
 
| 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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
 
| myisam_repair_threads                             | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| myisam_sort_buffer_size                           | 67108864                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
 
| 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                                  | 32879                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
 
| 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                                 | 1048576                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
 
| query_cache_min_res_unit                          | 4096                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
 
| query_cache_size                                  | 16777216                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
 
| 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                                         | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| read_rnd_buffer_size                              | 8388608                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
 
| 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                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| replicate_wild_do_table                           |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| replicate_wild_ignore_table                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| report_host                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| report_password                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| report_port                                       | 3306                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
 
| report_user                                       |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| rowid_merge_buff_size                             | 8388608                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
 
| rpl_recovery_rank                                 | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| secure_auth                                       | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| secure_file_priv                                  |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| server_id                                         | 1002                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
 
| skip_external_locking                             | ON                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| skip_name_resolve                                 | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| 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                                 | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| slave_sql_verify_checksum                         | ON                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| slave_transaction_retries                         | 10                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| slave_type_conversions                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| slow_launch_time                                  | 2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| slow_query_log                                    | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| slow_query_log_file                               | malcolm-slow.log                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
 
| socket                                            | /var/run/mysqld/mysqld.sock                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
 
| sort_buffer_size                                  | 1048576                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
 
| 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                                          |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| 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                                       | 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| sync_frm                                          | ON                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| sync_master_info                                  | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| sync_relay_log                                    | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| sync_relay_log_info                               | 0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| system_time_zone                                  | BST                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| table_definition_cache                            | 400                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| table_open_cache                                  | 16384                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
 
| thread_cache_size                                 | 64                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| thread_concurrency                                | 16                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| thread_handling                                   | one-thread-per-connection                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
 
| thread_pool_idle_timeout                          | 60                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
 
| thread_pool_max_threads                           | 500                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| thread_pool_oversubscribe                         | 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| thread_pool_size                                  | 4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
 
| thread_pool_stall_limit                           | 500                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| thread_stack                                      | 196608                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
 
| time_format                                       | %H:%i:%s                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
 
| time_zone                                         | SYSTEM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
 
| timed_mutexes                                     | OFF                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
| tmp_table_size                                    | 67108864                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
 
| 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.31-MariaDB-1~wheezy                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
 
| version_comment                                   | mariadb.org binary distribution                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
 
| version_compile_machine                           | x86_64                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
 
| version_compile_os                                | debian-linux-gnu                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
 
| wait_timeout                                      | 600                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
 
+---------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
414 rows in set (0.02 sec)

Comment by Ilan Shemes [ 2013-06-25 ]

Sorry for the bad markup. But 

 

doesn't seem to work for this comment as it did for the person who edited my first post.

mysqld is now consuming 84.6% out of 32GB of memory according to top.

Comment by Elena Stepanova [ 2013-06-27 ]

Hi,

Could you please also run

select engine,sum(data_length)/1024/1024 as DATA_MB,sum(INDEX_LENGTH)/1024/1024 as INDEX_MB from information_schema.tables group by engine;

Also, did you try to free the memory by running
echo 1|3 > /proc/sys/vm/drop_caches
and if you did, did it help or not?

Thanks.

Don't worry about the markup, not your fault – comments don't allow any formatting.

Comment by Elena Stepanova [ 2013-07-05 ]

Hi,

could you please disable the query cache and see if it helps?

Thanks.

Comment by Ilan Shemes [ 2013-07-06 ]

I ran the query you requested. But on the original server, not the second one that I showed you the other queries from:

MariaDB [(none)]> select engine,sum(data_length)/1024/1024 as DATA_MB,sum(INDEX_LENGTH)/1024/1024 as INDEX_MB from information_schema.tables group by engine;
-------------------------------------------------

engine DATA_MB INDEX_MB

-------------------------------------------------

Aria 0.07812500 0.07812500
CSV 0.00000000 0.00000000
InnoDB 12431.53125000 839.00000000
MEMORY 0.00000000 0.00000000
MRG_MYISAM 614686.32986069 0.00000000
MyISAM 538012.02685833 59083.39453125
PERFORMANCE_SCHEMA 0.00000000 0.00000000

-------------------------------------------------
7 rows in set (2.96 sec)

I tried freeing memory by dropping caches. This turned Cache in Free memory. But since I only had 2GB of Cache, I ended up with 2GB of Free memory. Before the upgrade to MariaDB 5.5.31 this machine always had about 12 to 16GB of memory in use by Cache.

I disabled the Query Cache with:

SET GLOBAL query_cache_size = 0;

This did not give back any free memory. I disabled the query cache in the my.cfg file and restarted the mysql service again because it was slowing down too much. I will check to see if disabling the query cache will stop the memory leak. After the restart of mysql I have 29GB of memory available.

Comment by Elena Stepanova [ 2013-07-07 ]

Hi,

That's right, disabling query cache at runtime wasn't expected to free any memory, but the hope is that it will prevent further memory leaks. The current main suspect is the XtraDB bug https://bugs.launchpad.net/percona-server/+bug/1170103 , assuming you are using XtraDB.

Please let us know whether disabling the query cache helps or not.

Thanks.

Comment by Ilan Shemes [ 2013-07-09 ]

Disabling the query cache seemed to have fixed the problem. With an uptime of 3 days mysqld is only using 23.1% of memory as is configured. Most of the rest of the servers memory is now in use by the filesystem cache which dramatically improved the query times on large MyISAM tables. Thank you for suggesting this fix Elena.

Comment by Elena Stepanova [ 2013-07-09 ]

Hi Ilan,

I'm glad it helped. The bug seems to have been fixed in XtraDB already, so the fix should be merged into the next MariaDB release (5.5.32).

I can't take credit for the workaround, readdressing your thanks to Patryk Pomykalski who posted the link to the XtraDB bug in a similar recently filed JIRA issue:

https://mariadb.atlassian.net/browse/MDEV-4754?focusedCommentId=33087&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-33087

Comment by Ilan Shemes [ 2013-07-15 ]

Just wanted to drop a note to let you know that without restarting the service it is still running with 23.5% of memory usage. So even after 8 days of running under high load the memory usage is stable. I'm now 100% sure the query cache is the cause of my memory problems.

Comment by Elena Stepanova [ 2013-07-15 ]

Thanks for letting us know!

Comment by Elena Stepanova [ 2013-07-18 ]

The fix should be in 5.5.32 release. The bug was fixed in XtraDB 5.5.32 (at least it is marked as such in https://bugs.launchpad.net/percona-server/+bug/1170103), and MariaDB 5.5.32 includes XtraDB 5.5.32.

We didn't have a reproducible test case to verify it, so please re-open the issue (or comment on it to get it re-opened) if you still have the problem with MariaDB 5.5.32,

Generated at Thu Feb 08 06:58:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.