# 检查编译结果
[root@fgedu.net.cn ~]# ls -la /usr/local/mariadb/
total 48
drwxr-xr-x 13 root root 4096 Apr 7 12:00 .
drwxr-xr-x. 1 root root 4096 Apr 7 11:30 ..
drwxr-xr-x 2 root root 4096 Apr 7 12:00 bin
drwxr-xr-x 3 root root 4096 Apr 7 12:00 docs
drwxr-xr-x 3 root root 4096 Apr 7 12:00 include
drwxr-xr-x 4 root root 4096 Apr 7 12:00 lib
drwxr-xr-x 4 root root 4096 Apr 7 12:00 man
drwxr-xr-x 10 root root 4096 Apr 7 12:00 mysql-test
drwxr-xr-x 2 root root 4096 Apr 7 12:00 scripts
drwxr-xr-x 28 root root 4096 Apr 7 12:00 share
drwxr-xr-x 4 root root 4096 Apr 7 12:00 sql-bench
drwxr-xr-x 3 root root 4096 Apr 7 12:00 support-files
# 检查服务状态
[root@fgedu.net.cn ~]# systemctl status mariadb
● mariadb.service – MariaDB 10.11.8 database server
Loaded: loaded (/etc/systemd/system/mariadb.service;
enabled;
vendor preset: disabled)
Active: active (running) since Mon 2026-04-07 12:10:00 CST;
5min ago
Main PID: 3456 (mysqld)
Status: “Taking your SQL requests now…”
Tasks: 35 (limit: 32768)
Memory: 1.5G
CPU: 3.2s
CGroup: /system.slice/mariadb.service
└─3456 /usr/local/mariadb/bin/mysqld –defaults-file=/etc/my.cnf
Apr 07 12:10:00 fgedu.net.cn systemd[1]: Started MariaDB 10.11.8 database server.

# 连接MariaDB
[root@fgedu.net.cn ~]# /usr/local/mariadb/bin/mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with;
or \g.
Your MariaDB connection id is 8
Server version: 10.11.8-MariaDB Source distribution
# 查看参数配置
MariaDB [(none)]> SHOW VARIABLES LIKE ‘innodb_buffer_pool_size’;
+————————-+————+
| Variable_name | Value |
+————————-+————+
| innodb_buffer_pool_size | 8589934592 |
+————————-+————+
1 row in set (0.00 sec)
MariaDB [(none)]> SHOW VARIABLES LIKE ‘max_connections’;
+—————–+——-+
| Variable_name | Value |
+—————–+——-+
| max_connections | 2000 |
+—————–+——-+
1 row in set (0.00 sec)
# 查看状态
MariaDB [(none)]> SHOW GLOBAL STATUS LIKE ‘Innodb_buffer_pool_%’;
+—————————————+————-+
| Variable_name | Value |
+—————————————+————-+
| Innodb_buffer_pool_dump_status | not started |
| Innodb_buffer_pool_load_status | not started |
| Innodb_buffer_pool_resize_status | not started |
| Innodb_buffer_pool_pages_data | 262144 |
| Innodb_buffer_pool_bytes_data | 4294967296 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 262144 |
| Innodb_buffer_pool_pages_misc | 0 |
| Innodb_buffer_pool_pages_total | 524288 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 0 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 12345 |
| Innodb_buffer_pool_reads | 123 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 6789 |
+—————————————+————-+
18 rows in set (0.01 sec)

# 创建测试数据库
MariaDB [(none)]> CREATE DATABASE fgedudb;
Query OK, 1 row affected (0.00 sec)
MariaDB [(none)]> USE fgedudb;
Database changed
# 创建测试表
MariaDB [fgedudb]> CREATE TABLE fgedu_test (
-> id INT PRIMARY KEY AUTO_INCREMENT,
-> name VARCHAR(100),
-> value INT,
-> created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
-> ) ENGINE=InnoDB;
Query OK, 0 rows affected (0.01 sec)
# 插入测试数据
MariaDB [fgedudb]> DELIMITER //
MariaDB [fgedudb]> CREATE PROCEDURE insert_large_data()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i <= 200000 DO
INSERT INTO fgedu_test (name, value) VALUES (CONCAT(‘test_’, i), i);
SET i = i + 1;
END WHILE;
END //
MariaDB [fgedudb]> DELIMITER;
MariaDB [fgedudb]> CALL insert_large_data();
Query OK, 1 row affected (8.45 sec)
# 测试查询性能
MariaDB [fgedudb]> EXPLAIN SELECT * FROM fgedu_test WHERE id BETWEEN 100000 AND 100100;
+——+————-+———–+——-+—————+———+———+——+——+————-+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+——+————-+———–+——-+—————+———+———+——+——+————-+
| 1 | SIMPLE | fgedu_test | range | PRIMARY | PRIMARY | 4 | NULL | 101 | Using where |
+——+————-+———–+——-+—————+———+———+——+——+————-+
1 row in set (0.00 sec)
MariaDB [fgedudb]> SELECT COUNT(*) FROM fgedu_test;
+———-+
| COUNT(*) |
+———-+
| 200000 |
+———-+
1 row in set (0.04 sec)