MySQL Logs | Size error

[Thib]

Hellow,

I have two questions,

First is about MySQL logs : i'm so freaking out when i see mysql.log's size. is that normal i see it getting bigger ( ~ 1Mo every minut) ? I only have 14 hosts with the default templates..

I can see every request is logged, is there a way to reduce log level?

Edit : BTW, other question about MySQL : i can see in PhpMyAdmin, in my zabbix database, ~ 2,3 Go used
I tried in command line to dump the table with mysqldump, the file' size created is 660Mo .. Is that normal ?
---

The other question is about my linux servers :

Zabbix version :
Total disk space on / 21 May 15:42:08 6.77 TB

SSH version :
[admin@NET01 ~]$ df -h
Sys. de fich. Tail. Occ. Disp. %Occ. Monté sur
/dev/hda1 6,8G 5,8G 658M 91% /
tmpfs 252M 0 252M 0% /dev/shm

How can GB can be convertissed in TB ?

Thanks !

[MrKen]

Hellow,

I have two questions,

First is about MySQL logs : i'm so freaking out when i see mysql.log's size. is that normal i see it getting bigger ( ~ 1Mo every minut) ? I only have 14 hosts with the default templates..

I can see every request is logged, is there a way to reduce log level?

Depends on what logs you're talking about. If you are talking about bin-logs, then you can make the necessary changes to my.cnf

#log-bin = /var/log/mysql/mysql-bin.log
#expire_logs_days = 10
#max_binlog_size = 100M

A good idea is to hash them out and not to use them at all. However, if your company requires it then maybe you can reduce the number of expire_logs_days to 2 or 3.

Regarding using default templates, you should check the update intervals and change them to something sane. Why update every 30 seconds when every 3 minutes is satisfactory.

Edit : BTW, other question about MySQL : i can see in PhpMyAdmin, in my zabbix database, ~ 2,3 Go used
I tried in command line to dump the table with mysqldump, the file' size created is 660Mo .. Is that normal ?
---

It's possible, yes. If you have added and removed hosts, items, etc. Dumping the database is useful when the db is getting too big, you can dump it and it will usually be smaller when re-imported.

The other question is about my linux servers :

Zabbix version :
Total disk space on / 21 May 15:42:08 6.77 TB

SSH version :
[admin@NET01 ~]$ df -h
Sys. de fich. Tail. Occ. Disp. %Occ. Monté sur
/dev/hda1 6,8G 5,8G 658M 91% /
tmpfs 252M 0 252M 0% /dev/shm

How can GB can be convertissed in TB ?

Thanks !

Shame you missed the most important part "Zabbix version :"

Could it be this: https://support.zabbix.com/browse/ZBX-737

HTH
MrKen