List:Cluster« Previous MessageNext Message »
From:franco riggi Date:April 20 2012 2:38pm
Subject:Re: MySQL Cluster Tuning
View as plain text  
Hi Antonio,

In case your database is full, I suggest you to:

1) do a database backup using ndb way (ndb_mgm> START BACKUP; )
2) increase DataMemory
3) do a rolling restart  (
http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-rolling-restart.html)
4) restore backup with ndb_restore

I hope this can help.

Regards,
Francesco


2012/4/20 Johan Andersson <johan@stripped>

> 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).
> >>
> >>
> >>
>
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:    http://lists.mysql.com/cluster
>
>

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