null+****@clear*****
null+****@clear*****
2011年 11月 28日 (月) 16:58:29 JST
Kouhei Sutou 2011-11-28 07:58:29 +0000 (Mon, 28 Nov 2011) New Revision: 20605f2661510d68f40af435a7c9fbba02c22493 Log: [doc] add examples for status variables. Modified files: doc/source/reference.rst Modified: doc/source/reference.rst (+20 -0) =================================================================== --- doc/source/reference.rst 2011-11-28 07:51:23 +0000 (550a44d) +++ doc/source/reference.rst 2011-11-28 07:58:29 +0000 (b5e7dc5) @@ -133,8 +133,28 @@ groonga_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 'groonga_count_skip'; + +--------------------+-------+ + | Variable_name | Value | + +--------------------+-------+ + | groonga_count_skip | 0 | + +--------------------+-------+ + 1 row in set (0.00 sec) + groonga_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 'groonga_fast_order_limit'; + +--------------------------+-------+ + | Variable_name | Value | + +--------------------------+-------+ + | groonga_fast_order_limit | 0 | + +--------------------------+-------+ + 1 row in set (0.00 sec)