【YashanDB知识库】YFS_修改AU_SIZE参数

本文内容来自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