release/src/router/mysql/support-files/config.huge.ini.sh

   1 # Copyright (c) 2008 MySQL AB
   2 # Use is subject to license terms.
   3 #
   4 # This program is free software; you can redistribute it and/or modify
   5 # it under the terms of the GNU General Public License as published by
   6 # the Free Software Foundation; version 2 of the License.
   7 #
   8 # This program is distributed in the hope that it will be useful,
   9 # but WITHOUT ANY WARRANTY; without even the implied warranty of
  10 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  11 # GNU General Public License for more details.
  12 #
  13 # You should have received a copy of the GNU General Public License
  14 # along with this program; if not, write to the Free Software
  15 # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
  16 #
  17 ######################################################
  18 # MySQL NDB Cluster Huge Sample Configuration File   #
  19 ######################################################
  20 # This files assumes that you are using at least 9   #
  21 # hosts for running the cluster. Hostnames and paths #
  22 # listed below should be changed to match your setup #
  23 ######################################################
  24
  25 [NDBD DEFAULT]
  26 NoOfReplicas: 2
  27 DataDir: /add/path/here
  28 FileSystemPath: /add/path/here
  29
  30 # Data Memory, Index Memory, and String Memory #
  31 DataMemory: 6000M
  32 IndexMemory: 1500M
  33 StringMemory: 5
  34
  35 # Transaction Parameters #
  36 MaxNoOfConcurrentTransactions: 4096
  37 MaxNoOfConcurrentOperations: 100000
  38 MaxNoOfLocalOperations: 100000
  39
  40 # Transaction Temporary Storage #
  41 MaxNoOfConcurrentIndexOperations: 8192
  42 MaxNoOfFiredTriggers: 4000
  43 TransactionBufferMemory: 1M
  44
  45 # Scans and buffering #
  46 MaxNoOfConcurrentScans: 300
  47 MaxNoOfLocalScans: 32
  48 BatchSizePerLocalScan: 64
  49 LongMessageBuffer: 1M
  50
  51 # Logging and Checkpointing #
  52 NoOfFragmentLogFiles: 300
  53 FragmentLogFileSize: 16M
  54 MaxNoOfOpenFiles: 40
  55 InitialNoOfOpenFiles: 27
  56 MaxNoOfSavedMessages: 25
  57
  58 # Metadata Objects #
  59 MaxNoOfAttributes: 1500
  60 MaxNoOfTables: 400
  61 MaxNoOfOrderedIndexes: 200
  62 MaxNoOfUniqueHashIndexes: 200
  63 MaxNoOfTriggers: 770
  64
  65 # Boolean Parameters #
  66 LockPagesInMainMemory: 0
  67 StopOnError: 1
  68 Diskless: 0
  69 ODirect: 0
  70
  71 # Controlling Timeouts, Intervals, and Disk Paging #
  72 TimeBetweenWatchDogCheck: 6000
  73 TimeBetweenWatchDogCheckInitial: 6000
  74 StartPartialTimeout: 30000
  75 StartPartitionedTimeout: 60000
  76 StartFailureTimeout: 1000000
  77 HeartbeatIntervalDbDb: 2000
  78 HeartbeatIntervalDbApi: 3000
  79 TimeBetweenLocalCheckpoints: 20
  80 TimeBetweenGlobalCheckpoints: 2000
  81 TransactionInactiveTimeout: 0
  82 TransactionDeadlockDetectionTimeout: 1200
  83 DiskSyncSize: 4M
  84 DiskCheckpointSpeed: 10M
  85 DiskCheckpointSpeedInRestart: 100M
  86 ArbitrationTimeout: 10
  87
  88 # Buffering and Logging #
  89 UndoIndexBuffer: 2M
  90 UndoDataBuffer: 1M
  91 RedoBuffer: 32M
  92 LogLevelStartup: 15
  93 LogLevelShutdown: 3
  94 LogLevelStatistic: 0
  95 LogLevelCheckpoint: 0
  96 LogLevelNodeRestart: 0
  97 LogLevelConnection: 0
  98 LogLevelError: 15
  99 LogLevelCongestion: 0
 100 LogLevelInfo: 3
 101 MemReportFrequency: 0
 102
 103 # Backup Parameters #
 104 BackupDataBufferSize: 2M
 105 BackupLogBufferSize: 2M
 106 BackupMemory: 64M
 107 BackupWriteSize: 32K
 108 BackupMaxWriteSize: 256K
 109
 110 [MGM DEFAULT]
 111 PortNumber: 1186
 112 DataDir: /add/path/here
 113
 114 [TCP DEFAULT]
 115 SendBufferMemory: 2M
 116
 117 #######################################
 118 # Change HOST1 to the name of the NDB_MGMD host
 119 # Change HOST2 to the name of the NDB_MGMD host
 120 # Change HOST3 to the name of the NDB_MGMD host
 121 # Change HOST4 to the name of the NDBD host
 122 # Change HOST5 to the name of the NDBD host
 123 # Change HOST6 to the name of the NDBD host
 124 # Change HOST7 to the name of the NDBD host
 125 # Change HOST8 to the name of the NDBD host
 126 # Change HOST9 to the name of the NDBD host
 127 #######################################
 128
 129 [NDB_MGMD]
 130 Id: 1
 131 HostName: HOST1
 132 ArbitrationRank: 1
 133
 134 [NDB_MGMD]
 135 Id: 2
 136 HostName: HOST2
 137 ArbitrationRank: 1
 138
 139 [NDB_MGMD]
 140 Id: 3
 141 HostName: HOST3
 142 ArbitrationRank: 1
 143
 144 [NDBD]
 145 Id: 4
 146 HostName: HOST4
 147
 148 [NDBD]
 149 Id: 5
 150 HostName: HOST5
 151
 152 [NDBD]
 153 Id: 6
 154 HostName: HOST6
 155
 156 [NDBD]
 157 Id: 7
 158 HostName: HOST7
 159
 160 [NDBD]
 161 Id: 8
 162 HostName: HOST8
 163
 164 [NDBD]
 165 Id: 9
 166 HostName: HOST9
 167
 168 ######################################################
 169 # Note: The following can be MySQLD connections or   #
 170 #      NDB API application connecting to the cluster #
 171 ######################################################
 172
 173 [API]
 174 Id: 10
 175 HostName: HOST1
 176 ArbitrationRank: 2
 177
 178 [API]
 179 Id: 11
 180 HostName: HOST2
 181 ArbitrationRank: 2
 182
 183 [API]
 184 Id: 12
 185 HostName: HOST3
 186
 187 [API]
 188 Id: 13
 189 HostName: HOST4
 190
 191 [API]
 192 Id: 14
 193 HostName: HOST5
 194
 195 [API]
 196 Id: 15
 197 HostName: HOST6
 198
 199 [API]
 200 Id: 16
 201 HostName: HOST7
 202
 203 [API]
 204 Id: 17
 205 HostName: HOST8
 206
 207 [API]
 208 Id: 19
 209 HostName: HOST9
 210
 211 [API]
 212 Id: 20
 213
 214 [API]
 215 Id: 21
 216
 217 [API]
 218 Id: 22
 219
 220 [API]
 221 Id: 23
 222
 223 [API]
 224 Id: 24
 225
 226 [API]
 227 Id: 25
 228