List:Cluster« Previous MessageNext Message »
From:Johan Andersson Date:April 20 2012 2:15pm
Subject:Re: MySQL Cluster Tuning
View as plain text  
Hi,

Please do:

ndb_mgm
ndb_mgm> all report memory

Or use a Management/monitoring tool.

Best regards,
Johan Andersson
Severalnines AB



On Apr 20, 2012, at 4:13 PM, Wagner Bianchi wrote:

> 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