Advertisement: Over 100,000 Jobs Worldwide. Click here to find one for you.

MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
Send This Page to Friend
Enter Friend's Email
Enter Your Email
http://www.kareerlinks.com/jobs/skill/MySQL
 

Blackhole Storage Engine / Table Type in MySQL

Blackhole is available as of MySQL version 4.1.11. The BLACKHOLE storage engine operates just like the MyISAM engine except that it won't store any data. You might use this engine to gauge the overhead incurred by logging, because it's still possible to log the queries even though data will not be stored

The BLACKHOLE storage engine isn’t enabled by default, meaning you need to include the option --with-blackhole-storage-engine at configuration time to use it.

Blackhole Engine Related FAQs