MySQL

The BLACKHOLE Storage Engine

The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. Retrievals always return an empty result:

mysql> CREATE TABLE test(i INT, c CHAR(10)) ENGINE = BLACKHOLE;

Query OK, 0 rows affected (0.03 sec)

 

mysql> INSERT INTO test VALUES(1,’record one’),(2,’record two’);

Query OK, 2 rows affected (0.00 sec)

Records: 2  Duplicates: 0  Warnings: 0

 

mysql> SELECT * FROM test;

Empty set (0.00 sec).

Tagged ,

About Jit

Having expertise in dynamic and interactive web applications design and development looking for a challenging position in LAMP (Linux, Apache, MySQL and PHP) environment and MySQL DBA.In depth Knowledge and experience of client/server technologies, internet/intranet based programming techniques, MVC Architecture server management and object-oriented approaches, user centered design approach.Expertise in Provides Business Solutions, Project Documentations, Architecture, Design, Functional Documentation
View all posts by Jit →

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.