Logo by Maya - Contribute your own Logo!

END OF AN ERA, FRACTALFORUMS.COM IS CONTINUED ON FRACTALFORUMS.ORG

it was a great time but no longer maintainable by c.Kleinhuis contact him for any data retrieval,
thanks and see you perhaps in 10 years again

this forum will stay online for reference
News: Check out the originating "3d Mandelbulb" thread here
 
*
Welcome, Guest. Please login or register. January 18, 2018, 06:45:51 AM


Login with username, password and session length


The All New FractalForums is now in Public Beta Testing! Visit FractalForums.org and check it out!


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 336 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: 819


« 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: 121



« 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
Global Moderator
Fractal Senior
******
Posts: 1558



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^] https://en.wikibooks.org/wiki/Fractals/fragmentarium
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 1508 Last post December 04, 2010, 03:03:55 PM
by twinbee
Formula Database Update Other / General Discussion Plotz 9 2363 Last post July 21, 2011, 12:07:04 AM
by Plotz
database dependency graph Fractal Humor willvarfar 2 913 Last post July 16, 2012, 12:56:06 AM
by cKleinhuis
Formula database? feature request 0Encrypted0 4 542 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.211 seconds with 28 queries. (Pretty URLs adds 0.013s, 2q)