How long should I keep binary logs?

Two INNODB/mysql/Win questions from a new user: [1] How long should I keep around copies of binarylog? (They're used to recover in case of failure, yes? (I'm also shutting down the databases and dumping them each night to a large text file as backup, too.) [2] Can anyone offer advice (or links t

locking

Hi. I am new to my my sql and have a basic question about locking. I am running Ver 11.18 Distrib 3.23.54, for Win95/Win98. I have a table that holds work on jobs needing processing FieldTypeNullKey Default Extra --- - -- ---

INNODB beginner question

Hi -- I'm still relatively new to MySql. I'm using InnoDB tables and foreign keys. When I set up the databases, I recall assigning a few large fixed-size files to the InnoDB engine for data (and I think) logs. I've been adding data to my databases daily and wish to know how full they are, and

assorted: foreign keys, mult databases, and crashes

Hi Three questions from a Mysql newcomer Syntax question: Can a table in database A have a foreign key relationship with a table in database B? (both INNODB, both with appropriate indexes, etc) Architecture question: What is the rule-of-thumb to use use multiple databases, rather than