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/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-pruning.html
When the optimizer can make use of partition pruning in performing this query, execution of the query can be an order of magnitude faster than the same query against a nonpartitioned table containing the same column definitions and data. The ...In ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-tables.html
Note The Performance Schema tables described here are available as of MySQL 8.0.17. The following sections describe the Performance Schema tables associated with the clone plugin (see Section 7.6.7, “The Clone Plugin”). clone_status: status ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-keyring-keys-table.html
As of MySQL 8.0.16, the keyring_keys table exposes metadata for keys in the keyring. The keyring_keys table does not expose any sensitive keyring data such as key contents. Key metadata includes key IDs, key owners, and backend key IDs. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-restrictions.html
The Performance Schema avoids using mutexes to collect or produce data, so there are no guarantees of consistency and results can sometimes be incorrect. Tables in the performance_schema database cannot be locked with LOCK TABLES, except the ...If ...Instruments that apply to storage engines might not be implemented for all storage ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-threads-table.html
This column uses the SET data type, so multiple flags from the following list can be set per instrument: singleton: The instrument has a single instance. row *************************** NAME: thread/sql/event_scheduler ENABLED: YES HISTORY: YES ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-histogram-summary-tables.html
To permit assessment at a more fine-grained level, the Performance Schema also collects histogram data for statement latencies. The Performance Schema maintains statement event summary tables that contain information about minimum, maximum, and ...
https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery.html
(The full backup can be made in several ways, such as those listed in Section 9.2, “Database Backup Methods”.) Point-in-time recovery then brings the server up to date incrementally from the time of the full backup to a more recent time.
https://dev.mysql.com/doc/refman/8.0/en/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-blackhole.html
The BLACKHOLE storage engine accepts data but discards it and does not store it. When performing binary logging, all inserts to such tables are always logged, regardless of the logging format in use. Updates and deletes are handled differently ...