aboutsummaryrefslogtreecommitdiff
path: root/project/dclib/dclib-mysql.h
diff options
context:
space:
mode:
authorWiimm <wiimm@wiimm.de>2022-05-13 19:22:13 +0200
committerWiimm <wiimm@wiimm.de>2022-05-13 19:22:13 +0200
commit568365f5bdd4dc71a156ca963d89ac002f405a34 (patch)
tree730d0311536d8fd46a56b74e2c8cac028e778243 /project/dclib/dclib-mysql.h
parent9ae8841ec4720e74173e2f72fac33f0848bbf435 (diff)
SZS v2.27a
Diffstat (limited to '')
-rw-r--r--project/dclib/dclib-mysql.h38
1 files changed, 32 insertions, 6 deletions
diff --git a/project/dclib/dclib-mysql.h b/project/dclib/dclib-mysql.h
index c251fda..8ae7e2c 100644
--- a/project/dclib/dclib-mysql.h
+++ b/project/dclib/dclib-mysql.h
@@ -14,16 +14,16 @@
* *
***************************************************************************
* *
- * Copyright (c) 2012-2021 by Dirk Clemens <wiimm@wiimm.de> *
+ * Copyright (c) 2012-2022 by Dirk Clemens <wiimm@wiimm.de> *
* *
***************************************************************************
* *
- * This program is free software; you can redistribute it and/or modify *
+ * This library is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or *
* (at your option) any later version. *
* *
- * This program is distributed in the hope that it will be useful, *
+ * This library is distributed in the hope that it will be useful, *
* but WITHOUT ANY WARRANTY; without even the implied warranty of *
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
* GNU General Public License for more details. *
@@ -66,6 +66,22 @@ LogLevelMYSQL;
//
///////////////////////////////////////////////////////////////////////////////
+/////////////// watch long queries ///////////////
+///////////////////////////////////////////////////////////////////////////////
+
+void SetupQueryLogMYSQL
+(
+ ccp fname, // filename of log file, openend with mode "a"
+ ccp tag, // identification of the tool for shared log files
+ u_nsec_t nsec, // >0: log queries that need ≥# nsec
+ uint size // >0: log queries that are longer ≥# bytes
+);
+
+void CloseQueryLogMYSQL(void);
+struct LogFile_t * OpenQueryLogMYSQL(void);
+
+//
+///////////////////////////////////////////////////////////////////////////////
/////////////// struct MySqlStatus_t ///////////////
///////////////////////////////////////////////////////////////////////////////
@@ -142,7 +158,7 @@ typedef struct MySql_t
//--- statistics
- uint total_connect_count; // total number of connections (usualy 1)
+ uint total_connect_count; // total number of connections (usually 1)
uint total_query_count; // total number of queries
u64 total_query_size; // total size of all queries
uint total_result_count; // total number of fetched results
@@ -158,6 +174,8 @@ typedef struct MySql_t
}
MySql_t;
+extern const SaveRestoreTab_t SRT_Mysql[];
+
//
///////////////////////////////////////////////////////////////////////////////
/////////////// interface for MySql_t ///////////////
@@ -264,6 +282,7 @@ s64 FetchIntMYSQL
(
MySql_t *my, // valid struct
LogLevelMYSQL loglevel, // log level for mysql errors and queries
+ bool allow_trail, // allow additional chars behind number
s64 return_default // return this value on non existent result
);
@@ -271,6 +290,7 @@ u64 FetchUIntMYSQL
(
MySql_t *my, // valid struct
LogLevelMYSQL loglevel, // log level for mysql errors and queries
+ bool allow_trail, // allow additional chars behind number
u64 return_default // return this value on non existent result
);
@@ -302,21 +322,23 @@ s64 PrintFetchIntMYSQL
(
MySql_t *my, // valid struct
LogLevelMYSQL loglevel, // log level for mysql errors and queries
+ bool allow_trail, // allow additional chars behind number
s64 return_default, // return this value on non existent result
ccp format, // format string for vsnprintf()
... // parameters for 'format'
)
-__attribute__ ((__format__(__printf__,4,5)));
+__attribute__ ((__format__(__printf__,5,6)));
u64 PrintFetchUIntMYSQL
(
MySql_t *my, // valid struct
LogLevelMYSQL loglevel, // log level for mysql errors and queries
+ bool allow_trail, // allow additional chars behind number
u64 return_default, // return this value on non existent result
ccp format, // format string for vsnprintf()
... // parameters for 'format'
)
-__attribute__ ((__format__(__printf__,4,5)));
+__attribute__ ((__format__(__printf__,5,6)));
//-----------------------------------------------------------------------------
// fetch single row
@@ -535,6 +557,10 @@ MySqlServerStats_t * Max2MySqlServerStats
const MySqlServerStats_t *src // NULL or source
);
+///////////////////////////////////////////////////////////////////////////////
+
+extern UsageDuration_t mysql_query_usage;
+
//
///////////////////////////////////////////////////////////////////////////////
/////////////// E N D ///////////////