PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-table-statistics-with-buffer.html
By default, rows are sorted by descending total wait time (tables with most contention first). fetch_latency The total wait time of timed read I/O events for the table. insert_latency The total wait time of timed insert I/O events for the table.
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
If the table has a foreign key relationship, foreign_key_checks must be disabled before executing DISCARD TABLESPACE. Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... A schema mismatch ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgm.html
--connect-retries=# Command-Line Format --connect-retries=# Type Numeric Default Value 3 Minimum Value 0 Maximum Value 4294967295 This option specifies the number of times following the first attempt to retry a connection before giving up (the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-pool-stats-table.html
PAGES_MADE_YOUNG_RATE The number of pages made young per second (pages made young since the last printout / time elapsed). PAGES_MADE_NOT_YOUNG_RATE The number of pages not made per second (pages not made young since the last printout / time ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer.html
Note If the first-time or subsequent manifest download is unsuccessful, an error is logged and you may have limited access to MySQL products during your session. It is downloaded with and supports the following MySQL products: MySQL Servers MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Whereas a trigger is a database object whose ...Scheduled tasks of this type are also sometimes known as “temporal triggers”, implying that these are objects that are triggered by the passage of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-nodes-groups.html
This is also the case when using ndbmtd with MaxNoOfExecutionThreads set to 3 or less. (You should be aware that the number of LDM threads increases with the value of this parameter, but not in a strictly linear fashion, and that there are ... This ...
https://dev.mysql.com/doc/refman/5.7/en/events-metadata.html
The session time zone that is current when a CREATE EVENT or ALTER EVENT statement executes is used to interpret times specified in the event definition. This becomes the event time zone (ETZ); that is, the time zone that is used for event ...Event ... To obtain metadata about events: Query the event table of the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
The password is fetched from the MySQL keyring, which must be enabled or an error occurs. Return value: The password string for success (up to 766 bytes), or NULL and an error for failure. Current sessions are no longer logged unless they disconnect ...Unless those objects are installed, the audit_log plugin operates in legacy ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-configuring-instances.html
It might work, but chances are that the operations race and then the act of joining the group ends up in an error or a time out. The use of other storage engines, including the temporary MEMORY storage engine, might cause errors in Group Replication. Set the disabled_storage_engines system variable as follows to prevent their use: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Note that with the MyISAM storage engine disabled, when you are upgrading a MySQL instance to a release where mysql_upgrade is still used (before MySQL 8.0.16), mysql_upgrade might fail with an ...