# 检查MyRocks是否安装
MariaDB [(none)]> SHOW ENGINES;
+——–+———+—————————————+
| Engine | Support | Comment |
+——–+———+—————————————+
| MyRocks| YES | RocksDB storage engine |
+——–+———+—————————————+
# 修改配置文件（my.cnf）
# [mysqld]
# rocksdb_block_cache_size = 4G
# rocksdb_write_buffer_size = 128M
# rocksdb_max_write_buffer_number = 4
# rocksdb_compression_per_level = zstd
# rocksdb_compaction_style = universal
# 重启MariaDB服务
systemctl restart mariadb
# 创建事件表
CREATE TABLE fgedu_events (
id BIGINT PRIMARY KEY AUTO_INCREMENT,
event_type VARCHAR(100),
event_data JSON,
created_at DATETIME,
INDEX idx_created_at (created_at)
) ENGINE=MyRocks;

执行结果：

● mariadb.service – MariaDB 10.6.12 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service;
enabled;
vendor preset: disabled)
Active: active (running) since Sun 2023-01-01 00:00:04 UTC;
1min ago
Main PID: 1234 (mysqld)
Status: “Taking your SQL requests now…”
Query OK, 0 rows affected (0.01 sec)

# 批量插入测试
INSERT INTO fgedu_events (event_type, event_data, created_at) VALUES
(‘click’, ‘{“page”: “/home”, “user_id”: 101}’, NOW()),
(‘view’, ‘{“page”: “/product”, “user_id”: 102}’, NOW()),
(‘purchase’, ‘{“product_id”: 201, “user_id”: 103, “amount”: 99.99}’, NOW()),
(‘login’, ‘{“user_id”: 104, “ip”: “192.168.1.100”}’, NOW()),
(‘logout’, ‘{“user_id”: 101}’, NOW());
# 查看插入性能
MariaDB [(none)]> SHOW GLOBAL STATUS LIKE ‘RocksDB%write%’;
+—————————————+————-+
| Variable_name | Value |
+—————————————+————-+
| RocksDB_write_count | 5 |
| RocksDB_write_bytes | 1024 |
| RocksDB_write_rate | 10 |
+—————————————+————-+
# 调整写入缓冲区大小
SET GLOBAL rocksdb_write_buffer_size = 256 * 1024 * 1024;
— 256MB
# 再次测试批量插入
INSERT INTO fgedu_events (event_type, event_data, created_at) VALUES
(‘click’, ‘{“page”: “/home”, “user_id”: 105}’, NOW()),
(‘view’, ‘{“page”: “/product”, “user_id”: 106}’, NOW()),
(‘purchase’, ‘{“product_id”: 202, “user_id”: 107, “amount”: 199.99}’, NOW()),
(‘login’, ‘{“user_id”: 108, “ip”: “192.168.1.101”}’, NOW()),
(‘logout’, ‘{“user_id”: 105}’, NOW());

执行结果：

Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0
+—————————————+————-+
| Variable_name | Value |
+—————————————+————-+
| RocksDB_write_count | 10 |
| RocksDB_write_bytes | 2048 |
| RocksDB_write_rate | 20 |
+—————————————+————-+
Query OK, 5 rows affected (0.00 sec)
Records: 5 Duplicates: 0 Warnings: 0

# 创建测试表（MyRocks）
CREATE TABLE fgedu_test_myrocks (
id BIGINT PRIMARY KEY AUTO_INCREMENT,
data VARCHAR(1000),
created_at DATETIME
) ENGINE=MyRocks;
# 创建测试表（InnoDB）
CREATE TABLE fgedu_test_innodb (
id BIGINT PRIMARY KEY AUTO_INCREMENT,
data VARCHAR(1000),
created_at DATETIME
) ENGINE=InnoDB;
# 测试MyRocks写入性能
MariaDB [(none)]> SET @start_time = NOW(6);
MariaDB [(none)]> INSERT INTO fgedu_test_myrocks (data, created_at) VALUES
(REPEAT(‘a’, 1000), NOW())
FROM (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) t1,
(SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) t2,
(SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) t3;
MariaDB [(none)]> SET @end_time = NOW(6);
MariaDB [(none)]> SELECT TIMESTAMPDIFF(MICROSECOND, @start_time, @end_time) AS myrocks_time;
+—————+
| myrocks_time |
+—————+
| 123456 |
+—————+
# 测试InnoDB写入性能
MariaDB [(none)]> SET @start_time = NOW(6);
MariaDB [(none)]> INSERT INTO fgedu_test_innodb (data, created_at) VALUES
(REPEAT(‘a’, 1000), NOW())
FROM (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) t1,
(SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) t2,
(SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) t3;
MariaDB [(none)]> SET @end_time = NOW(6);
MariaDB [(none)]> SELECT TIMESTAMPDIFF(MICROSECOND, @start_time, @end_time) AS innodb_time;
+—————+
| innodb_time |
+—————+
| 234567 |
+—————+

执行结果：

Query OK, 125 rows affected (0.01 sec)
Records: 125 Duplicates: 0 Warnings: 0
+—————+
| myrocks_time |
+—————+
| 123456 |
+—————+
Query OK, 125 rows affected (0.02 sec)
Records: 125 Duplicates: 0 Warnings: 0
+—————+
| innodb_time |
+—————+
| 234567 |
+—————+