[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 11, 2006 9:47 AM
To: MySQL General
Subject: [SPAM] - Re: mysql 5 - disk bound - fixed - Email found in
subject
2006/1/11, George Law <[EMAIL PROTECTED]>:
> Hi All,
>
>
[snip]
>
> I have to work on an automatic way to rotate these t
2006/1/11, George Law <[EMAIL PROTECTED]>:
> Hi All,
>
>
[snip]
>
> 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?
>
I believe CREATE TABLE newtbl SELECT blah... is what you'r
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 da
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 millio
RE: mysql 5 - disk bound ?Replying to my own message.
Both of these tables have several indexes.
As mentioned before, My myisam_sort_buffer_size is fairly large :
myisam_sort_buffer_size | 134217728
alter table xxx disable keys
(But this table is INNODB)
I tried alter table xx
Hi All,
I have a question for you all.
Working with 2 innodb tables. One is a table of cdrs (call detail
records) with 33 columns and 7 million + rows. Second table is a clone
of the first, meant as a "work" table.
>From the mysql command line client, I gave the query :
insert into table2 sele
