A good idea, thanks very much.
--
Thanks & Regards
Chylli
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The default charset of c is utf8, and that of a and b is latin1.
Maybe charset cause size of table increased?
--
Thanks & Regards
Chylli
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
chylli <[EMAIL PROTECTED]> writes:
> Chris <[EMAIL PROTECTED]> writes:
>
>>
>> Because you're adding all columns from a and b into it.
>>
>>> It is too slow. Has anyone better methods to do that work?
>>
>> Drop the indexes on c an
Chris <[EMAIL PROTECTED]> writes:
> chylli wrote:
>> I run following command :
>> use db1;
>> insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on
>> (a.id=b.id);
>
> Do you have an index on a.id and b.id ?
>
>> size of ta
I run following command :
use db1;
insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on
(a.id=b.id);
size of table a and table b is:
[EMAIL PROTECTED] ls -l ../db1/a.*
-rw-rw 1 mysql mysql 9230 May 10 15:41 ../db1/a.frm
-rw-rw 1 mysql mysql 880880528 Jul 17 01