PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. However, this conversion is subject to the following exceptions: When you compare two columns When you compare a DATE, TIME, DATETIME, or TIMESTAMP column ...For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric context and vice ...
https://dev.mysql.com/doc/refman/5.7/en/windows-restrictions.html
This is because the physical address limit on Windows 32-bit is 4GB and the default setting within Windows is to split the virtual address space between kernel (2GB) and user/applications (2GB). This facility is often used to move the data and index ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-ip-address-permissions.html
If you set this option on a server s1, then when server s2 is establishing a connection to s1 for the purpose of engaging group communication, s1 first checks the allowlist before accepting the connection from s2. This address is not the same as the ... The Group Replication plugin has a configuration option to determine from which hosts an incoming Group Communication System connection can be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
In this case, manually remove the .isl file from the schema directory. Replicating the path in this case would cause the source and replica to create the table in same location. mysql> CREATE TABLE t2 (c1 INT PRIMARY KEY) TABLESPACE = ... There are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
In this case, you could manually rename the tablespace file and restart crash recovery, or you could restart the server in recovery mode using the innodb_force_recovery option. To achieve point-in-time recovery after restoring a backup, you can ...
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 ...