Disk space increasing dramatically.

zimmer

Does anyone know, why Server folder use almost over 300GB just only in 1 week?
I've tried to find exactly folder and find out that server/data/ uses this space and inside that folder, there is a lot of mysql-bin.000324 files with 1GB.. My mysql is around 80MB and running just one website.
Does anyone face this issue before? and what should I do to prevent of creating mysql-bin files in server/data directory?

TheWormsUnited

zimmer are you running the version 6.6.6?

zimmer

TheWormsUnited Yes 🙂

TheWormsUnited

zimmer what do you have in logs? Can you output the logs in here?

kaz050457

zimmer

recyclebin enabled?

zimmer

Sorry for the late response.
I'm using MariaDB _ 10.3 version and my server config is Apache + Mysql_MariaDB+PHP 7.3

TheWormsUnited
Logs are ok more or less,
2020-05-04 22:16:51 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2020-05-04 22:16:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-05-04 22:16:51 0 [Note] Server socket created on IP: '::'.
2020-05-04 22:16:51 0 [Note] Reading of all Master_info entries succeeded
2020-05-04 22:16:51 0 [Note] Added new Master_info '' to hash table
2020-05-04 22:16:51 0 [Note] /www/server/mysql/bin/mysqld: ready for connections.
Version: '10.3.22-MariaDB-log' socket: '/tmp/mysql.sock' Source distribution
2020-05-04 22:16:51 9 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2020-05-04 22:16:51 0 [Note] InnoDB: Buffer pool(s) load completed at 200504 22:16:51

But I saw this which is interesting I guess but not sure what should be changed here :

[mysqld]
port = 3306
socket = /tmp/mysql.sock
datadir = /www/server/data
default_storage_engine = InnoDB
performance_schema_max_table_instances = 400
table_definition_cache = 400
skip-external-locking
key_buffer_size = 1024M
max_allowed_packet = 100G
table_open_cache = 4096
sort_buffer_size = 16M
net_buffer_length = 4K
read_buffer_size = 16M
read_rnd_buffer_size = 256K
myisam_sort_buffer_size = 256M
thread_cache_size = 512
query_cache_size = 512M
tmp_table_size = 512M
sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

kaz050457
I'm not sure where I can check it?

cybertech
Do I need it to disable from Mysql configuration which is mentioned above?

cybertech

Disable binary logging

kaz050457

zimmer

click files -> recyclebin at the top of the filemanager

idflorin

this is the worst [mysqld] config seen by me, but I'm not an expert.

try the default config for 1-2Gb or 2-4gb RAM from aapanel
2.reboot

zimmer

idflorin
That's default one ) without any modifications.

zimmer

kaz050457
Unfortunately it's not the issue, as in Bin there is just only 10 files which are mostly html.

aaPanel_Jose

zimmer
/www/data/serverThis is your database directory, mysql-bin is your binary log, which can be used to restore data, it is recommended that you do not close it
Our default setting is to keep the binary log for 10 days

If you want to close, you can close it in the mysql manager

zimmer

aaPanel_Jose
Thanks a lot,
Where I can check those default settings? I checked on FTP and saw that it's collecting already more than 3 weeks, so basically it means that default settings are not working for me or are not enabled. Can you tell me where to check it?

Thanks.

aaPanel_Jose

zimmer
in mysql manager

It needs to be restarted after modification to take effect

zimmer

aaPanel_Jose

Okay, it was 10, I cleared logs and set to 7 days.. Restarted/Reloaded SQL and now will monitor and get back with results in one week.

Thanks everyone 😃