Page 1 of 2
Nagios Mysql database taking lot of root volume in ubuntu
Posted: Wed Aug 02, 2017 4:42 am
by Teja
Hi Everyone,
I Have Nagios in UBUNTU (14.04) server with mysql database running locally. But for some reason we didn't recognize mysql process was not running and then we configured mysql and started the process and since after that the ROOT partition is filling very fast (approx: 2GB in 4hours) (My root volume size is 500 gb) and then i have checked "/var/lib/mysql" folder size it was already taking "288gb". So is this Normal or do i need to make any changes in database ? Please assist.
Thanks in Advance!!
Re: Nagios Mysql database taking lot of root volume in ubunt
Posted: Wed Aug 02, 2017 9:52 am
by bolson
Hello Teja,
This does not seem normal. Are you running Nagios Core or Nagios XI? How did you install Nagios?
Re: Nagios Mysql database taking lot of root volume in ubunt
Posted: Wed Aug 02, 2017 10:19 am
by Teja
Hi bolson,
Thanks for your reply.It's Nagios Core 4.0.2 . So do i need to post this in Core section ?.I have just checked what's eating the space it was Binary files, in "/var/lib/mysql/" path. So what exactly do these files store? . Can i find an alternative to save the space or should i "Purge" them?
Re: Nagios Mysql database taking lot of root volume in ubunt
Posted: Wed Aug 02, 2017 10:55 am
by bolson
Hello Teja,
Yes, you should be posting in the Core forum. Please execute the following commands and post the result:
Code: Select all
du -h /var/lib/mysql
ls -l /var/lib/mysql
ls -l /var/lib/mysql/nagiosql
ls -l /var/lib/mysql/nagios
ls -l /var/lib/mysql/nagiosxi
Re: Nagios Mysql database taking lot of root volume in ubunt
Posted: Wed Aug 02, 2017 10:56 am
by bolson
Also, what method did you use to install Nagios?
Re: Nagios Mysql database taking lot of root volume in ubunt
Posted: Thu Aug 03, 2017 6:06 am
by Teja
Hi bolson,
Here are the outputs of the commands and sorry i don't know how the Nagios was installed.
du -h /var/lib/mysql
Code: Select all
212K /var/lib/mysql/performance_schema
1.1M /var/lib/mysql/mysql
153G /var/lib/mysql/nagios
4.0K /var/lib/mysql/test
320G /var/lib/mysql
ls -l /var/lib/mysql
Code: Select all
-rwxr-xr-x 1 mysql mysql 0 Jul 27 10:20 debian-5.5.flag
-rw-r--r-- 1 mysql mysql 15718 Jul 31 06:17 error.log
-rwxr-xr-x 1 mysql mysql 18874368 Jul 31 06:14 ibdata1
-rw-rw---- 1 mysql mysql 268435456 Jul 31 06:17 ib_logfile0
-rw-rw---- 1 mysql mysql 268435456 Jul 27 10:13 ib_logfile1
-rw-rw---- 1 mysql mysql 268435456 Jul 27 10:13 ib_logfile2
-rw-rw---- 1 mysql mysql 6 Jul 31 06:17 ip-xxx-xx-x-xxx.pid
-rw-rw---- 1 mysql mysql 1668738 Aug 3 05:55 ip-xxx-xx-x-xxx-slow.log
drwx------ 2 mysql mysql 4096 Jul 27 10:20 mysql
-rw-rw---- 1 mysql mysql 3109 Jul 27 08:13 mysql-bin.018208
-rw-rw---- 1 mysql mysql 2948 Jul 27 08:20 mysql-bin.018209
-rw-rw---- 1 mysql mysql 7336915 Jul 27 08:23 mysql-bin.018210
-rw-rw---- 1 mysql mysql 3310 Jul 27 08:35 mysql-bin.018211
-rw-rw---- 1 mysql mysql 3579712 Jul 27 08:46 mysql-bin.018212
-rw-rw---- 1 mysql mysql 7845673 Jul 27 08:57 mysql-bin.018213
-rw-rw---- 1 mysql mysql 11720953 Jul 27 09:17 mysql-bin.018214
-rw-rw---- 1 mysql mysql 126 Jul 27 10:14 mysql-bin.018215
-rw-rw---- 1 mysql mysql 25993 Jul 27 10:19 mysql-bin.018216
-rw-rw---- 1 mysql mysql 1123841 Jul 27 10:19 mysql-bin.018217
-rw-rw---- 1 mysql mysql 301 Jul 27 10:19 mysql-bin.018218
-rw-rw---- 1 mysql mysql 126 Jul 27 10:19 mysql-bin.018219
-rw-rw---- 1 mysql mysql 1017 Jul 27 10:19 mysql-bin.018220
-rw-rw---- 1 mysql mysql 126 Jul 27 10:19 mysql-bin.018221
-rw-rw---- 1 mysql mysql 25993 Jul 27 10:20 mysql-bin.018222
-rw-rw---- 1 mysql mysql 1123841 Jul 27 10:20 mysql-bin.018223
-rw-rw---- 1 mysql mysql 301 Jul 27 10:20 mysql-bin.018224
-rw-rw---- 1 mysql mysql 472 Jul 27 10:20 mysql-bin.018225
-rw-rw---- 1 mysql mysql 126 Jul 27 10:20 mysql-bin.018226
-rw-rw---- 1 mysql mysql 1017 Jul 27 10:20 mysql-bin.018227
-rw-rw---- 1 mysql mysql 126 Jul 27 10:20 mysql-bin.018228
-rw-rw---- 1 mysql mysql 126 Jul 28 02:29 mysql-bin.018229
-rw-rw---- 1 mysql mysql 126 Jul 28 02:31 mysql-bin.018230
-rw-rw---- 1 mysql mysql 218690686 Jul 28 02:57 mysql-bin.018231
-rw-rw---- 1 mysql mysql 1073742368 Jul 28 03:57 mysql-bin.018232
-rw-rw---- 1 mysql mysql 1073742151 Jul 28 04:51 mysql-bin.018233
-rw-rw---- 1 mysql mysql 1073742196 Jul 28 05:45 mysql-bin.018234
-rw-rw---- 1 mysql mysql 1073741885 Jul 28 06:40 mysql-bin.018235
-rw-rw---- 1 mysql mysql 197285604 Jul 28 06:50 mysql-bin.018236
-rw-rw---- 1 mysql mysql 1073741971 Jul 28 07:44 mysql-bin.018237
-rw-rw---- 1 mysql mysql 1073742678 Jul 28 08:38 mysql-bin.018238
-rw-rw---- 1 mysql mysql 1073742743 Jul 28 09:05 mysql-bin.018239
-rw-rw---- 1 mysql mysql 1073742101 Jul 28 09:59 mysql-bin.018240
-rw-rw---- 1 mysql mysql 1073742503 Jul 28 10:49 mysql-bin.018241
-rw-rw---- 1 mysql mysql 1073742182 Jul 28 11:44 mysql-bin.018242
-rw-rw---- 1 mysql mysql 1073742199 Jul 28 12:29 mysql-bin.018243
-rw-rw---- 1 mysql mysql 1073741893 Jul 28 13:14 mysql-bin.018244
-rw-rw---- 1 mysql mysql 1073742087 Jul 28 14:04 mysql-bin.018245
-rw-rw---- 1 mysql mysql 1073742494 Jul 28 14:49 mysql-bin.018246
-rw-rw---- 1 mysql mysql 1073742485 Jul 28 15:29 mysql-bin.018247
-rw-rw---- 1 mysql mysql 1073742124 Jul 28 16:01 mysql-bin.018248
-rw-rw---- 1 mysql mysql 1073742129 Jul 28 16:44 mysql-bin.018249
-rw-rw---- 1 mysql mysql 1073742522 Jul 28 17:25 mysql-bin.018250
-rw-rw---- 1 mysql mysql 1073742030 Jul 28 18:16 mysql-bin.018251
-rw-rw---- 1 mysql mysql 1073741945 Jul 28 19:03 mysql-bin.018252
-rw-rw---- 1 mysql mysql 1073742806 Jul 28 19:53 mysql-bin.018253
-rw-rw---- 1 mysql mysql 1073742131 Jul 28 20:45 mysql-bin.018254
-rw-rw---- 1 mysql mysql 1073741988 Jul 28 21:34 mysql-bin.018255
-rw-rw---- 1 mysql mysql 1073742348 Jul 28 22:23 mysql-bin.018256
-rw-rw---- 1 mysql mysql 1073742558 Jul 28 23:05 mysql-bin.018257
-rw-rw---- 1 mysql mysql 1073741933 Jul 28 23:39 mysql-bin.018258
-rw-rw---- 1 mysql mysql 1073741900 Jul 29 00:26 mysql-bin.018259
-rw-rw---- 1 mysql mysql 1073742012 Jul 29 01:16 mysql-bin.018260
-rw-rw---- 1 mysql mysql 1073742043 Jul 29 02:05 mysql-bin.018261
-rw-rw---- 1 mysql mysql 1073741874 Jul 29 02:53 mysql-bin.018262
-rw-rw---- 1 mysql mysql 1073742490 Jul 29 03:42 mysql-bin.018263
-rw-rw---- 1 mysql mysql 1073742602 Jul 29 04:28 mysql-bin.018264
-rw-rw---- 1 mysql mysql 1073741998 Jul 29 05:16 mysql-bin.018265
-rw-rw---- 1 mysql mysql 1073741955 Jul 29 06:01 mysql-bin.018266
-rw-rw---- 1 mysql mysql 1073742225 Jul 29 06:46 mysql-bin.018267
-rw-rw---- 1 mysql mysql 52554671 Jul 29 06:49 mysql-bin.018268
-rw-rw---- 1 mysql mysql 1073742041 Jul 29 07:37 mysql-bin.018269
-rw-rw---- 1 mysql mysql 1073741915 Jul 29 08:28 mysql-bin.018270
-rw-rw---- 1 mysql mysql 1073742575 Jul 29 09:21 mysql-bin.018271
-rw-rw---- 1 mysql mysql 1073742141 Jul 29 10:14 mysql-bin.018272
-rw-rw---- 1 mysql mysql 1073742830 Jul 29 10:48 mysql-bin.018273
-rw-rw---- 1 mysql mysql 1073742214 Jul 29 11:40 mysql-bin.018274
-rw-rw---- 1 mysql mysql 1073742578 Jul 29 12:31 mysql-bin.018275
-rw-rw---- 1 mysql mysql 1073742142 Jul 29 13:24 mysql-bin.018276
-rw-rw---- 1 mysql mysql 1073742648 Jul 29 14:16 mysql-bin.018277
-rw-rw---- 1 mysql mysql 1073742406 Jul 29 15:09 mysql-bin.018278
-rw-rw---- 1 mysql mysql 1073741880 Jul 29 15:59 mysql-bin.018279
-rw-rw---- 1 mysql mysql 1073742299 Jul 29 16:45 mysql-bin.018280
-rw-rw---- 1 mysql mysql 1073741896 Jul 29 17:34 mysql-bin.018281
-rw-rw---- 1 mysql mysql 1073742215 Jul 29 18:28 mysql-bin.018282
-rw-rw---- 1 mysql mysql 1073742531 Jul 29 19:22 mysql-bin.018283
-rw-rw---- 1 mysql mysql 1073741989 Jul 29 20:16 mysql-bin.018284
-rw-rw---- 1 mysql mysql 1073742192 Jul 29 21:11 mysql-bin.018285
-rw-rw---- 1 mysql mysql 1073742024 Jul 29 22:00 mysql-bin.018286
-rw-rw---- 1 mysql mysql 1073742437 Jul 29 22:54 mysql-bin.018287
-rw-rw---- 1 mysql mysql 1073743013 Jul 29 23:47 mysql-bin.018288
-rw-rw---- 1 mysql mysql 1073742668 Jul 30 00:40 mysql-bin.018289
-rw-rw---- 1 mysql mysql 1073742047 Jul 30 01:34 mysql-bin.018290
-rw-rw---- 1 mysql mysql 1073742598 Jul 30 02:28 mysql-bin.018291
-rw-rw---- 1 mysql mysql 1073741969 Jul 30 03:21 mysql-bin.018292
-rw-rw---- 1 mysql mysql 1073742180 Jul 30 04:14 mysql-bin.018293
-rw-rw---- 1 mysql mysql 1073741929 Jul 30 05:08 mysql-bin.018294
-rw-rw---- 1 mysql mysql 1073742393 Jul 30 06:01 mysql-bin.018295
-rw-rw---- 1 mysql mysql 684744539 Jul 30 06:35 mysql-bin.018296
-rw-rw---- 1 mysql mysql 1073742079 Jul 30 07:28 mysql-bin.018297
-rw-rw---- 1 mysql mysql 1073741920 Jul 30 08:22 mysql-bin.018298
-rw-rw---- 1 mysql mysql 1073742886 Jul 30 09:16 mysql-bin.018299
-rw-rw---- 1 mysql mysql 1073742786 Jul 30 10:10 mysql-bin.018300
-rw-rw---- 1 mysql mysql 1073742023 Jul 30 11:04 mysql-bin.018301
-rw-rw---- 1 mysql mysql 1073742645 Jul 30 11:58 mysql-bin.018302
-rw-rw---- 1 mysql mysql 1073741874 Jul 30 12:51 mysql-bin.018303
-rw-rw---- 1 mysql mysql 1073741869 Jul 30 13:41 mysql-bin.018304
-rw-rw---- 1 mysql mysql 1073741956 Jul 30 14:34 mysql-bin.018305
-rw-rw---- 1 mysql mysql 1073741887 Jul 30 15:28 mysql-bin.018306
-rw-rw---- 1 mysql mysql 1073742968 Jul 30 16:21 mysql-bin.018307
-rw-rw---- 1 mysql mysql 1073741917 Jul 30 17:15 mysql-bin.018308
-rw-rw---- 1 mysql mysql 1073741922 Jul 30 18:09 mysql-bin.018309
-rw-rw---- 1 mysql mysql 1073742129 Jul 30 19:03 mysql-bin.018310
-rw-rw---- 1 mysql mysql 1073742671 Jul 30 19:57 mysql-bin.018311
-rw-rw---- 1 mysql mysql 867253535 Jul 31 05:58 mysql-bin.018312
-rw-rw---- 1 mysql mysql 126 Jul 31 06:14 mysql-bin.018313
-rw-rw---- 1 mysql mysql 464180872 Jul 31 06:28 mysql-bin.018314
-rw-rw---- 1 mysql mysql 1073742169 Jul 31 07:20 mysql-bin.018315
-rw-rw---- 1 mysql mysql 1073742162 Jul 31 08:14 mysql-bin.018316
-rw-rw---- 1 mysql mysql 1073742856 Jul 31 09:03 mysql-bin.018317
-rw-rw---- 1 mysql mysql 1073742694 Jul 31 09:57 mysql-bin.018318
-rw-rw---- 1 mysql mysql 1073742003 Jul 31 10:40 mysql-bin.018319
-rw-rw---- 1 mysql mysql 1073742243 Jul 31 11:29 mysql-bin.018320
-rw-rw---- 1 mysql mysql 1073742219 Jul 31 12:19 mysql-bin.018321
-rw-rw---- 1 mysql mysql 1073742499 Jul 31 13:12 mysql-bin.018322
-rw-rw---- 1 mysql mysql 1073741979 Jul 31 14:03 mysql-bin.018323
-rw-rw---- 1 mysql mysql 1073742112 Jul 31 14:48 mysql-bin.018324
-rw-rw---- 1 mysql mysql 1073742512 Jul 31 15:37 mysql-bin.018325
-rw-rw---- 1 mysql mysql 1073742019 Jul 31 16:22 mysql-bin.018326
-rw-rw---- 1 mysql mysql 1073742558 Jul 31 17:16 mysql-bin.018327
-rw-rw---- 1 mysql mysql 1073742174 Jul 31 17:52 mysql-bin.018328
-rw-rw---- 1 mysql mysql 1073742248 Jul 31 18:31 mysql-bin.018329
-rw-rw---- 1 mysql mysql 1073742915 Jul 31 19:16 mysql-bin.018330
-rw-rw---- 1 mysql mysql 1073741982 Jul 31 20:09 mysql-bin.018331
-rw-rw---- 1 mysql mysql 1073742684 Jul 31 20:55 mysql-bin.018332
-rw-rw---- 1 mysql mysql 1073742151 Jul 31 21:48 mysql-bin.018333
-rw-rw---- 1 mysql mysql 1073742095 Jul 31 22:42 mysql-bin.018334
-rw-rw---- 1 mysql mysql 1073741877 Jul 31 23:31 mysql-bin.018335
-rw-rw---- 1 mysql mysql 1073742385 Aug 1 00:23 mysql-bin.018336
-rw-rw---- 1 mysql mysql 1073742615 Aug 1 01:16 mysql-bin.018337
-rw-rw---- 1 mysql mysql 1073742221 Aug 1 02:04 mysql-bin.018338
-rw-rw---- 1 mysql mysql 1073742718 Aug 1 02:57 mysql-bin.018339
-rw-rw---- 1 mysql mysql 1073742470 Aug 1 03:49 mysql-bin.018340
-rw-rw---- 1 mysql mysql 1073742781 Aug 1 04:42 mysql-bin.018341
-rw-rw---- 1 mysql mysql 1073742019 Aug 1 05:34 mysql-bin.018342
-rw-rw---- 1 mysql mysql 1073742166 Aug 1 06:24 mysql-bin.018343
-rw-rw---- 1 mysql mysql 224356362 Aug 1 06:33 mysql-bin.018344
-rw-rw---- 1 mysql mysql 1073742244 Aug 1 07:21 mysql-bin.018345
-rw-rw---- 1 mysql mysql 1073742080 Aug 1 08:04 mysql-bin.018346
-rw-rw---- 1 mysql mysql 1073741937 Aug 1 08:52 mysql-bin.018347
-rw-rw---- 1 mysql mysql 1073742042 Aug 1 09:24 mysql-bin.018348
-rw-rw---- 1 mysql mysql 1073743177 Aug 1 10:17 mysql-bin.018349
-rw-rw---- 1 mysql mysql 1073743036 Aug 1 11:05 mysql-bin.018350
-rw-rw---- 1 mysql mysql 1073742157 Aug 1 11:55 mysql-bin.018351
-rw-rw---- 1 mysql mysql 1073742067 Aug 1 12:39 mysql-bin.018352
-rw-rw---- 1 mysql mysql 1073742195 Aug 1 13:26 mysql-bin.018353
-rw-rw---- 1 mysql mysql 1073742076 Aug 1 14:16 mysql-bin.018354
-rw-rw---- 1 mysql mysql 1073741952 Aug 1 15:02 mysql-bin.018355
-rw-rw---- 1 mysql mysql 1073741929 Aug 1 15:53 mysql-bin.018356
-rw-rw---- 1 mysql mysql 1073741966 Aug 1 16:31 mysql-bin.018357
-rw-rw---- 1 mysql mysql 1073742109 Aug 1 17:14 mysql-bin.018358
-rw-rw---- 1 mysql mysql 1073742391 Aug 1 18:08 mysql-bin.018359
-rw-rw---- 1 mysql mysql 1073742402 Aug 1 18:56 mysql-bin.018360
-rw-rw---- 1 mysql mysql 1073742002 Aug 1 19:50 mysql-bin.018361
-rw-rw---- 1 mysql mysql 1073743011 Aug 1 20:38 mysql-bin.018362
-rw-rw---- 1 mysql mysql 1073742147 Aug 1 21:32 mysql-bin.018363
-rw-rw---- 1 mysql mysql 1073742513 Aug 1 22:25 mysql-bin.018364
-rw-rw---- 1 mysql mysql 1073742239 Aug 1 23:18 mysql-bin.018365
-rw-rw---- 1 mysql mysql 1073742554 Aug 2 00:10 mysql-bin.018366
-rw-rw---- 1 mysql mysql 1073742715 Aug 2 01:03 mysql-bin.018367
-rw-rw---- 1 mysql mysql 1073741905 Aug 2 01:54 mysql-bin.018368
-rw-rw---- 1 mysql mysql 1073742516 Aug 2 02:43 mysql-bin.018369
-rw-rw---- 1 mysql mysql 1073741950 Aug 2 03:35 mysql-bin.018370
-rw-rw---- 1 mysql mysql 1073742107 Aug 2 04:28 mysql-bin.018371
-rw-rw---- 1 mysql mysql 1073742154 Aug 2 05:21 mysql-bin.018372
-rw-rw---- 1 mysql mysql 1073742058 Aug 2 06:13 mysql-bin.018373
-rw-rw---- 1 mysql mysql 455927205 Aug 2 06:30 mysql-bin.018374
-rw-rw---- 1 mysql mysql 1073742758 Aug 2 07:17 mysql-bin.018375
-rw-rw---- 1 mysql mysql 1073742253 Aug 2 08:00 mysql-bin.018376
-rw-rw---- 1 mysql mysql 1073742061 Aug 2 08:53 mysql-bin.018377
-rw-rw---- 1 mysql mysql 1073742809 Aug 2 09:45 mysql-bin.018378
-rw-rw---- 1 mysql mysql 1073741920 Aug 2 10:39 mysql-bin.018379
-rw-rw---- 1 mysql mysql 1073743076 Aug 2 11:31 mysql-bin.018380
-rw-rw---- 1 mysql mysql 1073742705 Aug 2 12:16 mysql-bin.018381
-rw-rw---- 1 mysql mysql 1073742467 Aug 2 13:08 mysql-bin.018382
-rw-rw---- 1 mysql mysql 1073742401 Aug 2 14:01 mysql-bin.018383
-rw-rw---- 1 mysql mysql 1073741892 Aug 2 14:50 mysql-bin.018384
-rw-rw---- 1 mysql mysql 1073741968 Aug 2 15:41 mysql-bin.018385
-rw-rw---- 1 mysql mysql 1073741976 Aug 2 16:33 mysql-bin.018386
-rw-rw---- 1 mysql mysql 1073742051 Aug 2 17:27 mysql-bin.018387
-rw-rw---- 1 mysql mysql 1073742311 Aug 2 18:12 mysql-bin.018388
-rw-rw---- 1 mysql mysql 1073741975 Aug 2 19:00 mysql-bin.018389
-rw-rw---- 1 mysql mysql 1073742182 Aug 2 19:44 mysql-bin.018390
-rw-rw---- 1 mysql mysql 1073742262 Aug 2 20:38 mysql-bin.018391
-rw-rw---- 1 mysql mysql 1073742192 Aug 2 21:27 mysql-bin.018392
-rw-rw---- 1 mysql mysql 1073742185 Aug 2 22:18 mysql-bin.018393
-rw-rw---- 1 mysql mysql 1073742073 Aug 2 23:11 mysql-bin.018394
-rw-rw---- 1 mysql mysql 1073742112 Aug 3 00:01 mysql-bin.018395
-rw-rw---- 1 mysql mysql 1073742554 Aug 3 00:52 mysql-bin.018396
-rw-rw---- 1 mysql mysql 1073743125 Aug 3 01:42 mysql-bin.018397
-rw-rw---- 1 mysql mysql 1073742521 Aug 3 02:31 mysql-bin.018398
-rw-rw---- 1 mysql mysql 1073741872 Aug 3 03:14 mysql-bin.018399
-rw-rw---- 1 mysql mysql 1073741977 Aug 3 04:05 mysql-bin.018400
-rw-rw---- 1 mysql mysql 1073742018 Aug 3 04:53 mysql-bin.018401
-rw-rw---- 1 mysql mysql 1073742064 Aug 3 05:42 mysql-bin.018402
-rw-rw---- 1 mysql mysql 305892795 Aug 3 05:56 mysql-bin.018403
-rwxr-xr-x 1 mysql mysql 3724 Aug 3 05:42 mysql-bin.index
-rwxr-xr-x 1 mysql mysql 6 Jul 27 09:43 mysql_upgrade_info
drwxr-xr-x 2 mysql mysql 12288 Jul 28 02:35 nagios
drwx------ 2 mysql mysql 4096 Jul 27 10:20 performance_schema
drwxr-xr-x 2 mysql mysql 4096 Feb 21 2014 test
ls -l /var/lib/mysql/nagios
Code: Select all
-rwxr-xr-x 1 mysql mysql 65 Feb 21 2014 db.opt
-rwxr-xr-x 1 mysql mysql 9100 Feb 21 2014 nagios_acknowledgements.frm
-rwxr-xr-x 1 mysql mysql 452 Jul 31 22:15 nagios_acknowledgements.MYD
-rwxr-xr-x 1 mysql mysql 3072 Jul 31 22:15 nagios_acknowledgements.MYI
-rwxr-xr-x 1 mysql mysql 8746 Feb 21 2014 nagios_commands.frm
-rwxr-xr-x 1 mysql mysql 18656 Aug 3 02:44 nagios_commands.MYD
-rwxr-xr-x 1 mysql mysql 9216 Aug 3 02:44 nagios_commands.MYI
-rwxr-xr-x 1 mysql mysql 9340 Feb 21 2014 nagios_commenthistory.frm
-rwxr-xr-x 1 mysql mysql 212213060 Aug 3 05:53 nagios_commenthistory.MYD
-rwxr-xr-x 1 mysql mysql 25422848 Aug 3 05:53 nagios_commenthistory.MYI
-rwxr-xr-x 1 mysql mysql 9220 Feb 21 2014 nagios_comments.frm
-rwxr-xr-x 1 mysql mysql 420768 Aug 3 05:53 nagios_comments.MYD
-rwxr-xr-x 1 mysql mysql 61440 Aug 3 05:53 nagios_comments.MYI
-rwxr-xr-x 1 mysql mysql 8726 Feb 21 2014 nagios_configfiles.frm
-rwxr-xr-x 1 mysql mysql 104 Aug 3 02:44 nagios_configfiles.MYD
-rwxr-xr-x 1 mysql mysql 5120 Aug 3 02:44 nagios_configfiles.MYI
-rwxr-xr-x 1 mysql mysql 8760 Feb 21 2014 nagios_configfilevariables.frm
-rwxr-xr-x 1 mysql mysql 9648 Aug 3 02:44 nagios_configfilevariables.MYD
-rwxr-xr-x 1 mysql mysql 4096 Aug 3 02:44 nagios_configfilevariables.MYI
-rwxr-xr-x 1 mysql mysql 9262 Feb 21 2014 nagios_conninfo.frm
-rwxr-xr-x 1 mysql mysql 946468 Aug 3 05:58 nagios_conninfo.MYD
-rwxr-xr-x 1 mysql mysql 107520 Aug 3 05:58 nagios_conninfo.MYI
-rwxr-xr-x 1 mysql mysql 8760 Feb 21 2014 nagios_contact_addresses.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_contact_addresses.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_contact_addresses.MYI
-rwxr-xr-x 1 mysql mysql 8748 Feb 21 2014 nagios_contactgroup_members.frm
-rwxr-xr-x 1 mysql mysql 420 Aug 3 02:44 nagios_contactgroup_members.MYD
-rwxr-xr-x 1 mysql mysql 3072 Aug 3 02:44 nagios_contactgroup_members.MYI
-rwxr-xr-x 1 mysql mysql 8768 Feb 21 2014 nagios_contactgroups.frm
-rwxr-xr-x 1 mysql mysql 1128 Aug 3 02:44 nagios_contactgroups.MYD
-rwxr-xr-x 1 mysql mysql 3072 Aug 3 02:44 nagios_contactgroups.MYI
-rwxr-xr-x 1 mysql mysql 8856 Feb 21 2014 nagios_contact_notificationcommands.frm
-rwxr-xr-x 1 mysql mysql 9904 Aug 3 02:44 nagios_contact_notificationcommands.MYD
-rwxr-xr-x 1 mysql mysql 13312 Aug 3 02:44 nagios_contact_notificationcommands.MYI
-rwxr-xr-x 1 mysql mysql 9000 Feb 21 2014 nagios_contactnotificationmethods.frm
-rwxr-xr-x 1 mysql mysql 78092284 Aug 3 05:41 nagios_contactnotificationmethods.MYD
-rwxr-xr-x 1 mysql mysql 79298560 Aug 3 05:41 nagios_contactnotificationmethods.MYI
-rwxr-xr-x 1 mysql mysql 8928 Feb 21 2014 nagios_contactnotifications.frm
-rwxr-xr-x 1 mysql mysql 52634517 Aug 3 05:41 nagios_contactnotifications.MYD
-rwxr-xr-x 1 mysql mysql 88110080 Aug 3 05:41 nagios_contactnotifications.MYI
-rwxr-xr-x 1 mysql mysql 9968 Feb 21 2014 nagios_contacts.frm
-rwxr-xr-x 1 mysql mysql 3408 Aug 3 02:44 nagios_contacts.MYD
-rwxr-xr-x 1 mysql mysql 3072 Aug 3 02:44 nagios_contacts.MYI
-rwxr-xr-x 1 mysql mysql 9240 Feb 21 2014 nagios_contactstatus.frm
-rwxr-xr-x 1 mysql mysql 1428 Aug 3 02:44 nagios_contactstatus.MYD
-rwxr-xr-x 1 mysql mysql 3072 Aug 3 02:44 nagios_contactstatus.MYI
-rwxr-xr-x 1 mysql mysql 8844 Feb 21 2014 nagios_customvariables.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_customvariables.MYD
-rwxr-xr-x 1 mysql mysql 2048 Feb 21 2014 nagios_customvariables.MYI
-rwxr-xr-x 1 mysql mysql 8870 Feb 21 2014 nagios_customvariablestatus.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_customvariablestatus.MYD
-rwxr-xr-x 1 mysql mysql 2048 Feb 21 2014 nagios_customvariablestatus.MYI
-rwxr-xr-x 1 mysql mysql 8596 Feb 21 2014 nagios_dbversion.frm
-rwxr-xr-x 1 mysql mysql 20 Feb 21 2014 nagios_dbversion.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 26 2014 nagios_dbversion.MYI
-rwxr-xr-x 1 mysql mysql 9490 Feb 21 2014 nagios_downtimehistory.frm
-rwxr-xr-x 1 mysql mysql 52340 Aug 3 02:57 nagios_downtimehistory.MYD
-rwxr-xr-x 1 mysql mysql 18432 Aug 3 02:57 nagios_downtimehistory.MYI
-rwxr-xr-x 1 mysql mysql 9380 Feb 21 2014 nagios_eventhandlers.frm
-rwxr-xr-x 1 mysql mysql 286865136 Aug 3 05:59 nagios_eventhandlers.MYD
-rwxr-xr-x 1 mysql mysql 76975104 Aug 3 05:59 nagios_eventhandlers.MYI
-rwxr-xr-x 1 mysql mysql 8812 Feb 21 2014 nagios_externalcommands.frm
-rwxr-xr-x 1 mysql mysql 306232 Aug 3 03:12 nagios_externalcommands.MYD
-rwxr-xr-x 1 mysql mysql 38912 Aug 3 03:12 nagios_externalcommands.MYI
-rwxr-xr-x 1 mysql mysql 9166 Feb 21 2014 nagios_flappinghistory.frm
-rwxr-xr-x 1 mysql mysql 170056055 Aug 3 05:53 nagios_flappinghistory.MYD
-rwxr-xr-x 1 mysql mysql 26850304 Aug 3 05:53 nagios_flappinghistory.MYI
-rwxr-xr-x 1 mysql mysql 9660 Feb 21 2014 nagios_hostchecks.frm
-rwxr-xr-x 1 mysql mysql 32895014768 Aug 3 05:59 nagios_hostchecks.MYD
-rwxr-xr-x 1 mysql mysql 8286479360 Aug 3 05:59 nagios_hostchecks.MYI
-rwxr-xr-x 1 mysql mysql 8738 Feb 21 2014 nagios_host_contactgroups.frm
-rwxr-xr-x 1 mysql mysql 34905 Aug 3 02:44 nagios_host_contactgroups.MYD
-rwxr-xr-x 1 mysql mysql 59392 Aug 3 02:44 nagios_host_contactgroups.MYI
-rwxr-xr-x 1 mysql mysql 8718 Feb 21 2014 nagios_host_contacts.frm
-rwxr-xr-x 1 mysql mysql 375 Aug 3 02:44 nagios_host_contacts.MYD
-rwxr-xr-x 1 mysql mysql 3072 Aug 3 02:44 nagios_host_contacts.MYI
-rwxr-xr-x 1 mysql mysql 9108 Feb 21 2014 nagios_hostdependencies.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_hostdependencies.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_hostdependencies.MYI
-rwxr-xr-x 1 mysql mysql 8778 Feb 21 2014 nagios_hostescalation_contactgroups.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_hostescalation_contactgroups.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_hostescalation_contactgroups.MYI
-rwxr-xr-x 1 mysql mysql 8758 Feb 21 2014 nagios_hostescalation_contacts.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_hostescalation_contacts.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_hostescalation_contacts.MYI
-rwxr-xr-x 1 mysql mysql 9148 Feb 21 2014 nagios_hostescalations.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_hostescalations.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_hostescalations.MYI
-rwxr-xr-x 1 mysql mysql 8730 Feb 21 2014 nagios_hostgroup_members.frm
-rwxr-xr-x 1 mysql mysql 35355 Aug 3 02:44 nagios_hostgroup_members.MYD
-rwxr-xr-x 1 mysql mysql 71680 Aug 3 02:44 nagios_hostgroup_members.MYI
-rwxr-xr-x 1 mysql mysql 8756 Feb 21 2014 nagios_hostgroups.frm
-rwxr-xr-x 1 mysql mysql 1152 Aug 3 02:44 nagios_hostgroups.MYD
-rwxr-xr-x 1 mysql mysql 3072 Aug 3 02:44 nagios_hostgroups.MYI
-rwxr-xr-x 1 mysql mysql 8732 Feb 21 2014 nagios_host_parenthosts.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_host_parenthosts.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_host_parenthosts.MYI
-rwxr-xr-x 1 mysql mysql 11890 Feb 21 2014 nagios_hosts.frm
-rwxr-xr-x 1 mysql mysql 329448 Aug 3 02:44 nagios_hosts.MYD
-rwxr-xr-x 1 mysql mysql 98304 Aug 3 02:44 nagios_hosts.MYI
-rwxr-xr-x 1 mysql mysql 15368 Feb 21 2014 nagios_hoststatus.frm
-rwxr-xr-x 1 mysql mysql 678580 Aug 3 05:59 nagios_hoststatus.MYD
-rwxr-xr-x 1 mysql mysql 603136 Aug 3 05:59 nagios_hoststatus.MYI
-rwxr-xr-x 1 mysql mysql 8684 Feb 21 2014 nagios_instances.frm
-rwxr-xr-x 1 mysql mysql 20 Feb 21 2014 nagios_instances.MYD
-rwxr-xr-x 1 mysql mysql 2048 Feb 21 2014 nagios_instances.MYI
-rwxr-xr-x 1 mysql mysql 8972 Feb 21 2014 nagios_logentries.frm
-rwxr-xr-x 1 mysql mysql 92416749088 Aug 3 05:59 nagios_logentries.MYD
-rwxr-xr-x 1 mysql mysql 18445841408 Aug 3 05:59 nagios_logentries.MYI
-rwxr-xr-x 1 mysql mysql 9168 Feb 21 2014 nagios_notifications.frm
-rwxr-xr-x 1 mysql mysql 125942956 Aug 3 05:41 nagios_notifications.MYD
-rwxr-xr-x 1 mysql mysql 61649920 Aug 3 05:41 nagios_notifications.MYI
-rwxr-xr-x 1 mysql mysql 8766 Feb 21 2014 nagios_objects.frm
-rwxr-xr-x 1 mysql mysql 2223572 Aug 3 02:45 nagios_objects.MYD
-rwxr-xr-x 1 mysql mysql 1794048 Aug 3 02:45 nagios_objects.MYI
-rwxr-xr-x 1 mysql mysql 8948 Feb 21 2014 nagios_processevents.frm
-rwxr-xr-x 1 mysql mysql 2478724 Aug 3 02:45 nagios_processevents.MYD
-rwxr-xr-x 1 mysql mysql 491520 Aug 3 02:45 nagios_processevents.MYI
-rwxr-xr-x 1 mysql mysql 10174 Feb 21 2014 nagios_programstatus.frm
-rwxr-xr-x 1 mysql mysql 96 Feb 21 2014 nagios_programstatus.MYD
-rwxr-xr-x 1 mysql mysql 3072 Feb 26 2014 nagios_programstatus.MYI
-rwxr-xr-x 1 mysql mysql 8706 Feb 21 2014 nagios_runtimevariables.frm
-rwxr-xr-x 1 mysql mysql 1268 Aug 3 02:45 nagios_runtimevariables.MYD
-rwxr-xr-x 1 mysql mysql 3072 Aug 3 02:45 nagios_runtimevariables.MYI
-rwxr-xr-x 1 mysql mysql 9332 Feb 21 2014 nagios_scheduleddowntime.frm
-rwxr-xr-x 1 mysql mysql 31964 Aug 3 02:57 nagios_scheduleddowntime.MYD
-rwxr-xr-x 1 mysql mysql 13312 Aug 3 02:57 nagios_scheduleddowntime.MYI
-rwxr-xr-x 1 mysql mysql 9626 Feb 21 2014 nagios_servicechecks.frm
-rwxr-xr-x 1 mysql mysql 3367315000 Aug 3 05:59 nagios_servicechecks.MYD
-rwxr-xr-x 1 mysql mysql 1163973632 Aug 3 05:59 nagios_servicechecks.MYI
-rwxr-xr-x 1 mysql mysql 8750 Jul 28 02:35 nagios_service_contactgroups.frm
-rw-rw---- 1 mysql mysql 610063665 Aug 3 02:45 nagios_service_contactgroups.MYD
-rwxr-xr-x 1 mysql mysql 995975168 Aug 3 02:45 nagios_service_contactgroups.MYI
-rwxr-xr-x 1 mysql mysql 8730 Feb 21 2014 nagios_service_contacts.frm
-rwxr-xr-x 1 mysql mysql 1350 Aug 3 02:45 nagios_service_contacts.MYD
-rwxr-xr-x 1 mysql mysql 5120 Aug 3 02:45 nagios_service_contacts.MYI
-rwxr-xr-x 1 mysql mysql 9178 Feb 21 2014 nagios_servicedependencies.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_servicedependencies.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_servicedependencies.MYI
-rwxr-xr-x 1 mysql mysql 8790 Feb 21 2014 nagios_serviceescalation_contactgroups.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_serviceescalation_contactgroups.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_serviceescalation_contactgroups.MYI
-rwxr-xr-x 1 mysql mysql 8770 Feb 21 2014 nagios_serviceescalation_contacts.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_serviceescalation_contacts.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_serviceescalation_contacts.MYI
-rwxr-xr-x 1 mysql mysql 9220 Feb 21 2014 nagios_serviceescalations.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_serviceescalations.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_serviceescalations.MYI
-rwxr-xr-x 1 mysql mysql 8748 Feb 21 2014 nagios_servicegroup_members.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_servicegroup_members.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_servicegroup_members.MYI
-rwxr-xr-x 1 mysql mysql 8768 Feb 21 2014 nagios_servicegroups.frm
-rwxr-xr-x 1 mysql mysql 0 Feb 21 2014 nagios_servicegroups.MYD
-rwxr-xr-x 1 mysql mysql 1024 Feb 21 2014 nagios_servicegroups.MYI
-rwxr-xr-x 1 mysql mysql 11724 Feb 21 2014 nagios_services.frm
-rwxr-xr-x 1 mysql mysql 3372136 Aug 3 02:45 nagios_services.MYD
-rwxr-xr-x 1 mysql mysql 917504 Aug 3 02:45 nagios_services.MYI
-rwxr-xr-x 1 mysql mysql 15448 Feb 21 2014 nagios_servicestatus.frm
-rwxr-xr-x 1 mysql mysql 7161500 Aug 3 05:59 nagios_servicestatus.MYD
-rwxr-xr-x 1 mysql mysql 5826560 Aug 3 05:59 nagios_servicestatus.MYI
-rwxr-xr-x 1 mysql mysql 9174 Feb 21 2014 nagios_statehistory.frm
-rwxr-xr-x 1 mysql mysql 3670220820 Feb 21 2014 nagios_statehistory.MYD
-rwxr-xr-x 1 mysql mysql 320622592 Feb 26 2014 nagios_statehistory.MYI
-rwxr-xr-x 1 mysql mysql 9110 Feb 21 2014 nagios_systemcommands.frm
-rwxr-xr-x 1 mysql mysql 30592732 Feb 28 2014 nagios_systemcommands.MYD
-rwxr-xr-x 1 mysql mysql 5234688 Apr 4 2014 nagios_systemcommands.MYI
-rwxr-xr-x 1 mysql mysql 8914 Feb 21 2014 nagios_timedeventqueue.frm
-rwxr-xr-x 1 mysql mysql 385105 Feb 21 2014 nagios_timedeventqueue.MYD
-rwxr-xr-x 1 mysql mysql 593920 Feb 26 2014 nagios_timedeventqueue.MYI
-rwxr-xr-x 1 mysql mysql 9104 Feb 21 2014 nagios_timedevents.frm
-rwxr-xr-x 1 mysql mysql 132503793 Feb 23 2014 nagios_timedevents.MYD
-rwxr-xr-x 1 mysql mysql 118774784 Feb 26 2014 nagios_timedevents.MYI
-rwxr-xr-x 1 mysql mysql 8760 Feb 21 2014 nagios_timeperiods.frm
-rwxr-xr-x 1 mysql mysql 192 Aug 3 02:44 nagios_timeperiods.MYD
-rwxr-xr-x 1 mysql mysql 3072 Aug 3 02:44 nagios_timeperiods.MYI
-rwxr-xr-x 1 mysql mysql 8794 Feb 21 2014 nagios_timeperiod_timeranges.frm
-rwxr-xr-x 1 mysql mysql 399 Aug 3 02:44 nagios_timeperiod_timeranges.MYD
-rwxr-xr-x 1 mysql mysql 3072 Aug 3 02:44 nagios_timeperiod_timeranges.MYI
Thank You!!
Re: Nagios Mysql database taking lot of root volume in ubunt
Posted: Thu Aug 03, 2017 10:35 am
by bolson
Hi Teja,
This is a tad bit our of scope for us but I may be able to provide some insight.
Your issue is caused by your having binary logging enabled in mysql and not configured properly. A default installation of Nagios Core does not enable this by default.
Is there a reason why you have binary logging enabled?
Re: Nagios Mysql database taking lot of root volume in ubunt
Posted: Fri Aug 04, 2017 2:44 am
by Teja
Hi bolson,
My First Question would be What are Binary logs?, & What are they Used for ? ,Then i can say you the reason behind enabling them.
Thanks Much mate!!
Re: Nagios Mysql database taking lot of root volume in ubunt
Posted: Fri Aug 04, 2017 12:17 pm
by bolson
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. Writing to the binary log provides some protection against a server crash or disk failure in that these log entries are "written" more quickly than actual database writes. The binary log is also used in master/slave replication. You can read more here:
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
You run into a problem when you have an application like Nagios that is constantly reading from and writing to the database as every one of these events is logged... hence the files grow very fast. For this reason, binary logging on a Nagios server is not practical.
Re: Nagios Mysql database taking lot of root volume in ubunt
Posted: Sat Aug 05, 2017 6:23 am
by Teja
Hi bolson,
Thanks a lot for your reply . I think it could be a false call opening the Binary logs, Everyday we have lot of changes being made to the Nagios box that's leading to kill the disk space here. So yesterday i have tested by purging 2 days of binary logs and found nothing impacted thankfully. Now bolson can i start purging all the binary logs not daily but on weekly basis??