mysql> show create table category;
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                                                                                                                                    |
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| category | CREATE TABLE `category` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='This is a test table.' |
+----------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> analyze category;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'category' at line 1
mysql> analyze table category;
+-------------------+---------+----------+----------+
| Table             | Op      | Msg_type | Msg_text |
+-------------------+---------+----------+----------+
| jac_test.category | analyze | status   | OK       |
+-------------------+---------+----------+----------+
1 row in set (0.03 sec)

mysql> show indexes from category;
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table    | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| category |          0 | PRIMARY  |            1 | id          | A         |           7 |     NULL | NULL   |      | BTREE      |         |               |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
1 row in set (0.00 sec)

mysql> show create table entry_group;
+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table       | Create Table                                                                                                                                                                                                                                                                                                                                                |
+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| entry_group | CREATE TABLE `entry_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` smallint(6) NOT NULL,
  `grp_val1` smallint(6) NOT NULL,
  `grp_val2` smallint(6) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_jac_entry_group_on_category_id` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24984 DEFAULT CHARSET=utf8 COMMENT='This is a test table.' |
+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> analyze table entry_group;
+----------------------+---------+----------+----------+
| Table                | Op      | Msg_type | Msg_text |
+----------------------+---------+----------+----------+
| jac_test.entry_group | analyze | status   | OK       |
+----------------------+---------+----------+----------+
1 row in set (0.02 sec)

mysql> show indexes from entry_group;
+-------------+------------+------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table       | Non_unique | Key_name                           | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------+------------+------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| entry_group |          0 | PRIMARY                            |            1 | id          | A         |       24943 |     NULL | NULL   |      | BTREE      |         |               |
| entry_group |          1 | idx_jac_entry_group_on_category_id |            1 | category_id | A         |          14 |     NULL | NULL   |      | BTREE      |         |               |
+-------------+------------+------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
2 rows in set (0.00 sec)

mysql> show create table entry;
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                                                                                |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| entry | CREATE TABLE `entry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `entry_val1` smallint(6) NOT NULL,
  `uneven_val` smallint(6) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_jac_entry_on_group_id` (`group_id`),
  KEY `idx_jac_entry_on_uneven_val` (`uneven_val`)
) ENGINE=InnoDB AUTO_INCREMENT=250001 DEFAULT CHARSET=utf8 COMMENT='This is a test table.' |
+-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> analyze table entry;
+----------------+---------+----------+----------+
| Table          | Op      | Msg_type | Msg_text |
+----------------+---------+----------+----------+
| jac_test.entry | analyze | status   | OK       |
+----------------+---------+----------+----------+
1 row in set (0.03 sec)

mysql> show indexes from entry;
+-------+------------+-----------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name                    | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+-----------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| entry |          0 | PRIMARY                     |            1 | id          | A         |      249996 |     NULL | NULL   |      | BTREE      |         |               |
| entry |          1 | idx_jac_entry_on_group_id   |            1 | group_id    | A         |       62499 |     NULL | NULL   |      | BTREE      |         |               |
| entry |          1 | idx_jac_entry_on_uneven_val |            1 | uneven_val  | A         |       49999 |     NULL | NULL   |      | BTREE      |         |               |
+-------+------------+-----------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
3 rows in set (0.00 sec)

mysql> select count(id) from category;
+-----------+
| count(id) |
+-----------+
|         7 |
+-----------+
1 row in set (0.00 sec)

mysql> select count(id) from entry_group;
+-----------+
| count(id) |
+-----------+
|     24983 |
+-----------+
1 row in set (0.01 sec)

mysql> select count(id) from entry;
+-----------+
| count(id) |
+-----------+
|    250000 |
+-----------+
1 row in set (0.14 sec)

mysql> explain extended
    -> select sql_no_cache e.id, g.id, c.id
    -> from entry e inner join
    -> entry_group g on 
    -> g.id = e.group_id inner join
    -> category c on
    -> c.id = g.category_id
    -> where e.uneven_val between 300 and 8000;
+----+-------------+-------+-------+-------------------------------------------------------+------------------------------------+---------+---------------+------+----------+-------------+
| id | select_type | table | type  | possible_keys                                         | key                                | key_len | ref           | rows | filtered | Extra       |
+----+-------------+-------+-------+-------------------------------------------------------+------------------------------------+---------+---------------+------+----------+-------------+
|  1 | SIMPLE      | c     | index | PRIMARY                                               | PRIMARY                            | 2       | NULL          |    7 |   100.00 | Using index |
|  1 | SIMPLE      | g     | ref   | PRIMARY,idx_jac_entry_group_on_category_id            | idx_jac_entry_group_on_category_id | 2       | jac_test.c.id | 1781 |   100.00 | Using index |
|  1 | SIMPLE      | e     | ref   | idx_jac_entry_on_group_id,idx_jac_entry_on_uneven_val | idx_jac_entry_on_group_id          | 4       | jac_test.g.id |    4 |   100.00 | Using where |
+----+-------------+-------+-------+-------------------------------------------------------+------------------------------------+---------+---------------+------+----------+-------------+
3 rows in set, 1 warning (0.01 sec)

mysql> set profiling=1;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show session variables;
+--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name                                          | Value                                                                                                                                                                                                                                                                                                                                            |
+--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| auto_increment_increment                               | 1                                                                                                                                                                                                                                                                                                                                                |
| auto_increment_offset                                  | 1                                                                                                                                                                                                                                                                                                                                                |
| autocommit                                             | ON                                                                                                                                                                                                                                                                                                                                               |
| automatic_sp_privileges                                | ON                                                                                                                                                                                                                                                                                                                                               |
| back_log                                               | 150                                                                                                                                                                                                                                                                                                                                              |
| basedir                                                | /usr                                                                                                                                                                                                                                                                                                                                             |
| big_tables                                             | OFF                                                                                                                                                                                                                                                                                                                                              |
| bind_address                                           | *                                                                                                                                                                                                                                                                                                                                                |
| binlog_cache_size                                      | 32768                                                                                                                                                                                                                                                                                                                                            |
| binlog_checksum                                        | CRC32                                                                                                                                                                                                                                                                                                                                            |
| binlog_direct_non_transactional_updates                | OFF                                                                                                                                                                                                                                                                                                                                              |
| binlog_format                                          | STATEMENT                                                                                                                                                                                                                                                                                                                                        |
| binlog_max_flush_queue_time                            | 0                                                                                                                                                                                                                                                                                                                                                |
| binlog_order_commits                                   | ON                                                                                                                                                                                                                                                                                                                                               |
| binlog_row_image                                       | FULL                                                                                                                                                                                                                                                                                                                                             |
| binlog_rows_query_log_events                           | OFF                                                                                                                                                                                                                                                                                                                                              |
| binlog_stmt_cache_size                                 | 32768                                                                                                                                                                                                                                                                                                                                            |
| binlogging_impossible_mode                             | IGNORE_ERROR                                                                                                                                                                                                                                                                                                                                     |
| block_encryption_mode                                  | aes-128-ecb                                                                                                                                                                                                                                                                                                                                      |
| bulk_insert_buffer_size                                | 8388608                                                                                                                                                                                                                                                                                                                                          |
| character_set_client                                   | utf8                                                                                                                                                                                                                                                                                                                                             |
| character_set_connection                               | utf8                                                                                                                                                                                                                                                                                                                                             |
| character_set_database                                 | latin1                                                                                                                                                                                                                                                                                                                                           |
| character_set_filesystem                               | binary                                                                                                                                                                                                                                                                                                                                           |
| character_set_results                                  | utf8                                                                                                                                                                                                                                                                                                                                             |
| character_set_server                                   | latin1                                                                                                                                                                                                                                                                                                                                           |
| character_set_system                                   | utf8                                                                                                                                                                                                                                                                                                                                             |
| character_sets_dir                                     | /usr/share/mysql/charsets/                                                                                                                                                                                                                                                                                                                       |
| collation_connection                                   | utf8_general_ci                                                                                                                                                                                                                                                                                                                                  |
| collation_database                                     | latin1_swedish_ci                                                                                                                                                                                                                                                                                                                                |
| collation_server                                       | latin1_swedish_ci                                                                                                                                                                                                                                                                                                                                |
| completion_type                                        | NO_CHAIN                                                                                                                                                                                                                                                                                                                                         |
| concurrent_insert                                      | AUTO                                                                                                                                                                                                                                                                                                                                             |
| connect_timeout                                        | 10                                                                                                                                                                                                                                                                                                                                               |
| core_file                                              | OFF                                                                                                                                                                                                                                                                                                                                              |
| datadir                                                | /var/lib/mysql/                                                                                                                                                                                                                                                                                                                                  |
| date_format                                            | %Y-%m-%d                                                                                                                                                                                                                                                                                                                                         |
| datetime_format                                        | %Y-%m-%d %H:%i:%s                                                                                                                                                                                                                                                                                                                                |
| default_storage_engine                                 | InnoDB                                                                                                                                                                                                                                                                                                                                           |
| default_tmp_storage_engine                             | InnoDB                                                                                                                                                                                                                                                                                                                                           |
| default_week_format                                    | 0                                                                                                                                                                                                                                                                                                                                                |
| delay_key_write                                        | ON                                                                                                                                                                                                                                                                                                                                               |
| delayed_insert_limit                                   | 100                                                                                                                                                                                                                                                                                                                                              |
| delayed_insert_timeout                                 | 300                                                                                                                                                                                                                                                                                                                                              |
| delayed_queue_size                                     | 1000                                                                                                                                                                                                                                                                                                                                             |
| disconnect_on_expired_password                         | ON                                                                                                                                                                                                                                                                                                                                               |
| div_precision_increment                                | 4                                                                                                                                                                                                                                                                                                                                                |
| end_markers_in_json                                    | OFF                                                                                                                                                                                                                                                                                                                                              |
| enforce_gtid_consistency                               | OFF                                                                                                                                                                                                                                                                                                                                              |
| eq_range_index_dive_limit                              | 10                                                                                                                                                                                                                                                                                                                                               |
| error_count                                            | 0                                                                                                                                                                                                                                                                                                                                                |
| event_scheduler                                        | OFF                                                                                                                                                                                                                                                                                                                                              |
| expire_logs_days                                       | 0                                                                                                                                                                                                                                                                                                                                                |
| explicit_defaults_for_timestamp                        | OFF                                                                                                                                                                                                                                                                                                                                              |
| external_user                                          |                                                                                                                                                                                                                                                                                                                                                  |
| 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                                       | /var/lib/mysql/db2.log                                                                                                                                                                                                                                                                                                                           |
| group_concat_max_len                                   | 1024                                                                                                                                                                                                                                                                                                                                             |
| gtid_executed                                          |                                                                                                                                                                                                                                                                                                                                                  |
| gtid_mode                                              | OFF                                                                                                                                                                                                                                                                                                                                              |
| gtid_next                                              | AUTOMATIC                                                                                                                                                                                                                                                                                                                                        |
| gtid_owned                                             |                                                                                                                                                                                                                                                                                                                                                  |
| gtid_purged                                            |                                                                                                                                                                                                                                                                                                                                                  |
| have_compress                                          | YES                                                                                                                                                                                                                                                                                                                                              |
| have_crypt                                             | YES                                                                                                                                                                                                                                                                                                                                              |
| have_dynamic_loading                                   | YES                                                                                                                                                                                                                                                                                                                                              |
| have_geometry                                          | YES                                                                                                                                                                                                                                                                                                                                              |
| have_openssl                                           | DISABLED                                                                                                                                                                                                                                                                                                                                         |
| have_profiling                                         | YES                                                                                                                                                                                                                                                                                                                                              |
| have_query_cache                                       | YES                                                                                                                                                                                                                                                                                                                                              |
| have_rtree_keys                                        | YES                                                                                                                                                                                                                                                                                                                                              |
| have_ssl                                               | DISABLED                                                                                                                                                                                                                                                                                                                                         |
| have_symlink                                           | YES                                                                                                                                                                                                                                                                                                                                              |
| host_cache_size                                        | 628                                                                                                                                                                                                                                                                                                                                              |
| hostname                                               | db2.scrs.gov                                                                                                                                                                                                                                                                                                                                     |
| identity                                               | 0                                                                                                                                                                                                                                                                                                                                                |
| ignore_builtin_innodb                                  | OFF                                                                                                                                                                                                                                                                                                                                              |
| ignore_db_dirs                                         |                                                                                                                                                                                                                                                                                                                                                  |
| init_connect                                           |                                                                                                                                                                                                                                                                                                                                                  |
| init_file                                              |                                                                                                                                                                                                                                                                                                                                                  |
| init_slave                                             |                                                                                                                                                                                                                                                                                                                                                  |
| innodb_adaptive_flushing                               | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_adaptive_flushing_lwm                           | 10                                                                                                                                                                                                                                                                                                                                               |
| innodb_adaptive_hash_index                             | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_adaptive_max_sleep_delay                        | 150000                                                                                                                                                                                                                                                                                                                                           |
| innodb_additional_mem_pool_size                        | 8388608                                                                                                                                                                                                                                                                                                                                          |
| innodb_api_bk_commit_interval                          | 5                                                                                                                                                                                                                                                                                                                                                |
| innodb_api_disable_rowlock                             | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_api_enable_binlog                               | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_api_enable_mdl                                  | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_api_trx_level                                   | 0                                                                                                                                                                                                                                                                                                                                                |
| innodb_autoextend_increment                            | 64                                                                                                                                                                                                                                                                                                                                               |
| innodb_autoinc_lock_mode                               | 1                                                                                                                                                                                                                                                                                                                                                |
| innodb_buffer_pool_dump_at_shutdown                    | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_buffer_pool_dump_now                            | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_buffer_pool_filename                            | ib_buffer_pool                                                                                                                                                                                                                                                                                                                                   |
| innodb_buffer_pool_instances                           | 8                                                                                                                                                                                                                                                                                                                                                |
| innodb_buffer_pool_load_abort                          | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_buffer_pool_load_at_startup                     | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_buffer_pool_load_now                            | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_buffer_pool_size                                | 12026118144                                                                                                                                                                                                                                                                                                                                      |
| innodb_change_buffer_max_size                          | 25                                                                                                                                                                                                                                                                                                                                               |
| innodb_change_buffering                                | all                                                                                                                                                                                                                                                                                                                                              |
| innodb_checksum_algorithm                              | innodb                                                                                                                                                                                                                                                                                                                                           |
| innodb_checksums                                       | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_cmp_per_index_enabled                           | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_commit_concurrency                              | 0                                                                                                                                                                                                                                                                                                                                                |
| innodb_compression_failure_threshold_pct               | 5                                                                                                                                                                                                                                                                                                                                                |
| innodb_compression_level                               | 6                                                                                                                                                                                                                                                                                                                                                |
| innodb_compression_pad_pct_max                         | 50                                                                                                                                                                                                                                                                                                                                               |
| innodb_concurrency_tickets                             | 5000                                                                                                                                                                                                                                                                                                                                             |
| innodb_data_file_path                                  | ibdata1:12M:autoextend                                                                                                                                                                                                                                                                                                                           |
| innodb_data_home_dir                                   |                                                                                                                                                                                                                                                                                                                                                  |
| innodb_disable_sort_file_cache                         | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_doublewrite                                     | ON                                                                                                                                                                                                                                                                                                                                               |
| 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_timeout                            | 1                                                                                                                                                                                                                                                                                                                                                |
| innodb_flush_log_at_trx_commit                         | 1                                                                                                                                                                                                                                                                                                                                                |
| innodb_flush_method                                    |                                                                                                                                                                                                                                                                                                                                                  |
| innodb_flush_neighbors                                 | 1                                                                                                                                                                                                                                                                                                                                                |
| innodb_flushing_avg_loops                              | 30                                                                                                                                                                                                                                                                                                                                               |
| innodb_force_load_corrupted                            | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_force_recovery                                  | 0                                                                                                                                                                                                                                                                                                                                                |
| innodb_ft_aux_table                                    |                                                                                                                                                                                                                                                                                                                                                  |
| innodb_ft_cache_size                                   | 8000000                                                                                                                                                                                                                                                                                                                                          |
| innodb_ft_enable_diag_print                            | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_ft_enable_stopword                              | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_ft_max_token_size                               | 84                                                                                                                                                                                                                                                                                                                                               |
| innodb_ft_min_token_size                               | 3                                                                                                                                                                                                                                                                                                                                                |
| innodb_ft_num_word_optimize                            | 2000                                                                                                                                                                                                                                                                                                                                             |
| innodb_ft_result_cache_limit                           | 2000000000                                                                                                                                                                                                                                                                                                                                       |
| innodb_ft_server_stopword_table                        |                                                                                                                                                                                                                                                                                                                                                  |
| innodb_ft_sort_pll_degree                              | 2                                                                                                                                                                                                                                                                                                                                                |
| innodb_ft_total_cache_size                             | 640000000                                                                                                                                                                                                                                                                                                                                        |
| innodb_ft_user_stopword_table                          |                                                                                                                                                                                                                                                                                                                                                  |
| innodb_io_capacity                                     | 200                                                                                                                                                                                                                                                                                                                                              |
| innodb_io_capacity_max                                 | 2000                                                                                                                                                                                                                                                                                                                                             |
| innodb_large_prefix                                    | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_lock_wait_timeout                               | 50                                                                                                                                                                                                                                                                                                                                               |
| innodb_locks_unsafe_for_binlog                         | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_log_buffer_size                                 | 8388608                                                                                                                                                                                                                                                                                                                                          |
| innodb_log_compressed_pages                            | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_log_file_size                                   | 536870912                                                                                                                                                                                                                                                                                                                                        |
| innodb_log_files_in_group                              | 2                                                                                                                                                                                                                                                                                                                                                |
| innodb_log_group_home_dir                              | ./                                                                                                                                                                                                                                                                                                                                               |
| innodb_lru_scan_depth                                  | 1024                                                                                                                                                                                                                                                                                                                                             |
| innodb_max_dirty_pages_pct                             | 75                                                                                                                                                                                                                                                                                                                                               |
| innodb_max_dirty_pages_pct_lwm                         | 0                                                                                                                                                                                                                                                                                                                                                |
| innodb_max_purge_lag                                   | 0                                                                                                                                                                                                                                                                                                                                                |
| innodb_max_purge_lag_delay                             | 0                                                                                                                                                                                                                                                                                                                                                |
| innodb_mirrored_log_groups                             | 1                                                                                                                                                                                                                                                                                                                                                |
| innodb_monitor_disable                                 |                                                                                                                                                                                                                                                                                                                                                  |
| innodb_monitor_enable                                  |                                                                                                                                                                                                                                                                                                                                                  |
| innodb_monitor_reset                                   |                                                                                                                                                                                                                                                                                                                                                  |
| innodb_monitor_reset_all                               |                                                                                                                                                                                                                                                                                                                                                  |
| innodb_old_blocks_pct                                  | 37                                                                                                                                                                                                                                                                                                                                               |
| innodb_old_blocks_time                                 | 1000                                                                                                                                                                                                                                                                                                                                             |
| innodb_online_alter_log_max_size                       | 134217728                                                                                                                                                                                                                                                                                                                                        |
| innodb_open_files                                      | 2000                                                                                                                                                                                                                                                                                                                                             |
| innodb_optimize_fulltext_only                          | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_page_size                                       | 16384                                                                                                                                                                                                                                                                                                                                            |
| innodb_print_all_deadlocks                             | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_purge_batch_size                                | 300                                                                                                                                                                                                                                                                                                                                              |
| innodb_purge_threads                                   | 1                                                                                                                                                                                                                                                                                                                                                |
| innodb_random_read_ahead                               | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_read_ahead_threshold                            | 56                                                                                                                                                                                                                                                                                                                                               |
| innodb_read_io_threads                                 | 4                                                                                                                                                                                                                                                                                                                                                |
| innodb_read_only                                       | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_replication_delay                               | 0                                                                                                                                                                                                                                                                                                                                                |
| innodb_rollback_on_timeout                             | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_rollback_segments                               | 128                                                                                                                                                                                                                                                                                                                                              |
| innodb_sort_buffer_size                                | 1048576                                                                                                                                                                                                                                                                                                                                          |
| innodb_spin_wait_delay                                 | 6                                                                                                                                                                                                                                                                                                                                                |
| innodb_stats_auto_recalc                               | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_stats_method                                    | nulls_equal                                                                                                                                                                                                                                                                                                                                      |
| innodb_stats_on_metadata                               | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_stats_persistent                                | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_stats_persistent_sample_pages                   | 20                                                                                                                                                                                                                                                                                                                                               |
| innodb_stats_sample_pages                              | 8                                                                                                                                                                                                                                                                                                                                                |
| innodb_stats_transient_sample_pages                    | 8                                                                                                                                                                                                                                                                                                                                                |
| innodb_status_output                                   | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_status_output_locks                             | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_strict_mode                                     | OFF                                                                                                                                                                                                                                                                                                                                              |
| innodb_support_xa                                      | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_sync_array_size                                 | 1                                                                                                                                                                                                                                                                                                                                                |
| innodb_sync_spin_loops                                 | 30                                                                                                                                                                                                                                                                                                                                               |
| innodb_table_locks                                     | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_thread_concurrency                              | 0                                                                                                                                                                                                                                                                                                                                                |
| innodb_thread_sleep_delay                              | 10000                                                                                                                                                                                                                                                                                                                                            |
| innodb_undo_directory                                  | .                                                                                                                                                                                                                                                                                                                                                |
| innodb_undo_logs                                       | 128                                                                                                                                                                                                                                                                                                                                              |
| innodb_undo_tablespaces                                | 0                                                                                                                                                                                                                                                                                                                                                |
| innodb_use_native_aio                                  | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_use_sys_malloc                                  | ON                                                                                                                                                                                                                                                                                                                                               |
| innodb_version                                         | 5.6.21                                                                                                                                                                                                                                                                                                                                           |
| innodb_write_io_threads                                | 4                                                                                                                                                                                                                                                                                                                                                |
| insert_id                                              | 0                                                                                                                                                                                                                                                                                                                                                |
| interactive_timeout                                    | 28800                                                                                                                                                                                                                                                                                                                                            |
| join_buffer_size                                       | 262144                                                                                                                                                                                                                                                                                                                                           |
| keep_files_on_create                                   | OFF                                                                                                                                                                                                                                                                                                                                              |
| key_buffer_size                                        | 8388608                                                                                                                                                                                                                                                                                                                                          |
| key_cache_age_threshold                                | 300                                                                                                                                                                                                                                                                                                                                              |
| key_cache_block_size                                   | 1024                                                                                                                                                                                                                                                                                                                                             |
| key_cache_division_limit                               | 100                                                                                                                                                                                                                                                                                                                                              |
| large_files_support                                    | ON                                                                                                                                                                                                                                                                                                                                               |
| large_page_size                                        | 0                                                                                                                                                                                                                                                                                                                                                |
| large_pages                                            | OFF                                                                                                                                                                                                                                                                                                                                              |
| last_insert_id                                         | 0                                                                                                                                                                                                                                                                                                                                                |
| lc_messages                                            | en_US                                                                                                                                                                                                                                                                                                                                            |
| lc_messages_dir                                        | /usr/share/mysql/                                                                                                                                                                                                                                                                                                                                |
| lc_time_names                                          | en_US                                                                                                                                                                                                                                                                                                                                            |
| license                                                | Commercial                                                                                                                                                                                                                                                                                                                                       |
| local_infile                                           | ON                                                                                                                                                                                                                                                                                                                                               |
| lock_wait_timeout                                      | 31536000                                                                                                                                                                                                                                                                                                                                         |
| locked_in_memory                                       | OFF                                                                                                                                                                                                                                                                                                                                              |
| log_bin                                                | OFF                                                                                                                                                                                                                                                                                                                                              |
| log_bin_basename                                       |                                                                                                                                                                                                                                                                                                                                                  |
| log_bin_index                                          |                                                                                                                                                                                                                                                                                                                                                  |
| log_bin_trust_function_creators                        | OFF                                                                                                                                                                                                                                                                                                                                              |
| log_bin_use_v1_row_events                              | OFF                                                                                                                                                                                                                                                                                                                                              |
| log_error                                              | /var/lib/mysql/db2.scrs.gov.err                                                                                                                                                                                                                                                                                                                  |
| log_output                                             | FILE                                                                                                                                                                                                                                                                                                                                             |
| log_queries_not_using_indexes                          | OFF                                                                                                                                                                                                                                                                                                                                              |
| log_slave_updates                                      | OFF                                                                                                                                                                                                                                                                                                                                              |
| log_slow_admin_statements                              | OFF                                                                                                                                                                                                                                                                                                                                              |
| log_slow_slave_statements                              | OFF                                                                                                                                                                                                                                                                                                                                              |
| log_throttle_queries_not_using_indexes                 | 0                                                                                                                                                                                                                                                                                                                                                |
| log_warnings                                           | 1                                                                                                                                                                                                                                                                                                                                                |
| long_query_time                                        | 10.000000                                                                                                                                                                                                                                                                                                                                        |
| low_priority_updates                                   | OFF                                                                                                                                                                                                                                                                                                                                              |
| lower_case_file_system                                 | OFF                                                                                                                                                                                                                                                                                                                                              |
| lower_case_table_names                                 | 0                                                                                                                                                                                                                                                                                                                                                |
| master_info_repository                                 | FILE                                                                                                                                                                                                                                                                                                                                             |
| master_verify_checksum                                 | OFF                                                                                                                                                                                                                                                                                                                                              |
| max_allowed_packet                                     | 67108864                                                                                                                                                                                                                                                                                                                                         |
| max_binlog_cache_size                                  | 18446744073709547520                                                                                                                                                                                                                                                                                                                             |
| max_binlog_size                                        | 1073741824                                                                                                                                                                                                                                                                                                                                       |
| max_binlog_stmt_cache_size                             | 18446744073709547520                                                                                                                                                                                                                                                                                                                             |
| max_connect_errors                                     | 100                                                                                                                                                                                                                                                                                                                                              |
| max_connections                                        | 500                                                                                                                                                                                                                                                                                                                                              |
| max_delayed_threads                                    | 20                                                                                                                                                                                                                                                                                                                                               |
| max_error_count                                        | 64                                                                                                                                                                                                                                                                                                                                               |
| max_heap_table_size                                    | 16777216                                                                                                                                                                                                                                                                                                                                         |
| max_insert_delayed_threads                             | 20                                                                                                                                                                                                                                                                                                                                               |
| max_join_size                                          | 18446744073709551615                                                                                                                                                                                                                                                                                                                             |
| max_length_for_sort_data                               | 1024                                                                                                                                                                                                                                                                                                                                             |
| max_prepared_stmt_count                                | 16382                                                                                                                                                                                                                                                                                                                                            |
| max_relay_log_size                                     | 0                                                                                                                                                                                                                                                                                                                                                |
| max_seeks_for_key                                      | 18446744073709551615                                                                                                                                                                                                                                                                                                                             |
| max_sort_length                                        | 1024                                                                                                                                                                                                                                                                                                                                             |
| max_sp_recursion_depth                                 | 0                                                                                                                                                                                                                                                                                                                                                |
| max_tmp_tables                                         | 32                                                                                                                                                                                                                                                                                                                                               |
| max_user_connections                                   | 0                                                                                                                                                                                                                                                                                                                                                |
| max_write_lock_count                                   | 18446744073709551615                                                                                                                                                                                                                                                                                                                             |
| metadata_locks_cache_size                              | 1024                                                                                                                                                                                                                                                                                                                                             |
| metadata_locks_hash_instances                          | 8                                                                                                                                                                                                                                                                                                                                                |
| min_examined_row_limit                                 | 0                                                                                                                                                                                                                                                                                                                                                |
| multi_range_count                                      | 256                                                                                                                                                                                                                                                                                                                                              |
| myisam_data_pointer_size                               | 6                                                                                                                                                                                                                                                                                                                                                |
| myisam_max_sort_file_size                              | 9223372036853727232                                                                                                                                                                                                                                                                                                                              |
| myisam_mmap_size                                       | 18446744073709551615                                                                                                                                                                                                                                                                                                                             |
| myisam_recover_options                                 | OFF                                                                                                                                                                                                                                                                                                                                              |
| myisam_repair_threads                                  | 1                                                                                                                                                                                                                                                                                                                                                |
| myisam_sort_buffer_size                                | 8388608                                                                                                                                                                                                                                                                                                                                          |
| 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                                                                                                                                                                                                                                                                                                                                               |
| new                                                    | OFF                                                                                                                                                                                                                                                                                                                                              |
| old                                                    | OFF                                                                                                                                                                                                                                                                                                                                              |
| old_alter_table                                        | OFF                                                                                                                                                                                                                                                                                                                                              |
| old_passwords                                          | 0                                                                                                                                                                                                                                                                                                                                                |
| open_files_limit                                       | 5000                                                                                                                                                                                                                                                                                                                                             |
| 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,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on |
| optimizer_trace                                        | enabled=off,one_line=off                                                                                                                                                                                                                                                                                                                         |
| optimizer_trace_features                               | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on                                                                                                                                                                                                                                                                       |
| optimizer_trace_limit                                  | 1                                                                                                                                                                                                                                                                                                                                                |
| optimizer_trace_max_mem_size                           | 16384                                                                                                                                                                                                                                                                                                                                            |
| optimizer_trace_offset                                 | -1                                                                                                                                                                                                                                                                                                                                               |
| performance_schema                                     | ON                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_accounts_size                       | 100                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_digests_size                        | 10000                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_events_stages_history_long_size     | 10000                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_events_stages_history_size          | 10                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_events_statements_history_long_size | 10000                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_events_statements_history_size      | 10                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_events_waits_history_long_size      | 10000                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_events_waits_history_size           | 10                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_hosts_size                          | 100                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_max_cond_classes                    | 80                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_cond_instances                  | 4900                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_max_file_classes                    | 50                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_file_handles                    | 32768                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_max_file_instances                  | 7693                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_max_mutex_classes                   | 200                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_max_mutex_instances                 | 18000                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_max_rwlock_classes                  | 40                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_rwlock_instances                | 9800                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_max_socket_classes                  | 10                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_socket_instances                | 1020                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_max_stage_classes                   | 150                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_max_statement_classes               | 168                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_max_table_handles                   | 4000                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_max_table_instances                 | 12500                                                                                                                                                                                                                                                                                                                                            |
| performance_schema_max_thread_classes                  | 50                                                                                                                                                                                                                                                                                                                                               |
| performance_schema_max_thread_instances                | 1100                                                                                                                                                                                                                                                                                                                                             |
| performance_schema_session_connect_attrs_size          | 512                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_setup_actors_size                   | 100                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_setup_objects_size                  | 100                                                                                                                                                                                                                                                                                                                                              |
| performance_schema_users_size                          | 100                                                                                                                                                                                                                                                                                                                                              |
| pid_file                                               | /var/lib/mysql/db2.scrs.gov.pid                                                                                                                                                                                                                                                                                                                  |
| plugin_dir                                             | /usr/lib64/mysql/plugin/                                                                                                                                                                                                                                                                                                                         |
| port                                                   | 3306                                                                                                                                                                                                                                                                                                                                             |
| preload_buffer_size                                    | 32768                                                                                                                                                                                                                                                                                                                                            |
| profiling                                              | ON                                                                                                                                                                                                                                                                                                                                               |
| profiling_history_size                                 | 15                                                                                                                                                                                                                                                                                                                                               |
| protocol_version                                       | 10                                                                                                                                                                                                                                                                                                                                               |
| proxy_user                                             |                                                                                                                                                                                                                                                                                                                                                  |
| pseudo_slave_mode                                      | OFF                                                                                                                                                                                                                                                                                                                                              |
| pseudo_thread_id                                       | 32451                                                                                                                                                                                                                                                                                                                                            |
| query_alloc_block_size                                 | 8192                                                                                                                                                                                                                                                                                                                                             |
| query_cache_limit                                      | 1048576                                                                                                                                                                                                                                                                                                                                          |
| query_cache_min_res_unit                               | 4096                                                                                                                                                                                                                                                                                                                                             |
| query_cache_size                                       | 1048576                                                                                                                                                                                                                                                                                                                                          |
| query_cache_type                                       | OFF                                                                                                                                                                                                                                                                                                                                              |
| query_cache_wlock_invalidate                           | OFF                                                                                                                                                                                                                                                                                                                                              |
| query_prealloc_size                                    | 8192                                                                                                                                                                                                                                                                                                                                             |
| rand_seed1                                             | 0                                                                                                                                                                                                                                                                                                                                                |
| rand_seed2                                             | 0                                                                                                                                                                                                                                                                                                                                                |
| range_alloc_block_size                                 | 4096                                                                                                                                                                                                                                                                                                                                             |
| read_buffer_size                                       | 131072                                                                                                                                                                                                                                                                                                                                           |
| read_only                                              | OFF                                                                                                                                                                                                                                                                                                                                              |
| read_rnd_buffer_size                                   | 262144                                                                                                                                                                                                                                                                                                                                           |
| relay_log                                              |                                                                                                                                                                                                                                                                                                                                                  |
| relay_log_basename                                     |                                                                                                                                                                                                                                                                                                                                                  |
| relay_log_index                                        |                                                                                                                                                                                                                                                                                                                                                  |
| relay_log_info_file                                    | relay-log.info                                                                                                                                                                                                                                                                                                                                   |
| relay_log_info_repository                              | FILE                                                                                                                                                                                                                                                                                                                                             |
| relay_log_purge                                        | ON                                                                                                                                                                                                                                                                                                                                               |
| relay_log_recovery                                     | OFF                                                                                                                                                                                                                                                                                                                                              |
| relay_log_space_limit                                  | 0                                                                                                                                                                                                                                                                                                                                                |
| report_host                                            |                                                                                                                                                                                                                                                                                                                                                  |
| report_password                                        |                                                                                                                                                                                                                                                                                                                                                  |
| report_port                                            | 3306                                                                                                                                                                                                                                                                                                                                             |
| report_user                                            |                                                                                                                                                                                                                                                                                                                                                  |
| rpl_stop_slave_timeout                                 | 31536000                                                                                                                                                                                                                                                                                                                                         |
| secure_auth                                            | ON                                                                                                                                                                                                                                                                                                                                               |
| secure_file_priv                                       |                                                                                                                                                                                                                                                                                                                                                  |
| server_id                                              | 0                                                                                                                                                                                                                                                                                                                                                |
| server_id_bits                                         | 32                                                                                                                                                                                                                                                                                                                                               |
| server_uuid                                            | b8dcbed0-d3cd-11e4-ad53-00505691005a                                                                                                                                                                                                                                                                                                             |
| sha256_password_private_key_path                       | private_key.pem                                                                                                                                                                                                                                                                                                                                  |
| sha256_password_public_key_path                        | public_key.pem                                                                                                                                                                                                                                                                                                                                   |
| simplified_binlog_gtid_recovery                        | OFF                                                                                                                                                                                                                                                                                                                                              |
| skip_external_locking                                  | ON                                                                                                                                                                                                                                                                                                                                               |
| skip_name_resolve                                      | OFF                                                                                                                                                                                                                                                                                                                                              |
| skip_networking                                        | OFF                                                                                                                                                                                                                                                                                                                                              |
| skip_show_database                                     | OFF                                                                                                                                                                                                                                                                                                                                              |
| slave_allow_batching                                   | OFF                                                                                                                                                                                                                                                                                                                                              |
| slave_checkpoint_group                                 | 512                                                                                                                                                                                                                                                                                                                                              |
| slave_checkpoint_period                                | 300                                                                                                                                                                                                                                                                                                                                              |
| slave_compressed_protocol                              | OFF                                                                                                                                                                                                                                                                                                                                              |
| slave_exec_mode                                        | STRICT                                                                                                                                                                                                                                                                                                                                           |
| slave_load_tmpdir                                      | /tmp                                                                                                                                                                                                                                                                                                                                             |
| slave_max_allowed_packet                               | 1073741824                                                                                                                                                                                                                                                                                                                                       |
| slave_net_timeout                                      | 3600                                                                                                                                                                                                                                                                                                                                             |
| slave_parallel_workers                                 | 0                                                                                                                                                                                                                                                                                                                                                |
| slave_pending_jobs_size_max                            | 16777216                                                                                                                                                                                                                                                                                                                                         |
| slave_rows_search_algorithms                           | TABLE_SCAN,INDEX_SCAN                                                                                                                                                                                                                                                                                                                            |
| 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                                    | /var/lib/mysql/db2-slow.log                                                                                                                                                                                                                                                                                                                      |
| socket                                                 | /var/lib/mysql/mysql.sock                                                                                                                                                                                                                                                                                                                        |
| sort_buffer_size                                       | 262144                                                                                                                                                                                                                                                                                                                                           |
| sql_auto_is_null                                       | OFF                                                                                                                                                                                                                                                                                                                                              |
| sql_big_selects                                        | ON                                                                                                                                                                                                                                                                                                                                               |
| sql_buffer_result                                      | OFF                                                                                                                                                                                                                                                                                                                                              |
| sql_log_bin                                            | ON                                                                                                                                                                                                                                                                                                                                               |
| sql_log_off                                            | OFF                                                                                                                                                                                                                                                                                                                                              |
| sql_mode                                               | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION                                                                                                                                                                                                                                                                                                       |
| sql_notes                                              | ON                                                                                                                                                                                                                                                                                                                                               |
| sql_quote_show_create                                  | ON                                                                                                                                                                                                                                                                                                                                               |
| sql_safe_updates                                       | OFF                                                                                                                                                                                                                                                                                                                                              |
| sql_select_limit                                       | 18446744073709551615                                                                                                                                                                                                                                                                                                                             |
| sql_slave_skip_counter                                 | 0                                                                                                                                                                                                                                                                                                                                                |
| sql_warnings                                           | OFF                                                                                                                                                                                                                                                                                                                                              |
| ssl_ca                                                 |                                                                                                                                                                                                                                                                                                                                                  |
| ssl_capath                                             |                                                                                                                                                                                                                                                                                                                                                  |
| ssl_cert                                               |                                                                                                                                                                                                                                                                                                                                                  |
| ssl_cipher                                             |                                                                                                                                                                                                                                                                                                                                                  |
| ssl_crl                                                |                                                                                                                                                                                                                                                                                                                                                  |
| ssl_crlpath                                            |                                                                                                                                                                                                                                                                                                                                                  |
| ssl_key                                                |                                                                                                                                                                                                                                                                                                                                                  |
| storage_engine                                         | InnoDB                                                                                                                                                                                                                                                                                                                                           |
| stored_program_cache                                   | 256                                                                                                                                                                                                                                                                                                                                              |
| sync_binlog                                            | 0                                                                                                                                                                                                                                                                                                                                                |
| sync_frm                                               | ON                                                                                                                                                                                                                                                                                                                                               |
| sync_master_info                                       | 10000                                                                                                                                                                                                                                                                                                                                            |
| sync_relay_log                                         | 10000                                                                                                                                                                                                                                                                                                                                            |
| sync_relay_log_info                                    | 10000                                                                                                                                                                                                                                                                                                                                            |
| system_time_zone                                       | EDT                                                                                                                                                                                                                                                                                                                                              |
| table_definition_cache                                 | 1400                                                                                                                                                                                                                                                                                                                                             |
| table_open_cache                                       | 2000                                                                                                                                                                                                                                                                                                                                             |
| table_open_cache_instances                             | 1                                                                                                                                                                                                                                                                                                                                                |
| thread_cache_size                                      | 13                                                                                                                                                                                                                                                                                                                                               |
| thread_concurrency                                     | 10                                                                                                                                                                                                                                                                                                                                               |
| thread_handling                                        | one-thread-per-connection                                                                                                                                                                                                                                                                                                                        |
| thread_stack                                           | 262144                                                                                                                                                                                                                                                                                                                                           |
| time_format                                            | %H:%i:%s                                                                                                                                                                                                                                                                                                                                         |
| time_zone                                              | SYSTEM                                                                                                                                                                                                                                                                                                                                           |
| timed_mutexes                                          | OFF                                                                                                                                                                                                                                                                                                                                              |
| timestamp                                              | 1435669399.096587                                                                                                                                                                                                                                                                                                                                |
| tmp_table_size                                         | 16777216                                                                                                                                                                                                                                                                                                                                         |
| tmpdir                                                 | /tmp                                                                                                                                                                                                                                                                                                                                             |
| transaction_alloc_block_size                           | 8192                                                                                                                                                                                                                                                                                                                                             |
| transaction_allow_batching                             | OFF                                                                                                                                                                                                                                                                                                                                              |
| transaction_prealloc_size                              | 4096                                                                                                                                                                                                                                                                                                                                             |
| tx_isolation                                           | REPEATABLE-READ                                                                                                                                                                                                                                                                                                                                  |
| tx_read_only                                           | OFF                                                                                                                                                                                                                                                                                                                                              |
| unique_checks                                          | ON                                                                                                                                                                                                                                                                                                                                               |
| updatable_views_with_limit                             | YES                                                                                                                                                                                                                                                                                                                                              |
| version                                                | 5.6.21-enterprise-commercial-advanced                                                                                                                                                                                                                                                                                                            |
| version_comment                                        | MySQL Enterprise Server - Advanced Edition (Commercial)                                                                                                                                                                                                                                                                                          |
| version_compile_machine                                | x86_64                                                                                                                                                                                                                                                                                                                                           |
| version_compile_os                                     | Linux                                                                                                                                                                                                                                                                                                                                            |
| wait_timeout                                           | 28800                                                                                                                                                                                                                                                                                                                                            |
| warning_count                                          | 0                                                                                                                                                                                                                                                                                                                                                |
+--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
447 rows in set (0.00 sec)

mysql> show session status;
+-----------------------------------------------+-------------+
| Variable_name                                 | Value       |
+-----------------------------------------------+-------------+
| Aborted_clients                               | 35          |
| Aborted_connects                              | 5           |
| Binlog_cache_disk_use                         | 0           |
| Binlog_cache_use                              | 0           |
| Binlog_stmt_cache_disk_use                    | 0           |
| Binlog_stmt_cache_use                         | 0           |
| Bytes_received                                | 1376        |
| Bytes_sent                                    | 261256      |
| Com_admin_commands                            | 0           |
| 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                               | 0           |
| Com_alter_tablespace                          | 0           |
| Com_alter_user                                | 0           |
| Com_analyze                                   | 3           |
| Com_begin                                     | 0           |
| Com_binlog                                    | 0           |
| Com_call_procedure                            | 0           |
| Com_change_db                                 | 1           |
| 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                              | 0           |
| Com_create_trigger                            | 0           |
| Com_create_udf                                | 0           |
| Com_create_user                               | 0           |
| Com_create_view                               | 0           |
| Com_dealloc_sql                               | 0           |
| Com_delete                                    | 0           |
| 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                                     | 0           |
| Com_get_diagnostics                           | 0           |
| Com_grant                                     | 0           |
| Com_ha_close                                  | 0           |
| Com_ha_open                                   | 0           |
| Com_ha_read                                   | 0           |
| Com_help                                      | 0           |
| Com_insert                                    | 0           |
| Com_insert_select                             | 0           |
| Com_install_plugin                            | 0           |
| Com_kill                                      | 0           |
| Com_load                                      | 0           |
| Com_lock_tables                               | 0           |
| 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                                   | 0           |
| 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                                    | 8           |
| Com_set_option                                | 3           |
| Com_signal                                    | 0           |
| Com_show_binlog_events                        | 0           |
| Com_show_binlogs                              | 0           |
| Com_show_charsets                             | 0           |
| Com_show_collations                           | 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                         | 3           |
| Com_show_create_trigger                       | 0           |
| Com_show_databases                            | 1           |
| Com_show_engine_logs                          | 0           |
| Com_show_engine_mutex                         | 0           |
| Com_show_engine_status                        | 0           |
| Com_show_events                               | 0           |
| Com_show_errors                               | 0           |
| Com_show_fields                               | 6           |
| Com_show_function_code                        | 0           |
| Com_show_function_status                      | 0           |
| Com_show_grants                               | 0           |
| Com_show_keys                                 | 3           |
| Com_show_master_status                        | 0           |
| Com_show_open_tables                          | 0           |
| Com_show_plugins                              | 0           |
| Com_show_privileges                           | 0           |
| Com_show_procedure_code                       | 0           |
| Com_show_procedure_status                     | 0           |
| Com_show_processlist                          | 0           |
| Com_show_profile                              | 0           |
| Com_show_profiles                             | 0           |
| Com_show_relaylog_events                      | 0           |
| Com_show_slave_hosts                          | 0           |
| Com_show_slave_status                         | 0           |
| Com_show_status                               | 1           |
| Com_show_storage_engines                      | 0           |
| Com_show_table_status                         | 0           |
| Com_show_tables                               | 1           |
| Com_show_triggers                             | 0           |
| Com_show_variables                            | 1           |
| Com_show_warnings                             | 0           |
| 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                                  | 0           |
| Com_uninstall_plugin                          | 0           |
| Com_unlock_tables                             | 0           |
| Com_update                                    | 0           |
| 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         |
| Connection_errors_accept                      | 0           |
| Connection_errors_internal                    | 0           |
| Connection_errors_max_connections             | 0           |
| Connection_errors_peer_address                | 0           |
| Connection_errors_select                      | 0           |
| Connection_errors_tcpwrap                     | 0           |
| Connections                                   | 32452       |
| Created_tmp_disk_tables                       | 1           |
| Created_tmp_files                             | 166         |
| Created_tmp_tables                            | 7           |
| Delayed_errors                                | 0           |
| Delayed_insert_threads                        | 0           |
| Delayed_writes                                | 0           |
| Flush_commands                                | 1           |
| Handler_commit                                | 8           |
| Handler_delete                                | 0           |
| Handler_discover                              | 0           |
| Handler_external_lock                         | 24          |
| Handler_mrr_init                              | 0           |
| Handler_prepare                               | 0           |
| Handler_read_first                            | 4           |
| Handler_read_key                              | 24994       |
| Handler_read_last                             | 0           |
| Handler_read_next                             | 549980      |
| Handler_read_prev                             | 0           |
| Handler_read_rnd                              | 0           |
| Handler_read_rnd_next                         | 506         |
| Handler_rollback                              | 0           |
| Handler_savepoint                             | 0           |
| Handler_savepoint_rollback                    | 0           |
| Handler_update                                | 0           |
| Handler_write                                 | 499         |
| Innodb_buffer_pool_dump_status                | not started |
| Innodb_buffer_pool_load_status                | not started |
| Innodb_buffer_pool_pages_data                 | 710519      |
| Innodb_buffer_pool_bytes_data                 | 11641143296 |
| Innodb_buffer_pool_pages_dirty                | 0           |
| Innodb_buffer_pool_bytes_dirty                | 0           |
| Innodb_buffer_pool_pages_flushed              | 1958842     |
| Innodb_buffer_pool_pages_free                 | 8192        |
| Innodb_buffer_pool_pages_misc                 | 15305       |
| Innodb_buffer_pool_pages_total                | 734016      |
| Innodb_buffer_pool_read_ahead_rnd             | 0           |
| Innodb_buffer_pool_read_ahead                 | 275855      |
| Innodb_buffer_pool_read_ahead_evicted         | 79          |
| Innodb_buffer_pool_read_requests              | 2707554795  |
| Innodb_buffer_pool_reads                      | 189099      |
| Innodb_buffer_pool_wait_free                  | 0           |
| Innodb_buffer_pool_write_requests             | 990134388   |
| Innodb_data_fsyncs                            | 1414216     |
| Innodb_data_pending_fsyncs                    | 0           |
| Innodb_data_pending_reads                     | 0           |
| Innodb_data_pending_writes                    | 0           |
| Innodb_data_read                              | 7617892352  |
| Innodb_data_reads                             | 472907      |
| Innodb_data_writes                            | 3330753     |
| Innodb_data_written                           | 89332672000 |
| Innodb_dblwr_pages_written                    | 1958842     |
| Innodb_dblwr_writes                           | 73021       |
| Innodb_have_atomic_builtins                   | ON          |
| Innodb_log_waits                              | 0           |
| Innodb_log_write_requests                     | 50090903    |
| Innodb_log_writes                             | 1260442     |
| Innodb_os_log_fsyncs                          | 1261223     |
| Innodb_os_log_pending_fsyncs                  | 0           |
| Innodb_os_log_pending_writes                  | 0           |
| Innodb_os_log_written                         | 25144829952 |
| Innodb_page_size                              | 16384       |
| Innodb_pages_created                          | 862125      |
| Innodb_pages_read                             | 464954      |
| Innodb_pages_written                          | 1958842     |
| Innodb_row_lock_current_waits                 | 0           |
| Innodb_row_lock_time                          | 0           |
| Innodb_row_lock_time_avg                      | 0           |
| Innodb_row_lock_time_max                      | 0           |
| Innodb_row_lock_waits                         | 0           |
| Innodb_rows_deleted                           | 803493      |
| Innodb_rows_inserted                          | 59906438    |
| Innodb_rows_read                              | 502148293   |
| Innodb_rows_updated                           | 0           |
| Innodb_num_open_files                         | 894         |
| Innodb_truncated_status_writes                | 0           |
| Innodb_available_undo_logs                    | 128         |
| Key_blocks_not_flushed                        | 0           |
| Key_blocks_unused                             | 6698        |
| Key_blocks_used                               | 11          |
| Key_read_requests                             | 60978345    |
| Key_reads                                     | 11          |
| Key_write_requests                            | 323         |
| Key_writes                                    | 0           |
| Last_query_cost                               | 10.499000   |
| Last_query_partial_plans                      | 1           |
| Max_used_connections                          | 9           |
| Not_flushed_delayed_rows                      | 0           |
| Open_files                                    | 82          |
| Open_streams                                  | 0           |
| Open_table_definitions                        | 1997        |
| Open_tables                                   | 1997        |
| Opened_files                                  | 223565      |
| Opened_table_definitions                      | 5           |
| Opened_tables                                 | 5           |
| Performance_schema_accounts_lost              | 0           |
| Performance_schema_cond_classes_lost          | 0           |
| Performance_schema_cond_instances_lost        | 0           |
| Performance_schema_digest_lost                | 0           |
| Performance_schema_file_classes_lost          | 0           |
| Performance_schema_file_handles_lost          | 0           |
| Performance_schema_file_instances_lost        | 0           |
| Performance_schema_hosts_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_session_connect_attrs_lost | 0           |
| Performance_schema_socket_classes_lost        | 0           |
| Performance_schema_socket_instances_lost      | 0           |
| Performance_schema_stage_classes_lost         | 0           |
| Performance_schema_statement_classes_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           |
| Performance_schema_users_lost                 | 0           |
| Prepared_stmt_count                           | 0           |
| Qcache_free_blocks                            | 1           |
| Qcache_free_memory                            | 1031352     |
| Qcache_hits                                   | 0           |
| Qcache_inserts                                | 0           |
| Qcache_lowmem_prunes                          | 0           |
| Qcache_not_cached                             | 1647745     |
| Qcache_queries_in_cache                       | 0           |
| Qcache_total_blocks                           | 1           |
| Queries                                       | 5732786     |
| Questions                                     | 32          |
| Rsa_public_key                                |             |
| Select_full_join                              | 0           |
| Select_full_range_join                        | 0           |
| Select_range                                  | 0           |
| Select_range_check                            | 0           |
| Select_scan                                   | 11          |
| Slave_heartbeat_period                        |             |
| Slave_last_heartbeat                          |             |
| Slave_open_temp_tables                        | 0           |
| Slave_received_heartbeats                     |             |
| Slave_retried_transactions                    |             |
| Slave_running                                 | OFF         |
| Slow_launch_threads                           | 0           |
| Slow_queries                                  | 0           |
| Sort_merge_passes                             | 0           |
| Sort_range                                    | 0           |
| Sort_rows                                     | 0           |
| Sort_scan                                     | 0           |
| 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_server_not_after                          |             |
| Ssl_server_not_before                         |             |
| 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                                   |             |
| Table_locks_immediate                         | 1512475     |
| Table_locks_waited                            | 0           |
| Table_open_cache_hits                         | 19          |
| Table_open_cache_misses                       | 5           |
| Table_open_cache_overflows                    | 0           |
| Tc_log_max_pages_used                         | 0           |
| Tc_log_page_size                              | 0           |
| Tc_log_page_waits                             | 0           |
| Threads_cached                                | 4           |
| Threads_connected                             | 5           |
| Threads_created                               | 9           |
| Threads_running                               | 1           |
| Uptime                                        | 1892792     |
| Uptime_since_flush_status                     | 1892792     |
+-----------------------------------------------+-------------+
342 rows in set (0.00 sec)

mysql> select sql_no_cache e.id, g.id, c.id from entry e inner join entry_group g on  g.id = e.group_id inner join category c on c.id = g.category_id where e.uneven_val between 300 and 8000;
+--------+-------+----+
| id     | id    | id |
+--------+-------+----+
|    602 |    48 |  1 |
   *** removed ***
| 249892 | 24971 |  7 |
+--------+-------+----+
11796 rows in set (0.46 sec)

mysql> show profile all for query 3;
+----------------------+----------+----------+------------+-------------------+---------------------+--------------+---------------+---------------+-------------------+-------------------+-------------------+-------+-----------------------+------------------+-------------+
| Status               | Duration | CPU_user | CPU_system | Context_voluntary | Context_involuntary | Block_ops_in | Block_ops_out | Messages_sent | Messages_received | Page_faults_major | Page_faults_minor | Swaps | Source_function       | Source_file      | Source_line |
+----------------------+----------+----------+------------+-------------------+---------------------+--------------+---------------+---------------+-------------------+-------------------+-------------------+-------+-----------------------+------------------+-------------+
| starting             | 0.000143 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | NULL                  | NULL             |        NULL |
| checking permissions | 0.000009 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | check_access          | sql_parse.cc     |        5266 |
| checking permissions | 0.000003 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | check_access          | sql_parse.cc     |        5266 |
| checking permissions | 0.000009 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | check_access          | sql_parse.cc     |        5266 |
| Opening tables       | 0.000078 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | open_tables           | sql_base.cc      |        4998 |
| init                 | 0.000052 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | mysql_prepare_select  | sql_select.cc    |        1050 |
| System lock          | 0.000018 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | mysql_lock_tables     | lock.cc          |         304 |
| optimizing           | 0.000039 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | optimize              | sql_optimizer.cc |         138 |
| statistics           | 0.000210 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | optimize              | sql_optimizer.cc |         362 |
| preparing            | 0.000050 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | optimize              | sql_optimizer.cc |         485 |
| executing            | 0.000007 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | exec                  | sql_executor.cc  |         110 |
| Sending data         | 0.454392 | 0.456930 |   0.001000 |                11 |                   0 |            0 |             0 |             0 |                 0 |                 0 |               213 |     0 | exec                  | sql_executor.cc  |         190 |
| end                  | 0.000016 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | mysql_execute_select  | sql_select.cc    |        1105 |
| query end            | 0.000012 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | mysql_execute_command | sql_parse.cc     |        4965 |
| closing tables       | 0.000020 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | mysql_execute_command | sql_parse.cc     |        5013 |
| freeing items        | 0.000030 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | mysql_parse           | sql_parse.cc     |        6292 |
| cleaning up          | 0.000173 | 0.000000 |   0.000000 |                 0 |                   0 |            0 |             0 |             0 |                 0 |                 0 |                 0 |     0 | dispatch_command      | sql_parse.cc     |        1772 |
+----------------------+----------+----------+------------+-------------------+---------------------+--------------+---------------+---------------+-------------------+-------------------+-------------------+-------+-----------------------+------------------+-------------+
17 rows in set, 1 warning (0.00 sec)

mysql> exit