9275 Commits (mysqlx-plugin-impl)

 

All Branches   

Search

Author	SHA1	Message	Date
René Cannaò	6ba6c52826	Added compression field in mysql_servers table ... Issue #220	11 years ago
René Cannaò	568ef1b5d1	Bulk delete of connections when server status is not online ... Used by issue #218	11 years ago
René Cannaò	e8d50d9f0a	Improvement on connection pool ... Issues #215 , #216 and #217 215 : Connection pool should not return connections if server status is not ONLINE 216 : Connection pool should return connections based on weight 217 : Crash if no backend	11 years ago
René Cannaò	308f3a8a90	Further development on MySQL Hostgroups Manager ... Implemented functions: - MySQL_HostGroups_Manager::dump_table_mysql_servers() - MySQL_HostGroups_Manager::generate_mysql_servers_table() - Standard_ProxySQL_Admin::save_mysql_servers_runtime_to_database() (issue #17) Improved Standard_ProxySQL_Admin::load_mysql_servers_to_runtime() to process also status Improved MySQL_HostGroups_Manager::commit() to modified MySrvCs Database in MyHGM is accessible via Admin (issue #212) Enforced debugging if specified at the command line (issue #213)	11 years ago
René Cannaò	2709cc369f	Improvements on backend management ... Issues #208 and #209	11 years ago
vegaicm	535874292e	More work on bug #207 ... Class Standard_MySQL_Thread was restructured mysql_thread___ thread variables are moved out to global variables Standard_Proxy_Admin calls Standard_MySQL_Thread::refresh_variables after initializing the thread structure	11 years ago
vegaicm	d315650f2c	More work on bug #207 . Class Standard_MySQL_Thread needs some review	11 years ago
René Cannaò	6e3c929b43	Fix bug #207	11 years ago
René Cannaò	17ddec943e	Added variables ping_timout_server and ping_interval_server ... Issues #205 and #206	11 years ago
René Cannaò	f0714676c3	Removing previous comment	11 years ago
René Cannaò	9cdebef9ca	Bug fix and improved debugging ... For better debugging, added functions: MySQL_Data_Stream::clean_net_failure() MySQL_Data_Stream::set_net_failure() MySQL_Data_Stream::setDSS_STATE_QUERY_SENT_NET() MySQL_Session::set_unhealthy() Added condition mybe->server_myds->PSarrayOUTpending->len==0 to determine if DSS can be STATE_QUERY_SENT_NET	11 years ago
René Cannaò	01834ee2f3	Adding some proxy_debug()	11 years ago
René Cannaò	c1b7a1873a	Attempt to improve connection pool	11 years ago
René Cannaò	24db7ed825	Removing the idle connection handler thread introduced in previous commit 21b20c0257	11 years ago
René Cannaò	21b20c0257	Connection pool improvements , in beta ... Developed class StatCounters to keep time series counters Added 2 new instances of StatCounters: - MySQL_Session::command_counters; - ProxySQL_Poll::loop_counters; Counters are dispayed in "dbg thread status" Defined new variables mysql-connect_timeout_server_error and mysql-connect_timeout_server (issue #202 and #203) . They are defined but not implemented yet. Fixed two crashing bug when "gdb command" was trying to access: - its own Query_Info if this one was not initialized - Query_Info of another thread if this one was not initialized Introduced new variable ProxySQL_Poll:poll_timeout that Session can overwrite to apply a timeout different than mysql_thread___poll_timeout Added variable MySQL_Connection::last_time_used , updated at creation time and when calling push_MyConn_to_pool(). for each Connection add a "last_time_used" Added function get_multiple_idle_connections() Implementing Standard_MySQL_Threads_Handler::connection_manager_thread() , but doesn't seems to be a good idea ==== New attempt for connection handling MySQL_Session has a new bool variable : connections_handler Standard_MySQL_Thread has a new variable PtrArray : mysql_sessions_connections_handler Added new function Standard_MySQL_Thread::register_session_connection_handler SESSIONS_FOR_CONNECTIONS_HANDLER sessions are created in Standard_MySQL_Thread::init() Added new function Standard_MySQL_Thread::process_all_sessions_connections_handler() New variables in Standard_MySQL_Thread: MySQL_Connection **my_idle_conns; bool processing_idles; unsigned long long last_processing_idles; Added DSS STATE_PING_SENT MySQL_Session::handler___status_WAITING_SERVER_DATA___STATE_PING_SENT	11 years ago
René Cannaò	663a1b5630	Further simplification of connection management. ... Removed MySQL_Connection *myconn from MySQL Backend Removed server_myds and server_myds from MySQL_Session Fixed a bug that caused an infinite loop in case the backed was not able to create new connection	11 years ago
René Cannaò	cc9eb4d807	Removed client_fd and server_fd from MySQL_Session	11 years ago
René Cannaò	a8ac2749b3	Removed old file mysql_session.cpp.old	11 years ago
René Cannaò	6cc87cb931	Remove MySQL_Protocol instances from MySQL_Session and moved into MySQL_Data_Stream	11 years ago
René Cannaò	06856206f3	Attempt to multiplex also on OK packets	11 years ago
René Cannaò	24ab9f4398	More work for facilitate debug in MySQL Thread (issue #198) ... Standard_MySQL_Threads_Handler::SQL3_Threads_status() (still not completed) now locks the MySQL Threads Some functions of Standard_MySQL_Threads_Handler and Standard_MySQL_Thread are taken out from the class definition	11 years ago
René Cannaò	125114b0d5	Work for facilitate debug in MySQL Thread (issue #198) ... In order to facilitate the reuse of code in Standard_ProxySQL_Admin.cpp : - moved remove_spaces() from Standard_ProxySQL_Admin.cpp to gen_utils.cpp - moved Standard_ProxySQL_Admin::SQLite3_to_MySQL() to MySQL_Session::SQLite3_to_MySQL() Moved few macros from Standard_Query_Processor.cpp to proxysql_macros.h Added functions: - MySQL_Session::SQL3_Session_status() - MySQL_Session::handler___status_WAITING_CLIENT_DATA___STATE_SLEEP___MYSQL_COM_QUERY_debug() - Standard_MySQL_Thread::SQL3_Thread_status() - MySQL_Threads_Handler::SQL3_Threads_status() (not completed) Modified class Query_Info to copy queries : this can be a small performance penalty, but can improve functionalities Added mysql commands: - DBG SESSION STATUS - DBG THREAD STATUS - DBG THREADS STATUS Added variable MySQL_Thread::thread_mutex , a mutex to protect the thread: this will be used to implement access to MySQL Thread via Admin MySQL_Thread now have a new per thread variable updated via Admin Interface : - mysql_thread___session_debug ProxySQL_Poll now counts number of poll() in variable "loops" If mysql_thread___session_debug is enabled and a query starts with "dbg " it is interpreted as a command for proxysql. In Standard_ProxySQL_Admin added a variable admin_mutex to protect the update of statistics. Fixed minor bugs.	11 years ago
Rene Cannao	ea46b285c7	Merge pull request #190 from jesmarcannao/last ... FIX ISSUE #174	11 years ago
René Cannaò	209d784397	Drafting auto-reconnect ... Issue #195 and relative subtickets: - issue #191 - issue #192 - issue #194	11 years ago
Jesmar Cannaò	d4f9c49e1b	Fix Issue #182 ... Prevent loading modules compiled for a different version	11 years ago
René Cannaò	b46fa7c5f2	Fix on bug #193	11 years ago
René Cannaò	df0b81ddea	More improvements on Connection Pool ... For issue #187: Introduced the follow functions: - MySQL_Session::handler___status_CHANGING_USER_SERVER() - MySQL_Session::handler___client_DSS_QUERY_SENT___send_CHANGE_USER_to_backend - MySQL_Protocol::generate_COM_CHANGE_USER() Modified MySQL_Session::handler___status_CHANGING_SCHEMA() to return a boolean to handle failures Connections where INIT_DB or COM_CHANGE_USER fails are not reusable Added session_statuses CHANGING_USER_SERVER and CHANGING_USER_CLIENT (currently not used, but needed for issue #187) For issue #188: Added variable MySQL_Connection_userinfo::hash : this is compared into MySQL_Session Added function MySQL_Connection_userinfo::compute_hash() to automatically compute MySQL_Connection_userinfo::hash when a variable is changed hash is compute with SpookyHash::Hash64() Fixed bug #189: removed an parameters incorrectly passed to fprintf	11 years ago
Jesmar Cannaò	0717312c50	Fix Issue #175 ... Print "DEBUG" in version if compiled with DEBUG option : main process	11 years ago
Jesmar Cannaò	3a9fe080ee	FIX ISSUE #174:: Print "DEBUG" in print_version() if compiled with DEBUG option : all modules	11 years ago
René Cannaò	5619f1293b	Fix broken pipe (SIGPIPE) when backend connections is closed ... Fix for bug #183	12 years ago
René Cannaò	e5aa508aeb	Fix few unallocated bytes , bug #185 ... Added "delete mysql_thr" Added Standard_ProxySQL_Admin::drop_tables_defs()	12 years ago
René Cannaò	9fe89b6d62	Temporary disabled the artificial random network failure	12 years ago
René Cannaò	2401b12803	Custom memory allocator is optional, and disabled by default ... Used new variable GloVars.global.use_proxysql_mem Issue #184	12 years ago
René Cannaò	3e8929d9c8	Clean up on Standard_MySQL_Thread ... To improve readability, added these functions: - myds_backend_pause_connect() - myds_backend_first_packet_after_connect() - listener_handle_new_connection()	12 years ago
René Cannaò	cc9e635abd	Clean up on Standard_MySQL_Thread ... Removed unnecessary code To improve readability, added these functions: - process_data_on_data_stream() - process_all_sessions() - myds_backend_set_failed_connect()	12 years ago
René Cannaò	b84960da67	Draft on Handle missing backends , issue #181 ... Introduced MySQL_Session variable "pause_until" Simulated random missing backend	12 years ago
René Cannaò	754327b00a	Fixed bug #154 : PROXYSQL STOP and RESTART do not graceful close sockets	12 years ago
René Cannaò	08d5de7f52	Disabling callgrind output file	12 years ago
René Cannaò	1eb485f632	Disabled profile information for gprof by default	12 years ago
René Cannaò	3e41779f7e	If client disconnect, active backends are destroyed	12 years ago
René Cannaò	71ca1453fc	Fix some memory issues detected by valgrind	12 years ago
René Cannaò	f929f433e3	Removed some files from gcov	12 years ago
René Cannaò	5851693505	Removed "MYSQL myconn" from MySQL_Connection	12 years ago
René Cannaò	cf0aabe7dd	Bug fix for issue #179	12 years ago
René Cannaò	90a7fe0720	Add support for gprof : issue #180	12 years ago
René Cannaò	bcc19d619f	Removed classes MySQL_Server MySQL_Hostgroup MySQL_Hostgroup_Entry MySQL_HostGroups_Handler	12 years ago
René Cannaò	9fbce31593	Attempt to remove references to MyHGH	12 years ago
René Cannaò	44f433c260	Replaced MySQL_Session_userinfo with MySQL_Connection_userinfo ... Due the change in Connection Pool, user information need to be stored at Connection level and not at Session level	12 years ago
René Cannaò	ca1704ba40	Bug fixes ... Fixed crashing bug in Admin module when ProxySQL is started with --no-start When a client connection is terminated, the backend connection is returned to connection pool on if not in a transaction	12 years ago
René Cannaò	4b8ac564ac	Clean up of MySQL_Session ... Made a copy of mysql_session.cpp to mysql_session.cpp.old Renamed mysql_session.cpp to MySQL_Session.cpp and performed some code cleanup	12 years ago