From: Johan Andersson
Date: April 20 2012 2:15pm
Subject: Re: MySQL Cluster Tuning
List-Archive: http://lists.mysql.com/cluster/8299
Message-Id: <0D8827FD-062F-4F06-BAF8-8C3B80044ACD@severalnines.com>
MIME-Version: 1.0 (Apple Message framework v1257)
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

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?
>=20
> 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
>=20
>=20
>=20
> Em 20 de abril de 2012 11:02, Antonio Modesto =
<modesto@stripped>escreveu:
>=20
>> Good morning,
>>=20
>>=20
>>   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:
>>=20
>> ERROR 1114 (HY000) at line 3818: The table 'radacct' is full
>>=20
>> Here is my config.ini:
>>=20
>> [NDBD DEFAULT]
>> NoOfReplicas: 2
>> DataDir: /usr/local/mysql/data
>> #FileSystemPath: /add/path/here
>>=20
>> # Data Memory, Index Memory, and String Memory #
>> DataMemory: 7000M
>> IndexMemory: 2000M
>> StringMemory: 5
>>=20
>> # Transaction Parameters #
>> MaxNoOfConcurrentTransactions: 4096
>> MaxNoOfConcurrentOperations: 100000
>> MaxNoOfLocalOperations: 100000
>>=20
>> # Transaction Temporary Storage #
>> MaxNoOfConcurrentIndexOperations: 8192
>> MaxNoOfFiredTriggers: 4000
>> TransactionBufferMemory: 1M
>>=20
>> # Scans and buffering #
>> MaxNoOfConcurrentScans: 300
>> MaxNoOfLocalScans: 32
>> BatchSizePerLocalScan: 64
>> LongMessageBuffer: 1M
>>=20
>> # Logging and Checkpointing #
>> NoOfFragmentLogFiles: 300
>> FragmentLogFileSize: 16M
>> MaxNoOfOpenFiles: 40
>> InitialNoOfOpenFiles: 27
>> MaxNoOfSavedMessages: 25
>>=20
>> # Metadata Objects #
>> MaxNoOfAttributes: 1500
>> MaxNoOfTables: 400
>> MaxNoOfOrderedIndexes: 200
>> MaxNoOfUniqueHashIndexes: 200
>> MaxNoOfTriggers: 770
>>=20
>> # Boolean Parameters #
>> LockPagesInMainMemory: 0
>> StopOnError: 1
>> Diskless: 0
>> ODirect: 0
>>=20
>> # 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
>>=20
>> # 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
>>=20
>> # Backup Parameters #
>> BackupDataBufferSize: 2M
>> BackupLogBufferSize: 2M
>> BackupMemory: 64M
>> BackupWriteSize: 32K
>> BackupMaxWriteSize: 256K
>>=20
>> [MGM DEFAULT]
>> PortNumber: 1186
>> DataDir: /usr/local/mysql/mysql-cluster
>>=20
>> [TCP DEFAULT]
>> SendBufferMemory: 2M
>>=20
>> #######################################
>> # 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
>> #######################################
>>=20
>> [NDB_MGMD]
>> NodeId: 1
>> HostName: 192.168.0.29
>> #ArbitrationRank: 1
>>=20
>>=20
>> [NDBD]
>> NodeId: 2
>> HostName: 192.168.0.30
>>=20
>> [NDBD]
>> NodeId: 3
>> HostName: 192.168.0.31
>>=20
>> ######################################################
>> # Note: The following can be MySQLD connections or   #
>> #      NDB API application connecting to the cluster #
>> ######################################################
>>=20
>> [API]
>> NodeId: 4
>> HostName: 192.168.0.30
>> #ArbitrationRank: 2
>>=20
>> [API]
>> NodeId: 5
>> HostName: 192.168.0.31
>> #ArbitrationRank: 2
>>=20
>>=20
>> 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).
>>=20
>>=20
>>=20