36 Commits (v3.0)

Author	SHA1	Message	Date
Miro Stauder	d020f577b2	reduce duplication in makefiles, use include for common stuff	4 months ago
René Cannaò	216b31feae	Added new event_type PROXYSQL_METADATA ... When creating an event log in binary format, a metadata packet is written. The metadata is in JSON format. It currently only provide the ProxySQL version. For illustration purposes, tool eventlog_reader_to_json.cpp supports it too. This commit includes also some reformatting	10 months ago
René Cannaò	a39580ffe1	Several fixes on prepared statements parameters logging ... In write_query_format_1() : * write the number of parameters (previously erroneously skipped) * write null_bitmap only if there are parameters * write the parameters values (this was previously erroneously skipped) In test_ps_logging-t.cpp : * verify that query logging is configured to file In eventlog_reader_to_json.cpp : * added verbose logging * added enum `log_event_type` for properly identifying event type * parse all events in the input file	11 months ago
René Cannaò	373f55c58b	Adding eventlog_reader_to_json ... eventlog_reader_to_json.cpp is the first iteration of a tool able to read an eventlog in binary format and generate a JSON	11 months ago
Javier Jaramago Fernández	d35acce244	Fix 'eventslog_reader_sample' crash when non-existing file is supplied	3 years ago
Javier Jaramago Fernández	4192041093	Add support to 'stmt_id' field to 'eventslog_reader_sample'	3 years ago
René Cannaò	2c154a2bab	Merge pull request #2143 from Mount565/v2.0.5 ... Fix a possible memory leak	7 years ago
William Wang	3a599fccee	Update eventslog_reader_sample.cpp ... Avoid `double free or corruption ` when free(client)	7 years ago
William Wang	54e7e8550b	Update eventslog_reader_sample.cpp ... fix a possible memory leak	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
Yakir Gibraltar	ab28efc5f2	Fix schemaname output in eventslog_reader_sample (#2053) ... Right now "schemaname" without one apostrophes, before: ProxySQL LOG QUERY: thread_id="378394" username="cs_rw" schemaname=trc" client="10.101.10.101:48485" HID=10 server="bdb:3306" starttime="2019-05-13 09:09:25.274582" endtime="2019-05-13 09:09:25.275245" duration=663us digest="0x3C82E0201EA10A7B" After fix: ProxySQL LOG QUERY: thread_id="378394" username="cs_rw" schemaname="trc" client="10.101.10.101:48485" HID=10 server="bdb:3306" starttime="2019-05-13 09:09:25.274582" endtime="2019-05-13 09:09:25.275245" duration=663us digest="0x3C82E0201EA10A7B"	7 years ago
René Cannaò	c41fc97fd0	Fix digest output in eventslog_reader_sample #2015	7 years ago
René Cannaò	29fb0d211f	Explicitly add /sbin in $PATH #1597	8 years ago
Hiroaki Nito	f3feddb302	Prevent duplicate execution of proxysql_galera_checker.sh	8 years ago
Krzysztof Ksiazek	31e29ddc90	Further improvements to reduce config reloading	9 years ago
René Cannaò	02cbe18284	Merging #981 into 1.4.2	9 years ago
René Cannaò	18b2a3cecd	proxysql_galera_check.sh Usage text #968	9 years ago
René Cannaò	e369076bfb	Merge pull request #880 from Dan83/master ... Replace the spinlock on ProxySQL_Admin::wrlock with a pthread mutex or wrlock	9 years ago
René Cannaò	28d9cbd893	Allows to compile eventslog_reader_sample.cpp in recent CentOS	9 years ago
Kenny Gryp	647cc8aea0	semi-rewrite of proxysql_galera_checker.sh	9 years ago
Kenny Gryp	5adad25561	prefer nodes with higher weight when number_writers>1 ... When limiting the number of writers, prefer nodes with highest weight	9 years ago
René Cannaò	c11d4b3359	Changing permission to proxysql_galera_writer.pl	10 years ago
Krzysztof Ksiazek	afd98fe4a7	Add support for handling case where only available nodes are in Donor/Desync state. It's preferred to use Desync/Donor node as reader and writer than to have all nodes in OFFLINE_SOFT	10 years ago
Francisco Miguel Biete	226bfa24d6	Fix: usage function must be defined before actual use	10 years ago
Francisco Miguel Biete	d0e9489a10	Special situation: don't disable read in writers when there are not ... readers online	10 years ago
Francisco Miguel Biete	be576c81de	Add writer, reader hostgroup functionality to proxysql_galera_checker.sh	10 years ago
hrvojem	28d3117002	Fixed issue #636 by reversing the order_by to get the correct ... credentials: mysql> SELECT variable_name FROM global_variables WHERE variable_name IN ('mysql-monitor_username','mysql-monitor_password') ORDER BY variable_name DESC; +------------------------+ | variable_name | +------------------------+ | mysql-monitor_username | | mysql-monitor_password | +------------------------+ 2 rows in set (0.01 sec)	10 years ago
René Cannaò	4b4e1234a1	Added tool proxysql_galera_writer.pl	10 years ago
René Cannaò	32163bf892	Scheduler now starts a thread for waitpid() ... Issue #578	10 years ago
René Cannaò	3cd072b9ab	Added tool proxysql_galera_checker.sh	10 years ago
René Cannaò	4e76620d8e	Added check_variables.pl script	10 years ago
René Cannaò	8e81495bee	Improved logging ... Added logging information for: - client - server - hostgroup_id - digest - duration	10 years ago
René Cannaò	fc36d5487f	Prefixing query logging with an identifier	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ò	1b5dcaf46a	Improvement on eventslog_reader	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/	10 years ago