33 Commits (v2.7.2)

Author	SHA1	Message	Date
Javier Jaramago Fernández	7c4445a44f	Add Prometheus metric for 'MySQL_Logger' metric 'totalGetAllEventsTimeMicros'	1 year ago
Javier Jaramago Fernández	c729b07544	Fix typo for 'MySQL_Logger' metric 'totalGetAllEventsTimeMicros'	1 year ago
Javier Jaramago Fernández	0a2cc5e5fc	Add Prometheus metrics support for 'MySQL_Logger' module	1 year ago
René Cannaò	124fb2895f	Adding errno into in-memory query logging ... New `errno` column in tables: - stats_mysql_query_events - history_mysql_query_events Logging into `stats_mysql_errors` also errors generated by ProxySQL (no backend) Added initial TAP test to be extended	2 years ago
René Cannaò	234d4e6d59	Drafting handling of errors in MySQL Events log 2	2 years ago
René Cannaò	9eeed3c45b	Drafting handling of errors in MySQL Events log	2 years ago
René Cannaò	ede0e7f268	MySQL_Logger::getAllMetrics() ... Added function MySQL_Logger::getAllMetrics() to export all metrics related to eventlogs	2 years ago
René Cannaò	8f0324b9af	MySQL_Event log buffering enhancements ... Added enhancements: * added mysql-eventslog_table_memory_size * liste columns names in insertMysqlEventsIntoDb() * added counters and metrics (not exported yet)	2 years ago
René Cannaò	8e768f4e2d	Improved documentation	2 years ago
René Cannaò	28982a4e0a	Adding documentation on in memory eventslog	2 years ago
René Cannaò	23e3244cc5	Implementation of processEvents() and DUMP EVENTSLOG commands ... MySQL_Logger::processEvents() is responsible for dumping mysql query events from the circular buffer into SQLite tables. DUMP EVENTSLOG commands trigger a call to processEvents(): * DUMP EVENTSLOG FROM BUFFER TO MEMORY: copies events to the in-memory SQLite table * DUMP EVENTSLOG FROM BUFFER TO DISK: copies events to the on-disk SQLite table * DUMP EVENTSLOG FROM BUFFER TO BOTH: copies events to both in-memory and on-disk SQLite tables simultaneously	2 years ago
René Cannaò	efb95ca87e	First implementation of insertMysqlEventsIntoDb() ... MySQL_Logger::insertMysqlEventsIntoDb() populate table `stats_mysql_query_events` using mysql query events in the circular buffer	2 years ago
René Cannaò	754f1e52f2	Reimplementation of MySQL_Logger_CircularBuffer::get_all_events() ... Accept a reference to a vector instead of returning a deque	2 years ago
René Cannaò	61c189b8c3	Reimplementation of the circular buffer for Query Logging	2 years ago
Rene Cannao	6a2d52f610	Adding a circular buffer to MySQL_Logger	2 years ago
René Cannaò	c0745b42c2	Adding last_insert_id and last_gtid to MySQL_Logger	3 years ago
Javier Jaramago Fernández	41ef582fc5	Add new field 'stmt_id' to eventslog for 'STMT_PREPARE|STMT_EXECUTE' events	4 years ago
René Cannaò	255d9247b8	Reduce locking on MySQL_Logger writes to disk	7 years ago
René Cannaò	0831740e45	Several enhancements on Query logger ... Enhancements: - added metrics rows_affected and rows_sent - added global variable mysql-eventslog_default_log : if 1 , logging is enabled for every query unless explicitly disabled in mysql_query_rules.log . Default is 0 - added global variable mysql-eventslog_format : default is 1 (legacy format). A value of 2 enables logging in JSON format. Issue #871 Changing value at runtime causes the current file to be closed and a new one created - fixed logging for prepared statements: till 2.0.5 only some percentage of prepared statements was correctly logged Extended tables stats_mysql_query_digest and stats_mysql_query_digest_reset to also include sum_rows_affected and sum_rows_sent Extended `eventslog_reader_sample.cpp` to support the new enhancements	7 years ago
René Cannaò	7ea33a1312	Completing initial implementation of Audit module	7 years ago
René Cannaò	9e2c1fdda1	Draft implementation of audit log	7 years ago
René Cannaò	5e05348b22	Remove spinlock from MySQL Logger #977	9 years ago
René Cannaò	abd83ff1a3	Compile 1.4.0 on on FreeBSD #898	9 years ago
René Cannaò	a6c53d0d12	Revert "Refactor header includes."	10 years ago
Maxim Bublis	30dbcc21a8	Refactor header includes. ... * reduce build time by 25%; * remove circular dependency on `cpp.h` and other headers. * fixes issue with `my_global.h` from mariadbclient which redefines `__attribute__`, that leads to broken STL and GCC intrinsics if `<algorithm>` wasn't included prior including this header; * fixes another issue with redefined `__attribute__` which leads to `_conn_exchange_t` not being aligned to cache line size; * removes `pthread_setstacksize` calls as `my_global.h` redefines `pthread_setstacksize` to be `pthread_dummy(0)` which led to stack size being never adjusted; * add missing include guards to some headers; * remove unused proxysql_hash.h header.	10 years ago
René Cannaò	8e81495bee	Improved logging ... Added logging information for: - client - server - hostgroup_id - digest - duration	10 years ago
René Cannaò	31ac6625f6	Logging improvements, related to #561 ... - added new function realtime_time() to get real time - added support for multiple events, default PROXYSQL_QUERY - MySQL_Event::write() will perfom a different action depending from log_event_type - rewrote part of eventslog_reader_sample.cpp: - it had few bugs - MySQL_Event::read() will perform a different action depending from log_event_type - time are printed in real time and not monotonic time - all info about a query are printed in one line	10 years ago
René Cannaò	7830689dd9	New event logger ... Implemented new event logger that will replace protobuf It uses the same encoding of mysql protocol Added also a reader in ./tools/	11 years ago
René Cannaò	a63b7cf951	MySQL_Logger configuration ... - added global variable eventslog_filename - added global variable eventslog_filesize	11 years ago
René Cannaò	5ad97666f2	Improvement on MySQL_Logger ... added flush_log_unlocked() hardcoded max size for testing	11 years ago
René Cannaò	535030d546	MySQL_Logger starts logging using protobuf	11 years ago
René Cannaò	dbb9c111bb	Extending and testing MySQL_Logger()	11 years ago
René Cannaò	125cfa2c3b	First commit with MySQL_Logger	11 years ago