CREATE TABLE blah LIKE old_table On 1/11/06, George Law <[EMAIL PROTECTED]> wrote: > Hi All, > > > > Just another follow up on my emails. > > > > What this came down to was sheer number of records and indices in my > tables causing it to take several minutes to insert 10-20K records via > "load data ..." > > > > table1 has probably 15 million rows, 60 fields per row, 1 index > > table2 has 7 million rows, 33 fields per row, 5 indices > > This is approx 2 months worth of data > > > > > > 2006-01-11 06:37:11 : begin import into table1 > 2006-01-11 06:43:14: end import into table1 records (17315) deleted : > (0) skipped (0) warnings:(0) > > > > 2006-01-11 06:43:42 : begin import into table2 > 2006-01-11 06:48:19 : import into table2 records: (16197) deleted:(0) > skipped: (0) warnings:(0) > > > > > > > > This morning, I created 2 new tables, renamed the original tables and > rotated the new tables in. > > > > 2006-01-11 08:46:16 : begin import into table1 > 2006-01-11 08:46:17: end import into table1 records (18853) deleted : > (0) skipped (0) warnings:(0) > > > > 2006-01-11 08:46:52 : begin import into table2 > 2006-01-11 08:46:55 : import into table2 records: (17615) deleted:(0) > skipped: (0) warnings:(0) > > > > This is mysql 5.0.18, running on a HP Proliant, dual P4 3 GHZ, 4 GB RAM, > running Suse 9.3, so I do not believe it is hardware related > > > > > > I have to work on an automatic way to rotate these tables every week. > Is there an easy way with SQL to create a new table based on the schema > of an existing table? > > -- > > Thanks! > > > > George Law > > > > > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
