List:General Discussion« Previous MessageNext Message »
From:gu_l Date:January 4 2007 2:38am
Subject:Err1114 The table 'sbtest' is full
View as plain text  
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)[root@ARCHITECT mysql]# ls -l ibdata1 -rw-rw----  1 mysql mysql 320864256 Jan  4 09:27 ibdata1[root@ARCHITECT 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
Thread
Err1114 The table 'sbtest' is fullgu_l4 Jan
  • Re: Err1114 The table 'sbtest' is fullViSolve DB Team5 Jan