MySQL Forums
Forum List  »  NDB clusters

Too many active Scans
Posted by: sushan ding
Date: April 29, 2014 01:25AM

Hi,
I am performance testing the ndb cluster 7.3.3 using sysbench.
when I try to test using 1000 threads,I got the following error:
"ALERT: MySQL error: Got temporary error 245 'Too many active scans' from NDBCLUSTER"
The sysbench script is "sysbench --test=oltp --mysql-user=xxx --mysql-password=xxx --mysql-host=xxx --oltp-table-size=500000 --mysql-db=test --max-requests=50000 --num-threads=1000 --mysql-table-engine=ndbcluster --oltp-read-only=on run".

I found this URL http://planet.mysql.com/entry/?id=34190
and change the configuration as follows:
MaxNoOfConcurrentScans=500
MaxNoOfLocalScans=200000

But it doesn't work. The error still appears.

Is anyone kown how to fix it?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Too many active Scans
3230
April 29, 2014 01:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.