`smartschool3`.`dispatch_receive` `smartschool3`.`teacher_subjects` `smartschool3`.`feetype` `smartschool3`.`student_fees` `smartschool3`.`student_applyleave` `smartschool3`.`exam_group_class_batch_exam_subjects` `smartschool3`.`feemasters` `smartschool3`.`libarary_members` `smartschool3`.`fee_receipt_no` `smartschool3`.`student_fees_master`
Console
Storage engines
MyISAM
Non-transactional engine with good performance and small data footprint
MyISAM is available on this MySQL server.
| bulk_insert_buffer_size | 8,192 KiB | |
|---|---|---|
| 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 B |
|
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 | 2,047 MiB |
| 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,QUICK |
|
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 KiB |
| myisam_stats_method | NULLS_UNEQUAL | |
| myisam_use_mmap | OFF | |
| skip_external_locking | ON |
