[Maia-users] database issues

Ryan Delany ryan at rynogear.com
Thu Aug 30 13:47:19 PDT 2007


> I've modified the my.cnf to comment out the log-bin line.
>
> Once I restart mysql, can I delete the  mysql-bin.00000x files, and
> potentially the  mysql-bin.index files?
>
> Kurt

Kurt,

I would move them first and see if everything is ok, but bottom line is
that without binary logging, those files aren't used/necessary any more. 
Here is the output of my /var/lib/mysql directory:

-rw-rw----   1 mysql mysql 2097152000 Aug 30 13:39 ibdata1
-rw-rw----   1 mysql mysql 1048576000 Aug 13 16:02 ibdata2
-rw-rw----   1 mysql mysql  104857600 Aug 30 13:39 ib_logfile0
-rw-rw----   1 mysql mysql  104857600 Aug 30 08:21 ib_logfile1
drwx------   2 mysql mysql       4096 Jun 30 09:25 maia
-rw-rw----   1 mysql mysql      45014 Aug 13 16:02 <servername>.err
drwx------   2 mysql mysql       4096 Apr 26  2006 mysql
srwxrwxrwx   1 mysql mysql          0 Aug 13 16:02 mysql.sock
drwx------   2 mysql mysql       4096 Mar 10 09:22 test

Regards,

Ryan



More information about the Maia-users mailing list