1590 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
Rahim Kanji	cea3ed9c2c	CentOS7 Ubuntu16 build fix	1 year ago
Yashwant Sahu	01158ed67a	Default compression level was 6 for MySQL clients and this was making ProxySQL slower. ... Following changes has been made: Made default compression level as 3. Added MySQL compression level variable For detail of issue, #4721	1 year ago
René Cannaò	8aea001013	Merge pull request #4713 from sysown/v2.x-logging_mem ... V2.x logging mem [WIP]	1 year ago
Javier Jaramago Fernández	9c56fafbd1	Fix worker threads stalling race condition on RESUME command ... During a RESUME operation, if a 'MySQL_Thread' is bootstrapping listeners (in `MySQL_Thread::run_BootstrapListener`) and detect that `MySQL_Threads_Handler::bootstrapping_listeners` is 'false', the thread prematurely shuts down its own bootstrapping flag from 'mypolls' (`ProxySQL_Poll::bootstrapping_listeners`). Since this thread wont ever bootstrap its corresponding listening sockets, the other working threads will be stalled waiting on it, eventually triggering the watchdog and crashing the instance. Since the bootstrapping operation is sequential, it's expected that all the threads but the one starting their listening sockets are in an active wait. A sensible delay has been introduced to reduce the overhead of such wait.	1 year ago
René Cannaò	737f3a1429	Merge branch 'v2.7' into v2.x-logging_mem	2 years 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ò	0158e98e20	Merge pull request #4733 from sysown/v2.7_issue_4707_threshold_resultset_size ... Fix Overflow in mysql_thread___threshold_resultset_size During Multiplication	2 years ago
René Cannaò	b95f1ddd08	Merge pull request #4729 from sysown/2.7_randomized_cache_ttl ... DNS cache enhancement	2 years ago
René Cannaò	24ffd9fae8	Merge branch 'v2.7' into v2.x-logging_mem	2 years ago
Rahim Kanji	4dd6867532	Added overflow_safe_multiply()	2 years ago
René Cannaò	234d4e6d59	Drafting handling of errors in MySQL Events log 2	2 years ago
Rahim Kanji	cfc2c977a7	* Introduced a 5% jitter to cache_ttl to increase the likelihood of ... distributing DNS resolution across multiple intervals, reducing the chance of simultaneous expiry times. * Added a small delay after queuing DNS records, allowing DNS resolver thread time to process as many hostnames as possible before assessing the need for additional helper threads. This helps prevent 'DNS resolver queue too big' warnings in the logs.	2 years ago
René Cannaò	9eeed3c45b	Drafting handling of errors in MySQL Events log	2 years ago
Rahim Kanji	8b526c69ed	Updated default value of cache_empty_result to -1, indicating that it has not been explicitly set	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ò	56eb2115d0	Added variable eventslog_buffer_max_query_length ... In MySQL_Event copy constructor, queries are copied up to eventslog_buffer_max_query_length bytes.	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ò	1d30d40e9b	Added stats_mysql_eventslog_sync_buffer_to_disk ... Added new Admin variable stats_mysql_eventslog_sync_buffer_to_disk . This variable defines how frequently mysql query eventslog are automatically dumped to disk.	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ò	d7a9254bbd	Add history_mysql_query_events in statsdb_disk	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
René Cannaò	2726c27710	Merge pull request #4662 from sysown/v2.7_dns_cache_fixes ... DNS record will be removed if MySQL connection fails or times out for a specific hostname [v2.7]	2 years ago
Rahim Kanji	c5bc9ed2c6	DNS Cache Fixes ... * If a MySQL connection fails or times out for a specific hostname, the corresponding DNS record will be removed from DNS Cache. This ensures that outdated DNS records are not retained. (Rest of the DNS resolution process remains unchanged) * DNS cache functionality will automatically be disabled when ProxySQL is run with the -M or --no-monitor option.	2 years ago
René Cannaò	38350292e2	Merge pull request #4600 from sysown/v2.x_proxy ... Implementation of PROXY protocol V1	2 years ago
René Cannaò	cf9d5fe21a	Merge pull request #4574 from sysown/set-thread-names ... Set thread names	2 years ago
René Cannaò	645963af8e	Removing trailing semicolon from `USE` #4628 ... Trailing semicolon are now removed. This commit also ensure that an error is returned if `USE` is part of a multi-statement.	2 years ago
Rene Cannao	eedb3978bf	WIP: improved USE query parsing	2 years ago
Rene Cannao	95fa15cdf9	Better parsing of USE queries sent with COM_QUERY #4598	2 years ago
Rene Cannao	d92e57f83a	Renamed mysql-eventslog_memory_history_size to mysql-eventslog_buffer_history_size	2 years ago
Rene Cannao	6a2d52f610	Adding a circular buffer to MySQL_Logger	2 years ago
Rene Cannao	d85430b709	Implementation of PROXY protocol V1 ... This commit introduces: - class ProxyProtocolInfo() , that: - performs parsing - validates subnet - run automated tests in DEBUG build - variable mysql-proxy_protocol_networks . Accepted values: - empty string: disables PROXY protocol - '*' : allows connections from any IP - comma separated list of subnets - automated testing in DEBUG build during start - export of PROXY protocol information in internal session, using PROXY_V1 - a TAP test to verify various connections	2 years ago
Javier Jaramago Fernández	b91b6b8f9f	Add list of special permitted variables tracking errors - Closes #4591 ... This list hold tracking errors that in practice are equivalent to ER_UNKNOWN_SYSTEM_VARIABLE and that we want to handle in the same way.	2 years ago
Javier Jaramago Fernández	eeaae2e758	Make 'proxy_debug_func' saves/restore 'errno' ... Several calls inside 'proxy_debug_func' (specially if database logging is enabled) could alter 'errno', which could influence error handling.	2 years ago
Niels Vogell	1b2982f5ab	Adding additional checks to only process discovered servers from an AWS RDS Multi-AZ DB Cluster	2 years ago
René Cannaò	25f02a33ce	Merge pull request #4496 from sysown/v2.6.x-freebsd_fixes ... various FreeBSD related fixes	2 years ago
Andriy Utkin	5e79afa8e0	Set thread names	2 years ago
Miro Stauder	8394fd444e	use local includes - prometheus	2 years ago
Miro Stauder	7695c42534	use local include - openssl	2 years ago
René Cannaò	cdfcfdce94	Merge pull request #4528 from sysown/v2.x_monitor_slave_lag_when_null_4521 ... Introduced new HG attribute 'monitor_slave_lag_when_null' which takes precedence over 'mysql_thread_monitor_slave_lag_when_null'	2 years ago
Miro Stauder	da61f23eb3	Merge branch 'v2.x' into v2.6.x-freebsd_fixes	2 years ago
René Cannaò	5514822161	Merge pull request #4517 from sysown/v2.x_hostgroup_online_servers ... Enforcing maximum online servers in a hostgroup	2 years ago
Javier Jaramago Fernández	cf7da4e9a2	Fix memory leak in 'pull_mysql_query_rules_from_peer' ... - Simplified memory managament in Cluster credentials API. - Moved several variables into local scopes.	2 years ago
Rahim Kanji	ca93da5857	Resolved conflicts	2 years ago