https://dev.mysql.com/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/c-api-prepared-call-statements.html
This section describes prepared-statement support in the C API for stored procedures executed using CALL statements: Stored procedures executed using prepared CALL statements can be used in the following ways: A stored procedure can produce any ...
https://dev.mysql.com/c-api-prepared-statement-type-codes.html
The buffer_type member of MYSQL_BIND structures indicates the data type of the C language variable bound to a statement parameter or result set column. For input, buffer_type indicates the type of the variable containing the value to be sent to the ...
https://dev.mysql.com/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/charset-binary-set.html
For example: _binary 'a' The _binary introducer is permitted for hexadecimal literals and bit-value literals as well, but unnecessary; such literals are binary strings by default. The binary character set is the character set for binary strings, ...
https://dev.mysql.com/charset-unicode-ucs2.html
The ucs2 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Uses a fixed-length 16-bit encoding and requires two bytes per character. In UCS-2, every character is represented by a 2-byte ...
https://dev.mysql.com/choosing-types.html
This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is ...
https://dev.mysql.com/clone-plugin-remote.html
For example, if the donor instance runs on a Linux 64-bit platform, the recipient instance must also run on that platform. The clone plugin supports the following syntax for cloning remote data; that is, cloning data from a remote MySQL server ...
https://dev.mysql.com/column-count-limit.html
Each NULL column takes one bit extra, rounded up to the nearest byte. This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits MySQL has hard limit of 4096 columns per ...
https://dev.mysql.com/compressed-format.html
Numbers with a value of zero are stored using one bit. Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space.
