Search Results
https://dev.mysql.com/doc/internals/en/com-query-response.html
ProtocolText::Resultset: A packet containing a Protocol::LengthEncodedInteger column_count column_count * Protocol::ColumnDefinition packets If the CLIENT_DEPRECATE_EOF client capability flag is not set, EOF_Packet One or more ...Image description ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-starting.html
NoOfFragmentLogFiles=300 DataDir=path/to/data/node/data/directory MaxNoOfConcurrentOperations=100000 SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 # Setting these parameters allows you to take advantage of real-time ...They ...Changes in configuration are also likely to be indicated when changes are made in the platform on which the cluster is run, or in applications that use the NDB Cluster 's ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/http-agent-timeout.html
The HTTP connection between agent and Service Manager has a default timeout of 250 seconds for an attempted connection and 300 seconds for an established connection. It is possible to override these values in bootstrap.properties by adding the ...
https://dev.mysql.com/doc/internals/en/transactions-life-cycle.html
In such situations there is little the server can do and the only option is to roll back transactions in all other participating engines, and send an error to the user. The remaining rare cases, when the server explicitly must commit a statement ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used. For example, utf8mb3 characters can require up to three bytes per character, so a VARCHAR ...
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-clusterj-object-models.html
It also stores parameters regarding how to connect to the cluster, including connection delays and timeouts. In addition, it enables the user to mark a transaction as being rollback-only, which makes it possible for a component that is not ... This ...
https://dev.mysql.com/doc/refman/8.4/en/stop-group-replication.html
The default value is 300 seconds; this means that Group Replication components are stopped after 5 minutes if the situation is not resolved before that time, allowing the member to be restarted and rejoin. The ...This statement requires the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-change-primary.html
You can specify a timeout from 1 to 3600 seconds (60 minutes) for transactions that are running when you use the function. When this is done, the current primary becomes a read-only secondary, and the specified group member becomes the read/write ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-statistics.html
The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The table is persistent so that column statistics need not be created each time the server ...The column_statistics table has these characteristics: The table contains statistics for columns of all data types except geometry types (spatial data) and ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
For the CHAR, VARCHAR, and TEXT data types, watch for these issues when converting your MySQL tables: Check all definitions of utf8mb3 columns and make sure they do not exceed the maximum length for the storage engine. Check all indexes on utf8mb3 ...In terms of table structure, these are the primary potential incompatibilities: For the variable-length character data types (VARCHAR and the TEXT types), the maximum permitted length in characters is less for utf8mb4 columns than for utf8mb3 ...