PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-master-status.html
SHOW MASTER STATUS This statement provides status information about the binary log files of the source. row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator when the routine is dropped. However, this privilege is granted automatically to the creator of a routine if necessary (and dropped from ... The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-tables.html
Alternatively, if mysqld is not running, symlinking can be accomplished manually using ln -s from the command line. This is an extremely good reason not to run mysqld as the root operating system user or permit operating system users to have write ...For files used by tables for other storage engines, you may get strange problems if you try to use symbolic ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema.html
Objects in this schema include: Views that summarize Performance Schema data into more easily understandable form. You can drop the sys schema manually after initialization if it is unneeded. To permit this behavior to be suppressed, mysql_upgrade ... MySQL 5.7 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
If you select this option, you are responsible for securing the Data folder and its related files manually after the server configuration finishes. This does not apply to files and directories for specific products, such as the MySQL server data ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
This clause is for use under these conditions: It is intended when upgrading MySQL to 5.1 or later from older versions. Use UPGRADE DATA DIRECTORY NAME in this case to explicitly tell the server to re-encode the database directory name to the ...
https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-example.html
Information about this recovery process is conveyed to the user through the MySQL error log. This means that MySQL fails to start successfully because some blocks of disk data are no longer readable. In this case, it is necessary to reformat the ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
In the mysql command-line client, this is handled with the delimiter command. This means that no transactional savepoint is set at the start of the instruction block and the BEGIN clause used in this context has no effect on the current transaction.
https://dev.mysql.com/doc/refman/5.7/en/binary-log-formats.html
You can cause this format to be used by starting the server with --binlog-format=STATEMENT. This helps to eliminate issues when replicating certain statements between a source and replica which are using different storage engines. If MySQL cannot ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
This means that, if the index requires unique values, duplicate-key errors occur for values that differ only in the number of trailing spaces. This is in contrast to all other data types, for which storage is allocated once per column when the table ... A BLOB is a binary large object that can hold a variable amount of ...