tag:blogger.com,1999:blog-19281624.post5864549985155609501..comments2023-11-29T09:00:11.662+00:00Comments on Johan Andersson's Cluster and HA Blog: MySQL Cluster: Too many active scansJohan Anderssonhttp://www.blogger.com/profile/09202425156709885026noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-19281624.post-70169697307781256982013-05-30T18:43:24.028+01:002013-05-30T18:43:24.028+01:00tcInstances = No of transaction coordinators
lqh i...tcInstances = No of transaction coordinators<br />lqh instances = No query handlers.<br /><br />Defined with:<br />http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbmtd-threadconfigJohan Anderssonhttps://www.blogger.com/profile/09202425156709885026noreply@blogger.comtag:blogger.com,1999:blog-19281624.post-83395838794997169162013-05-30T10:49:30.470+01:002013-05-30T10:49:30.470+01:00Hi Johan,
can you please explain what are the para...Hi Johan,<br />can you please explain what are the parameters<br /><br />tcInstances=1 and lqhInstances=4<br /><br />Thanks in advance<br />SumiAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-19281624.post-31959572198663579782012-10-04T17:48:19.422+01:002012-10-04T17:48:19.422+01:00Hi Johan
what about
MaxNoOfLocalScans = (TableFra...Hi Johan<br />what about <br />MaxNoOfLocalScans = (TableFragmentCount * noOfScanRecords) + 2 for releases before 7.2.x<br /><br />BR<br />Eduardo Anonymoushttps://www.blogger.com/profile/14897724228319146814noreply@blogger.comtag:blogger.com,1999:blog-19281624.post-46106046055868171622012-09-21T09:14:20.932+01:002012-09-21T09:14:20.932+01:00Hi Johan
just a question:
shouldn't it be b...Hi Johan<br /><br />just a question: <br /><br />shouldn't it be better, for a proper dimensioning, use the max number of fragments instead the noOfDBNodes ?<br /><br />BR<br />EduardoAnonymoushttps://www.blogger.com/profile/14897724228319146814noreply@blogger.com