MyISAM storage engine
MyISAM متوفر في خادم MySQL هذا.
bulk_insert_buffer_size | 8,192 كيلوبايت | |
---|---|---|
delay_key_write | ON | |
The default pointer size in bytes, to be used by CREATE TABLE for MyISAM tables when no MAX_ROWS option is specified. | Data pointer size | 6 بايت |
The maximum size of the temporary file MySQL is allowed to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD DATA INFILE). | Maximum size for temporary sort files | 8,192 بيتا بايت |
myisam_mmap_size | 18446744073709551615 | |
The mode for automatic recovery of crashed MyISAM tables, as set via the --myisam-recover server startup option. | Automatic recovery mode | OFF |
If this value is greater than 1, MyISAM table indexes are created in parallel (each index in its own thread) during the repair by sorting process. | Repair threads | 1 |
The buffer that is allocated when sorting MyISAM indexes during a REPAIR TABLE or when creating indexes with CREATE INDEX or ALTER TABLE. | Sort buffer size | 8,192 كيلوبايت |
myisam_stats_method | nulls_unequal | |
myisam_use_mmap | OFF | |
skip_external_locking | ON |