Considering the fact that that InnoDB makes the locks on the row level, not like the MyISAM on the table level, for the MySQL it would not say that I'm locking table x, but for it, it would be I'm locking in table x rows 1,5,2,9 .... well actually this thing really takes space, so if have newly tried to use InnoDB, you would usually have this error (ERROR 1206 (HY000): The total number of locks exceeds the lock table size) When performing large transactions. to fix this problem, you need to go to your configuration file (
my.cnf) and look for the option innodb_buffer_pool_size try to raise it's value, this had actually worked with me.
Hope this information was useful
--
Ala'a A. Ibrahim
http://360.yahoo.com/bai_83http://alaa83.blogspot.com/
_______________________________________________
General mailing list
[email protected]
http://mail.jolug.org/mailman/listinfo/general_jolug.org
