PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb.html
InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important. This section explains how to optimize database operations for InnoDB tables.
https://dev.mysql.com/doc/refman/8.0/en/optimizing-server.html
This section discusses optimization techniques for the database server, primarily dealing with system configuration rather than tuning SQL statements. The information in this section is appropriate for DBAs who want to ensure performance and ...
https://dev.mysql.com/doc/refman/8.0/en/pam-pluggable-authentication.html
There can be multiple applications associated with a single database server instance, so the choice of service name is left to the SQL application developer. Any user who connects using the proxy account is mapped to one of those MySQL accounts, the ... Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-cluster-tables.html
ndb_sync_excluded_objects: Shows information about NDB database objects for which automatic synchronization has failed due to permanent errors resulting from mismatches which cannot be reconciled without manual intervention; these objects are ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The effect of the default object configuration is to instrument all objects except those in the mysql, INFORMATION_SCHEMA, and performance_schema databases. (Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
The effect of the default object configuration is to instrument all tables except those in the mysql, INFORMATION_SCHEMA, and performance_schema databases. (Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents of ... The setup_objects table controls whether the Performance Schema monitors particular ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-relaylog.html
The relay log, like the binary log, consists of a set of numbered files containing events that describe database changes, and an index file that contains the names of all used relay log files. The term “relay log file” generally denotes an ...
https://dev.mysql.com/doc/refman/8.0/en/replication-bugs.html
If you have a repeatable test case that demonstrates the bug, please enter it into our bugs database using the instructions given in Section 1.5, “How to Report Bugs or Problems”. Then enter the problem with as much information as possible into ... When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug ...
https://dev.mysql.com/doc/refman/8.0/en/replication-delayed.html
To inspect what the database looked like in the past, without having to reload a backup. For example, by configuring a replica with a delay of one week, if you then need to see what the database looked like before the last few days' worth of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-charset.html
The following applies to replication between MySQL servers that use different character sets: If the source has databases with a character set different from the global character_set_server value, you should design your CREATE TABLE statements so ...A good workaround is to state the character set and collation explicitly in CREATE TABLE ...