PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
Records in the clustered index contain fields for all user-defined columns. Records in the clustered index contain fields for all user-defined columns. For example, a CHAR(255) column can exceed 768 bytes if the maximum byte length of the character ... The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML ...As more rows fit into a single disk page, ...
https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html
The log table implementation has the following characteristics: In general, the primary purpose of log tables is to provide an interface for users to observe the runtime execution of the server, not to interfere with its runtime execution. For users ...Possible destinations for log entries are log files or the general_log and slow_log tables in the mysql system ...Log Control at Server Startup Log Control at Runtime Log Table Benefits and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool.html
A page can be read because it is required for a user-initiated operation such as an SQL query, or as part of a read-ahead operation performed automatically by InnoDB. If the page was read because it was required by a user-initiated operation, the ...
https://dev.mysql.com/doc/refman/5.7/en/load-data-local-security.html
Such a server could access any file on the client host to which the client user has read access. In this environment, the client with respect to the MySQL server actually is the Web server, not a remote program being run by users who connect to the ...To implement this level of verification, you must first ensure that the CA certificate for the server is reliably available to the replica, otherwise availability issues will ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
Multiple-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_references SET assignment_list [WHERE where_condition] For the single-table syntax, the UPDATE statement updates columns of existing rows in the named table with new values. For example, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
MySQL implements several types of collations: Simple collations for 8-bit character sets This kind of collation is implemented using an array of 256 weights that defines a one-to-one mapping from character codes to weights. Complex collations for ...For 8-bit characters, character codes map to weights in case-insensitive ...It is a case-insensitive collation, so the uppercase and ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
To detect this condition, you can set up a handler for it or for a NOT FOUND condition. statement can be a simple statement such as SET var_name = value, or a compound statement written using BEGIN and END (see Section 13.6.1, “BEGIN ... It can ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
On Windows systems, innochecksum must be run separately for each user-defined tablespace file. innochecksum --allow-mismatches=1 --write innodb ../data/test/tab1.ibd With --allow-mismatches set to 1, if there is a mismatch at page 600 and another at ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html
mysql> SELECT ELT(1, 'Aa', 'Bb', 'Cc', 'Dd'); -> 'Aa' mysql> SELECT ELT(4, 'Aa', 'Bb', 'Cc', 'Dd'); -> 'Dd' EXPORT_SET(bits,on,off[,separator[,number_of_bits]]) Returns a string such that for every bit set in the value bits, you get an on string and ...For functions that operate on string positions, the first position is ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
if the user ID of the owner of the .frm, .MYD, or .MYI file is different from the user ID of the mysqld process, REPAIR TABLE generates a "cannot change ownership of the file" error unless mysqld is started by the root user. You may be able to ...