Under The Hood
Current Default MySQL Engine
InnoDB
Version that introduces MySQL InnoDB plugin
5.1
Utility for importing CSV data from the command line
mysqlimport
Max number of columns in an InnoDB table
1017
MySQL Enterprise feature used to track user activity
Audit
Original Non-Transactional MySQL Engine
MyISAM
MySQL version in which Replication was introduced
3.23
Improved utility for MySQL 5.7+ to be able to import data in parallel
mysqlpump
Max index length for default-sized InnoDB table
3072
MySQL Enterprise feature to protect data at rest
Enterprise Encryption
High Performance, non-Clustered Engine
Memory
MySQL Version in which full text search was available in the InnoDB engine
5.6
Useful utility if trying to view replication information
mysqlbinlog
512GB
Extra layer of protection to guard against malicious attacks
Enterprise Firewall
Engine you use when you want data to dissappear
Blackhole
MySQL version in which client / server communication was encrypted by default
5.7
Server variable used to disable TCP/IP connections to the server
skip_networking
Maximun default tablespace size for InnoDB
64TB
Feature to hide sensitive information by replacing real values with substitutes
Data Masking and De-Identification
Dual Server engine that sounds Governmental
Federated
MySQL version in which you could quickly 'clone' a server into another
8.0.17
Efficient server-side mechanism that takes advantage of the binary protocol
Prepared Statements
Max number of columns permitted for a multicolumn index
16
Feature that provides an alternative thread-handling model to reduce server overhead and improve performance
Thread Pool