Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/internals/en/source-directory-listing.html
Directory — Short Comment bdb — The Berkeley Database table handler BitKeeper — BitKeeper administration (not part of the source distribution) BUILD — Frequently used build scripts client — Client library cmd-line-utils — Command-line ...
https://dev.mysql.com/doc/refman/8.4/en/repair-table.html
In the worst case, you might have a new clean index file without information about the data file, and then the next operation you perform could overwrite the data file. QUICK If you use the QUICK option, REPAIR TABLE tries to repair only the index ...Important Make a backup of a table before performing a table repair operation; under some circumstances the operation might cause data ...Although normally ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. When you create an ARCHIVE table, the storage engine creates files with names that begin with the table name. To enable ...A SELECT never causes a flush of a bulk insert unless a normal insert occurs while it is ...
https://dev.mysql.com/doc/workbench/en/wb-notes-physical-schemata.html
Double-clicking the Add Note icon in the Model Notes section of the MySQL Model page adds a note with the default name of note1. If a note with this name already exists, the new note is named note2. Adding a new note automatically opens the note ...
https://dev.mysql.com/doc/workbench/en/wb-routines-routine-groups.html
You can add Routine Groups to a database either from the Physical Schemata section of the MySQL Model page or from an EER Diagram. To view an existing schema, along with its Routines and Routine Groups, choose Database, Reverse Engineer from the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
This routine includes options that define the structure and format used for storing task status and logs data. task_data (JSON): specifies additional metadata related to the task, represented in JSON format. You can use this parameter to store ...
https://dev.mysql.com/doc/ndbapi/en/ndb-object.html
This section provides information about the Object class, which contains meta-information about database objects such as tables and indexes. Description This parameter specifies how data in the table or index is distributed among the cluster's data ...The larger the table, the larger the number of fragments that should be ...Description This type enumerates partition balance ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/workbench/en/wb-migration-wizard-create-target.html
The generated objects are listed here, along with the error messages if any exist. The migration code may also be viewed and edited here (see the figure that follows). To make changes, select an object, edit the query code, and click Apply. Note ...