MySQL Forums
Forum List  »  Newbie

MySQL 5.7 database files
Posted by: Vaughan Wickham
Date: September 13, 2021 06:18PM

Hello,

My experience with database applications has been with SQL Server, which I've always found has two files in the filesystem for a database (MDF & LDF)

I'm working with an application that uses MySQL 5.7 and the database folder has many files which seem to be replaced daily (a new copy of each file is being created).

This is leading to the backups being larger than I'd like and I'm just wondering if the way this database is currently configured is standard practice or not.

I've done a bit of searching on MySQL indexing and not found anything useful so far, so was hoping I might be able to get some direction here on what I could check for.

Ideally I want to establish how indexing is currently configured and whether this process of creating new copies of all the tables (?) is standard practice for MySQL

Thanks

VW

Options: ReplyQuote


Subject
Written By
Posted
MySQL 5.7 database files
September 13, 2021 06:18PM
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.