本文内容来自YashanDB官网,原文内容请见 https://www.yashandb.com/newsinfo/7080871.html?templateId=1718516
基本信息
场景:YAC数据库已经创建完毕,需要修改DG0的AU_SIZE,提高创建数据文件性能。
DG0的AU_SIZE只能通过重建数据库来修改。本文说明修改方法。
源库版本:YashanDB 企业版 23.2.1.100
基本信息查询:
默认AU_SIZE是1M。
[yac@localhost ~]$ yasql / as sysdba
YashanDB SQL Enterprise Edition Release 23.2.1.100 aarch64
SQL> select * from V$YFS_DISKGROUP
2 ;
ID NAME AU_SIZE BLOCK_SIZE REDUNDANCY STATE TOTAL_MB FREE_MB USABLE_FILE_MB
------------ ---------------------------------------------------------------- ------------ ------------ ---------------------------------------------------------------- ---------------------------------------------------------------- --------------------- --------------------- ---------------------
0 DG0 1048576 4096 EXTERNAL MOUNTED 307200 289752 289752
1 row fetched.
SQL> exit
修改AU_SIZE
备份
[yac@localhost backup]$ yasrman / -c 'create catalog' -D /home/yac/backup/catalog
create catalog successfully
[yac@localhost backup]$ yasrman / -c 'show all'
+---------------------------+-----------+----------------+
| NAME | DEFAULT | VALUE |
+---------------------------+-----------+----------------+
| PARALLELISM | 2 | 2 |
| SECTION SIZE | 134217728 | 134217728 |
| COMPRESSION ALGORITHM | NONE | NONE |
| COMPRESSION LEVEL | LOW | LOW |
| DEST | SERVER | SERVER |
+---------------------------+-----------+----------------+
[yac@localhost backup]$ yasrman / -c 'configure PARALLELISM 8' -D /home/yac/backup/catalog
configure successfully
[yac@localhost backup]$ yasrman / -c 'configure COMPRESSION ALGORITHM zstd' -D /home/yac/backup/catalog
configure successfully
[yac@localhost backup]$ yasrman / -c 'show all' -D /home/yac/backup/catalog
+---------------------------+-----------+----------------+
| NAME | DEFAULT | VALUE |
+---------------------------+-----------+----------------+
| PARALLELISM | 2 | 8 |
| SECTION SIZE | 134217728 | 134217728 |
| COMPRESSION ALGORITHM | NONE | ZSTD |
| COMPRESSION LEVEL | LOW | LOW |
| DEST | SERVER | SERVER |
+---------------------------+-----------+----------------+
[yac