List:General Discussion« Previous MessageNext Message »
From:matt ryan Date:August 19 2004 4:42pm
Subject:Re: 1 day 28 min insert
View as plain text  
Andrew Pattison wrote:

> I'm guessing that you have indexes on the 321st_stat table? If this is 
> the case, try dropping them before you do the insert, then rebuilding 
> them. MySQL is known to be slow at doing bulk inserts on indexed 
> tables. Also, updates are much faster than inserts since with inserts 
> there are much more disk IOs required.
>
> Cheers
>
Table has a large primary key, to keep duplicates out, so I cant drop 
the index and remove.

Also, reindexing the table takes all day, dropping is not an option

Would I be better off doing an insert replace on all  17m new records, 
or only inserting the 500 new records using insert ignore ?
Thread
1 day 28 min insertmatt ryan19 Aug
  • Re: 1 day 28 min insertAndrew Pattison19 Aug
    • Re: 1 day 28 min insertmatt ryan19 Aug
      • Re: 1 day 28 min insertSGreen19 Aug
    • Re: 1 day 28 min insertSGreen19 Aug
  • Re: 1 day 28 min insertDan Nelson19 Aug
    • Re: 1 day 28 min insertmatt ryan19 Aug
      • Re: 1 day 28 min insertDan Nelson19 Aug
        • RE: 1 day 28 min insertBoyd E. Hemphill19 Aug
          • Re: 1 day 28 min insertmatt ryan19 Aug
            • Re: 1 day 28 min insertRemigiusz SokoĊ‚owski20 Aug
              • RE: 1 day 28 min insertDonny Simonton20 Aug
  • Re: 1 day 28 min insertRhino19 Aug
  • Re: 1 day 28 min insertMikhail Entaltsev20 Aug
    • Re: 1 day 28 min insertmatt ryan27 Aug
  • Re: 1 day 28 min insertMikhail Entaltsev27 Aug
    • Re: 1 day 28 min insertmatt ryan27 Aug
      • Re: 1 day 28 min insertSGreen27 Aug
        • Re: 1 day 28 min insertMikhail Entaltsev27 Aug
          • Re: 1 day 28 min insertSGreen27 Aug
            • Re: 1 day 28 min insertMikhail Entaltsev27 Aug
          • Re: 1 day 28 min insertmatt ryan1 Sep
  • Re: 1 day 28 min insertMikhail Entaltsev27 Aug