1.XTRADB and InnoDB are a good storage engine for common things. XTRADB and InnoDB are often the best choice when deciding which storage engine to use.
2.MyISAM and Aria, small footprint, easy to replicate between systems. MyISAM is the oldest storage engine in MySQL, and Aria is the mariadb for better improvement.
3.TokuDB is an optimized storage engine for things that are not suitable for memory loads and provides good compression ratios.
4.MEMORY facilitates temporary workspaces.
5.Archive archiving.
6.Cassandra is a nosql engine.
7.CONNECT allows access to different types of text files and remote resources.
8.SphinxSE runs the statement on the remote server as an agent (useful for full-text search).
9.Spider uses partitions to provide data segmentation over multiple servers.
10.ScaleDB is a commercial storage engine for large-scale online transaction processing and data warehousing.
MARIADB quickly select the storage engine that best suits your needs