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/range-optimization.html
If conditions that cover sets of rows contained within intervals are combined with OR, they form a condition that covers a set of rows contained within the union of their intervals. If the conditions are combined with AND, they form a condition that ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
The sys schema session view presents information about user sessions like the sys schema processlist view, but with background processes filtered out. Privileges Required to Access the Process List For most sources of process information, if you ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-waiter.html
SINGLE USER MODE: This is shown for all cluster data nodes when the cluster is in single user mode. --single-user The program waits for the cluster to enter single user mode. --ndb-connectstring Command-Line Format ...By default, it waits for the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-mysql.html
If you are using lookup values that contain spaces, transform or hash them into values without spaces before using them as keys in calls to add(), set(), get(), and so on. For example, prepend the table name, or the database name and the table name, ...If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string ... Consider these aspects of memcached applications when adapting an existing MySQL schema or ...
https://dev.mysql.com/doc/refman/5.7/en/security-guidelines.html
If you are able to connect successfully to the server without being asked for a password, anyone can connect to your MySQL server as the MySQL root user with full privileges! Review the MySQL installation instructions, paying particular attention to ...MySQL uses security based on Access Control Lists (ACLs) for all connections, queries, and other operations that users can attempt to ...Assume that all passwords will be subject to automated cracking ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
For example: mysqld_safe --user=mysql --datadir=/path/to/5.7-datadir & Reset the root password: $> mysql -u root -p Enter password: **** <- enter temporary root password mysql> ALTER USER USER() IDENTIFIED BY 'your new password'; Load the previously ...For example: mysqladmin -u root -p shutdown mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & Logical Upgrade A logical upgrade involves exporting SQL from the old MySQL instance using a backup or export utility such as mysqldump or mysqlpump, installing the new MySQL server, and applying the SQL to your new MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
Note The procedure shown here does not set up any passwords for MySQL accounts. Then perform the following steps as the mysql user, except as noted. Perform Postinstallation Setup The remainder of the installation process involves setting up the ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-options.html
--keyring-migration-user=user_name Command-Line Format --keyring-migration-user=user_name Introduced 5.7.21 Type String The user name of the MySQL account used for connecting to the running server that is currently using one of the key migration ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
When database db2 is copied to server1, the GTIDs of the transactions committed on server2, which are not in the binary log files on server1, must be added to gtid_purged for server1 to make the set complete. This section provides examples of ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
row *************************** Id: 2 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 3 State: Waiting for next activation Info: NULL 2 rows in set (0.00 sec) Event scheduling can be stopped by setting the value of ...When ...