Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizing-subqueries.html
See also Section 10.2.2, “Optimizing Subqueries, Derived Tables, View References, and Common Table Expressions”. Development is ongoing, so no optimization tip is reliable for the long term. The following list provides some interesting tricks ...
https://dev.mysql.com/doc/refman/8.4/en/replication-formats.html
When using row-based logging, the source writes events to the binary log that indicate how individual table rows are changed. Replication of the source to the replica works by copying the events representing the changes to the table rows to the ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
A schema mismatch in a MySQL 8.3 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.4 to fail. To address this issue, dump and restore affected tables before attempting the upgrade again. If ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-2.html
Bugs Fixed InnoDB: In some cases, following the creation of a very large number of tables (8001 or more), the server could not be restarted successfully. (Bug #110402, Bug #35200385) Group Replication: Running a CREATE TABLE ... (Bug #36808732) ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-prepare.html
However, they are not permitted for identifiers (such as table or column names), or to specify both operands of a binary operator such as the = equal sign. Metadata changes to tables or views referred to by prepared statements are detected and cause ... int mysql_stmt_prepare(MYSQL_STMT *stmt, const char *stmt_str, unsigned long length) Description Given the statement handler returned by mysql_stmt_init(), prepares the SQL statement pointed to by the string stmt_str and returns a status ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-api-characteristics.html
This information can be examined in the INFORMATION_SCHEMA.PLUGINS table or using the SHOW PLUGINS statement. Interfaces for several types of plugins exist, such as storage engines, full-text parser, and INFORMATION_SCHEMA tables. The server plugin ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-33.html
It is suitable for use with MySQL Server versions 8.0 and 5.7. The check wrongly rejected queries that had a WITH clause in which there was no space after the comma between two common table expressions. Version 8.0.33 is the latest General ...
https://dev.mysql.com/doc/workbench/en/wb-develop-object-management.html
From here, you can perform common tasks such as selecting tables and fields to query, edit tables, create new or drop tables and databases, perform searches, and more. The Object Browser allows you to navigate database schemas and objects.
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. TABLE not migrated There is not ...SMALLINT SMALLINT BIGINT BIGINT BIT TINYINT(1) FLOAT FLOAT Precision value is used for storage size in ...