Restarting Dynamic Zone After a Crash?

[trevius]

Almost 1GB in 6hours. Not sure where it is going...


System hostname XXXX
Operating system Debian Linux 4.0
Webmin version 1.410
Time on system Sat May 3 12:12:10 2008
System uptime 2 days, 11 hours, 24 minutes
CPU load averages 23.73 (1 min) 21.77 (5 mins) 19.31 (15 mins)
Real memory 2.95 GB total, 1 GB used

Virtual memory 651.03 MB total, 68 kB used

Local disk space 13.14 GB total, 11.23 GB used

[AndMetal]

After doing some searching, I found this website that says you can run this command to search for large files:

find / -type f -size +100000k -exec ls -lh {} \; | awk '{ print $9 ": " $5 }'

Specifically, that will search for files larger than 100000 KB (~100 MB).

For me, this yielded the following:

/var/lib/mysql/ibdata1: 114M
/proc/kcore: 897M
/home/eqemu/source/EQEmu-0.7.0-1090/utils/defaults/logs/eqemu_debug_zone.log: 361M
/home/eqemu/source/EQEmu-0.7.0-1090/utils/defaults/logs/zone-dynamic_26.log: 185M
/home/eqemu/common/Maps.tar.gz: 302M
/home/wowemu/source/src/game/libmangosgame.a: 132M

Hope this helps.

[Aramid]

It's probably your log files, because the start program you are using erases them when you re-boot the server. Every time someone just logs into your server it adds a lot of info. There has to be a way to turn them off....

[trevius]

Well, my eqemu log files aren't very bad at all. They only get to be a couple hundred MB total per day. But, apparently mysql has decided to start some logs of it's own...

