Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
If set to False (the default setting) it causes a System.DateTime object to be returned for all valid values and an exception to be thrown for disallowed values, such as zero datetime values. ExceptionInterceptors , Exception Interceptors The list ... This chapter describes the full set of MySQL Connector/NET 8.0 connection ...
https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html
If set to False (the default setting) it causes a System.DateTime object to be returned for all valid values and an exception to be thrown for disallowed values, such as zero datetime values. ExceptionInterceptors , Exception Interceptors The list ... This chapter describes the full set of MySQL Connector/NET 8.0 connection ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
Maximum and minimum word length values are configurable using the innodb_ft_max_token_size and innodb_ft_min_token_size variables. The stopword list is loaded and searched for full-text queries using the server character set and collation (the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-cluster-config-metric-sourcestatus-category.html
Replication Max Allowed Packet Maximum size of packets transmitted between source and replica. Max Relay Log Size Maximum size for a single relay log file. Gtid Assignment Block Size Number of GTIDs the server can assign in a single block. Flow ...
https://dev.mysql.com/doc/internals/en/x-protocol-use-cases-use-cases.html
Streaming Inserts When inserting a large set of data (data import), make a trade-off among: memory usage on client and server side network round-trips error reporting For this example it is assumed that 1 million rows, each 1024 bytes in size have ...Optimizing for Network Round-Trips (Assuming the MySQL Client/Server Protocol in this case) Network round-trips can be minimized by creating a huge SQL statements of up to 1Gbyte in chunks of 16Mbyte (the protocol's maximum frame size) and sending it over the wire and letting the server execute ... Topics in this section: Prepared Statements with Single Round-Trip Streaming ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-transaction-management.html
Avoid performing rollbacks after inserting, updating, or deleting huge numbers of rows. To minimize the chance of this issue occurring: Increase the size of the buffer pool so that all the data change changes can be cached rather than immediately ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Returns Mysqlx.Resultset:: message Update { required Collection collection = 2; optional DataModel data_model = 3; optional Mysqlx.Expr.Expr criteria = 4; repeated Mysqlx.Datatypes.Scalar args = 8; optional Limit limit = 5; repeated Order order = 6; ... Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines ...
https://dev.mysql.com/doc/ndbapi/en/ndb-tablespace.html
Tablespace Class Overview Tablespace Constructor Tablespace::getAutoGrowSpecification() Tablespace::getDefaultLogfileGroup() Tablespace::getDefaultLogfileGroupId() Tablespace::getExtentSize() Tablespace::getObjectId() Tablespace::getName() ...Return ...For an overview of Cluster Disk Data and data file characteristics, see CREATE TABLESPACE Statement, in the MySQL ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-introduction.html
The communication buffer must be large enough to contain a single SQL statement (for client-to-server traffic) and one row of returned data (for server-to-client traffic). Each session's communication buffer is dynamically enlarged to handle any ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
A binary log file may become larger than max_binlog_size if you are using large transactions because a transaction is written to the file in one piece, never split between files. These two variables can be used for tuning binlog_cache_size to a ...