Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-buffer-pool-flushing.html
The innodb_io_capacity_max value defines an upper limit on I/O capacity in such situations, so that a spike in I/O activity does not consume the entire I/O capacity of the server. Side effects of limiting page flushing during idle periods may ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
MySQL Workbench Editors: Query, Object, and More Starting with MySQL Workbench 8.0.22, visual explain diagrams use the phrase hash join within the diamond symbol instead of block nested loop when the server version is 8.0.20 or higher. New and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
Statement-based replication requires the consecutive auto-increment lock mode to ensure that auto-increment values are assigned in a predictable and repeatable order for a given sequence of SQL statements, whereas row-based replication is not ...To ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-prepared-statements-instances-table.html
This is accessed through the MySQL C API and maps onto underlying server commands as shown in the following table. C API Function Corresponding Server Command mysql_stmt_prepare() COM_STMT_PREPARE mysql_stmt_execute() COM_STMT_EXECUTE ...This table ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-config-editor.html
The file can be read later by MySQL client programs to obtain authentication credentials for connecting to MySQL Server. Think of a login path option group as a set of options that specify which MySQL server to connect to and which account to ...The ...
https://dev.mysql.com/doc/workbench/en/wb-requirements.html
MySQL server: Although it is not required, MySQL Workbench is designed to have either a remote or local MySQL server connection. For additional information about connecting to a MySQL server, see Chapter 5, Connections in MySQL Workbench. For ...
https://dev.mysql.com/doc/refman/8.4/en/comments.html
MySQL Server supports three comment styles: From a # character to the end of the line. (Under some conditions, nested comments might be permitted, but usually are not, and users should avoid them.) MySQL Server supports certain variants of C-style ...In MySQL, the -- (double-dash) comment style requires the second dash to be followed by at least one whitespace or control character, such as a space or ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-8.html
It is suitable for use with MySQL Server versions 5.5, 5.6, 5.7, and 8.0. By providing a comma-separated list of values to this option (for example, “TLSv1,TLSv1.1,TLSv1.2”) users can, for example, prevent connections from using older TLS ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
Typically it indicates that the connection you are using is stale, the server is too busy to accept your request or that the server has gone away. Outer Join Error When using some applications to access a MySQL server using Connector/ODBC and outer ..."Transactions are not enabled" Error The following error is reported when using transactions: Transactions are not enabled This error indicates that you are trying to use transactions with a MySQL table that does not support ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-errors.html
Typically it indicates that the connection you are using is stale, the server is too busy to accept your request or that the server has gone away. Outer Join Error When using some applications to access a MySQL server using Connector/ODBC and outer ..."Transactions are not enabled" Error The following error is reported when using transactions: Transactions are not enabled This error indicates that you are trying to use transactions with a MySQL table that does not support ...