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/mysql-cluster-replication-pitr.html
This backup should be updated regularly—perhaps even hourly—depending on your needs. Point-in-time recovery—that is, recovery of data changes made since a given point in time—is performed after restoring a full backup that returns the ...
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/binary-log-mixed.html
Like all other unsafe statements, this generates a warning if binlog_format = STATEMENT. For example, this occurs when the statement creating a view uses the UUID() function. This is true whether or not any temporary tables are actually logged. The ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a DML statement updates an NDBCLUSTER ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
Suppose that join buffer B1 is employed to join tables t1 and t2 and the result of this operation is joined with table t3 using join buffer B2: A regular join buffer contains columns from each join operand. This provides a savings in buffer space ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
This is also true of the contents of tables in INFORMATION_SCHEMA because those tables by definition contain information about database objects. This does not cause any disruption if you never use accented or non-Latin characters. It is more ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
This means that, when not otherwise inside a transaction, each statement is atomic, as if it were surrounded by START TRANSACTION and COMMIT. Because of this, SHOW PROCESSLIST displays Rolling back in the State column for the session, not only for ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
The relevant factors in the expression are: info_length is space needed for “screens.” This is related to MySQL's Unireg heritage. In this context, “int” does not mean “integer.” It means “interval,” a term that refers collectively ... MySQL represents each table by an .frm table format (definition) file in the database ...