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-memory-tables.html
Consider using MEMORY tables for noncritical data that is accessed often, and is read-only or rarely updated. For best performance with MEMORY tables, examine the kinds of queries against each table, and specify the type to use for each associated ...Benchmark your application against equivalent InnoDB or MyISAM tables under a realistic workload, to confirm that any additional performance is worth the risk of losing data, or the overhead of copying data from a disk-based table at application ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-server.html
The information in this section is appropriate for DBAs who want to ensure performance and scalability across the servers they manage; for developers constructing installation scripts that include setting up the database; and people running MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point queries that search for all objects that contain a given point Region queries that ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-admin.html
See Section 8.2.15, “Password Management”, and Section 8.2.16, “Server Handling of Expired Passwords”. The validate_password plugin can be used to enforce a policy on acceptable password. A user who has access to modify the plugin directory ... Database administrators should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-clone-progress-table.html
The stages of a cloning operation include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. Stages include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. BEGIN_TIME A timestamp in ... Note ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-options.html
Performance Schema parameters can be specified at server startup on the command line or in option files to configure Performance Schema instruments and consumers. Runtime configuration is also possible in many cases (see Section 29.4, ...Options ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-queries.html
Pre-filtering limits which event information is collected and is independent of any particular user. If the event tables contain both file and nonfile information, post-filtering is another way to see information only for file events. By contrast, ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-group-communication-information-table.html
This is set to accommodate the oldest MySQL Server version that you want the group to support. For a group in single-primary mode with the group_replication_paxos_single_leader system variable set to ON and the communication protocol version set to ... This table shows group configuration options for the whole replication ...
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. If the values in this table for a given timer name are NULL, that timer is not supported on ...