# 使用阿里云CLI创建PolarDB MySQL版实例
$ aliyun polardb CreateDBCluster \
–DBClusterDescription “fgedu-production-cluster” \
–Engine “MySQL” \
–EngineVersion “8.0” \
–DBNodeClass “polar.mysql.x4.large” \
–DBClusterNetworkType “VPC” \
–VPCId “vpc-12345678” \
–VSwitchId “vsw-12345678” \
–ZoneId “cn-hangzhou-a” \
–MasterUsername “fgedu” \
–MasterPassword “Fgedu123!”

# 查看实例状态
$ aliyun polardb DescribeDBClusters \
–DBClusterId “pc-12345678”
{
“DBClusters”: [
{
“DBClusterId”: “pc-12345678”,
“DBClusterDescription”: “fgedu-production-cluster”,
“Engine”: “MySQL”,
“EngineVersion”: “8.0”,
“DBNodeClass”: “polar.mysql.x4.large”,
“Status”: “Running”,
“CreateTime”: “2026-03-31T10:00:00Z”,
“EndTime”: “”,
“DBClusterNetworkType”: “VPC”,
“VPCId”: “vpc-12345678”,
“VSwitchId”: “vsw-12345678”,
“ZoneId”: “cn-hangzhou-a”,
“PayType”: “PostPaid”,
“DBNodeCount”: 1,
“MasterUsername”: “fgedu”,
“Port”: “3306”,
“ConnectionString”: “pc-12345678.mysql.polardb.rds.aliyuncs.com”
}
],
“RequestId”: “12345678-1234-1234-1234-1234567890ab”
}

# 连接PolarDB实例
$ mysql -u fgedu -p -h pc-12345678.mysql.polardb.rds.aliyuncs.com -P 3306
Enter password:

# 创建数据库
mysql> create database fgedudb character set utf8mb4 collate utf8mb4_unicode_ci;
Query OK, 1 row affected (0.01 sec)

# 创建用户
mysql> create user ‘fgedu_app’@’%’ identified by ‘Fgedu123!’;
mysql> create user ‘fgedu_read’@’%’ identified by ‘Fgedu123!’;

# 授予权限
mysql> grant all privileges on fgedudb.* to ‘fgedu_app’@’%’;
mysql> grant select on fgedudb.* to ‘fgedu_read’@’%’;

# 刷新权限
mysql> flush privileges;

# 创建表结构
mysql> use fgedudb;
mysql> create table tb_user (
-> id bigint primary key auto_increment,
-> name varchar(50) not null,
-> age int,
-> create_time datetime default current_timestamp
-> ) engine=InnoDB default charset=utf8mb4;

# 插入测试数据
mysql> insert into tb_user (name, age) values (‘test1’, 20), (‘test2’, 25), (‘test3’, 30);
Query OK, 3 rows affected (0.01 sec)
Records: 3 Duplicates: 0 Warnings: 0

# 验证数据
mysql> select * from tb_user;
+—-+——-+—–+———————+
| id | name | age | create_time |
+—-+——-+—–+———————+
| 1 | test1 | 20 | 2026-03-31 10:00:00 |
| 2 | test2 | 25 | 2026-03-31 10:00:00 |
| 3 | test3 | 30 | 2026-03-31 10:00:00 |
+—-+——-+—–+———————+

# 登录PolarDB实例
$ mysql -u fgedu -p -h pc-12345678.mysql.polardb.rds.aliyuncs.com -P 3306
Enter password:

# 查看当前参数配置
mysql> show variables like ‘innodb_buffer_pool_size’;
+————————-+———+
| Variable_name | Value |
+————————-+———+
| innodb_buffer_pool_size | 8388608 |
+————————-+———+

# 修改内存参数
mysql> set global innodb_buffer_pool_size = 8589934592;
Query OK, 0 rows affected (0.00 sec)

# 修改连接参数
mysql> set global max_connections = 2000;
Query OK, 0 rows affected (0.00 sec)

# 修改存储参数
mysql> set global innodb_io_capacity = 2000;
Query OK, 0 rows affected (0.00 sec)

# 创建索引
mysql> create index idx_name on tb_user(name);
Query OK, 0 rows affected (0.01 sec)

# 优化查询
mysql> explain select * from tb_user where name = ‘test1’;
+—-+————-+———+————+——+—————+———+———+——-+——+———-+——-+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+—-+————-+———+————+——+—————+———+———+——-+——+———-+——-+
| 1 | SIMPLE | tb_user | NULL | ref | idx_name | idx_name | 202 | const | 1 | 100.00 | NULL |
+—-+————-+———+————+——+—————+———+———+——-+——+———-+——-+