Debian Codegraph @

mysql-test/suite/ndb_big/my.cnf

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