Drago, you only had the default InnoDB buffer bool, that is 8 MB. InnoDB row locks CAN fill it in a big import if you have duplicate key errors in the inserted rowset.
Also, tell us your MySQL version. Regards, Heikki ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Sent: Saturday, December 20, 2003 4:50 AM Subject: Re: memory trap > One more thing - I had the following command issued: > > LOCK TABLES old WRITE; > > and then I try to insert 20GB (1+ Million records) of data. > > Drago > > > Heikki Tuuri wrote: > > > > Hi! > > > > What MySQL version you are running? > > > > Can you show us your my.cnf, so that we see how much memory you had > > allocated to the InnoDB buffer pool? > > > > Did you run some big DELETE, UPDATE, or SELECT ... FOR UPDATE, or SELECT ... > > LOCK IN SHARE MODE query at that time, so that you could really exhaust all > > the memory in the buffer pool? > > > > Best regards, > > > > Heikki > > Innobase Oy > > http://www.innodb.com > > InnoDB - transactions, row level locking, and foreign keys for MySQL > > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM > > tables > > > > Order MySQL support from http://www.mysql.com/support/index.html > > > > > > ................................................... > > List:MySQL General Discussion« Previous MessageNext Message » > > From:radev at umich dot edu Date:December 19 2003 5:38am > > Subject:memory trap > > > > > > > > 031218 20:53:48 InnoDB: WARNING: over 4 / 5 of the buffer pool is > > occupied by > > InnoDB: lock heaps or the adaptive hash index! Check that your > > InnoDB: transactions do not set too many row locks. Starting InnoDB > > InnoDB: Monitor to print diagnostics, including lock heap and hash > > index > > InnoDB: sizes. > > 031218 20:53:48 InnoDB: WARNING: over 4 / 5 of the buffer pool is > > occupied by > > InnoDB: lock heaps or the adaptive hash index! Check that your > > InnoDB: transactions do not set too many row locks. Starting InnoDB > > InnoDB: Monitor to print diagnostics, including lock heap and hash > > index > > InnoDB: sizes. > > 031218 20:53:48 InnoDB: ERROR: over 9 / 10 of the buffer pool is > > occupied by > > InnoDB: lock heaps or the adaptive hash index! > > InnoDB: We intentionally generate a seg fault to print a stack trace > > 031218 20:53:48 InnoDB: Assertion failure in thread 10 in file > > buf0lru.c line 219 > > InnoDB: We intentionally generate a memory trap. > > InnoDB: Send a detailed bug report to [EMAIL PROTECTED] > > mysqld got signal 11; > > This could be because you hit a bug. It is also possible that this > > binary > > or one of the libraries it was linked against is corrupt, improperly > > built, > > or misconfigured. This error can also be caused by malfunctioning > > hardware. > > We will try our best to scrape up some info that will hopefully help > > diagnose > > the problem, but since we have already crashed, something is > > definitely wrong > > and this may fail. > > > > key_buffer_size=8388600 > > read_buffer_size=131072 > > 031218 20:54:11 mysqld restarted > > 031218 20:54:13 InnoDB: Out of memory in additional memory pool. > > InnoDB: InnoDB will start allocating memory from the OS. > > InnoDB: You may get better performance if you configure a bigger > > InnoDB: value in the MySQL my.cnf file for > > InnoDB: innodb_additional_mem_pool_size. > > 031218 20:54:20 InnoDB: Database was not shut down normally. > > InnoDB: Starting recovery from log files... > > InnoDB: Starting log scan based on checkpoint at > > InnoDB: log sequence number 0 2898284579 > > InnoDB: Doing recovery: scanned up to log sequence number 0 2898284579 > > InnoDB: 1 transaction(s) which must be rolled back or cleaned up > > InnoDB: Trx id counter is 0 1792 > > InnoDB: Starting rollback of uncommitted transactions > > InnoDB: Rolling back trx with id 0 1298 > > > > > > > -- > Dragomir R. Radev [EMAIL PROTECTED] > Assistant Professor of Information, Electrical Engineering and > Computer Science, and Linguistics, the University of Michigan, Ann Arbor > Phone: 734-615-5225 Fax: 734-764-2475 http://www.si.umich.edu/~radev -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]