关于流程处理很慢的问题

lemsn

流程使用起来很难受，特别慢，具体如下：
数据库：MySQL8
OA版本：9.0.2
服务器系统配置：8核16G
单次处理流程的时间大概是12秒左右，每次处理流程的时候，等待都很难受，经常被老板骂


数据库的配置，按按咱管理的建议也优化过了，并没有问题
以下是我最大的几个表的截图：


看日志， CTE_SCHEDULELOG  这个表的操作比较多，请技术伙伴看看怎么回事，能优化吗，按理来说，这种流程的处理操作应该是秒级的。
我看论坛也是有不少朋友是这样的问题，请官方重视这个问题


对于这个服务器的配置来说，肯定是没有问题的。

以下是Druid日志：

lemsn

补充：

以下是部分慢查询日志的记录：
这个时间还是比较可怕的

# Time: 2024-03-28T13:42:15.668752+08:00
# User@Host: oadb[oadb] @ localhost [127.0.0.1]  Id:    88
# Query_time: 5.225437 Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
use oadb;
SET timestamp=1711604530;
commit;

# Time: 2024-03-28T13:42:21.226345+08:00
# User@Host: oadb[oadb] @ localhost [127.0.0.1]  Id:    88
# Query_time: 5.552583  Lock_time: 0.000005 Rows_sent: 0  Rows_examined: 2
SET timestamp=1711604535;
UPDATE CTE_SCHEDULELOG SET xupdateTime = '2024-03-28 13:42:15.672', xelapsed = 5, xsuccess = 1 WHERE xid = 'd42bc052-23ac-49e1-94a8-4063518261f1';
# Time: 2024-03-28T13:43:07.799012+08:00
# User@Host: oadb[oadb] @ localhost [127.0.0.1]  Id:    88

# Query_time: 5.786587  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1711604582;
commit;
# Time: 2024-03-28T13:43:46.931437+08:00
# User@Host: oadb[oadb] @ localhost [127.0.0.1]  Id:    88

# Query_time: 8.742696  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1711604618;
commit;


# Time: 2024-03-28T19:55:37.879994+08:00
# User@Host: oadb[oadb] @ localhost [127.0.0.1]  Id:   172
# Query_time: 9.022195  Lock_time: 0.000008 Rows_sent: 0  Rows_examined: 0
SET timestamp=1711626928;
INSERT INTO CTE_SCHEDULELOG (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xapplication, xclassName, xelapsed, xfireTime, xnode, xstackTrace, xsuccess, xtype) VALUES ('0ebf9e89-77e3-4457-a0bd-843955691b2c', '2024-03-28 19:55:28.856', '202403281955280ebf9e89-77e3-4457-a0bd-843955691b2c', '2024-03-28 19:55:28.856', null, 'com.x.base.core.project.x_program_center', 'com.x.program.center.schedule.FireSchedule', null, '2024-03-28 19:55:28', '127.0.0.1', null, null, 'scheduleLocal');



# Time: 2024-03-29T01:00:43.745220+08:00
# User@Host: oadb[oadb] @ localhost [127.0.0.1]  Id:    34
# Query_time: 8.500379 Lock_time: 0.000006 Rows_sent: 0  Rows_examined: 0
SET timestamp=1711645235;
INSERT INTO CTE_SCHEDULELOG (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xapplication, xclassName, xelapsed, xfireTime, xnode, xstackTrace, xsuccess, xtype) VALUES ('6c3a6370-0a18-4289-a57f-e549d098c555', '2024-03-29 01:00:35.243', '202403290100356c3a6370-0a18-4289-a57f-e549d098c555', '2024-03-29 01:00:35.243', null, 'com.x.base.core.project.x_program_center', 'com.x.program.center.schedule.TriggerAgent', null, '2024-03-29 01:00:25', '127.0.0.1', null, null, 'scheduleLocal');

# Time: 2024-03-29T01:00:43.748173+08:00
# User@Host: oadb[oadb] @ localhost [127.0.0.1]  Id:    31
# Query_time: 18.564057  Lock_time: 0.000006 Rows_sent: 0  Rows_examined: 0
SET timestamp=1711645225;
INSERT INTO CTE_SCHEDULELOG (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xapplication, xclassName, xelapsed, xfireTime, xnode, xstackTrace, xsuccess, xtype) VALUES ('1fa1bf75-279f-48c1-a626-acc7d4d8299c', '2024-03-29 01:00:25.175', '202403290100251fa1bf75-279f-48c1-a626-acc7d4d8299c', '2024-03-29 01:00:25.175', null, 'com.x.base.core.project.x_program_center', 'com.x.program.center.schedule.FireSchedule', null, '2024-03-29 01:00:25', '127.0.0.1', null, null, 'scheduleLocal');

# Time: 2024-03-29T01:00:43.748680+08:00
# User@Host: oadb[oadb] @ localhost [127.0.0.1]  Id:    33
# Query_time: 16.741545 Lock_time: 0.000005 Rows_sent: 0  Rows_examined: 1
SET timestamp=1711645227;
DELETE FROM CMS_REVIEW WHERE xid = '0177701d-8972-4c80-a5e0-3fa3af75e614';
# Time: 2024-03-31T12:27:47.304830+08:00
# User@Host: oadb[oadb] @ localhost [127.0.0.1]  Id:   529
# Query_time: 6.433537  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0
SET timestamp=1711859260;
rollback;

启蒙星

你的mysql有没有优化过，参考文档：https://www.yuque.com/o2oa/fuwefs/ooma2p 或者网上搜索下，处理流程要12秒那是很难接收的，建议联系商务我们给你的环境做全面检查

lemsn

启蒙星 发表于 2024-4-12 10:59
你的mysql有没有优化过，参考文档：https://www.yuque.com/o2oa/fuwefs/ooma2p 或者网上搜索下，处理流程要 ...

已经安这个文档优化过了的