Skip to content

Out of Memory Issue with oltp_read_only on 10,000 Threads and Table Size of 10,000 #547

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

Open
shaoxiqian opened this issue Nov 11, 2024 · 1 comment

Comments

@shaoxiqian
Copy link

sysbench version:sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)
sysbench oltp_read_only run --mysql-host=xxx--mysql-port=xxx --mysql-user=root --db-driver=mysql --mysql-db=test --threads=100 --time=900 --report-interval=10 --tables=10000 --table-size=10000 --mysql-ignore-errors=1062,2013,8028,9002,9007 --auto-inc=false --debug
image

@mdcallag
Copy link
Contributor

10k connections likely means 10k thread stacks from the sysbench client, and then 10k thread stacks in mysqld. That can easily be 10G + 10G of memory. But this bug report provides so little detail that we can only wave hands at what the problem might be.

Consider providing more detail on bug reports if you want useful feedback. For example:

  1. Share the my.cnf
  2. Explain the hardware you are using (amount of memory, etc)

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