For feature requests, please see: http://www.mattermost.org/feature-requests/ . For troubleshooting questions, please post in the following format: Summary Some query’s make High CPU Load and Disk I/O SELECT COUNT(DISTINCT(Posts.RootId)) FROM Posts LEFT JOIN ThreadMemberships ON Posts.RootId = Th…

@Linu - Please upgrade to 7.0.0 which has improved this query. As a side note: we don’t support MariaDB. So you will likely run into issues using this database. I’d suggest moving to MySQL or Postgres.

Some SQL Execute query's make High usage disk I/O and CPU

Troubleshooting

agnivade (Agniva De Sarker) June 30, 2022, 8:24am 3

// cc @agarciamontoro

Topic		Replies	Views
Db query is eating all cpus Troubleshooting	1	370	May 6, 2022
MariaDB crash on SELECT COUNT FROM POSTS Troubleshooting	3	755	September 2, 2021
Database performace has degraded considerable after upgrading to 7.1 Troubleshooting	12	1473	June 20, 2023
Statistics with SQL request Troubleshooting	1	661	December 4, 2019
Performance issues following upgrade to Mattermost 6.0.0 Troubleshooting	2	774	November 25, 2021

Some SQL Execute query's make High usage disk I/O and CPU

Related topics