MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: INSERT/UPDATE within transactions (autocommit=0)
Posted by: Rick James
Date: July 28, 2010 12:08AM

A bad combination: 
   `id` bigint(20) unsigned NOT NULL auto_increment,
   PRIMARY KEY (`id`,`created`),
I worry that it will cause trouble with id not being unique.

How much RAM do you have? 64-bit MySQL?

A little speed could be had by turning this off:
innodb doublewrite

FOREIGN KEY has overhead -- a check into the other table.

Anything in the slowlog?

How many rows in the tables?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
INSERT/UPDATE within transactions (autocommit=0)
6330
Alexander Golubowitsch
July 26, 2010 10:15AM
Re: INSERT/UPDATE within transactions (autocommit=0)
1703
Rick James
July 28, 2010 12:08AM
Re: INSERT/UPDATE within transactions (autocommit=0)
2016
Alexander Golubowitsch
July 28, 2010 01:03PM
Re: INSERT/UPDATE within transactions (autocommit=0)
1903
Rick James
July 28, 2010 08:12PM
Re: INSERT/UPDATE within transactions (autocommit=0)
1797
Alexander Golubowitsch
August 05, 2010 03:18AM
Re: INSERT/UPDATE within transactions (autocommit=0)
1688
Rick James
August 05, 2010 08:29AM
Re: INSERT/UPDATE within transactions (autocommit=0)
1647
Alexander Golubowitsch
August 05, 2010 08:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.