Test server configuration: Dell R730; 24 cores; 64G memory; ssd disk. Centos version: 6.4; MySQL version: Community 5.6.12; Test database size: 24G. sysbench parameters: 64 threads, 10 tables, each table is pre-initialized with 10 million data, read and write mixed OLTP mode. Running on the same machine as mysql. Test duration: 5 minutes/scenario. Plug-in OLTP test statistics: not installed queries performed: read: 15377012 write: 4393432 other: 2196716 total: 21967160 transactions: 1098358 (3661.01 per sec.) read/write reque
1. MySQL audit plug-in test (mcafee and mariadb version) detailed introduction
Introduction: Centos version: 6.4; MySQL version: Community 5.6.12; Test database size: 24G. sysbench parameters: 64 threads, 10 tables, each table is pre-initialized with 10 million data, read and write mixed OLTP mode. Running on the same machine as mysql.
2. MySQL audit plug-in installation and use instructions document--upgraded version
Introduction: Based on previous design and development The content of the mysql audit plug-in and the "MySQL Audit Plug-in Installation and Use Instructions Document" are introduced to supplement and explain the improved mysql audit plug-in.
##Introduction: --- Create a new directory to save the audit log mkdir / usr/local/mysql/mysql_logs/auditlogchown mysql:mysql /usr/local/mysql/mysql_logs/auditlog/--2. Install the audit plug-in SHOW GLOBAL VARIABLES LIKE plugin_dir;INSTALL PLUGIN server_audit SONAME server_audit.so;SELECT * fro
4. MySQL audit plug-in performance test comparison_MySQL
##Introduction: MySQL audit plug-in performance test comparisonThe above is the detailed content of Content recommendations for audit plug-ins. For more information, please follow other related articles on the PHP Chinese website!