Saqtaýysh mehanızmdary
MyISAM
Non-transactional engine with good performance and small data footprint
MyISAM bul MySQL serverinde qoljetimdi.
| bulk_insert_buffer_size | 16 384 KiB | |
|---|---|---|
| delay_key_write | ON | |
| myisam_block_size | 1024 | |
MAX_ROWS opsıasy kórsetilmese, MyISAM kesteleri úshin CREATE TABLE paıdalanatyn baıttardaǵy ádepki kórsetkish ólshemi.
|
Derekter meńzeriniń ólshemi | 6 B |
MyISAM ındeksin qaıta qurý kezinde (REPAIR TABLE, ALTER TABLE nemese LOAD DATA INFILE barysynda) paıdalanýǵa ruqsat etilgen MySQL ýaqytsha faılynyń eń úlken ólshemi.
|
Ýaqytsha suryptaý faıldarynyń eń úlken ólshemi | 8 192 PiB |
| myisam_mmap_size | 18446744073709551615 | |
Server iske qosylǵanda --myisam-recover opsıasy arqyly ornatylǵan, buzylǵan MyISAM kestelerin avtomatty qalpyna keltirý rejimi.
|
Avtomatty qalpyna keltirý rejımi | BACKUP |
Eger bul mán 1-den úlkenirek bolsa, suryptaý prosesimen jóndeý kezinde MyISAM keste ındeksteri qatarlas (ár ındeks óziniń tizbeginde) jasalady.
|
Jóndeý tizbeleri | 1 |
REPAIR TABLE mezgilinde MyISAM ındeksterin suryptaǵanda, nemese CREATE INDEX arqyly ındeksterdi jasaǵanda, nemese ALTER TABLE kómegimen bólinetin býfer.
|
Suryptaý buferiniń ólshemi | 524 k KiB |
| myisam_stats_method | NULLS_UNEQUAL | |
| myisam_use_mmap | OFF | |
| skip_external_locking | ON |
phpMyAdmin demo-serveri:
Aǵymda master tarmaǵynan RELEASE_5_2_1-5377-g8e721911f0 Git túzetýi iske qosylǵan.