Practical MySQL tips and literature for more advanced use?

Question

This is yet another MySQL literature question. I asked for some MySQL / DBA literature earlier that day, but most of the suggestions were beginners guides that were more or less like a commented documentation with examples. Of course I can still learn a lot from these books / tutorials, too - but it´s NOT what I ask for here.

Rather I´d like to collect some advice for practical use – questions like "How to handle periodical imports of multiple csv files into an existing database (with foreign key constraints etc.)" should be covered in the literature I am looking for.

I am not sure where to search because most stuff i found is the typical beginners guide.

Thx for any suggestions – maybe it be printed or online…

Answer 1

Rather I´d like to collect some advice for practical use – questions like "How to handle periodical imports of multiple csv files into an existing database (with foreign key constraints etc.)" should be covered in the literature I am looking for.

I'd say ask stuff like this here (or refer to the various questions in the field that already exist) - this is what SO is there for, and IMO is better suited than a book.

The scenarios and platforms surrounding things like CSV imports, backups, frequent maintenance.... are often so varied that I can't see a book giving solid advice here, when it often takes the creativity of several people to come up with a good solution.

I'll be happy to be proven wrong though!

Answer 2

The MySQL cookbook is pretty helpful for stuff like this.

http://oreilly.com/catalog/9780596001452

I also have a few helpful hints on my own site regarding replication and obscure optimizations.

http://chr.ishenry.com/category/mysql/

Answer 3

For admin / performance: High Performance MySQL: http://oreilly.com/catalog/9780596003067