View Single Post
Old 01-05-2008, 07:13 PM   #23 (permalink)
Village Idiot
Wizard
Top Contributor 
 
Village Idiot's Avatar
 
Join Date: Sep 2007
Posts: 1,299
Thanks: 17
Village Idiot is on a distinguished road
Default

Quote:
Originally Posted by Aaron View Post
What is this engine=myisam?
Short version: Internal stuff, complicated. Just use myisam
Long version: The engine is how the database internally stores things. Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An .frm file stores the table format. The data file has an .MYD (MYData) extension. The index file has an .MYI (MYIndex) extension. For more on the engines, go here MySQL AB :: MySQL 5.0 Reference Manual :: 12 Storage Engines
__________________

Village Idiot is offline  
Reply With Quote
The Following User Says Thank You to Village Idiot For This Useful Post:
Aaron (01-05-2008)