PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-error-log-table.html
The table implementation uses a fixed-size, in-memory ring buffer, with old events automatically discarded as necessary to make room for new ones. The error_log table is a view on a fixed-size, in-memory ring buffer, with old events automatically ...
https://dev.mysql.com/doc/refman/9.7/en/selecting-all.html
Fix only the erroneous record with an UPDATE statement: mysql> UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser'; The UPDATE changes only the record in question and does not require you to reload the table. For example, you may happen to ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table.html
ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-file-formats.html
The MySQL server calls the audit log component to write an audit record to its log file whenever an auditable event occurs. Typically the first audit record written after component startup contains the server description and startup options.
https://dev.mysql.com/doc/refman/9.7/en/can-not-connect-to-server.html
The fix in this case is to change the cron job to not remove mysql.sock or to place the socket file somewhere else. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file ...
https://dev.mysql.com/doc/refman/9.7/en/cannot-create.html
One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option file. If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set ...
https://dev.mysql.com/doc/refman/9.7/en/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. Note The ucs2 character set is deprecated; expect it ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode.html
They can be encoded in a fixed-length encoding using 16 bits (2 bytes). In addition, you should be aware that collations using the utf8_ prefix in older releases of MySQL have since been renamed using the prefix utf8mb3_, instead. The Unicode ...
https://dev.mysql.com/doc/refman/9.7/en/choosing-types.html
For high precision, you can always convert to a fixed-point type stored in a BIGINT. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the range from 1 to 99999, ...