Deadlock problem

Hi Can somebody help me to figure out why this deadlock happen? Thanks = 050405 9:12:17 INNODB MONITOR OUTPUT = Per second averages calculated from the last 50 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reser

question to locks on an update statement

Hi I saw following example in the documentation on chapter 15.5 when you look at the property "innodb_locks_unsafe_for_binlog": Example from the docu START--- CREATE TABLE A(A INT NOT NULL, B INT); INSERT INTO A VALUES

Re: InnoDB Performance

The MyIsam storage engine is a non transactional engine and InnoDb is a transactional engine. That is the main difference. So I think the MyIsam engine should be faster. Try to adjust the "innodb_thread_concurrency" parameter when you have a lot of users. Reto Marcin Lewandowski wrote: Hi, I'v

Re: InnoDB Performance

see this link http://dev.mysql.com/doc/mysql/en/ansi-diff-transactions.html Reto Eko Budiharto wrote: The MyIsam storage engine is a non transactional engine and InnoDb is a transactional engine. That is the main difference. So I think the MyIsam engine should be faster. what is transactional mea

Why is this table lock?

Hi In the output from the show innodb monitor I can see, that I have a table lock on a table. But, I never set a table lock on a table (only row locks). Do I misinterpret the output or what causes this table lock? thanks Reto TRANSACTIONS Trx id counter 0 95338708 Pur

Null values in a csv file and import to a mssql database

Hi I exported data from a mysql database to a csv file. Null values are exported as \N. When I import this csv file with the dts service from MSSql then I receive the following error when a null value (\N) is read: Error: -2147213268 (8004202C); Provider Error: 0 (0) Error string: Transform