MySQL Forums
Forum List  »  Newbie

Re: MySQL 5.7 database files
Posted by: Peter Brawley
Date: September 13, 2021 07:04PM

> 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.

Options: ReplyQuote


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.