You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I would like to report quite huge performance issues when running complex queries on Herd Pro Mysql service. With my old homestead (vagrant) setup the query is executed around 2.12ms, with Herd it takes 30seconds or even more. (Often getting 504, which I set to 60 seconds) I tried to play with innodb_io_capacity and innodb_io_capacity_max variables, but no luck.
The query contains a lot of SUM and working with up to ten thousands of records, so it's not that heavy from the 'row count' perspective.
This discussion was converted from issue #837 on August 09, 2024 10:09.
Heading
Bold
Italic
Quote
Code
Link
Numbered list
Unordered list
Task list
Attach files
Mention
Reference
Menu
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
Platform
Windows
Operating system version
Windows 11
System architecture
Intel (x86)
Herd Version
1.7.2
PHP Version
No response
Bug description
I would like to report quite huge performance issues when running complex queries on Herd Pro Mysql service. With my old homestead (vagrant) setup the query is executed around 2.12ms, with Herd it takes 30seconds or even more. (Often getting 504, which I set to 60 seconds) I tried to play with innodb_io_capacity and innodb_io_capacity_max variables, but no luck.
The query contains a lot of SUM and working with up to ten thousands of records, so it's not that heavy from the 'row count' perspective.
Is there anybody who experienced similar issues?
Steps to reproduce
No response
Relevant log output
No response
Beta Was this translation helpful? Give feedback.
All reactions