Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-download.html
The world_x Schema The world_x example schema contains the following JSON collection and relational tables: Collection countryinfo: Information about countries in the world. As part of this quick-start guide, an example schema is provided which is ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. Typically this is value+1, where value is the ...
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 ...