Speeding up inserts in InnoDB

2010-04-22 Thread Chris W
I have a very simple table. CREATE TABLE `hams`.`phoneticcallsign` ( `CallSign` char(6) NOT NULL, `PhoneticCallSign` char(6) NOT NULL, PRIMARY KEY (`CallSign`), KEY `PhoneticIdx` (`PhoneticCallSign`) USING BTREE ) I inserted a little over 1 million records with CallSign = to a value from

Re: Speeding up inserts in InnoDB

2010-04-22 Thread Johnny Withers
I'm a little confused.. are the inserts slow, or are the updates slow? It sounds like you mean the updates were going about 50/updates sec. You could speed up the update by adding an index on phoneticcallsign.CallSign. JW On Thu, Apr 22, 2010 at 10:13 AM, Chris W 4rfv...@cox.net wrote: I have

Re: Speeding up inserts in InnoDB

2010-04-22 Thread Chris W
Sorry I misspoke, I am doing updates not inserts. If I was doing inserts I thought about the multiple record at a time idea but unless there is something I don't know, I don't think you can do that with updates. I will look into turning autocommit off and see what that does. Chris W.

Speeding up Inserts

2004-05-25 Thread Amit_Wadhwa
Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to remove indexes? And to speed up selectes, ...add the indexes again? Regards, Amit -- MySQL General

Re: Speeding up Inserts

2004-05-25 Thread cristi
well, you could try mass insertion... instead of inserting each row one by one -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Speeding up Inserts

2004-05-25 Thread Mirza
Use: ALTER TABLE DISABLE KEYS ... inserts here ALTER TABLE ENABLE KEYS mirza [EMAIL PROTECTED] wrote: Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to

RE: Speeding up Inserts

2004-05-25 Thread Amit_Wadhwa
That fixed it, Thanks! -Original Message- From: Mirza [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 7:46 PM To: [EMAIL PROTECTED] Subject: Re: Speeding up Inserts Use: ALTER TABLE DISABLE KEYS ... inserts here ALTER TABLE ENABLE KEYS mirza [EMAIL PROTECTED] wrote: Hi

Re: Speeding up Inserts

2004-05-25 Thread mos
At 08:55 AM 5/25/2004, you wrote: Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to remove indexes? And to speed up selectes, ...add the indexes again?

Re: Speeding up Inserts

2004-05-25 Thread Egor Egorov
[EMAIL PROTECTED] wrote: Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to remove indexes? And to speed up selectes, ...add the indexes again? Take a look at

RE: Speeding up Inserts

2004-05-25 Thread Amit_Wadhwa
:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 7:57 PM To: [EMAIL PROTECTED] Subject: Re: Speeding up Inserts At 08:55 AM 5/25/2004, you wrote: Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time

RE: Speeding up Inserts

2004-05-25 Thread mos
Ignore to ignore the row when a row already exists with the same unique index/primary key. Mike -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 7:57 PM To: [EMAIL PROTECTED] Subject: Re: Speeding up Inserts At 08:55 AM 5/25/2004, you wrote: Hi All, Whats