PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
In this case, when the server opens a MyISAM table, it checks whether the table is marked as crashed or whether the open count variable for the table is not 0 and you are running the server with external locking disabled. If the server finds an ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--keys-used=val, -k val Command-Line Format --keys-used=val Type Numeric For myisamchk, the option value is a bit value that indicates which indexes to update. --safe-recover, -o Command-Line Format --safe-recover Do a repair using an old recovery ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-benchmarking.html
To measure performance, consider the following factors: Whether you are measuring the speed of a single operation on a quiet system, or how a set of operations (a “workload”) works over a period of time. Benchmarks are typically long-running ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-transitioning.html
If you need to set any validate_password.xxx system variables, you can do so at runtime using SET GLOBAL. Note In MySQL 8.0, the validate_password plugin was reimplemented as the validate_password component. The validate_password plugin is ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-table-statistics.html
update_latency The total wait time of timed update I/O events for the table. By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these ...
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. If ...
https://dev.mysql.com/doc/refman/8.0/en/alter-tablespace.html
The only values for engine_name compatible with NDB tablespaces are NDB and NDBCLUSTER. A keyring plugin must be installed and configured before encryption can be enabled. It can be used to add a new data file to, or to drop a data file from an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/bit-value-literals.html
A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-restrictions.html
Identifiers are stored in mysql database tables (user, db, and so forth) using utf8mb3, but identifiers can contain only characters in the Basic Multilingual Plane (BMP). The ucs2, utf16, utf16le, and utf32 character sets have the following ...It ...
https://dev.mysql.com/doc/refman/8.0/en/cleartext-pluggable-authentication.html
Table 8.19 Plugin and Library Names for Cleartext Authentication Plugin or File Plugin or File Name Server-side plugin None, see discussion Client-side plugin mysql_clear_password Library file None (plugin is built in) Many client-side ... A ...