mirror of
https://github.com/MariaDB/server.git
synced 2025-01-15 19:42:28 +01:00
243b9f3cd2
This is to update the plugin to be compatible with Percona's query_response_time plugin, with some additions. Some of the tests are taken from Percona server. - Added plugins QUERY_RESPONSE_TIME_READ, QUERY_RESPONSE_TIME_WRITE and QUERY_RESPONSE_TIME_READ_WRITE. - Added option query_response_time_session_stats, with possible values GLOBAL, ON or OFF, to the query_response_time plugin. Notes: - All modules are dependent on QUERY_RESPONSE_READ_TIME. This must always be enabled if any of the other modules are used. This will be auto-enabled in the near future. - Accounting are done per statement. Stored functions are regarded as part of the original statement. - For stored procedures the accounting are done per statement executed in the stored procedure. CALL will not be accounted because of this. - FLUSH commands will not be accounted for. This is to ensure that FLUSH QUERY_RESPONSE_TIME is not part of the statistics. (This helps when testing with mtr and otherwise). - FLUSH QUERY_RESPONSE_TIME_READ and FLUSH QUERY_RESPONSE_TIME_READ only resets the corresponding status. - FLUSH QUERY_RESPONSE_TIME and FLUSH QUERY_RESPONSE_TIME_READ_WRITE or changing the value of query_response_time_range_base followed by any FLUSH of QUERY_RESPOSNSE_TIME resets all status.
87 lines
2.7 KiB
C
87 lines
2.7 KiB
C
#ifndef QUERY_RESPONSE_TIME_H
|
|
#define QUERY_RESPONSE_TIME_H
|
|
|
|
/*
|
|
Settings for query response time
|
|
*/
|
|
|
|
/*
|
|
Maximum string length for (10 ^ (-1 * QRT_STRING_NEGATIVE_POWER_LENGTH)) in text representation.
|
|
Example: for 6 is 0.000001
|
|
Always 2
|
|
|
|
Maximum string length for (10 ^ (QRT_STRING_POSITIVE_POWER_LENGTH + 1) - 1) in text representation.
|
|
Example: for 7 is 9999999.0
|
|
*/
|
|
#define QRT_TIME_STRING_POSITIVE_POWER_LENGTH 7
|
|
#define QRT_TOTAL_STRING_POSITIVE_POWER_LENGTH 7
|
|
|
|
/*
|
|
Minimum base for log - ALWAYS 2
|
|
Maximum base for log:
|
|
*/
|
|
#define QRT_MAXIMUM_BASE 1000
|
|
|
|
/*
|
|
Filler for whole number (positive power)
|
|
Example: for
|
|
QRT_POSITIVE_POWER_FILLER ' '
|
|
QRT_POSITIVE_POWER_LENGTH 7
|
|
and number 7234 result is:
|
|
' 7234'
|
|
*/
|
|
#define QRT_POSITIVE_POWER_FILLER ""
|
|
/*
|
|
Filler for fractional number. Similiary to whole number
|
|
*/
|
|
#define QRT_NEGATIVE_POWER_FILLER "0"
|
|
|
|
/*
|
|
Message if time too big for statistic collecting (very long query)
|
|
*/
|
|
#define QRT_TIME_OVERFLOW "TOO LONG"
|
|
|
|
#define QRT_DEFAULT_BASE 10
|
|
|
|
#define QRT_TIME_STRING_LENGTH \
|
|
MY_MAX( (QRT_TIME_STRING_POSITIVE_POWER_LENGTH + 1 /* '.' */ + 6 /*QRT_TIME_STRING_NEGATIVE_POWER_LENGTH*/), \
|
|
(sizeof(QRT_TIME_OVERFLOW) - 1) )
|
|
|
|
#define QRT_TOTAL_STRING_LENGTH \
|
|
MY_MAX( (QRT_TOTAL_STRING_POSITIVE_POWER_LENGTH + 1 /* '.' */ + 6 /*QRT_TOTAL_STRING_NEGATIVE_POWER_LENGTH*/), \
|
|
(sizeof(QRT_TIME_OVERFLOW) - 1) )
|
|
|
|
extern ST_SCHEMA_TABLE query_response_time_table;
|
|
|
|
enum QUERY_TYPE
|
|
{
|
|
ANY= 0, /* Total */
|
|
READ= 1, /* Only reads */
|
|
WRITE= 2 /* Only writes */
|
|
};
|
|
|
|
#define QUERY_TYPES (QUERY_TYPE::WRITE+1)
|
|
|
|
typedef class Item COND;
|
|
|
|
#ifdef HAVE_RESPONSE_TIME_DISTRIBUTION
|
|
extern void query_response_time_init();
|
|
extern void query_response_time_free();
|
|
extern int query_response_time_flush_all();
|
|
extern int query_response_time_flush_read();
|
|
extern int query_response_time_flush_write();
|
|
extern void query_response_time_collect(QUERY_TYPE type, ulonglong query_time);
|
|
extern int query_response_time_fill(THD* thd, TABLE_LIST *tables,
|
|
COND *cond);
|
|
extern int query_response_time_fill_read(THD* thd, TABLE_LIST *tables,
|
|
COND *cond);
|
|
extern int query_response_time_fill_write(THD* thd, TABLE_LIST *tables,
|
|
COND *cond);
|
|
extern int query_response_time_fill_read_write(THD* thd, TABLE_LIST *tables,
|
|
COND *cond);
|
|
|
|
extern ulong opt_query_response_time_range_base;
|
|
extern my_bool opt_query_response_time_stats;
|
|
#endif // HAVE_RESPONSE_TIME_DISTRIBUTION
|
|
|
|
#endif // QUERY_RESPONSE_TIME_H
|