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/MySQLInstallerConsole.html
On success, the catalog is applied the next time either MySQLInstaller or MySQLInstallerConsole.exe is executed. This reference includes: MySQL Product Names Command Syntax Command Actions The console is installed when MySQL Installer is initially ... MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/alter-instance.html
ENCRYPTION operations, and locks are taken to prevent conflicts that could arise from concurrent execution of these statements. ALTER INSTANCE actions are written to the binary log so that they can be executed on replicated servers. ALTER INSTANCE ...
https://dev.mysql.com/doc/refman/5.7/en/condition-handling-restrictions.html
In MySQL, this is not guaranteed, so to get the main error, you cannot do this: GET DIAGNOSTICS CONDITION 1 @errno = MYSQL_ERRNO; Instead, do this: GET DIAGNOSTICS @cno = NUMBER; GET DIAGNOSTICS CONDITION @cno @errno = MYSQL_ERRNO; . SIGNAL, ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
At startup, and at runtime when FLUSH PRIVILEGES is executed, the server checks user table rows. 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 ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/5.7/en/creating-many-tables.html
If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table that has to be opened, another must be closed. If you have many MyISAM tables in the same database ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-loadable-function-information.html
dl The name of the function library file containing the executable function code. The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION: SELECT * FROM mysql.func; The func table has these columns: ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html
For example: [mysqld] innodb_temp_data_file_path=ibtmp1:12M:autoextend:max:500M When the data file reaches the maximum size, queries fail with an error indicating that the table is full. The temporary tablespace is removed on normal shutdown or on ... Non-compressed, user-created temporary tables and on-disk internal temporary tables are created in a shared temporary ...
https://dev.mysql.com/doc/refman/5.7/en/charset-server.html
By default, these are latin1 and latin1_swedish_ci, but they can be set explicitly at server startup on the command line or in an option file and changed at runtime. MySQL Server has a server character set and a server collation. Initially, the ...
https://dev.mysql.com/doc/refman/5.7/en/conditions-and-parameters.html
If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of RESIGNAL pops the Diagnostics Area stack, thus signalling the exception (that is, the information that existed before entry into the handler).
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-reference.html
Rewriter_reload_error Whether an error occurred the most recent time that the rewrite_rules table was loaded into the in-memory cache used by the Rewriter plugin. If no error occurs when the rules table is loaded into memory, the plugin sets the ...