Hi,
Do anyone know there may be a limitation in mysql to do a 15 tables equi-join?
I did some experiment with it if I only do 10 tables equi-join, it takes seconds to
retrieve the results,
but if I do more than 10 tables, it took forever and run with 100% CPU time to execute
the query.
The
Hi,
Does anybody know how to copy an existing mySQL table schema with varchar datatype
my sql statement is:
CREATE TABLE new_table AS SELECT * FROM old_table where 1=0;
All the text columns in the old_table are in VARCHAR datatype, however,
after I copy to a new_table, all columns change to CH
Hi,
It happens to me, just make sure you are not using any symbolic link, when I try to
use symbolic link to mysql 4.0.0-aplha and it won't work. In my case, I just do "mv
mysql-4.0.0-alpha-pc-linux-gnu-i686 mysql" and it works.
Wai Lee
Zeborg Inc.
-Original Message-
similar function like Oracle to check "NOT
EXISTS" or there is a better queries than what I use here.
Thanks
Wai Lee
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
innodb_buffer_pool_size=300M
>set-variable = innodb_additional_mem_pool_size=20M
>set-variable = innodb_file_io_threads=4
>set-variable = innodb_lock_wait_timeout=50
>set-variable=tmp_table_size=500M
>
>Wai Lee
>Zeborg
Regards,
Heikki
http://www.innodb.com/ibman.html
--
db_log_archive=0
set-variable = innodb_buffer_pool_size=300M
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
set-variable=tmp_table_size=500M
Wai Lee
Zeborg
umn I use
is VARCHAR(40), and I am not sure when I use
create index idx1 on transaction(vendor_id(20));
will help???
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 10:53 AM
To: Wai Lee
Cc: [EMAIL PROTECTED]
Subject: Re: Indexing Prob
Hi all,
Can someone tell me how to speed up the index creation???
I am trying to build an index for a 13,875,354 records(13 million) table
with 176,322 distinct vendor_id(VARCHAR(40)) in the table.
the existing size of the transaction table:
transaction.MYD = 2,128,954,624 bytes
transaction.MYI
Hi,
I am experiencing a very slow performance while I am building an index on a
table. The following are some facts of system and the table I am dealing
with:
Table size: 13,857,354
Number of distinct value in the column I use as index: 176,322
Platform: Linux system with dual CPUs 1G Hz and 4G
