[Maria-developers] doubt about mdev 4682 - tests
Guys, i'm with time and was looking an old patch about query cache information schema https://mariadb.atlassian.net/browse/MDEV-4682 it add an statistic about query cache hits my doubt is... i was trying to understand how could i create tests, since the result of statistic isn't deterministic how should i execute a test case like this? columns that i have doubt: columns ... QUERY_ROWS <- deterministic SELECT_ROWS_READ <- deterministic QUERY_HITS <- deterministic QUERY_HITS_PERIOD_LOW <- non deterministic QUERY_HITS_PERIOD_HIGH <- non deterministic QUERY_HITS_PERIOD_OUTLIERS <- non deterministic QUERY_HITS_TOTAL_TIME_US <- non deterministic QUERY_HITS_MEAN_PERIOD_US <- non deterministic QUERY_HITS_MEAN_PERIOD_LOW_US <- non deterministic QUERY_HITS_MEAN_PERIOD_HIGH_US <- non deterministic QUERY_INSERT_TIME <- probably deterministic (or not?) QUERY_LAST_HIT_TIME <- probably deterministic (or not?) SELECT_EXPEND_TIME_US <- non deterministic SELECT_LOCK_TIME_US <- non deterministic ... -- Roberto Spadim
On 09/04/2014 06:21 AM, Roberto Spadim wrote:
my doubt is... i was trying to understand how could i create tests, since the result of statistic isn't deterministic how should i execute a test case like this?
there is very simple/limited support for this with the --replace-... commands in mysqltest, see: http://dev.mysql.com/doc/mysqltest/2.0/en/writing-tests-output-postprocessin... http://dev.mysql.com/doc/mysqltest/2.0/en/mysqltest-commands.html#idm4769095... http://dev.mysql.com/doc/mysqltest/2.0/en/mysqltest-commands.html#idm4769095... or you could wrap this up in a stored procedure call and check for expected value ranges in there ... -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL - The MariaDB Company | http://www.skysql.com/
participants (2)
-
Hartmut Holzgraefe
-
Roberto Spadim