PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/password-security-admin.html
Database administrators should use the following guidelines to keep passwords secure. A user who has access to modify the plugin directory (the value of the plugin_dir system variable) or the my.cnf file that specifies the plugin directory location ...MySQL stores passwords for user accounts in the mysql.user system ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-digests.html
Consider these statements: SELECT * FROM orders WHERE customer_id=10 AND quantity>20 SELECT * FROM orders WHERE customer_id = 20 AND quantity > 100 To normalize these statements, the parser replaces data values by ? and adjusts whitespace. The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
uuid: hhhhhhhh-hhhh-hhhh-hhhh-hhhhhhhhhhhh h: [0-9|A-F] interval: n[-n] (n >= 1) mysql.gtid_executed Table GTIDs are stored in a table named gtid_executed, in the mysql database. To save space, the MySQL server compresses the mysql.gtid_executed ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
An example use case for this action is when you are restoring a backup of one or more databases on a server, but you do not have the relevant binary logs containing the transactions on the server. The MySQL Server system variables described in this ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
Search the bugs database at http://bugs.mysql.com/ to see whether the bug has been reported and fixed. If you cannot find an answer in the manual, the bugs database, or the mailing list archives, check with your local MySQL expert. The normal way to ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
The following list shows the CHANGE REPLICATION FILTER options and how they relate to --replicate-* server options: REPLICATE_DO_DB: Include updates based on database name. REPLICATE_REWRITE_DB: Perform updates on replica after substituting new name ...Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP SLAVE SQL_THREAD first (and restarted with START SLAVE SQL_THREAD ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory.html
Each subdirectory of the data directory is a database directory and corresponds to a database managed by the server. All MySQL installations have certain standard databases: The mysql directory corresponds to the mysql system database, which ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
To investigate database page corruption, you might dump your tables from the database with SELECT ... Before doing so, ensure that you have a backup copy of your database in case you need to recreate it. Only use an innodb_force_recovery setting of ...Usually, most of the data obtained in this way is ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-query-expansion.html
For example, a user searching for “database” may really mean that “MySQL”, “Oracle”, “DB2”, and “RDBMS” all are phrases that should match “databases” and should be returned, too. Thus, if one of these documents contains the ... Full-text search supports query expansion (and in particular, its variant “blind query ...