List:General Discussion« Previous MessageNext Message »
From:Mikhail Entaltsev Date:August 27 2004 3:00pm
Subject:Re: 1 day 28 min insert
View as plain text  
Could you execute "show create table 321st_stat" and "show create table
stat_in"
and send results back?

Best regards, Mikhail.


----- Original Message ----- 
From: "matt ryan" <matt_lists@stripped>
Cc: <mysql@stripped>
Sent: Friday, August 27, 2004 4:45 PM
Subject: Re: 1 day 28 min insert


> Mikhail Entaltsev wrote:
>
> >Hi,
> >
> >insert into 321st_stat select * from stat_in group by <primary key fields
> >from 321st_stat table>;
> >
> >did you try to use this query?
> >
> >Best regards,
> >Mikhail.
> >
> >
>
> Ran it, it took at least 24 hours, it finished but never gave me the
> total time, when I checked the server mysql dropped me back to the
> command prompt, with no time or number of records :(
>
> Matt
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

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