| Heikki Tuuri 2006-01-03, 3:23 am |
| John,
this SQL statement:
sets locks on all the records it scans in TV_LOG_ALL. If you have a small
buffer pool, then the InnoDB lock table may indeed grow so big that it does
not fit in the buffer pool. The default size of the buffer pool is just 8
MB.
Fix: modify my.cnf and increase innodb_buffer_pool_s
ize. But do not make it
bigger than about 70 % of your computer's RAM.
Best regards,
Heikki
Oracle Corp./Innobase Oy
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
http://www.innodb.com/order.php
----- Original Message -----
From: "Danny Stolle" <danny-boy@chello.nl>
Newsgroups: mailing.database.myodbc
Sent: Monday, January 02, 2006 9:31 PM
Subject: Re: Table Lock issue on insert
[color=darkred]
> Hi John,
>
> I have looked around a bit and you might be interested in this part:
>
> InnoDB: Do not intentionally crash mysqld if the buffer pool is
> exhausted by the lock table; return error 1206 instead ...
>
> check this link: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-8.html
>
> it is quite interesting and i am trying to get this error on my mysql
> databases by changing the bufferpool and inserting a lot of data;
>
> Best regards,
>
> Danny
>
> Brittingham, John wrote:
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|