4288 Commits (v3.0.1)

Author	SHA1	Message	Date
René Cannaò	2c26a42897	Merge pull request #4819 from sysown/v3.0-ff_conns_eof_caps_match ... Enforce `CLIENT_DEPRECATE_EOF` capability match for `fast-forward` sessions	11 months ago
René Cannaò	66322d05cf	Merge pull request #4851 from sysown/v3.0-ReadySet1 ... First POC for integration with ReadySet	12 months ago
René Cannaò	988d4049ac	Merge pull request #4941 from sysown/v3.0-4935 ... Fix losing database info on first logging for 'caching_sha2_password' - Closes #4935	12 months ago
René Cannaò	b888cb89b9	Readyset: always use proxy_warning() when changing status	12 months ago
René Cannaò	f9575b7ee9	Addressing minor issue on Readyset Monitoring ... - Renamed ReadySet to Readyset - fixed incorrect status variable - added missing newlines	12 months ago
René Cannaò	e5b30282b7	Adding info/warning message when ReadySet server change status ... INFO: if status is changed to ONLINE WARNING : if status is changed to anything else	12 months ago
René Cannaò	d641ca89be	First POC for integration with ReadySet ... Monitor is able to detect if a backend is a ReadySet server, and it enables special monitoring. The special monitoring hacks replication lag checks: a ReadySet server is "monitored for replication lag" , but it has a special query and a special handler. The query for check is "SHOW READYSET STATUS" , and the `Status` line is processed: * Online: the backend is configured as ONLINE * Maintenance* : the backend is configured as OFFLINE_SOFT * anything else, or failed check: SHUNNED A new monitor table is also added: `readyset_status_log` . It has a similar structure of `mysql_server_replication_lag_log` , but instead of storing `repl_lag` (replication lag) the full output of `SHOW READYSET STATUS` is saved as a JSON (that can be queried using `JSON_EXTRACT()`	12 months ago
René Cannaò	edc84ea14b	Merge pull request #4922 from sysown/v3.0-4861_fixes1 ... Further enhancement in prepared statement logging #4861	12 months ago
René Cannaò	d622fcfd4d	Merge pull request #4932 from sysown/v3.0-4918 ... Fix query digests for comments for certain query sizes - Closes #4918.	12 months ago
Javier Jaramago Fernández	f7c5756328	Fix losing database info on first logging for 'caching_sha2_password' ... The database specified in 'HandshakeResponse' was lost on the first logging when 'caching_sha2_password'. In this case a full-authentication was required, and this was the trigger for the context loss.	12 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	12 months ago
Rahim Kanji	0adf56eff1	Improved set parser. SET LOCAL will now lock on hostgroup.	12 months ago
Rahim Kanji	7c7cbd0bc1	Few improvements	12 months ago
Rahim Kanji	9559703a02	Removed extra semicolon	12 months ago
Rahim Kanji	c71aa550df	Added names (alias of client_encoding)	12 months ago
Javier Jaramago Fernández	5c3a063775	Fix digest comment removal for queries over 'query_digests_max_query_length' ... Due to a typo/confusion, the boundary being used for comments check was 'd_max_len' instead of 'q_len'. This prevented the correct detection of a comment start when the query exceeded 'query_digests_max_query_length' which determines the value for 'd_max_len'.	12 months ago
Rahim Kanji	9910a18e84	Some optimisation	12 months ago
Rahim Kanji	979b3a81f4	Added PgSQL_ExplicitTxnStateMgr in session ... Dump transaction state in proxysql internal session output	12 months ago
Rahim Kanji	190e369658	Added Transaction State flag in SQLite3_to_Postgres	12 months ago
Rahim Kanji	d90bf4ac73	Optimized savepoint detection ... Added get_pg_parameter_status	12 months ago
Rahim Kanji	c6fd3cef9c	Added reorder_dynamic_variables_idx flag for server connection variables	12 months ago
Rahim Kanji	d0952275ad	Added PgSQL_ExplicitTxnStateMgr in MakeFile	12 months ago
Rahim Kanji	2f9bb83dda	Added Abort (alias of Rollback)	12 months ago
Rahim Kanji	ae1f3126a2	Added explicit transaction state manager	12 months ago
René Cannaò	9737e0630a	Add variable mysql-eventslog_stmt_parameters #4923 ... Variable mysql-eventslog_stmt_parameters configures the logging of parameters in prepared statements: - 0 : logging disabled - 1 : logging enabled	1 year ago
René Cannaò	97304ffa91	prepared statements logging: use HEX for STRING type ... When parameters are strings or blobs, they are always converted to hex	1 year ago
René Cannaò	65f79a07d2	Changes on write_query_format_1() for datetime ... When logging the parameters of COM_STMT_EXECUTE , use sizeof(MYSQL_TIME) for these types: * MYSQL_TYPE_TIMESTAMP * MYSQL_TYPE_DATE * MYSQL_TYPE_TIME * MYSQL_TYPE_DATETIME Notes: * sizeof(MYSQL_TIME) is 40 * client library may use MYSQL_TYPE_DATETIME for all of these types	1 year ago
René Cannaò	cbb8505ca1	Improvement in prepared statements logging ... In bufferTypeInfoMap , use sizeof(MYSQL_TIME) for the size of these types: * MYSQL_TYPE_TIMESTAMP * MYSQL_TYPE_DATE * MYSQL_TYPE_TIME * MYSQL_TYPE_DATETIME Notes: * sizeof(MYSQL_TIME) is 40 * client library may use MYSQL_TYPE_DATETIME for all of these types	1 year ago
Rahim Kanji	d113bcb193	Use PG_EVENT_WRITE status for PgSQL	1 year ago
Rahim Kanji	4969bd8301	PQconnectPoll can file descriptor (FD) during the connection process. We need to check whether FD has changed and, if so, update it in the thread's poll array.	1 year ago
Rahim Kanji	857e501ca3	Added update_fd_at_index method	1 year ago
Javier Jaramago Fernández	6db52ea942	Fix query digests for certain comments of particular size ... Removed unnecessary boundary check for certain comments.	1 year ago
Rahim Kanji	6f6d241bb1	Removed gtid related code	1 year ago
René Cannaò	77247a1bd8	Merge pull request #4895 from sysown/v3.0-4861-mysql-logging_prepared_statement_parameters ... [MYSQL] logging of prepared statement parameters #4861	1 year ago
René Cannaò	eba0022a3b	Merge pull request #4917 from sysown/v3.0_read_only_action_deprecated ... Deprecate read_only_action()	1 year ago
René Cannaò	aff752980b	Merge pull request #4914 from msysyamamoto/fix/mysql_status_output ... fix: fix user name and database name are swapped.	1 year ago
René Cannaò	e88692c172	Deprecate read_only_action() ... This function is not in used anymore	1 year ago
Masayasu Yamamoto	f06d769be1	fix: swap username and schemaname	1 year ago
Javier Jaramago Fernández	811874bad1	Merge branch 'v3.0' of github.com:sysown/proxysql into v3.0-ff_conns_eof_caps_match	1 year ago
René Cannaò	dd58ea0b0a	Merge pull request #4908 from sysown/v3.0-4727 ... Fix MySQL 8.4 replication lag monitoring - Closes #4727	1 year ago
René Cannaò	6df3d6b84b	Merge pull request #4899 from sysown/v3.0_refactor_connection_info_param ... Refactor PostgreSQL Connection-Level Parameters Handling	1 year ago
Rahim Kanji	982be8b08a	Code cleanup	1 year 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	1 year ago
Javier Jaramago Fernández	7955dd21a8	Fix MySQL 8.4 replication lag monitoring - Closes #4727 ... Added support for new syntax to simulator.	1 year ago
René Cannaò	c48c3310a6	Check if database file exists before checking if it is writable ... Related to bf3cca8639	1 year ago
René Cannaò	bf3cca8639	exit if database file is not writable ... If database file (proxysql.db) is not writable, exit immediately instead of crashing because it is not writable. See issue #4893	1 year ago
Rahim Kanji	c2f2ae5aa4	* Updated code to use pgsql_tracked_variables[idx] consistently, removing ... direct usage of pgsql_tracked_variables[idx].idx. This change improves consistency and reduces potential human error. * Fixed some warning	1 year ago
Rahim Kanji	b8ffb7d56e	Fixed connection parameter validation	1 year ago
Rahim Kanji	db442ba8cf	Treat client_encoding as normal server parameter/variable. ... Optimized RESET ALL command handling. Few optimizations. Code cleanup	1 year ago
René Cannaò	be0fbeedc8	Adding documention for write_query_format_2_json()	1 year ago