232 Part II . SQL Essentials (Web hosting solutions) Tip All
232 Part II . SQL Essentials Tip All MySQL table types store data but there s usually a best type for any application. This section examines the table types supported in MySQL. With a solid understanding of the available table types, you re better equipped to choose the correct table type for your application. MySQL table types The six types of MySQL tables are best considered as three groups for the sake of compatibility: . Non-transactional tables. For many applications, non-transactional table types will be sufficient and will use fewer resources than transactional tables. For example, an online catalog, customer database, application database, and many other applications can utilize non-transactional tables successfully. The default table type in MySQL is the non-transactional MyISAM type. MyISAM is the table type of choice for nearly all applications. The three non-transactional table types are ISAM HEAP The HEAPtype is stored in volatile memory. If you are using a HEAPtable type and MySQL crashes or is shut down, all data in the table is lost! However, the HEAP table type is fast, making it a good choice for temporary tables. MyISAM Based on the ISAMtable type, MyISAMis the default for MySQL. . MERGE tables. The MERGE table type is a special extension of the MyISAM table. . Transaction-safe (transactional) tables. Transactional tables can combine statements and then commit or roll them back if some fail. Transactional tables are much safer in the event of MySQL or system crashes. These two table types are InnoDB BerkeleyDB The table types you can use depend on the version of MySQL installed on your server. Some table types weren t available in earlier versions of MySQL. Further, the tables available follow these general rules: . If you compiled MySQL from source code, you had the option to choose table types during the compilation process.
If you are looking for cheap and quality webhost to host and run your website check Jboss Web Hosting services.