1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
|
#
# Real world MySQL Cluster configuration suited
# to be run on a developer machine
#
# The configuration is tuned according to best
# practice with the limitation that all processes
# are run on one host with 4Gb RAM
#
!include include/default_mysqld.cnf
[cluster_config.1]
ndbd=,
ndb_mgmd=
mysqld=
DataMemory=920M
MaxNoOfConcurrentOperations=262144
StringMemory=25
MaxNoOfTables=12800
MaxNoOfOrderedIndexes=12800
MaxNoOfUniqueHashIndexes=12800
MaxNoOfAttributes=128000
MaxDiskWriteSpeedOwnRestart=200M
FragmentLogFileSize=256M
InitFragmentLogFiles=FULL
NoOfFragmentLogFiles=11
TimeBetweenLocalCheckpoints=20
TimeBetweenGlobalCheckpoints=2000
TimeBetweenEpochs=100
MemReportFrequency=30
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15
BackupMaxWriteSize=1M
BackupDataBufferSize=16M
BackupLogBufferSize=4M
BackupMemory=20M
ODirect=1
TimeBetweenWatchDogCheckInitial=60000
TransactionInactiveTimeout=30000
RealtimeScheduler=1
SchedulerExecutionTimer=80
SchedulerSpinTimer=40
SharedGlobalMemory=20M
DiskPageBufferMemory=64M
BatchSizePerLocalScan=512
Checksum=1
[cluster_config.TCP.1]
SendBufferMemory=2M
ReceiveBufferMemory=2M
[cluster_config.mysqld.1.1]
NodeId=49
Dedicated=1
BatchSize=512
BatchByteSize=1024K
[mysqld]
# Make all mysqlds use cluster
ndbcluster
ndb-cluster-connection-pool=1
ndb-force-send=1
ndb-use-exact-count=0
ndb-extra-logging=1
ndb-autoincrement-prefetch-sz=256
ndb-wait-connected=600
ndb-wait-setup=300
# check if this avoid excessive query time...resulting in timeouts
optimizer_search_depth=10
[mysqld.1.1]
ndb-nodeid=49
[ENV]
NDB_CONNECTSTRING= @mysql_cluster.1.ndb_connectstring
MASTER_MYPORT= @mysqld.1.1.port
|
