View Single Post
  #6  
Old 05-03-2008, 05:04 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

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...

Code:
-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:

Code:
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.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote