What is the purpose of MySQL’s BLACKHOLE Engine?
It is useful in a replicated environment where all SQL statements are run on all nodes, but you only want some nodes to actually store the result. This is a use case given in the documentation: http://dev.mysql.com/doc/refman/5.0/en/blackhole-storage-engine.html Other uses given in the documentation include: Verification of dump file syntax. Measurement of the overhead from binary … Read more