Logo by AGUS - Contribute your own Logo!
News: Support us via Flattr FLATTR Link
 
*
Welcome, Guest. Please login or register. July 26, 2017, 06:40:17 PM


Login with username, password and session length



Pages: [1]   Go Down
  Print  
Share this topic on DiggShare this topic on FacebookShare this topic on GoogleShare this topic on RedditShare this topic on StumbleUponShare this topic on Twitter
Author Topic: database down due to logging #2  (Read 280 times)
0 Members and 1 Guest are viewing this topic.
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« on: September 24, 2016, 09:26:30 AM »

it happened again, 700 mb of logs deleted, now i have a time interval since last downtime to check regularly for those
Logged

---

divide and conquer - iterate and rule - chaos is No random!
knighty
Fractal Iambus
***
Posts: 815


« Reply #1 on: September 24, 2016, 01:08:31 PM »

 I was wondering what happened yesterday.  smiley
Logged
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« Reply #2 on: September 24, 2016, 01:41:41 PM »

it builds up over time, need to delete the logs on a regular base, fix log errors, or disable logging
Logged

---

divide and conquer - iterate and rule - chaos is No random!
zebastian
Conqueror
*******
Posts: 108



« Reply #3 on: September 24, 2016, 04:22:26 PM »

@cKleinhuis

If you are already using logrotate to maintain the logs you mst just edit the
rotate 14 # delete logs older 14 days
variable in the corresponding logrotate config
Maybe here: /etc/logrotate.d/apache2

More info:
http://serverfault.com/questions/498475/how-can-i-automatically-delete-old-apache-error-log-files

Logged
cKleinhuis
Administrator
Fractal Senior
*******
Posts: 7044


formerly known as 'Trifox'


WWW
« Reply #4 on: September 24, 2016, 09:41:46 PM »

it is the internal forums error logging which lands in the database. strangely enough i cant do anything about the errors most of them are plain warnings,. but stored in the mysql database which has a hard cap of 1 gig
Logged

---

divide and conquer - iterate and rule - chaos is No random!
3dickulus
Fractal Senior
******
Posts: 1523



WWW
« Reply #5 on: September 24, 2016, 10:05:28 PM »

can you set the log level to critical errors only so warnings don't produce a log entry?
Logged

Resistance is fertile...
You will be illuminated!

                            #B^]
Pages: [1]   Go Down
  Print  
 
Jump to:  

Related Topics
Subject Started by Replies Views Last post
Notification about Database Consumption Fractal Forums News cKleinhuis 10 1495 Last post December 04, 2010, 03:03:55 PM
by twinbee
Formula Database Update Other / General Discussion Plotz 9 2173 Last post July 21, 2011, 12:07:04 AM
by Plotz
database dependency graph Fractal Humor willvarfar 2 818 Last post July 16, 2012, 12:56:06 AM
by cKleinhuis
Formula database? feature request 0Encrypted0 4 487 Last post April 13, 2015, 08:24:21 PM
by 0Encrypted0

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM
Page created in 0.789 seconds with 28 queries. (Pretty URLs adds 0.022s, 2q)