.MAD and .MAI files are created by "Aria", a MySQL

Question

.MAD and .MAI files are created by "Aria", a MySQL

format like MyISAM but with some "extras". The .MAD file contains data, the .MAI file contains indexes. It is NOT safe to delete these files, because you will delete data and indexes by doing that.

If your database is creating such files you could check these:
- Is your application logging data, e.g. logging all page accesses for statistics or debugging? (Frequent cause)
- Is your application creating tables where it stores binary objects (BLOBs), e.g. pictures or sound files directly into a database field instead of create files on disk?
- Is your application creating temporary tables, e.g. for pre-compiling or caching something?

You can also check:
- What exactly is in these tables? E.g. use phpMyAdmin to check their purpose. Also see what indexes are being created. It will normally explain why the large data volume is being created.

#database #dba #it #russian #software

0

21.09.2018

1 ответов

20 просмотров

Anton B · Accepted Answer

Anton B

Maybe the problem is related to InnoDB logging?

0

21.09.2018

72 похожих чатов

.MAD and .MAI files are created by "Aria", a MySQL

1 ответов

Похожие вопросы