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: <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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)[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 ）
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
