问题:执行SQL语句相当慢,某两个节点的Swap 100%被占用。
具体如下:
1. 现场在使用dev_noas_app用户执行insert的sql时,报下面的错误,帮分析一下存在什么问题?
Category Timestamp Duration Message Line Position Error 2012-12-11 11:37:59 0:05:08.734 ERROR 3587: Insufficient resources to execute plan on pool pool_noas_app [Timedout waiting for resource request: Due to queued higher priority queries, general cannot supply required overflow resourcesMemory(KB) Exceeded: Requested = 1754728, Free = 0 (Limit = 0, Used = 0)]
37 1
现场的resources pool设置如下:
图片。。。
2. 现场的vertica数据库非常慢,执行普通的小数据量的sql也非常慢,问一下从哪些角度定位原因,最好具体一下?
方便的话最好提供一份手册,方便我们去分析定位。
我们现场有两台vertica节点swap突然为零 ,且这两个节点只有MPP应用无任何其它应用,是我们数据库没释放资源还是什么,其它节点正常
10.213.16.15 top部分结果
top - 16:33:40 up 12 days, 11:21, 4 users, load average: 0.00, 0.00, 0.17
Tasks: 359 total, 1 running, 358 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 96729M total, 96270M used, 459M free, 2018M buffers
Swap: 0M total, 0M used, 0M free, 70503M cached
10.213.16.16 top部分结果
top - 16:33:38 up 33 days, 21:59, 4 users, load average: 0.00, 0.01, 0.19
Tasks: 361 total, 1 running, 360 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.1%us, 0.2%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 96729M total, 96307M used, 422M free, 997M buffers
Swap: 0M total, 0M used, 0M free, 78022M cached
10.213.16.17 top部分结果
top - 16:38:22 up 33 days, 23:00, 3 users, load average: 0.04, 0.08, 0.16
Tasks: 379 total, 1 running, 378 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.1%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 96724M total, 96283M used, 440M free, 861M buffers
Swap: 131069M total, 1384M used, 129684M free, 80609M cached
10.213.16.18 top部分结果
top - 16:39:21 up 33 days, 23:14, 2 users, load average: 6.98, 6.55, 6.58
Tasks: 354 total, 4 running, 350 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.0%us, 4.3%sy, 0.3%ni, 95.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 96729M total, 96234M used, 495M free, 954M buffers
Swap: 131069M total, 3511M used, 127557M free, 75237M cached
10.213.16.19 top部分结果
top - 16:36:45 up 33 days, 18:34, 2 users, load average: 0.00, 0.00, 0.06
Tasks: 354 total, 2 running, 352 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.1%us, 0.2%sy, 0.0%ni, 99.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 96729M total, 94751M used, 1977M free, 2289M buffers
Swap: 131069M total, 826M used, 130243M free, 70313M cached
--
-- You received this message because you are subscribed to the Google Groups Shanghai Linux User Group group. To post to this group, send email to sh...@googlegroups.com. To unsubscribe from this group, send email to shlug+un...@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/shlug?hl=zh-CN
---
您收到此邮件是因为您订阅了Google网上论坛上的“Shanghai Linux User Group”群组。
要退订此群组并停止接收此群组的电子邮件,请发送电子邮件到shlug+un...@googlegroups.com。
要查看更多选项,请访问https://groups.google.com/d/optout。
> shlug+unsubscribe@googlegroups.com. For more options, visit this group at
> https://groups.google.com/d/forum/shlug?hl=zh-CN
> ---
> 您收到此邮件是因为您订阅了Google网上论坛上的“Shanghai Linux User Group”群组。
> 要退订此群组并停止接收此群组的电子邮件,请发送电子邮件到shlug+unsubscribe@googlegroups.com。
> 要查看更多选项,请访问https://groups.google.com/d/optout。
--
-- You received this message because you are subscribed to the Google Groups Shanghai Linux User Group group. To post to this group, send email to sh...@googlegroups.com. To unsubscribe from this group, send email to shlug+unsubscribe@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/shlug?hl=zh-CN
---
您收到此邮件是因为您订阅了 Google 网上论坛的“Shanghai Linux User Group”群组。
要退订此群组并停止接收此群组的电子邮件,请发送电子邮件到shlug+unsubscribe@googlegroups.com。
要查看更多选项,请访问 https://groups.google.com/d/optout。
-- You received this message because you are subscribed to the Google Groups Shanghai Linux User Group group. To post to this group, send email to sh...@googlegroups.com. To unsubscribe from this group, send email to shlug+un...@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/shlug?hl=zh-CN
---
您收到此邮件是因为您订阅了Google网上论坛上的“Shanghai Linux User Group”群组。
要退订此群组并停止接收此群组的电子邮件,请发送电子邮件到shlug+un...@googlegroups.com。
要查看更多选项,请访问https://groups.google.com/d/optout。