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/replication-threads-monitor-worker.html
The message lists the following statistics for the relevant replication channel, or the default replication channel (which is not named): Seconds elapsed The difference in seconds between the current time and the last time this information was ...
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
This occurs when the spinlock did not work (the mutex was not locked during the spinlock and it was necessary to yield to the operating system and wait). In MySQL 5.7 timing is disabled and this value is always 0. This statement is intended to help ... SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-hosts.html
This can differ from the machine name as configured in the operating system. Statement output includes this column only if the source server is started with the --show-slave-auth-info option. Statement output includes this column only if the source ... SHOW SLAVE HOSTS Displays a list of replicas currently registered with the ...
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
This variable has global and session values and can be changed at runtime. This optimzation is performed by default whenever the optimizer determines that using it would allow for faster execution of the query. Because the algorithm that makes this ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
This might result in quicker lock release than the MERGE algorithm so that other clients that use the view are not blocked as long. In this case, MySQL generates a warning and sets the algorithm to UNDEFINED. The optional ALGORITHM clause for ...
https://dev.mysql.com/doc/refman/5.7/en/xa.html
This document is published by The Open Group and available at http://www.opengroup.org/public/pubs/catalog/c193.htm. In essence, this extends ACID properties “up a level” so that multiple ACID transactions can be executed in concert as ...
https://dev.mysql.com/doc/refman/5.7/en/function-loading.html
MySQL supports automatic function loading during server startup and manual loading thereafter. Installing Loadable Functions Uninstalling Loadable Functions Reinstalling or Upgrading Loadable Functions Installing Loadable Functions To load a ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
It is possible to use a different database for this purpose, in which case you should query the database_name.audit_log_filter table instead. audit_log_filter_flush(): Flush manual changes to the filter tables to affect ongoing filtering. To grant ... Note As of MySQL 5.7.13, for audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
One way this might occur is that there is no account listed in the grant tables for davida. However, this is faster than running the query again without LIMIT, because the result set need not be sent to the client. An example is a Web script that ...
https://dev.mysql.com/doc/refman/5.7/en/perl-installation.html
The files you need for Perl support can be obtained from the CPAN (Comprehensive Perl Archive Network) at http://search.cpan.org. It is also possible to download the module distributions in the form of compressed tar archives and build the modules ... MySQL Perl support requires that you have installed MySQL client programming support (libraries and header ...