MySQL disk Space co...
 
Notifications
Clear all

MySQL disk Space count report

20 Posts
5 Users
0 Reactions
3,514 Views
Posts: 13
Topic starter
(@tonyd)
Active Member
Joined: 3 years ago

The MySQL installation folder is at C:\Program Files\MySQL\MySQL Server 5.7

the folder that contains the data is in C:\ProgramData\MySQL\MySQL Server 5.7\Data

This is the configuration that is installed in Windows Server 2019 by default.

I remember a long time ago in the first versions of Websitepanel this worked correctly, from a later version the space count stopped working.

That is if currently when a database is created it is created perfectly in the right place, as well as the user without any problem.

I also have to say that the exact same problem also occurs with SQL

Reply
Posts: 13
Topic starter
(@tonyd)
Active Member
Joined: 3 years ago
Screenshot 2021 09 15 at 15 20 08 SolidCP   Servidores
Reply
Posts: 71
(@dolphyn5)
Estimable Member
Joined: 8 years ago

Here is a related thread from over five years ago: https://solidcp.com/forum/question/disk-space-report/

Back then, I found that "MySQL installation folder" is really asking for the folder that contains the data folder. I don't think SolidCP needs to find the MySQL executables.

In that thread, Marco stated "I do think the whole space and bw calculation can use a revamp" and I don't know if any revamp has occurred.

Our disk space and bandwidth reports in SolidCP are still missing a lot of data (especially email disk space which is a big deal for some users), but I haven't tried to figure out if the exact behavior still matches what I reported five years ago.

Reply
Posts: 35
(@indexebusiness)
Eminent Member
Joined: 8 years ago

Hi @dolphyn5 

Unfortunately, if I change the Installation folder to point at the Data folder, the manual backups do not work as they can't find the .exe files.  This is the error we get when:

msedge 210915 194959

That setting 100% needs to point at the Installation folder and not the Data folder so we are still stuck!

Thanks

Mark Donne

Reply
1 Reply
(@dolphyn5)
Joined: 8 years ago

Estimable Member
Posts: 71

@indexebusiness

Same issue here, but I never noticed!

I found a workaround: Copy the MySQL bin directory (or whatever portion is needed) alongside the data directory.

Reply
Posts: 1486
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hello,

I'm v1.4.8 we released a method of using a remote MariaDB 10.3+ database. This has a change of method to calculate the disk space rather than trying to always read the files.

For MySQL we look at the my.ini in the installation path for the datadir path. We then use this path to access the files and calculate the size.

Regards,

Trevor

Reply
Page 2 / 4
Share: