5.4. Status variables

Here are the explanations of status variables that are introduced by Mroonga.

5.4.1. Mroonga_count_skip

This value is increased when ‘fast line count feature’ is used. You can use this value to check if the feature is working when you enable it.

Here is an example how to check it:

mysql> SHOW STATUS LIKE 'Mroonga_count_skip';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| Mroonga_count_skip | 0     |
+--------------------+-------+
1 row in set (0.00 sec)

5.4.2. Mroonga_fast_order_limit

This value is increased when ‘fast ORDER BY LIMIT feature’ is used. You can use this value to check if the feature is working when you enable it.

Here is an example how to check it:

mysql> SHOW STATUS LIKE 'Mroonga_fast_order_limit';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Mroonga_fast_order_limit | 0     |
+--------------------------+-------+
1 row in set (0.00 sec)

5.4.3. Mroonga_condition_push_down

This value is increased when condition push down is used. You can use this value to check whether condition push down is used or not.

Here is an example how to check it:

mysql> SHOW STATUS LIKE 'Mroonga_condition_push_down';
+-----------------------------+-------+
| Variable_name               | Value |
+-----------------------------+-------+
| Mroonga_condition_push_down | 1     |
+-----------------------------+-------+
1 row in set (0.00 sec)

5.4.4. Mroonga_n_pooling_contexts

This value shows the number of pooling contexts for mroonga_command(). These contexts are reused from multiple mroonga_command() calls. So, it’s not increased continually.

Here is an example how to check it:

mysql> SHOW STATUS LIKE 'Mroonga_n_pooling_contexts';
+----------------------------+-------+
| Variable_name              | Value |
+----------------------------+-------+
| Mroonga_n_pooling_contexts | 0     |
+----------------------------+-------+
1 row in set (0.00 sec)

5.4.5. Mroonga_memory_map_size

New in version 12.0.4.

This value shows the currently memory mapped size in bytes.

Here is an example how to check it:

mysql> SHOW STATUS LIKE 'Mroonga_memory_map_size';
+-------------------------+----------+
| Variable_name           | Value    |
+-------------------------+----------+
| Mroonga_memory_map_size | 83406848 |
+-------------------------+----------+
1 row in set (0.00 sec)