List:Cluster« Previous MessageNext Message »
From:Wagner Bianchi Date:April 20 2012 2:13pm
Subject:Re: MySQL Cluster Tuning
View as plain text  
Did you check LOGFILE GROUP actual space or cluster log file to check
cluster's log messages?

Best wishes,
--
*Wagner Bianchi, Oracle ACE* - *wagnerbianchi.com*
*Blog:* wagnerbianchi.com/blog
*Mobile:* +55 (31) 8654 - 9510
*LinkedIn*: http://br.linkedin.com/in/wagnerbianchi
*Twitter*: @wagnerbianchijr
*Skype*: wbianchijr



Em 20 de abril de 2012 11:02, Antonio Modesto <modesto@stripped>escreveu:

> Good morning,
>
>
>    I'm trying to configure a cluster to use it as a backend to a radius
> system, However I'm with a problem to import my database to it, when I
> try to import, I get the following error:
>
> ERROR 1114 (HY000) at line 3818: The table 'radacct' is full
>
> Here is my config.ini:
>
> [NDBD DEFAULT]
> NoOfReplicas: 2
> DataDir: /usr/local/mysql/data
> #FileSystemPath: /add/path/here
>
> # Data Memory, Index Memory, and String Memory #
> DataMemory: 7000M
> IndexMemory: 2000M
> StringMemory: 5
>
> # Transaction Parameters #
> MaxNoOfConcurrentTransactions: 4096
> MaxNoOfConcurrentOperations: 100000
> MaxNoOfLocalOperations: 100000
>
> # Transaction Temporary Storage #
> MaxNoOfConcurrentIndexOperations: 8192
> MaxNoOfFiredTriggers: 4000
> TransactionBufferMemory: 1M
>
> # Scans and buffering #
> MaxNoOfConcurrentScans: 300
> MaxNoOfLocalScans: 32
> BatchSizePerLocalScan: 64
> LongMessageBuffer: 1M
>
> # Logging and Checkpointing #
> NoOfFragmentLogFiles: 300
> FragmentLogFileSize: 16M
> MaxNoOfOpenFiles: 40
> InitialNoOfOpenFiles: 27
> MaxNoOfSavedMessages: 25
>
> # Metadata Objects #
> MaxNoOfAttributes: 1500
> MaxNoOfTables: 400
> MaxNoOfOrderedIndexes: 200
> MaxNoOfUniqueHashIndexes: 200
> MaxNoOfTriggers: 770
>
> # Boolean Parameters #
> LockPagesInMainMemory: 0
> StopOnError: 1
> Diskless: 0
> ODirect: 0
>
> # Controlling Timeouts, Intervals, and Disk Paging #
> TimeBetweenWatchDogCheck: 6000
> TimeBetweenWatchDogCheckInitial: 6000
> StartPartialTimeout: 30000
> StartPartitionedTimeout: 60000
> StartFailureTimeout: 1000000
> HeartbeatIntervalDbDb: 2000
> HeartbeatIntervalDbApi: 3000
> TimeBetweenLocalCheckpoints: 20
> TimeBetweenGlobalCheckpoints: 2000
> TransactionInactiveTimeout: 0
> TransactionDeadlockDetectionTimeout: 1200
> DiskSyncSize: 4M
> DiskCheckpointSpeed: 10M
> DiskCheckpointSpeedInRestart: 100M
> ArbitrationTimeout: 10
>
> # Buffering and Logging #
> UndoIndexBuffer: 2M
> UndoDataBuffer: 1M
> RedoBuffer: 32M
> LogLevelStartup: 15
> LogLevelShutdown: 3
> LogLevelStatistic: 0
> LogLevelCheckpoint: 0
> LogLevelNodeRestart: 0
> LogLevelConnection: 0
> LogLevelError: 15
> LogLevelCongestion: 0
> LogLevelInfo: 3
> MemReportFrequency: 0
>
> # Backup Parameters #
> BackupDataBufferSize: 2M
> BackupLogBufferSize: 2M
> BackupMemory: 64M
> BackupWriteSize: 32K
> BackupMaxWriteSize: 256K
>
> [MGM DEFAULT]
> PortNumber: 1186
> DataDir: /usr/local/mysql/mysql-cluster
>
> [TCP DEFAULT]
> SendBufferMemory: 2M
>
> #######################################
> # Change HOST1 to the name of the NDB_MGMD host
> # Change HOST2 to the name of the NDB_MGMD host
> # Change HOST3 to the name of the NDB_MGMD host
> # Change HOST4 to the name of the NDBD host
> # Change HOST5 to the name of the NDBD host
> # Change HOST6 to the name of the NDBD host
> # Change HOST7 to the name of the NDBD host
> # Change HOST8 to the name of the NDBD host
> # Change HOST9 to the name of the NDBD host
> #######################################
>
> [NDB_MGMD]
> NodeId: 1
> HostName: 192.168.0.29
> #ArbitrationRank: 1
>
>
> [NDBD]
> NodeId: 2
> HostName: 192.168.0.30
>
> [NDBD]
> NodeId: 3
> HostName: 192.168.0.31
>
> ######################################################
> # Note: The following can be MySQLD connections or   #
> #      NDB API application connecting to the cluster #
> ######################################################
>
> [API]
> NodeId: 4
> HostName: 192.168.0.30
> #ArbitrationRank: 2
>
> [API]
> NodeId: 5
> HostName: 192.168.0.31
> #ArbitrationRank: 2
>
>
> I've asked it sometime ago at the freeradius user list, they told me
> that my cluster could be full, but I don't know how to tell if my
> cluster is full, in theory the 2 data nodes have enough RAM to host the
> database (This database is 3.9GB).
>
>
>

Thread
MySQL Cluster TuningAntonio Modesto20 Apr
  • Re: MySQL Cluster TuningWagner Bianchi20 Apr
    • Re: MySQL Cluster TuningJohan Andersson20 Apr
      • Re: MySQL Cluster Tuningfranco riggi20 Apr