------------------------------------------------------
|
mysql> use AUDIT
|
Database changed
|
mysql> CREATE TABLE audit_trail(
|
-> `timestamp` VARCHAR(255),
|
-> `serverhost` VARCHAR(255),
|
-> `username` VARCHAR(255),
|
-> `host` VARCHAR(255),
|
-> `connectionid` VARCHAR(255),
|
-> `queryid` VARCHAR(255),
|
-> `operation` VARCHAR(255),
|
-> `database` VARCHAR(255),
|
-> `object` VARCHAR(255),
|
-> `retcode` VARCHAR(255))
|
-> engine=CONNECT table_type=CSV file_name='/usr/local/mysql2/mariadb-audit.log'
|
-> sep_char=',' quoted=1;
|
ERROR 1286 (42000): Unknown storage engine 'CONNECT'
|
mysql>
|
|
mysql> show plugins;
|
+-------------------------------+----------+--------------------+-----------------+---------+
|
| Name | Status | Type | Library | License |
|
+-------------------------------+----------+--------------------+-----------------+---------+
|
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |
|
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL |
|
...
|
..
|
..
|
| SEQUENCE | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| user_variables | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| FEEDBACK | DISABLED | INFORMATION SCHEMA | NULL | GPL |
|
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| SERVER_AUDIT | ACTIVE | AUDIT | server_audit.so | GPL |
|
| CONNECT | ACTIVE | STORAGE ENGINE | ha_connect.so | GPL |
|
+-------------------------------+----------+--------------------+-----------------+---------+
|
54 rows in set (0.00 sec)
|
|
mysql>
|
|
mysql> show engines;
|
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
|
| Engine | Support | Comment | Transactions | XA | Savepoints |
|
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
|
| CSV | YES | CSV storage engine | NO | NO | NO |
|
| MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
|
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
|
| SEQUENCE | YES | Generated tables filled with sequential values | YES | NO | YES |
|
| CONNECT | YES | Management of External Data (SQL/NOSQL/MED), including many file formats | NO | NO | NO |
|
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
|
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
|
| Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO |
|
| InnoDB | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES | YES | YES |
|
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
|
9 rows in set (0.00 sec)
|
|
mysql>
|
------------------------------------------------------
|
|