【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
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值