Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-1648

Large inserts in Mysql are slow - Ffej says batch them

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: unspecified
    • Fix Version/s: None
    • Component/s: Administrative Tools
    • Labels:
      None
    • Environment:

      Operating System: Linux
      Platform: PC

    • Bugzilla Id:
      2977

      Description

      in whsumm for maverick names I see things like:

      2009-05-21 08:42:56.649 (3) [P0T9]: ... 2278277 Monthly Source Perf Records Inserted
      2009-05-21 08:43:14.633 (3) [P0T9]: ... 3009 Monthly Source Conversion Records
      Inserted
      2009-05-21 09:38:56.569 (3) [P0T9]: ... 2277834 Monthly Source Attribute Records
      Inserted
      2009-05-21 09:41:47.583 (3) [P0T9]: ... 2712 Monthly Group Perf Records Inserted
      2009-05-21 09:41:51.869 (3) [P0T9]: ... 2292 Monthly Group Conversion Records
      Inserted
      2009-05-21 09:42:02.314 (3) [P0T9]: ... 2434 Monthly Group Attribute Records
      Inserted
      2009-05-21 11:45:02.824 (3) [P0T9]: ... 2278277 Monthly Source Perf Records Inserted
      2009-05-21 11:45:25.799 (3) [P0T9]: ... 3011 Monthly Source Conversion Records
      Inserted

      Inserting 2.5 million records at a go will make MYSQL cranky. Ffej says batch them.

        Attachments

          Activity

            People

            • Assignee:
              therouxj Jeff Theroux
              Reporter:
              bduffy Bill Duffy (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: