麦粉社区
>
帖子详情

即席查询/仪表板 大数据量导出时的内存溢出(OOM)问题及规避方案

AIChat 发表于 半小时前
发表于 半小时前

在导出超过50万行的数据时,前端报错“超出最大单元格限制”或后台服务器内存溢出。


环境/版本:FineBI V6.0 / 服务器配置:8核16G。


已尝试的排查:尝试过分批导出、调整了JVM内存参数,但依然卡顿。


有没有大佬知道在限制单元格数量的前提下,如何通过后台配置或优化数据模型来降低导出内存消耗?

发表于 29 分钟前
谢谢
weibo.com/ttarticle/p/show?comment=1&id=2309405366612106019006
weibo.com/ttarticle/p/show?comment=1&id=2309405366612068008017
weibo.com/ttarticle/p/show?id=2309405366612185448540
weibo.com/ttarticle/p/show?id=2309405366612068008017
weibo.com/ttarticle/p/show?comment=1&id=2309405366612143767738
weibo.com/ttarticle/p/show?id=2309405366612106019006
weibo.com/ttarticle/p/show?id=2309405366612143767738
weibo.com/ttarticle/p/show?comment=1&id=2309405366612185448540
weibo.com/ttarticle/p/show?id=2309405366612223197260
weibo.com/ttarticle/p/show?comment=1&id=2309405366612223197260
weibo.com/ttarticle/p/show?comment=1&id=2309405366612260946053
weibo.com/ttarticle/p/show?id=2309405366612260946053
weibo.com/ttarticle/p/show?id=2309405366612302889133
weibo.com/ttarticle/p/show?comment=1&id=2309405366612340637780
weibo.com/ttarticle/p/show?id=2309405366612340637780
weibo.com/ttarticle/p/show?comment=1&id=2309405366612302889133
weibo.com/ttarticle/p/show?id=2309405366612382580796
weibo.com/ttarticle/p/show?id=2309405366612420591778
weibo.com/ttarticle/p/show?comment=1&id=2309405366612382580796
weibo.com/ttarticle/p/show?comment=1&id=2309405366612420591778
weibo.com/ttarticle/p/show?id=2309405366612466729008
weibo.com/ttarticle/p/show?id=2309405366612504477835
weibo.com/ttarticle/p/show?comment=1&id=2309405366612466729008
weibo.com/ttarticle/p/show?comment=1&id=2309405366612504477835
weibo.com/ttarticle/p/show?id=2309405366612583907391
weibo.com/ttarticle/p/show?comment=1&id=2309405366612583907391
weibo.com/ttarticle/p/show?comment=1&id=2309405366612546420771
weibo.com/ttarticle/p/show?id=2309405366612621656318
weibo.com/ttarticle/p/show?id=2309405366612546420771
weibo.com/ttarticle/p/show?comment=1&id=2309405366612621656318
weibo.com/ttarticle/p/show?comment=1&id=2309405366612663861344
weibo.com/ttarticle/p/show?id=2309405366612663861344
weibo.com/ttarticle/p/show?comment=1&id=2309405366612701610122
weibo.com/ttarticle/p/show?id=2309405366612701610122
weibo.com/ttarticle/p/show?id=2309405366612743290925
weibo.com/ttarticle/p/show?comment=1&id=2309405366612743290925
weibo.com/ttarticle/p/show?comment=1&id=2309405366612781301854
weibo.com/ttarticle/p/show?id=2309405366612822982769
weibo.com/ttarticle/p/show?id=2309405366612781301854
weibo.com/ttarticle/p/show?comment=1&id=2309405366612822982769
weibo.com/ttarticle/p/show?id=2309405366612860993811
weibo.com/ttarticle/p/show?comment=1&id=2309405366612860993811
weibo.com/ttarticle/p/show?comment=1&id=2309405366612902674534
weibo.com/ttarticle/p/show?id=2309405366612940685478
weibo.com/ttarticle/p/show?id=2309405366612902674534
weibo.com/ttarticle/p/show?comment=1&id=2309405366612940685478
weibo.com/ttarticle/p/show?id=2309405366612982628361
weibo.com/ttarticle/p/show?comment=1&id=2309405366612982628361
weibo.com/ttarticle/p/show?id=2309405366613020114992
weibo.com/ttarticle/p/show?comment=1&id=2309405366613020114992
weibo.com/ttarticle/p/show?id=2309405366613057863732
weibo.com/ttarticle/p/show?comment=1&id=2309405366613057863732
weibo.com/ttarticle/p/show?id=2309405366613137817709
weibo.com/ttarticle/p/show?id=2309405366613099806767
weibo.com/ttarticle/p/show?comment=1&id=2309405366613137817709
weibo.com/ttarticle/p/show?comment=1&id=2309405366613099806767
weibo.com/ttarticle/p/show?comment=1&id=2309405366613179498510
weibo.com/ttarticle/p/show?id=2309405366613179498510
weibo.com/ttarticle/p/show?id=2309405366613217509481
weibo.com/ttarticle/p/show?comment=1&id=2309405366613217509481
weibo.com/ttarticle/p/show?comment=1&id=2309405366613259452461
weibo.com/ttarticle/p/show?id=2309405366613296939107
weibo.com/ttarticle/p/show?comment=1&id=2309405366613296939107
weibo.com/ttarticle/p/show?id=2309405366613259452461
weibo.com/ttarticle/p/show?comment=1&id=2309405366613334950037
weibo.com/ttarticle/p/show?id=2309405366613334950037
weibo.com/ttarticle/p/show?id=2309405366613376630791
weibo.com/ttarticle/p/show?comment=1&id=2309405366613376630791
weibo.com/ttarticle/p/show?id=2309405366613414641752
weibo.com/ttarticle/p/show?comment=1&id=2309405366613414641752
weibo.com/ttarticle/p/show?id=2309405366613452390521
weibo.com/ttarticle/p/show?comment=1&id=2309405366613452390521
weibo.com/ttarticle/p/show?id=2309405366613494071326
weibo.com/ttarticle/p/show?comment=1&id=2309405366613494071326
weibo.com/ttarticle/p/show?id=2309405366613536276484
weibo.com/ttarticle/p/show?comment=1&id=2309405366613582151749
weibo.com/ttarticle/p/show?comment=1&id=2309405366613536276484
weibo.com/ttarticle/p/show?id=2309405366613582151749
weibo.com/ttarticle/p/show?id=2309405366613624356928
weibo.com/ttarticle/p/show?comment=1&id=2309405366613624356928
weibo.com/ttarticle/p/show?id=2309405366613674426424
weibo.com/ttarticle/p/show?comment=1&id=2309405366613674426424
weibo.com/ttarticle/p/show?comment=1&id=2309405366613724758066
weibo.com/ttarticle/p/show?id=2309405366613724758066
weibo.com/ttarticle/p/show?id=2309405366613770895390
weibo.com/ttarticle/p/show?comment=1&id=2309405366613770895390
weibo.com/ttarticle/p/show?id=2309405366613808644216
weibo.com/ttarticle/p/show?comment=1&id=2309405366613808644216
weibo.com/ttarticle/p/show?id=2309405366613850849354
weibo.com/ttarticle/p/show?comment=1&id=2309405366613850849354
weibo.com/ttarticle/p/show?comment=1&id=2309405366613888598166
weibo.com/ttarticle/p/show?id=2309405366613888598166
weibo.com/ttarticle/p/show?comment=1&id=2309405366613934735463
weibo.com/ttarticle/p/show?id=2309405366613934735463
weibo.com/ttarticle/p/show?id=2309405366667986731261
weibo.com/ttarticle/p/show?comment=1&id=2309405366667986731261
weibo.com/ttarticle/p/show?id=2309405366668028411947
weibo.com/ttarticle/p/show?comment=1&id=2309405366668028411947
weibo.com/ttarticle/p/show?id=2309405366668066160953
weibo.com/ttarticle/p/show?comment=1&id=2309405366668066160953
weibo.com/ttarticle/p/show?id=2309405366668108365871
weibo.com/ttarticle/p/show?comment=1&id=2309405366668108365871
weibo.com/ttarticle/p/show?id=2309405366668145852782
weibo.com/ttarticle/p/show?comment=1&id=2309405366668145852782
weibo.com/ttarticle/p/show?id=2309405366668188057690
weibo.com/ttarticle/p/show?comment=1&id=2309405366668188057690
weibo.com/ttarticle/p/show?id=2309405366668225544887
weibo.com/ttarticle/p/show?comment=1&id=2309405366668225544887
weibo.com/ttarticle/p/show?id=2309405366668267749493
weibo.com/ttarticle/p/show?comment=1&id=2309405366668267749493
weibo.com/ttarticle/p/show?id=2309405366668305498823
weibo.com/ttarticle/p/show?comment=1&id=2309405366668305498823
weibo.com/ttarticle/p/show?comment=1&id=2309405366668347179130
weibo.com/ttarticle/p/show?id=2309405366668347179130
weibo.com/ttarticle/p/show?comment=1&id=2309405366668384927794
weibo.com/ttarticle/p/show?id=2309405366668384927794
weibo.com/ttarticle/p/show?id=2309405366668426870862
weibo.com/ttarticle/p/show?comment=1&id=2309405366668426870862
weibo.com/ttarticle/p/show?id=2309405366668464620053
weibo.com/ttarticle/p/show?comment=1&id=2309405366668464620053
weibo.com/ttarticle/p/show?id=2309405366668506562618
weibo.com/ttarticle/p/show?comment=1&id=2309405366668506562618
weibo.com/ttarticle/p/show?id=2309405366668544311485
weibo.com/ttarticle/p/show?comment=1&id=2309405366668582322618
weibo.com/ttarticle/p/show?comment=1&id=2309405366668544311485
weibo.com/ttarticle/p/show?id=2309405366668582322618
weibo.com/ttarticle/p/show?id=2309405366668624265428
weibo.com/ttarticle/p/show?comment=1&id=2309405366668624265428
weibo.com/ttarticle/p/show?id=2309405366668665946117
weibo.com/ttarticle/p/show?comment=1&id=2309405366668665946117
weibo.com/ttarticle/p/show?id=2309405366668703957161
weibo.com/ttarticle/p/show?comment=1&id=2309405366668703957161
weibo.com/ttarticle/p/show?id=2309405366668741705935
weibo.com/ttarticle/p/show?comment=1&id=2309405366668741705935
weibo.com/ttarticle/p/show?id=2309405366668783648872
weibo.com/ttarticle/p/show?comment=1&id=2309405366668783648872
weibo.com/ttarticle/p/show?id=2309405366668821135610
weibo.com/ttarticle/p/show?comment=1&id=2309405366668821135610
weibo.com/ttarticle/p/show?id=2309405366668863078500
weibo.com/ttarticle/p/show?comment=1&id=2309405366668863078500
weibo.com/ttarticle/p/show?id=2309405366668901089430
weibo.com/ttarticle/p/show?comment=1&id=2309405366668901089430
weibo.com/ttarticle/p/show?comment=1&id=2309405366668943032422
weibo.com/ttarticle/p/show?id=2309405366668943032422
weibo.com/ttarticle/p/show?comment=1&id=2309405366668984975405
weibo.com/ttarticle/p/show?id=2309405366668984975405
weibo.com/ttarticle/p/show?id=2309405366669022724282
weibo.com/ttarticle/p/show?comment=1&id=2309405366669022724282
weibo.com/ttarticle/p/show?id=2309405366669064667142
weibo.com/ttarticle/p/show?comment=1&id=2309405366669064667142
weibo.com/ttarticle/p/show?id=2309405366669102415920
weibo.com/ttarticle/p/show?comment=1&id=2309405366669102415920
weibo.com/ttarticle/p/show?id=2309405366693928501323
weibo.com/ttarticle/p/show?comment=1&id=2309405366693928501323
weibo.com/ttarticle/p/show?id=2309405366693974638712
weibo.com/ttarticle/p/show?comment=1&id=2309405366693974638712
weibo.com/ttarticle/p/show?id=2309405366694016319686
weibo.com/ttarticle/p/show?comment=1&id=2309405366694016319686
weibo.com/ttarticle/p/show?id=2309405366694062456916
weibo.com/ttarticle/p/show?comment=1&id=2309405366694062456916
weibo.com/ttarticle/p/show?id=2309405366694116982918
weibo.com/ttarticle/p/show?comment=1&id=2309405366694116982918
weibo.com/ttarticle/p/show?id=2309405366694159188281
weibo.com/ttarticle/p/show?comment=1&id=2309405366694159188281
weibo.com/ttarticle/p/show?id=2309405366694205325355
weibo.com/ttarticle/p/show?comment=1&id=2309405366694205325355
weibo.com/ttarticle/p/show?id=2309405366694247268658
weibo.com/ttarticle/p/show?comment=1&id=2309405366694247268658
weibo.com/ttarticle/p/show?id=2309405366694293143615
weibo.com/ttarticle/p/show?comment=1&id=2309405366694293143615
weibo.com/ttarticle/p/show?id=2309405366694335348759
weibo.com/ttarticle/p/show?comment=1&id=2309405366694335348759
weibo.com/ttarticle/p/show?id=2309405366694377029719
weibo.com/ttarticle/p/show?comment=1&id=2309405366694377029719
weibo.com/ttarticle/p/show?id=2309405366694418973039
weibo.com/ttarticle/p/show?comment=1&id=2309405366694418973039
weibo.com/ttarticle/p/show?id=2309405366694465372174
weibo.com/ttarticle/p/show?comment=1&id=2309405366694465372174
weibo.com/ttarticle/p/show?id=2309405366694511247454
weibo.com/ttarticle/p/show?comment=1&id=2309405366694511247454
weibo.com/ttarticle/p/show?id=2309405366694561579020
weibo.com/ttarticle/p/show?comment=1&id=2309405366694561579020
weibo.com/ttarticle/p/show?id=2309405366694607978730
weibo.com/ttarticle/p/show?comment=1&id=2309405366694607978730
weibo.com/ttarticle/p/show?id=2309405366694653853782
weibo.com/ttarticle/p/show?comment=1&id=2309405366694653853782
weibo.com/ttarticle/p/show?id=2309405366694695796740
weibo.com/ttarticle/p/show?comment=1&id=2309405366694695796740
weibo.com/ttarticle/p/show?comment=1&id=2309405366694733545749
weibo.com/ttarticle/p/show?id=2309405366694733545749
weibo.com/ttarticle/p/show?id=2309405366694775750808
weibo.com/ttarticle/p/show?comment=1&id=2309405366694775750808
weibo.com/ttarticle/p/show?id=2309405366694821888202
weibo.com/ttarticle/p/show?comment=1&id=2309405366694821888202
weibo.com/ttarticle/p/show?comment=1&id=2309405366694863569213
weibo.com/ttarticle/p/show?id=2309405366694863569213
weibo.com/ttarticle/p/show?id=2309405366694909968636
weibo.com/ttarticle/p/show?comment=1&id=2309405366694909968636
weibo.com/ttarticle/p/show?id=2309405366694960037939
weibo.com/ttarticle/p/show?comment=1&id=2309405366694960037939
weibo.com/ttarticle/p/show?id=2309405366695010631813
weibo.com/ttarticle/p/show?comment=1&id=2309405366695010631813
weibo.com/ttarticle/p/show?id=2309405366695065157805
weibo.com/ttarticle/p/show?comment=1&id=2309405366695065157805
weibo.com/ttarticle/p/show?comment=1&id=2309405366695111295140
weibo.com/ttarticle/p/show?id=2309405366695111295140
weibo.com/ttarticle/p/show?id=2309405366695161364656
weibo.com/ttarticle/p/show?comment=1&id=2309405366695161364656
weibo.com/ttarticle/p/show?comment=1&id=2309405366695211958462
weibo.com/ttarticle/p/show?id=2309405366695211958462
weibo.com/ttarticle/p/show?id=2309405366695954350609
weibo.com/ttarticle/p/show?comment=1&id=2309405366695954350609
回复

使用道具 赞 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

1回帖数 0关注人数 4浏览人数
最后回复于:29 分钟前

社区

指南

AI

搜索

快速回复 返回顶部 返回列表