On my mysql servers, I've noticed some unexpected files in the
/usr/local/mysql/data/ directory.
Specifically, I have files like:
hostname-bin.001
hostname-bin.002
hostname-bin.003
etc. (obviously with hostname being replaced with the name of the
computer)
I also have files like...
Okay, replying to my own post is like talking to one's self but...
so I finally found the manual page that describes the two files. Any
reason I want them (the log files that is)? My databases currently are
not replicating (no plans to add it) and have many reads but few
writes.
On Sep 28,
Rob Best [EMAIL PROTECTED] wrote:
Okay, replying to my own post is like talking to one's self but...
so I finally found the manual page that describes the two files. Any
reason I want them (the log files that is)? My databases currently are
not replicating (no plans to add it) and have many
Hi Folks,
I am running a webserver with around 100.000 hits per day running mostly on
PHP / MySQL.
In the mysql-data-directory (for my home /var/lib/mysql) I find a some
files named:
./server-bin.009
./server-bin.010
./server-bin.011
./server-bin.012
./server-bin.013
./server-bin.014
and so
They are mysql binary logs of updates to your databases, and are usually
only needed for replication across multiple servers. If you don't need this,
remove or comment out the log-bin line from /etc/my.cnf and restart mysqld,
then you can delete them.
Hi Folks,
I am running a webserver with
Wow 300 MB logs ;-).
Thanks a lot!
Thomas
At 11:35 09.06.2001, you wrote:
They are mysql binary logs of updates to your databases, and are usually
only needed for replication across multiple servers. If you don't need this,
remove or comment out the log-bin line from /etc/my.cnf and restart
On Sat, Jun 09, 2001 at 12:14:54PM +0200, Thomas Seifert wrote:
Wow 300 MB logs ;-).
I once accumulated 30GB of binary logs on a server before thinking
hard about resetting things. :-)
It made for a great way to throw real queries at a test server. I'd
just make the test server a slave of the