MySQL Inner Workings

[samlutley]

How does MySQL store information?
I know that it stores information in files, but what are some of the specifics?

Flat file structure?
Naming scheme?
Default Location?

If I had 2 databases, each containing 2 tables, how would MySQL store that information?


Thanks,
Sam

[mitchind]

Try Googling

[satis]

http://dev.mysql.com/doc/refman/4.1/en/index.html

[samlutley]

Oh. Wow. Googling. Really?

[samlutley]

Thanks for the link to the MySQL user's manual. I've looked at that. Not saying the information isn't in there, but I couldn't find an answer to my question. I think we all know to first start with an internet search and then look at the user's manual.
Anyone have an actual answer?

Thanks

[mitchind]

Thanks for the link to the MySQL user's manual. I've looked at that. Not saying the information isn't in there, but I couldn't find an answer to my question. I think we all know to first start with an internet search and then look at the user's manual.
Anyone have an actual answer?

Thanks
We'd get the answer the same way you should. Satis gave you the start - try typing in "storage" at the Mysql search input box. You'd be amazed at what it turns up.

[mprovost]

MySQL defaults to storing tables in the MyISAM format. That's what you'll be using here at Powweb. You can get more details about the format here:
http://dev.mysql.com/doc/refman/4.1/en/myisam-storage-engine.html