PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/myisam-key-cache.html
To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems. It employs a cache mechanism to keep the most frequently accessed table blocks in memory: For index blocks, a special structure ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 15.7.3.2, “CHECK TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
The following options to mysqld can be used to change the behavior of MyISAM tables. bulk_insert_buffer_size The size of the tree cache used in bulk insert optimization. Note This is a limit per thread! delay_key_write=ALL Don't flush key buffers ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-table-maintenance.html
This section discusses how to use myisamchk to check or repair MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). For general myisamchk background, see Section 6.6.4, “myisamchk — MyISAM Table-Maintenance ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-other-options.html
myisamchk supports the following options for actions other than table checks and repairs: --analyze, -a Command-Line Format --analyze Analyze the distribution of key values. This improves join performance by enabling the join optimizer to better ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table. --data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/8.0/en/myisamlog.html
To create such a file, start the server with a --log-isam=log_file option. Invoke myisamlog like this: myisamlog [options] [file_name [tbl_name] ...] The default operation is update (-u). If a recovery is done (-r), all writes and possibly updates ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-calendar.html
MySQL uses what is known as a proleptic Gregorian calendar. Every country that has switched from the Julian to the Gregorian calendar has had to discard at least ten days during the switch. To see how this works, consider the month of October 1582, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-config-send-buffers.html
The NDB kernel employs a unified send buffer whose memory is allocated dynamically from a pool shared by all transporters. This means that the size of the send buffer can be adjusted as necessary. Configuration of the unified send buffer can ...