Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

clock_gettime calls in sql_optimizer.cc account for ~4% of CPU time in the worst case #1482

Open
mdcallag opened this issue Aug 6, 2024 · 2 comments

Comments

@mdcallag
Copy link
Contributor

mdcallag commented Aug 6, 2024

In the worst case (simple query such as fetch one row by PK) the usage of clock_gettime in sql_optimizer.cc accounts for ~4% of CPU time. The usage is here and is here.

Must this always be enabled?

@yoshinorim
Copy link
Contributor

Could you try enable_optimizer_cputime_with_wallclock=on and enable_cputime_with_wallclock=on?

@mdcallag
Copy link
Contributor Author

mdcallag commented Aug 7, 2024

with that the overhead is ~3% of CPU time

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants