mysql log file size

[rnott]

I noticed that the /var/log/mysql/mysql.log file is growing rapidly & I've had to delete the /var/log/mysql/*gz files several times and restart mysql

When I first discovered this, /var/log/mysql/mysql.log was 3gb+

so I did the following command to monitor what & when the file is getting written to...
tail -f /var/log/mysql/mysql.log

after I login to nubuilder, I get a series of queries (see below) on my console where the tail command is running... every second, another series of queries...even though I'm not doing anything in browser

140328 15:37:35 12612 Connect blah@localhost on blah
12612 Query SET NAMES utf8
12612 Query Select * From zzzsys_setup
12612 Query SET time_zone = '-5:00'
12612 Query SELECT * FROM zzzsys_setup WHERE zzzsys_setup_id = 1
12612 Query SELECT * FROM zzzsys_form WHERE zzzsys_form_id = '5326319a15d3b7e'
12612 Query SELECT * FROM zzzsys_form WHERE zzzsys_form_id = '5326319a15d3b7e'
12612 Query SELECT * FROM employee_master WHERE employee_master_id = ''
12612 Query SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'blah' AND TABLE_NAME = 'employee_master' ORDER BY ORDINAL_POSITION
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___
12612 Query SELECT
zzzsys_user_id AS user_id,
sug_code AS user_group,
sal_code AS access_level,
zzzsys_access_level_id AS access_level_id,
sus_name AS user_name,
sus_email AS email,
sal_zzzsys_form_id AS form_id
FROM zzzsys_session
INNER JOIN zzzsys_user ON sss_zzzsys_user_id = zzzsys_user_id
INNER JOIN zzzsys_user_group ON sus_zzzsys_user_group_id = zzzsys_user_group_id
INNER JOIN zzzsys_access_level ON sug_zzzsys_access_level_id = zzzsys_access_level_id
WHERE zzzsys_session_id = '5335ba2fb046ae3'
12612 Query UPDATE zzzsys_user_log SET sul_end = '2014-03-28 15:37:35' WHERE zzzsys_user_log_id = '5335ba2fb046ae3'
12612 Query DELETE FROM zzzsys_session WHERE sss_timeout < '1396031855'
12612 Query SELECT * FROM zzzsys_session WHERE zzzsys_session_id = '5335ba2fb046ae3'
12612 Query UPDATE zzzsys_session SET sss_timeout = 1396039055 WHERE zzzsys_session_id = '5335ba2fb046ae3'
12612 Query SELECT sfo_table, sfo_primary_key FROM zzzsys_form WHERE zzzsys_form_id = '5326319a15d3b7e'
12612 Query SELECT * FROM employee_master WHERE employee_master_id = ''
12612 Query SELECT sus_login_name FROM zzzsys_user WHERE zzzsys_user_id = NULL
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___a
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___b
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___c
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___d
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___e
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___f
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___g
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___h
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___i
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___j
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___k
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___l
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___m
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___n
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___o
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___p
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___q
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___r
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___s
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___t
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___u
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___v
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___w
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___x
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___y
12612 Query DROP TABLE IF EXISTS ___nu15335dd8fa3d50___z
12613 Connect blah@localhost on blah
12613 Query SET NAMES utf8
12613 Query Select * From zzzsys_setup
12613 Query SET time_zone = '-5:00'
12613 Query SELECT * FROM zzzsys_setup WHERE zzzsys_setup_id = 1
12613 Query SELECT * FROM zzzsys_form WHERE zzzsys_form_id = '5326319a15d3b7e'
12612 Quit
12613 Query SELECT * FROM zzzsys_form WHERE zzzsys_form_id = '5326319a15d3b7e'
12613 Query SELECT * FROM employee_master WHERE employee_master_id = ''
12613 Query SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'blah' AND TABLE_NAME = 'employee_master' ORDER BY ORDINAL_POSITION
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___
12613 Query SELECT
zzzsys_user_id AS user_id,
sug_code AS user_group,
sal_code AS access_level,
zzzsys_access_level_id AS access_level_id,
sus_name AS user_name,
sus_email AS email,
sal_zzzsys_form_id AS form_id
FROM zzzsys_session
INNER JOIN zzzsys_user ON sss_zzzsys_user_id = zzzsys_user_id
INNER JOIN zzzsys_user_group ON sus_zzzsys_user_group_id = zzzsys_user_group_id
INNER JOIN zzzsys_access_level ON sug_zzzsys_access_level_id = zzzsys_access_level_id
WHERE zzzsys_session_id = '5335ba2fb046ae3'
12613 Query UPDATE zzzsys_user_log SET sul_end = '2014-03-28 15:37:35' WHERE zzzsys_user_log_id = '5335ba2fb046ae3'
12613 Query DELETE FROM zzzsys_session WHERE sss_timeout < '1396031855'
12613 Query SELECT * FROM zzzsys_session WHERE zzzsys_session_id = '5335ba2fb046ae3'
12613 Query UPDATE zzzsys_session SET sss_timeout = 1396039055 WHERE zzzsys_session_id = '5335ba2fb046ae3'
12613 Query SELECT sfo_table, sfo_primary_key FROM zzzsys_form WHERE zzzsys_form_id = '5326319a15d3b7e'
12613 Query SELECT * FROM employee_master WHERE employee_master_id = ''
12613 Query SELECT sus_login_name FROM zzzsys_user WHERE zzzsys_user_id = NULL
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___a
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___b
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___c
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___d
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___e
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___f
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___g
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___h
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___i
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___j
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___k
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___l
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___m
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___n
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___o
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___p
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___q
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___r
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___s
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___t
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___u
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___v
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___w
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___x
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___y
12613 Query DROP TABLE IF EXISTS ___nu15335dd8fab11a___z
12614 Connect blah@localhost on blah
12614 Query SET NAMES utf8
12614 Query Select * From zzzsys_setup
12614 Query SET time_zone = '-5:00'
12614 Query SELECT * FROM zzzsys_setup WHERE zzzsys_setup_id = 1
12614 Query SELECT * FROM zzzsys_form WHERE zzzsys_form_id = 'nuobject'
12613 Quit
12614 Query SELECT * FROM zzzsys_form WHERE zzzsys_form_id = 'nuobject'
12614 Query CREATE TABLE ___nu15335dd8fb1a29___

[massiws]

rnott,
nuBuilder is an application that use a database to get, manage and store data; some queries are needed to start and configure the application, to check the login credentials, to create and delete temporary tables, etc: that's the normal workflow!
I think delete log files is not a good idea... That's the place where you have to look if something goes wrong.

What is the problem? Free disk space?
Run this command in your terminal to see what's the folder that takes up more space:

Code: Select all

sudo du -hs /var/*

Instead to delete log files I suggest to configure logrotate in your system.

Hope this helps,
Max