Re: Err1114 The table 'sbtest' is full

[ViSolve DB Team]

Hi,


1. The table full error was due to temporary table size being large, which 
is created during transaction processing.  Try setting SQL_BIG_TABLES, to 
avoid over-allocating memories for other queries.

2. Since Innodb engine, the innodb tablespace might run out of space. Try to 
increase the size of the tablespace,by adding another datafile, setting to 
innodb_autoextend_increment system variable.

3. Since you are doing with 2000 threads, try increasing thread_stack 
size.Hope with this FATAL error can be fixed.



Thanks
ViSolve DB Team

----- Original Message ----- 
From: <gu_l@stripped>
To: <mysql@stripped>
Sent: Thursday, January 04, 2007 8:08 AM
Subject: Err1114 The table 'sbtest' is full


> 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 ）