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/extensions-to-ansi.html
Functions and operators To make it easier for users who migrate from other SQL environments, MySQL Server supports aliases for many functions. Some SQL servers provide the same functionality but call this User space. (In MySQL Server, these ...For ... MySQL Server supports some extensions that are likely not to be found in other SQL ...
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
For batched_key_access to have any effect when set to on, the mrr flag must also be on. The derived_merge flag controls whether the optimizer attempts to merge derived tables and view references into the outer query block, assuming that no other ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html
Or you might want to give different users access to different mysqld servers that they manage themselves. Or you might run multiple instances of the current production version, each managing a different set of databases. For methods of configuring ...You might want to test a new MySQL release while leaving an existing production setup ...
https://dev.mysql.com/doc/refman/5.7/en/ldml-collation-example.html
You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; +--------------------+-----------------------------------------+ | Variable_name | Value | ...The ... To add a UCA collation for a Unicode character set without recompiling MySQL, use the following ...If you are unfamiliar with the LDML rules used to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
DEFINER The account named in the DEFINER clause (often the user who created the routine), in 'user_name'@'host_name' format. Notes To see information about a routine, you must be the user named in the routine DEFINER clause or have SELECT access to ...CHARACTER_SET_NAME For stored function character string return values, the character set ... The ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
The workaround to the problem is for the administrator to manually grant the SHOW VIEW privilege to users who are granted CREATE VIEW, since MySQL does not grant it implicitly when views are created. If a user is granted the basic privileges ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-server.html
To start up MySQL using this method, append a command like the one following to the appropriate startup file: /bin/sh -c 'cd /usr/local/mysql; ./bin/mysqld_safe --user=mysql &' For other systems, consult your operating system documentation to see ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
Records in the clustered index contain fields for all user-defined columns. Records in the clustered index contain fields for all user-defined columns. For example, a CHAR(255) column can exceed 768 bytes if the maximum byte length of the character ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...As more rows fit into a single disk page, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-consumer-configurations.html
The consumer settings in the setup_consumers table form a hierarchy from higher levels to lower. If you do not need the information provided by enabling lower-level settings, disable them and the Performance Schema executes less code on your behalf ...The following discussion describes how consumers work, showing specific configurations and their effects as consumer settings are enabled progressively from high to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
To change this value, set the performance_schema_max_sql_text_length system variable at server startup. CURRENT_SCHEMA The default database for the statement, NULL if there is none. The table stores one row per thread showing the current status of ...Of the tables that contain statement event rows, events_statements_current is the most ...