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/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/5.7/en/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Note Fixed-length row format is only available for tables without BLOB or TEXT columns. Of the three MyISAM storage formats, static format is the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-bytes.html
Given a byte count, converts it to human-readable format and returns a string consisting of a value and a units indicator. Depending on the size of the value, the units part is bytes, KiB (kibibytes), MiB (mebibytes), GiB (gibibytes), TiB ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-time.html
Given a Performance Schema latency or wait time in picoseconds, converts it to human-readable format and returns a string consisting of a value and a units indicator. Depending on the size of the value, the units part is ps (picoseconds), ns ...
https://dev.mysql.com/doc/refman/5.7/en/sys-quote-identifier.html
Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL statements. This is useful when a value to be used as an identifier is a reserved word or contains backtick (`) characters. Example mysql> SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/windows-start-service.html
Place your cursor at the end of the text appearing in the space marked Variable Value. On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and stops. A ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
If this item is omitted, the default is to read to the end of the log or until the read buffer is full, whichever comes first. The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log files. (This ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
This technique is described in the context of keyring functions in Using General-Purpose Keyring Functions; it can be adapted for use with filtering functions. To assign a filter explicitly to a particular user account or accounts, define the ...
https://dev.mysql.com/doc/refman/5.7/en/backup-and-recovery.html
This chapter discusses several backup and recovery topics with which you should be familiar: Types of backups: Logical versus physical, full versus incremental, and so forth. It is important to back up your databases so that you can recover your ...
https://dev.mysql.com/doc/refman/5.7/en/backup-strategy-summary.html
Make periodic full backups, using the mysqldump command shown earlier in Section 7.3.1, “Establishing a Backup Policy”, that makes an online, nonblocking backup. In case of an operating system crash or power failure, InnoDB itself does all the ...