All Questions
3 questions
2
votes
1
answer
235
views
Why is MySQL writing hundreds of 125 byte binary log files?
My MySQL Master (with no connected slaves right now) writes out a 125 byte file every minute or so:
-rw-rw---- 1 mysql mysql 125 2012-12-28 16:46 snapshot-mysql-v2-bin.004876
-rw-rw---- 1 ...
2
votes
2
answers
7k
views
MySQL Binary Log activated = high-end server damn slow
On MySQL 5.1(.57-1.dotdeb), I have a ~2.0Gb database, and an average of ~350 requests per second.
All is running fine if I don't activate the binary log. The CPU usage is decent (~15% of 1 CPU core)....
- 21
2
votes
1
answer
2k
views
Enable binary logging MySQL
How exactly can I enable binary logging on MySQL server. Conf.file? Server Startup Parameter? If possible give me an example.
- 161