Page 1 / 1 (3 Posts)

How to manage MySQL binary log space (Debian)

So it turns out that what is filling up my root partition is my MySQL binary logs.A collection of fat files in /var/log/mysql ...So I had several options: Move the logs to a different partition Increase the size of the root partition D…...

October 15, 2007 · 2 min · François Planque

How to check what MySQL version I am using?

In order to determine which MySQL version you're running you can type the following command: mysql -V Sample results: # mysql -V mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386) # mysql -V mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu…...

October 1, 2007 · 1 min · François Planque

mySQL 3.23 is making me sick!

No referential integrity No transactions (at least not enabled by default so hosting providers would have them) No subqueries in DELETE statements No UNION statement (can you believe it?) and of course no triggers of any kind... Not that I think mySQL…...

May 29, 2003 · 2 min · François Planque