Re: MySQL 5.7 database files
> I've done a bit of searching on MySQL indexing and not found anything useful
?! See
https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html
> creating new copies of all the tables (?) is standard practice for MySQL
It's not doing that. It is maintaining and updating all database and index files, plus buffers and backups for them. If your database uses the ACID-compliant InnoDB storage engine, it will will require more storage space---read about it at
https://dev.mysql.com/doc/refman/8.0/en/innodb-storage-engine.html; those docs desceibe options for keeping much such data in one file rather than in per-table files, but the savings in disk space usage will not be huge.
Subject
Written By
Posted
September 13, 2021 06:18PM
Re: MySQL 5.7 database files
September 13, 2021 07:04PM
September 14, 2021 04:44PM
September 14, 2021 07:56PM
September 14, 2021 01:28AM
September 14, 2021 04:16PM
September 14, 2021 04:42PM
September 14, 2021 04:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.