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/mysqld-safe.html
Linux users can use the libtcmalloc_minimal.so included in binary packages by adding these lines to the my.cnf file: [mysqld_safe] malloc-lib=tcmalloc Those lines also suffice for users on any platform who have installed a tcmalloc package in ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
A “login path” is an option group that permits only certain options: host, user, password, port and socket. If multiple instances of a given option are found, the last instance takes precedence, with one exception: For mysqld, the first instance ...[group] group is the name of the program or group for which you want to set ...(For mysqld, use --verbose and --help.) If the program reads option files, the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
For other summary tables not aggregated by account, host, or user, truncation resets the summary columns to zero rather than removing rows. For other summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, ...Event names refer to names of event instruments in the setup_instruments table: events_statements_summary_by_account_by_event_name has EVENT_NAME, USER, and HOST ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
The user-selected rule by which the division of data is accomplished is known as a partitioning function, which in MySQL can be the modulus, simple matching against a set of ranges or value lists, an internal hashing function, or a linear hashing ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
For example: mysql> prompt (\u@\h) [\d]>\_ PROMPT set to '(\u@\h) [\d]>\_' (user@host) [database]> (user@host) [database]> prompt Returning to default PROMPT of mysql> mysql> . For example: $> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> ...Resetting a connection has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and re-authentication is not ...For server side help, type 'help contents' If mysql is invoked ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
For additional information about the REQUIRE clause, see Section 13.7.1.2, “CREATE USER Statement”. For example: mysql --ssl-mode=REQUIRED mysqldump --ssl-mode=VERIFY_CA mysqladmin --ssl-mode=VERIFY_IDENTITY To configure a MySQL account to be ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-users-table.html
To set the table size explicitly, set the performance_schema_users_size system variable at server startup. The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
In this case, connect to s2 and issue: SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; SET SQL_LOG_BIN=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' \\ ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
Found wrong password for user 'some_user'@'some_host'; ignoring user As a result, the account is simply ignored by the permission system. Use mysql to update the account in the user table with a new password, making sure to use the PASSWORD() ... If ...Check whether the Password column of that table is shorter than 16 ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-mysql-cluster.html
There is no user-facing mechanism for influencing this selection, which is completely automatic; the fact that it is automatic is a key part of NDB Cluster's internal architecture. For more information about MySQL Cluster Manager, see MySQL Cluster ...How do I handle MySQL users in an NDB Cluster having multiple MySQL servers? ...In the event of a catastrophic failure— for ...