I used sysbench to test mysql with 2000 threads and then sysbench threw some alerts below: ALERT: failed to execute mysql_stmt_execute(): Err1114 The table 'sbtest' is fullFATAL: database error, exiting...I don't know what does it mean because sbtest is not full.mysql> show create table sbtest\G*************************** 1. row *************************** Table: sbtestCreate Table: CREATE TABLE `sbtest` ( `id` int(10) unsigned NOT NULL auto_increment, `k` int(10) unsigned NOT NULL default '0', `c` char(120) NOT NULL default '', `pad` char(60) NOT NULL default '', PRIMARY KEY (`id`), KEY `k` (`k`)) ENGINE=InnoDB DEFAULT CHARSET=latin11 row in set (0.00 sec)mysql> show table status from sbtest\G*************************** 1. row *************************** Name: sbtest Engine: InnoDB Version: 10 Row_format: Compact Rows: 100092 Avg_row_length: 225 Data_length: 22593536Max_data_length: 0 Index_length: 1589248 Data_free: 0 Auto_increment: 100001 Create_time: 2007-01-04 09:25:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: InnoDB free: 58368 kB1 row in set (0.01 sec)[EMAIL PROTECTED] mysql]# ls -l ibdata1 -rw-rw---- 1 mysql mysql 320864256 Jan 4 09:27 [EMAIL PROTECTED] mysql]# cat /etc/my.cnf[mysqld]log-bin=masterlogmax_connections=3000innodb_data_file_path=ibdata1:306M:autoextendmax_prepared_stmt_count=32765#logquery_cache_size=16M#innodb_buffer_pool_size=512M#key_buffer_size=512Mserver-id=1 binlog-do-db=backup master-host=172.20.23.28master-user=backupmaster-password=backupmaster-port=3306 mysql> show variables like 'innodb_data%';+-----------------------+-------------------------+| Variable_name | Value |+-----------------------+-------------------------+| innodb_data_file_path | ibdata1:306M:autoextend | | innodb_data_home_dir | | +-----------------------+-------------------------+2 rows in set (0.00 sec)MySQL's version is 5.0.27-standard-log.OS is RHEL 4.0What should I do?ThanksGu Lei
------------------------------------------------------------------- 惠普商用台式机dc5750,高性能，低功耗！( http://ad4.sina.com.cn/sina/limeng3/mail_zhuiyu/2006/mail_zhuiyu_20061225.html ) =================================================================== 注册新浪2G免费邮箱（ http://mail.sina.com.cn/chooseMode.html ）
