Search Results
https://dev.mysql.com/doc/internals/en/risky-handling-around-additional-sessions.html
This is most probably good for the throughput of usual application but has some annoying consequences for the development of tests. If a disconnect <connection> or KILL <connection_id> or --exec <client program which connects to the server> occurs ...It triggers some disconnect for any open session but this is also ...
https://dev.mysql.com/doc/internals/en/capability-flags.html
Value 0x00000080 Server Enables the LOCAL INFILE request of LOAD DATA|XML. Value 0x00040000 Requires CLIENT_PROTOCOL_41 CLIENT_PLUGIN_AUTH Value 0x00080000 Server Sends extra data in Initial Handshake Packet and supports the pluggable authentication ... The capability flags are used by the client and server to indicate which features they support and want to ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
For example, you cannot have a tablespace and a log file group with the same name, or a tablespace and a data file with the same name. This includes any default value implied for this option by the setting of the InitialLogFileGroup data node ...For ... CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] engine_name This statement creates a new log file group named logfile_group having a single undo file named ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-networking.html
This class must implement the interface 'com.mysql.cj.protocol.SocketFactory' and have a public no-args constructor. Default Value 0 Since Version 3.0.1 dnsSrv Should the driver use the given host name to lookup for DNS SRV records and use the ...
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...A combination of a fixed order in which tables are joined and the corresponding table access methods for each table is called query execution plan ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-memoryusage.html
Suppose that the cluster has 2 data nodes having node IDs 5 and 6, and the config.ini file contains the following: [ndbd default] DataMemory = 1G IndexMemory = 1G Suppose also that the value of the LongMessageBuffer configuration parameter is ...The ... Querying this table provides information similar to that provided by the ALL REPORT MemoryUsage command in the ndb_mgm client, or logged by ALL DUMP ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-oracle-mysql-discovery.html
If you want to use socket only, you must delete the value in the Port and Host fields. To configure Auto Discovery for Oracle MySQL, do the following: From the Setup menu, select Add Target, Configure Auto Discovery. From the Targets on Hosts table, ... It is possible to discover MySQL instances automatically, using OMS Auto ...
https://dev.mysql.com/doc/workbench/en/wb-performance-explain.html
It is fast because the index search directly leads to the page with all the row data REF Green Non-Unique Key Lookup Low-medium -- Low if the number of matching rows is small; higher as the number of rows increases FULLTEXT Yellow Fulltext Index ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-locally.html
Create a directory named data, then in that directory create a subdirectory for each server instance, for example s1, s2 and s3, and initialize each one. mysql-8.4/bin/mysqld --initialize-insecure --basedir=$PWD/mysql-8.4 --datadir=$PWD/data/s1 ...
https://dev.mysql.com/doc/refman/8.4/en/log-destinations.html
Possible destinations for log entries are log files or the general_log and slow_log tables in the mysql system database. For users who have access to the .CSV files that contain log table data, the files are easy to import into other programs such ...Setting this variable does not in itself enable the logs; they must be enabled ... MySQL Server provides flexible control over the destination of output ...