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

YCSB java out of memory error with mysql jdbc scan #196

Closed
renep123 opened this issue Nov 17, 2014 · 3 comments
Closed

YCSB java out of memory error with mysql jdbc scan #196

renep123 opened this issue Nov 17, 2014 · 3 comments

Comments

@renep123
Copy link

Hi,
I have setup a 10GB mysql database using ycsb (0.1.4). When I am running the workloade (scan test) against my database, I end up in java out of memory error "Exception in thread "Thread-1" java.lang.OutOfMemoryError: Java heap space".

I can see some commits back in 2012 to fix some scan issue with jdbc in the git repo that adds a fetch size parameter. I am using the following command to run workloade, still I get the error:-

./bin/ycsb run jdbc -P workloads/workloade -p db.driver=com.mysql.jdbc.Driver -p db.url=jdbc:mysql://localhost:3306/testycsbWA -p db.user=username -p jdbc.fetchsize=1 -p recordcount=10 -p operationcount=10 -p maxexecutiontime=1800

I am not sure if the fix works for mysql or if I need to use any more parameters. Could someone help me out to identify/fix the error?

Thanks!

@busbey
Copy link
Collaborator

busbey commented Jun 6, 2015

you can now pass a command line arg to give the YCSB client more java heap, see #261

@kruthar
Copy link
Collaborator

kruthar commented Nov 1, 2015

OOM errors with the JDBC module doing scan operations initially found in #171, known issue.

@kruthar
Copy link
Collaborator

kruthar commented Dec 15, 2015

@renep123 - #171 was fixed with #468, does this fix you issue?

@kruthar kruthar closed this as completed Jan 13, 2016
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

3 participants