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/downgrading.html
Note In the following discussion, MySQL commands that must be run using a MySQL account with administrative privileges include -u root on the command line to specify the MySQL root user. Commands that require a password for root also include a -p ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading.html
Note In the following discussion, MySQL commands that must be run using a MySQL account with administrative privileges include -u root on the command line to specify the MySQL root user. Commands that require a password for root also include a -p ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
The most important preconditions for using indexes for GROUP BY are that all GROUP BY columns reference attributes from the same index, and that the index stores its keys in order (as is true, for example, for a BTREE index, but not for a HASH ...
https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html
For example, before upgrading from MySQL 5.6 to 5.7, use mysqladmin from MySQL 5.6 as follows: C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, invoke mysqladmin with ... There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was ...
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...MySQL offers a variety of backup strategies from which you can choose the methods that best suit the requirements for your ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
This is useful when you want to store a “possibly wrong” value which the user has specified (for example, in a web form) in the database for future processing. The date and time data types for representing temporal values are DATE, TIME, ...
https://dev.mysql.com/doc/refman/5.7/en/general-security-issues.html
For information specifically about the access control system that MySQL uses for setting up user accounts and checking database access, see Section 2.9, “Postinstallation Setup and Testing”. For answers to some questions that are often asked ...
https://dev.mysql.com/doc/refman/5.7/en/installing.html
This section describes how to secure the initial MySQL root user account, which has no password until you assign one. For information about those platforms that are officially supported, see ...If you plan to upgrade an existing version of MySQL to ...A summary of the procedure follows and later sections provide the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-filtering.html
For example, if you do not care about historical event information, disable the history consumers: UPDATE performance_schema.setup_consumers SET ENABLED = 'NO' WHERE NAME LIKE '%history%'; The consumer settings in the setup_consumers table form a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-shutdowns.html
For the greatest possible durability and consistency in a replication setup using InnoDB with transactions, you should also set innodb_flush_log_at_trx_commit=1. Setting sync_relay_log_info to 0 causes no writes to be forced to disk and the server ...However, the replica notices the network outage only after receiving no data from the source for slave_net_timeout ...