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/alter-database.html
Use UPGRADE DATA DIRECTORY NAME in this case to explicitly tell the server to re-encode the database directory name to the current encoding format: ALTER DATABASE `#mysql50#a-b-c` UPGRADE DATA DIRECTORY NAME; After executing this statement, you can ...ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA DIRECTORY NAME alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/5.7/en/cache-index.html
A key cache must exist before you assign indexes to it, or an error occurs: mysql> CACHE INDEX t1 IN non_existent_cache; ERROR 1284 (HY000): Unknown key cache 'non_existent_cache' By default, table indexes are assigned to the main (default) key ...| ...
https://dev.mysql.com/doc/refman/5.7/en/purge-binary-logs.html
PURGE { BINARY | MASTER } LOGS { TO 'log_name' | BEFORE datetime_expr } The binary log is a set of files that contain information about data modifications made by the MySQL server. Examples: PURGE BINARY LOGS TO 'mysql-bin.010'; PURGE BINARY LOGS ...The log consists of a set of binary log files, plus an index file (see Section 5.4.4, “The Binary ...
https://dev.mysql.com/doc/refman/5.7/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. The implementation comprises these elements: Keyring plugins that manage a backing store or communicate ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benefits.html
InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware or software issue, regardless of what was happening in the database at the time, you don't need to do anything special after restarting the database.
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-temp-tables.html
total_latency The total wait time of timed occurrences of the statement. last_seen The time at which the statement was most recently seen. These views list normalized statements that have used temporary tables. By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/5.7/en/cursor-restrictions.html
For example, if a client executes a query but is only interested in the first row, the remaining rows are not transferred. Initially, this is a MEMORY table, but is converted to a MyISAM table when its size exceeds the minimum value of the ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
As of MySQL 5.7.18, for any operation that modifies a grant table, the server checks whether the table has the expected structure and produces an error if not. These privileges enable the admin user to execute the mysqladmin reload, mysqladmin ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
The administrator needs to execute a statement like this: mysql> GRANT ALL ON menagerie.* TO 'your_mysql_name'@'your_client_host'; where your_mysql_name is the MySQL user name assigned to you and your_client_host is the host from which you connect ... Once you know how to enter SQL statements, you are ready to access a ...