-rw-rw----  1 mysql adm      14523 2008-04-30 03:24 mysql-bin.000001
-rw-rw----  1 mysql adm     510697 2008-04-30 03:24 mysql-bin.000002
-rw-rw----  1 mysql adm        272 2008-04-30 03:24 mysql-bin.000003
-rw-rw----  1 mysql adm        538 2008-04-30 03:24 mysql-bin.000004
-rw-rw----  1 mysql adm        695 2008-04-30 03:24 mysql-bin.000005
-rw-rw----  1 mysql adm        117 2008-04-30 03:24 mysql-bin.000006
-rw-rw----  1 mysql adm  104883277 2008-04-30 04:20 mysql-bin.000007
-rw-rw----  1 mysql adm  104864605 2008-04-30 04:20 mysql-bin.000008
-rw-rw----  1 mysql adm  104868599 2008-04-30 04:20 mysql-bin.000009
-rw-rw----  1 mysql adm  104857658 2008-04-30 04:22 mysql-bin.000010
-rw-rw----  1 mysql adm  104858441 2008-04-30 04:26 mysql-bin.000011
-rw-rw----  1 mysql adm  104857668 2008-04-30 04:29 mysql-bin.000012
-rw-rw----  1 mysql adm   71238529 2008-04-30 06:04 mysql-bin.000013
-rw-rw----  1 mysql adm      58356 2008-04-30 18:41 mysql-bin.000014
-rw-rw----  1 mysql adm      74191 2008-05-01 00:36 mysql-bin.000015
-rw-rw----  1 mysql adm  104880860 2008-05-01 01:01 mysql-bin.000016
-rw-rw----  1 mysql adm  104880772 2008-05-01 01:02 mysql-bin.000017
-rw-rw----  1 mysql adm  104868271 2008-05-01 01:02 mysql-bin.000018
-rw-rw----  1 mysql adm  104870093 2008-05-01 01:02 mysql-bin.000019
-rw-rw----  1 mysql adm  104857810 2008-05-01 01:10 mysql-bin.000020
-rw-rw----  1 mysql adm  104858636 2008-05-01 01:14 mysql-bin.000021
-rw-rw----  1 mysql adm  104857681 2008-05-01 01:21 mysql-bin.000022
-rw-rw----  1 mysql adm  104888312 2008-05-01 01:44 mysql-bin.000023
-rw-rw----  1 mysql adm  104891014 2008-05-01 01:44 mysql-bin.000024
-rw-rw----  1 mysql adm  104886951 2008-05-01 01:45 mysql-bin.000025
-rw-rw----  1 mysql adm  104889375 2008-05-01 01:45 mysql-bin.000026
-rw-rw----  1 mysql adm  104857726 2008-05-01 01:52 mysql-bin.000027
-rw-rw----  1 mysql adm  104858523 2008-05-01 01:53 mysql-bin.000028
-rw-rw----  1 mysql adm  104857765 2008-05-01 01:57 mysql-bin.000029
-rw-rw----  1 mysql adm  104864791 2008-05-01 03:47 mysql-bin.000030
-rw-rw----  1 mysql adm  104872158 2008-05-01 05:17 mysql-bin.000031
-rw-rw----  1 mysql adm  104871022 2008-05-01 07:15 mysql-bin.000032
-rw-rw----  1 mysql adm  104858638 2008-05-01 08:52 mysql-bin.000033
-rw-rw----  1 mysql adm  104895455 2008-05-01 10:24 mysql-bin.000034
-rw-rw----  1 mysql adm  104884507 2008-05-01 12:12 mysql-bin.000035
-rw-rw----  1 mysql adm  104870085 2008-05-01 14:01 mysql-bin.000036
-rw-rw----  1 mysql adm  104881715 2008-05-01 15:43 mysql-bin.000037
-rw-rw----  1 mysql adm  104880952 2008-05-01 17:15 mysql-bin.000038
-rw-rw----  1 mysql adm  104882831 2008-05-01 19:04 mysql-bin.000039
-rw-rw----  1 mysql adm  104859016 2008-05-01 20:37 mysql-bin.000040
-rw-rw----  1 mysql adm  104876683 2008-05-01 22:05 mysql-bin.000041
-rw-rw----  1 mysql adm  104887706 2008-05-01 23:21 mysql-bin.000042
-rw-rw----  1 mysql adm  104882239 2008-05-02 00:57 mysql-bin.000043
-rw-rw----  1 mysql adm  104859634 2008-05-02 03:06 mysql-bin.000044
-rw-rw----  1 mysql adm  104857648 2008-05-02 05:28 mysql-bin.000045
-rw-rw----  1 mysql adm   85713663 2008-05-02 07:35 mysql-bin.000046
-rw-rw----  1 mysql adm  104876061 2008-05-02 09:43 mysql-bin.000047
-rw-rw----  1 mysql adm  104869046 2008-05-02 11:53 mysql-bin.000048
-rw-rw----  1 mysql adm  104860169 2008-05-02 14:21 mysql-bin.000049
-rw-rw----  1 mysql adm  104873747 2008-05-02 16:17 mysql-bin.000050
-rw-rw----  1 mysql adm  104880877 2008-05-02 17:37 mysql-bin.000051
-rw-rw----  1 mysql adm  104892336 2008-05-02 19:03 mysql-bin.000052
-rw-rw----  1 mysql adm  104879856 2008-05-02 20:14 mysql-bin.000053
-rw-rw----  1 mysql adm  104889066 2008-05-02 21:24 mysql-bin.000054
-rw-rw----  1 mysql adm  104878996 2008-05-02 22:32 mysql-bin.000055
-rw-rw----  1 mysql adm  104885167 2008-05-02 23:42 mysql-bin.000056
-rw-rw----  1 mysql adm  104877980 2008-05-03 00:59 mysql-bin.000057
-rw-rw----  1 mysql adm  104895987 2008-05-03 02:39 mysql-bin.000058
-rw-rw----  1 mysql adm  104862508 2008-05-03 05:17 mysql-bin.000059
-rw-rw----  1 mysql adm   89631985 2008-05-03 07:35 mysql-bin.000060
-rw-rw----  1 mysql adm  104895799 2008-05-03 09:38 mysql-bin.000061
-rw-rw----  1 mysql adm  104864798 2008-05-03 11:10 mysql-bin.000062
-rw-rw----  1 mysql adm  104880617 2008-05-03 12:23 mysql-bin.000063
-rw-rw----  1 mysql adm  104863114 2008-05-03 13:57 mysql-bin.000064
-rw-rw----  1 mysql adm  104893903 2008-05-03 15:09 mysql-bin.000065
-rw-rw----  1 mysql adm   59043841 2008-05-03 15:46 mysql-bin.000066

After some research, it looks like these files are all some sort of mysql backup. This is enabled in the my.cnf file. So, you can give temporary edit rights from root so you can open it in a text editor:

server:/etc/mysql# chmod go+rw my.cnf

Then, open the my.cnf file in a text editor and comment these lines by putting a # in front of them:

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

Then save the file and don't forget the remove the rw rights you added before or mysql will have problems loading:

server:/etc/mysql# chmod go-rw my.cnf

I just tried all of this myself, but I haven't restarted mysql yet to see if it works, but I imagine it should. I will restart mysql the next time I reboot the server and I will report back if this doesn't work.

[Aramid]

Well, SQL uses log files in case it has to roll back an incomplete transaction. Being that I don't run an active server, I didn't even think about the MySQL log files.... You shouldn't need to have them, so you should be ok to comment them out.