mysql ndbcluster table is full_ndbcluster 求助,报错table is full

本帖最后由 flyingwww 于 2012-11-30 09:41 编辑

Mysql 集群(NDBCLUSTER)。版本是5.5.27

现在报个错(table is full)，数据插不进去。不管哪一张表都插入不了，查询都没问题，谁知道是哪个参数设置不对吗。服务器上的配置参数如下。

NDBMGM:

[NDBD DEFAULT]

# Data Memory, Index Memory, and String Memory #

NoOfReplicas= 2

DataMemory=16G

IndexMemory=4G

# Transaction Parameters #

MaxNoOfConcurrentTransactions=8192

MaxNoOfConcurrentOperations=100000

MaxNoOfLocalOperations=110000

MaxNoOfAttributes=250000

MaxNoOfTables = 1600

MaxNoOfOrderedIndexes=25000

NoOfFragmentLogFiles=300

TimeBetweenLocalCheckpoints=20

FragmentLogFileSize=512M

RedoBuffer=312M

# Transaction Temporary Storage #

MaxNoOfConcurrentIndexOperations=8192

MaxNoOfFiredTriggers=4000

TransactionBufferMemory=1M

# Scans and buffering #

MaxNoOfConcurrentScans=300

MaxNoOfLocalScans=32

BatchSizePerLocalScan=64

LongMessageBuffer=1M

# Logging and Checkpointing #

MaxNoOfOpenFiles=40

InitialNoOfOpenFiles=27

MaxNoOfSavedMessages=25

# Metadata Objects #

MaxNoOfUniqueHashIndexes=200

MaxNoOfTriggers=770

# Controlling Timeouts, Intervals, and Disk Paging #

TimeBetweenWatchDogCheck=6000

TimeBetweenWatchDogCheckInitial=6000

StartPartialTimeout=30000

StartPartitionedTimeout=60000

StartFailureTimeout=1000000

HeartbeatIntervalDbDb=2000

HeartbeatIntervalDbApi=3000

TimeBetweenGlobalCheckpoints=2000

TransactionInactiveTimeout=0

TransactionDeadlockDetectionTimeout=1200

DiskSyncSize=4M

DiskCheckpointSpeed=10M

DiskCheckpointSpeedInRestart=100M

ArbitrationTimeout=10

# Buffering and Logging #

UndoIndexBuffer=2M

UndoDataBuffer=1M

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

MYSQLD:

[mysqld]

ndbcluster

datadir=/usr/local/mysql/ndb1data

basedir=/usr/local/mysql

pid-file=/usr/local/mysql/n1.pid

log-error=/usr/local/mysql/n1_err.log

slow_query_log_file=/usr/loca/mysql/n1_slow.log

character_set_server=utf8

lower_case_table_names=1

tmp_table_size = 4096M

max_heap_table_size = 4096M

default-storage-engine=ndbcluster

max_connections = 300

max_connect_errors = 50

port=3306

skip-external-locking

key_buffer_size = 384M

max_allowed_packet = 1M

table_open_cache = 512

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size = 8M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size = 32M

[mysqldump]

quick

max_allowed_packet = 16M

[myisamchk]

key_buffer_size = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M