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/innodb-read-only-instance.html
If the MySQL server is started with --innodb-read-only but the data directory is still on writeable media, the root user can still perform DCL operations such as GRANT and REVOKE. To prepare an instance for read-only operation, set ...How to Enable ... You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
For example: SET time_zone = 'MET'; Unique UTC values stored in the TIMESTAMP column are not unique in the session time zone due to DST shifts. (This is the same type of conversion performed by the CONVERT_TZ() function. If the session time zone is ... Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and ...
https://dev.mysql.com/doc/refman/5.7/en/string-literals.html
For nonbinary strings, the unit is the character and some character sets support multibyte characters; comparisons use numeric character code values. These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; ...Every binary string has a character set and collation named ... A string is a sequence of bytes or characters, ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production use with MySQL. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/5.7/en/my-print-defaults.html
To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client --user=myusername --password=password --host=localhost The output consists of options, one per ...--defaults-extra-file=file_name, --extra-file=file_name, -e file_name Read this option file after the global option file but (on Unix) before the user option ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking-table-access.html
Users are strongly urged not to use database files that contain Barracuda file format tables with releases of InnoDB older than the MySQL 5.1 with the InnoDB Plugin. All tables using any file format supported by a release can be read or written ...
https://dev.mysql.com/doc/refman/5.7/en/windows-create-option-file.html
You need to tune the server settings, such as memory, cache, or InnoDB configuration information. Note When using the MySQL Installer to install MySQL Server, it creates the my.ini in the default location, and the user executing MySQL Installer is ...For options that are used every time the server starts, you may find it most convenient to use an option file to specify your MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
See X DevAPI User Guide for in-depth tutorials on using X DevAPI. Relational databases such as MySQL usually required a document schema to be defined before documents can be stored. This differs from working with a relational database and storing ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
Because the output of mysqlbinlog includes SET TIMESTAMP statements before each SQL statement recorded, the recovered data and related MySQL logs reflect the original times at which the transactions were executed. Your database has now been restored ... The last section, Section 7.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
See Section 9.4, “User-Defined Variables”, for more information and examples of workarounds. A user variable cannot be used directly in an SQL statement as an identifier or as part of an identifier. If you have databases or tables from an older ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, and other object names are known as ...