Is there an Advanced MySQL Manual?

[BNPMike]

I'm interested in documentation that shows how MYSQL works - the formats of tablespaces, the formats of indexes, how it develops access plans etc etc - the sort of thing you need if you are a DBA and want to design databases optimally and tune existing queries.

On Amazon.co.uk all the MySQL books seem to be introductory. Has no-one written a professional book yet?

 

[sleipnir214]

Have you read the pertinent sections of the online MySQL manual?

http://www.mysql.com/doc/en/Table_types.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[rzs0502]

There are quite a few.
SAMS Teach Yourself MySQL In 21 Days
I have the pdf version (2.6MB zipped)

 

[jjjamie]

That hardly sounds like an advanced book!

 

[BNPMike]

I'll illustrate what I mean.

I would expect MySQL uses pages (but what size? Can you control the size?) When a page is 'active' there will be pointers to eg the next page and to the begining of the deleted list for that page.

So your application deletes a record on that page (assume this page had been loaded in the middle of a tablespace and was full). You then do an insert. Does MySQL
a) read the deleted list from the first page in the tablespace.
b) always insert at the end of the tablespace
c) first look at the deleted list on the page it is on and if there are no deletions go to the next page? or to the end of the table space?

Here's another one: Does MySQL have tablespaces all of one tabletype or does it mix tables? DB2 as I recall gives you a choice of either.

You need to know this if you want to design, manage and tune databases in a professional manner.

Where do you get this sort of detailed mechanics without reading code?

 

[rzs0502]

Have to read this manual?

http://sunsite.informatik.rwth-aachen.de/mysql/Downloads/Manual/manual-a4.pdf