Storage engines

MyISAM

Non-transactional engine with good performance and small data footprint

MyISAM متوفر في خادم MySQL هذا.

	bulk_insert_buffer_size	16,384 كيلوبايت
	delay_key_write	ON
	myisam_block_size	1024
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	BACKUP
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	524 k كيلوبايت
	myisam_stats_method	NULLS_UNEQUAL
	myisam_use_mmap	OFF
	skip_external_locking	ON