PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-upgrade-testing.html
Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled properly. After you have verified that the definitions are handled properly, dump the data ...
https://dev.mysql.com/doc/refman/8.0/en/obtaining-component-information.html
For example: mysql> SELECT * FROM mysql.component; +--------------+--------------------+------------------------------------+ | component_id | component_group_id | component_urn | ... The mysql.component system table contains information about ...
https://dev.mysql.com/doc/refman/8.0/en/obtaining-plugin-information.html
Any that have a PLUGIN_LIBRARY value of NULL are built in and cannot be unloaded. row *************************** PLUGIN_NAME: InnoDB PLUGIN_VERSION: 1.0 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: STORAGE ENGINE PLUGIN_TYPE_VERSION: 50158.0 PLUGIN_LIBRARY: ... There are several ways to determine which plugins are installed in the server: The Information Schema PLUGINS table contains a row for each loaded ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-tables.html
The Performance Schema clone tables are implemented by the clone plugin and are loaded and unloaded when that plugin is loaded and unloaded (see Section 7.6.7.1, “Installing the Clone Plugin”). Note The Performance Schema tables described here ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-lock-tables.html
The Performance Schema exposes lock information through these tables: data_locks: Data locks held and requested data_lock_waits: Relationships between data lock owners and data lock requestors blocked by those owners metadata_locks: Metadata locks ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-excluded-objects-table.html
This table provides information about NDB database objects which cannot be automatically synchronized between NDB Cluster's dictionary and the MySQL data dictionary. Example information about NDB database objects which cannot be synchronized with ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-pre-filtering.html
Pre-filtering is done by the Performance Schema and has a global effect that applies to all users. setup_objects controls whether the Performance Schema monitors particular table and stored program objects. Events already collected remain in the ...
https://dev.mysql.com/doc/refman/8.0/en/perror.html
For example, for the ER_WRONG_VALUE_FOR_VAR error, perror understands any of these arguments: 1231, 001231, MY-1231, or MY-001231, or ER_WRONG_VALUE_FOR_VAR. perror displays the error message for MySQL or operating system error codes. The meaning ...