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/performance-schema-status-variable-tables.html
There are also summary tables that provide status variable information aggregated by account, host name, and user name. The Performance Schema supports TRUNCATE TABLE for status variable tables as follows: global_status: Resets thread, account, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Summary tables provide aggregated information for terminated events over time. The tables in this group summarize event data in different ways. Each summary table has grouping columns that determine how to group the data to be aggregated, and ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-storage-engines.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDB table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. If a ... The ...Partitioned InnoDB tables cannot have foreign key references, nor can they have columns referenced by foreign ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
To signal a generic SQLSTATE value, use '45000', which means “unhandled user-defined exception.” The SIGNAL statement optionally includes a SET clause that contains multiple signal items, in a list of condition_information_item_name = ...SIGNAL ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. Otherwise, users would not be able to name columns and tables using their own languages. The metadata requirements mean that the ...
https://dev.mysql.com/doc/refman/5.7/en/environment-variables.html
USER The default user name on Windows when connecting to mysqld. MYSQL_TEST_LOGIN_FILE is the path name of the login path file (the file created by mysql_config_editor). The UMASK and UMASK_DIR variables, despite their names, are used as modes, not ... This section lists environment variables that are used directly or indirectly by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} Introduced 5.7.11-ndb-7.5.1 System Variable ndb_default_column_format Scope Global Dynamic Yes Type Enumeration Default Value (≥ ... This ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
The reason for this is that the MySQL server cannot create a file that is owned by anyone other than the user under whose account it is running. Note Any file created by INTO OUTFILE or INTO DUMPFILE is writable by all users on the server host. For ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
Users can create, modify, and drop scheduled events using SQL statements intended for these purposes. The default definer of an event is the user who created the event, unless the event has been altered, in which case the definer is the user who ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
As of MySQL 5.7.23, for new MySQL installations, the USER and HOST columns in the audit_log_user table used by MySQL Enterprise Audit have definitions that better correspond to the definitions of the User and Host columns in the mysql.user system ...