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/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/account-management-statements.html
MySQL account information is stored in the tables of the mysql system database. This database and the access control system are discussed extensively in Chapter 5, MySQL Server Administration, which you should consult for additional details. This ...Important Some MySQL releases introduce changes to the grant tables to add new privileges or ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. Other grant tables indicate privileges an account has for ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
(See Section 13.1.12, “CREATE EVENT Statement”.) Any user can alter an event defined on a database for which that user has the EVENT privilege. This statement renames the event myevent to yourevent: ALTER EVENT myevent RENAME TO yourevent; You ... ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the characteristics of an existing event without the need to drop and recreate ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
By default, audit log filter definitions are stored in the mysql system database, and you can display audit filters by querying the mysql.audit_log_filter table. It is possible to use a different database for this purpose, in which case you should ... Note As of MySQL 5.7.13, for audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
The character_set_database and collation_database system variables indicate the character set and collation of the default database. A SET CHARACTER SET charset_name statement is equivalent to these three statements: SET character_set_client = ... A ...
https://dev.mysql.com/doc/refman/5.7/en/charset-examples.html
Example 4: Database, Table, and Column Definition CREATE DATABASE d1 DEFAULT CHARACTER SET latin2 COLLATE latin2_czech_cs; USE d1; CREATE TABLE t1 ( c1 CHAR(10) ); We create a column without specifying its character set and collation. In this ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
The CONSTRAINT symbol value, if defined, must be unique in the database. Disabling foreign_key_checks has these additional implications: It is permitted to drop a database that contains tables with foreign keys that are referenced by tables outside ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...