【YashanDB知识库】YFS_修改AU_SIZE参数
1.【YashanDB知识库】yasql执行报错2.【YashanDB知识库】YCM Monit进程频繁误告警3.【YashanDB知识库】ycm托管主机报错libnsl.so.1 no such file or directory4.【YashanDB知识库】安装共享集群时报错:YAS-05721 invalid input parameter, reason: node name invalid5.【YashanDB知识库】调用外部UDF未能识别Java环境配置6.【YashanDB知识库】个别数据库用户无法登录数据库,报错 io fail:IO.EOF7.【YashanDB知识库】过期统计信息导致SQL执行计划变差8.【YashanDB知识库】隐藏参数怎么查看初始值9.【YashanDB知识库】原生mysql驱动配置连接崖山数据库10.【YashanDB知识库】yashandb升级后,yasboot restart出现版本回退、报错control file version incompatible11.【YashanDB知识库】解压安装包时报错"tar:Error is not recoverable"12.【YashanDB知识库】如何使用MySQL客户端链接YashanDB13.【YashanDB知识库】YashanDB 单机一主一备自动切换14.【YashanDB知识库】YashanDB到YashanDB手工元数据迁移
15.【YashanDB知识库】YFS_修改AU_SIZE参数
16.【YashanDB知识库】YashanDB备份恢复的两种渠道17.【YashanDB知识库】YashanDB获取统计信息18.【YashanDB知识库】关于表空间压缩19.【YashanDB知识库】如何更改自动统计信息收集任务20.【YashanDB知识库】如何利用数据库线程池稳定TP吞吐21.【YashanDB知识库】为什么YashanDB只有Geometry类型,没有Geogrephy类型22.【YashanDB知识库】用crontab实现YashanDB自动备份23.【YashanDB知识库】YashanDB与Oracle数据类型对齐24.【YashanDB知识库】多csv文件一键式导入yashandb25.【YashanDB知识库】手工迁移Doris数据到崖山分布式26.【YashanDB知识库】锁冲突检查27.【YashanDB知识库】重装新库及元数据和数据导出导入指导28.【YashanDB知识库】Mybatis-Plus适配崖山配置29.【YashanDB知识库】WAS配置YashanDB JDBC连接30.【YashanDB知识库】YashanDB安全设置示例31.【YashanDB知识库】YashanDB查询时间与实际时间默认少8小时32.【YashanDB知识库】Yasldr错误处理33.【YashanDB知识库】YCM和YMP密码重置34.【YashanDB知识库】YCM数据库托管遇到的问题35.【YashanDB知识库】备库扩缩容指导36.【YashanDB知识库】非YCM方式的自动备份方案示例37.【YashanDB知识库】归档日志清理38.【YashanDB知识库】私有maven使用崖山JDBC驱动39.【YashanDB知识库】通过导入导出修改用户名称40.【YashanDB知识库】字符集latin1的MySQL中文数据如何迁移到YashanDB41.【YashanDB知识库】透明故障转移配置指导42.【YashanDB知识库】MySQL的FIND_IN_SET如何在YashanDB改写43.【YashanDB知识库】对比Oracle和YashanDB对象不一致的方法44.【YashanDB知识库】MySQL的FROM_UNIXTIME和UNIX_TIMESTAMP如何在YashanDB改写45.【YashanDB知识库】YMP从oracle到yashan迁移评估报OCI相关错误46.【YashanDB 知识库】如何避免 yasdb 进程被 Linux OOM Killer 杀掉47.【YashanDB 知识库】DolphinScheduler 适配崖山 Python 驱动48.【YashanDB知识库】Flink CDC实时同步Oracle数据到崖山49.【YashanDB知识库】Kettle迁移MySQL到YashanDB50.【YashanDB知识库】Kettle迁移PostgreSQL到YashanDB51.【YashanDB知识库】MySQL返回结果集的存储过程的改写方法52.【YashanDB知识库】沙箱备库53.【YashanDB知识库】DataX迁移Hive到崖山分布式54.【YashanDB知识库】Springboot启动找不到崖山jdbc驱动的问题处理55.【YashanDB知识库】分布式LSC表修改字段56.【YashanDB知识库】扩展redo大小57.【YashanDB知识库】共享超过32000字节字符串插入CLOB类型方案58.【YashanDB知识库】共享利用Python脚本解决Oracle的SQL脚本@@用法59.【YashanDB知识库】数据库升级后用yasboot在线扩充备节点出现报错60.【YashanDB知识库】共享从 MySQL异常处理CONTINUE HANDLER的改写方法61.【YashanDB知识库】服务器重启后启动yasom和yasagent进程时有告警62.【YashanDB知识库】MySQL field 函数的改写方法63.【YashanDB知识库】MySQL和YashanDB 隐式转换不一致引起的报错64.【YashanDB知识库】YashanDB 支持MySQL多表更新语句的解决方法65.【YashanDB知识库】从PostgreSQL迁移到YashanDB如何进行数据行数比对66.【YashanDB知识库】使用DataX工具迁移yashan数据到maxcompute67.【YashanDB知识库】如何从内存中获取SQL语句的执行计划68.两个案例带你看懂YashanDB执行计划69.YashanDB物理规格70.YashanDB逻辑规格71.YashanDB数据类型规格72.YashanDB与Oracle兼容性说明73.YashanDB个人版、标准版和企业版功能差异74.YashanDB体系架构75.YashanDB存储引擎76.YashanDB SQL引擎77.YashanDB PL引擎78.YashanDB主备高可用79.YashanDB共享集群80.YashanDB实例架构81.YashanDB数据库实例82.YashanDB内存体系83.YashanDB进程线程体系本文内容来自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@localhost backup]$ yasrman sys/Cod-2022 -c "backup database tag 'full_1' format '/home/yac/backup/full_bak_1'" -D /home/yac/backup/catalog
backup successfully
[yac@localhost full_bak_1]$ pwd
/home/yac/backup/full_bak_1
[yac@localhost full_bak_1]$ ll
total 19632
-rw-r----- 1 yac yac 5632 Apr 9 18:43 backup_filelist
-rw-r----- 1 yac yac 16777216 Apr 9 18:43 backup_profile
-rw-r----- 1 yac yac 5120 Apr 9 18:43 ctrl_0_0_0.bak
-rw-r----- 1 yac yac 1318400 Apr 9 18:43 data_0_0_0.bak
-rw-r----- 1 yac yac 208384 Apr 9 18:43 data_1_0_0.bak
-rw-r----- 1 yac yac 512 Apr 9 18:43 data_2_0_0.bak
-rw-r----- 1 yac yac 512 Apr 9 18:43 data_3_0_0.bak
-rw-r----- 1 yac yac 167424 Apr 9 18:43 data_4_0_0.bak
-rw-r----- 1 yac yac 1158144 Apr 9 18:43 data_5_0_0.bak
-rw-r----- 1 yac yac 230400 Apr 9 18:43 data_6_0_0.bak
-rw-r----- 1 yac yac 93696 Apr 9 18:43 redo0_0_2_0.bak
-rw-r----- 1 yac yac 117760 Apr 9 18:43 redo1_0_1_0.bak
[yac@localhost full_bak_1]$
删除数据库
[yac@localhost full_bak_1]$ yasboot cluster clean --purge -c yashandb -d
Are you sure you want to CLEAN cluster: [yashandb], AND ALL DATA WILL BE DELETED (-p/--purge is given)?
[yes/no]: yes
type | uuid | name | hostid | index | status | return_code | progress | cost
-----------------------------------------------------------------------------------------------------------------------
task | 794bab4eb2b31232 | CleanYasdbCluster | - | yashandb | SUCCESS | 0 | 100 | 1
-------+------------------+-------------------+----------+-------------------+---------+-------------+----------+------
child | 49fb78339719543e | CleanYasdbNode | host0001 | yashandb.host0001 | SUCCESS | 0 | 100 | 1
+------------------+-------------------+----------+-------------------+---------+-------------+----------+------
| 18e112cf6e61c0c7 | CleanYasdbNode | host0002 | yashandb.host0002 | SUCCESS | 0 | 100 | 1
-------+------------------+-------------------+----------+-------------------+---------+-------------+----------+------
task completed, status: SUCCESS
[yac@localhost full_bak_1]$
修改建库脚本,修改AU_SIZE
获取默认的diskgroup创建语句
[yac@localhost log]$ grep -i 'create diskgroup' yasagent.log
2024-04-09 18:33:19 DEBUG [yashandb-1-1] exec.go:63 exec: bash -c /home/yac/yashandb/23.2.1.100/bin/yfscmd -D /home/yac/data/ycs/ce-1-1 exec "create diskgroup DG0 external redundancy disk '/dev/yas/data' force attribute 'au_size'='1M'" starting
[yac@localhost log]$
修改yashandb.toml
修改yashandb.toml
在[group.config之前]添加,注意au_size已经修改为32M。
[group.create_sql]
create_diskgroup = "create diskgroup DG0 external redundancy disk '/dev/yas/data' force attribute 'au_size'='32M';"
完整yashandb.toml如下
[yac@localhost install]$ cat yashandb.toml
cluster = "yashandb"
create_simple_schema = false
uuid = "661518c0de3db7d39125706474b55a89"
yas_type = "CE"
[CEDisk]
data = "/dev/yas/data"
vote = "/dev/yas/vote"
ycr = "/dev/yas/ycr"
[YFSConfig]
RECY_INTERVAL = "86400"
SHM_POOL_SIZE = "2G"
SYS_AREA_SIZE = "1G"
YFS_PACKET_SIZE = "1M"
[[group]]
group_type = "ce"
name = "ceg1"
[group.create_sql]
create_diskgroup"create diskgroup DG0 external redundancy disk '/dev/yas/data' force attribute 'au_size'='32M';"
[group.config]
CHARACTER_SET = "gbk"
ISARCHIVELOG = true
REDO_FILE_NUM = 8
REDO_FILE_SIZE = "1G"
YFS_FORCE_CREATE = true
[[group.node]]
data_path = "/home/yac/data"
hostid = "host0001"
role = 1
[group.node.config]
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.27.28:1989"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.27.28:2088"
LISTEN_ADDR = "192.168.27.28:1988"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/home/yac/yashandb/23.2.1.100/log/yashandb/ce-1-1/run"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/home/yac/yashandb/23.2.1.100/log/yashandb/ce-1-1/slow"
SQL_POOL_PARTS = 8
[[group.node]]
data_path = "/home/yac/data"
hostid = "host0002"
role = 2
[group.node.config]
CLUSTER_DATABASE = "TRUE"
CLUSTER_INTERCONNECT = "192.168.27.29:1989"
DATA_BUFFER_SIZE = "1G"
HA_ELECTION_TIMEOUT = 18
HA_HEARTBEAT_INTERVAL = 6
INTER_URL = "192.168.27.29:2088"
LISTEN_ADDR = "192.168.27.29:1988"
REDO_BUFFER_PARTS = 8
REDO_BUFFER_SIZE = "64M"
RUN_LOG_FILE_PATH = "/home/yac/yashandb/23.2.1.100/log/yashandb/ce-1-2/run"
SHARE_POOL_SIZE = "1G"
SLOW_LOG_FILE_PATH = "/home/yac/yashandb/23.2.1.100/log/yashandb/ce-1-2/slow"
SQL_POOL_PARTS = 8
[yac@localhost install]$
重建集群
[yac@localhost install]$ ./bin/yasboot cluster deploy -t yashandb.toml -d
type | uuid | name | hostid | index | status | return_code | progress | cost
------------------------------------------------------------------------------------------------------------------------
task | febed9e9d11051f6 | DeployYasdbCluster | - | yashandb | SUCCESS | 0 | 100 | 154
-------+------------------+--------------------+----------+-------------------+---------+-------------+----------+------
child | fd7f36bebd8c6690 | DeployCePrimary | host0001 | yashandb.1-1 | SUCCESS | 0 | 100 | 138
+------------------+--------------------+----------+-------------------+---------+-------------+----------+------
| 6b8097c29ae76eb5 | DeployCeStandby | host0002 | yashandb.1-2 | SUCCESS | 0 | 100 | 13
+------------------+--------------------+----------+-------------------+---------+-------------+----------+------
| ac33cca0038effe3 | SyncNodeConfig | - | yashandb | SUCCESS | 0 | 100 | 1
+------------------+--------------------+----------+-------------------+---------+-------------+----------+------
| ae8d99b094cdf85f | MonitReload | host0001 | yashandb-host0001 | SUCCESS | 0 | 100 | 1
+------------------+--------------------+----------+-------------------+---------+-------------+----------+------
| 1c0e0f77c6268465 | MonitReload | host0002 | yashandb-host0002 | SUCCESS | 0 | 100 | 1
-------+------------------+--------------------+----------+-------------------+---------+-------------+----------+------
task completed, status: SUCCESS
确认AU_SIZE已经修改
[yac@localhost install]$ yasql / as sysdba
YashanDB SQL Enterprise Edition Release 23.2.1.100 aarch64
SQL> select name,au_size/1024/1024 from v$yfs_diskgroup;
NAME AU_SIZE/1024/1024
---------------------------------------------------------------- -----------------
DG0 32
1 row fetched.
SQL>
恢复数据库
[yac@localhost install]$ yasboot cluster clean -c yashandb --restore -d
Are you sure you want to CLEAN cluster: [yashandb], NODES DATA WILL BE DELETED AND RESTART WITH 'NOMOUNT' STATUS (-r/--restore is given)?
[yes/no]: yes
type | uuid | name | hostid | index | status | return_code | progress | cost
----------------------------------------------------------------------------------------------------------------------------
task | 93b8e4c5d11e4cc6 | CleanYasdbCluster | - | yashandb | SUCCESS | 0 | 100 | 44
-------+------------------+-------------------+----------+------------------------+---------+-------------+----------+------
child | 2dea5296ca43b64b | StopYasdbYasce | host0001 | yashandb.1-1.ForceStop | SUCCESS | 0 | 100 | 1
+------------------+-------------------+----------+------------------------+---------+-------------+----------+------
| 4395ef7a8f1acb88 | StopYasdbYasce | host0002 | yashandb.1-2.ForceStop | SUCCESS | 0 | 100 | 1
+------------------+-------------------+----------+------------------------+---------+-------------+----------+------
| 3398f9d85a07c56a | RestoreCleanYasce | host0001 | yashandb.1-1 | SUCCESS | 0 | 100 | 39
+------------------+-------------------+----------+------------------------+---------+-------------+----------+------
| 8727a602b3b696fd | StartYasdbYasce | host0002 | yashandb.1-2 | SUCCESS | 0 | 100 | 4
-------+------------------+-------------------+----------+------------------------+---------+-------------+----------+------
task completed, status: SUCCESS
[yac@localhost install]$
[yac@localhost backup]$ yasrman / -c "list backup" -D /home/yac/backup/catalog
Group: type DB, tag: full_1, format: /home/yac/backup/full_bak_1, connect url: , nodeCount: 1, distribution: FALSE, isClient: FALSE, offset: 0
backup path: /home/yac/backup/full_bak_1
instance: 1, archive range sequence: 2-2
scn: 552231634862604288-552233372626141184
instance: 2, archive range sequence: 1-1
scn: 552231634862604288-552233372626141184
[yac@localhost backup]$
[yac@localhost backup]$ yasrman sys/Cod-2022 -c "restore database from tag 'full_1'" -D /home/yac/backup/catalog
yashan
restore successfully
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· 清华大学推出第四讲使用 DeepSeek + DeepResearch 让科研像聊天一样简单!
· 实操Deepseek接入个人知识库
· 易语言 —— 开山篇
· CSnakes vs Python.NET:高效嵌入与灵活互通的跨语言方案对比