Mark kirkwood wrote:
>
> Dear List,
>
> I have a (standard table handler ) table defined as follows :
>
> CREATE TABLE fact0 ( d0key INTEGER,
> d1key INTEGER,
> d2key INTEGER,
> val INTEGER,
> filler VARCHAR(200)
> );
>
> I then LOAD 3000000 rows into it ( about 350Mb)
> This takes about 2m30s on my ( fairly old ) hardware ( I think this is quite
> fast ).
>
> Distribution wise the d0key values are loaded in order. there are 300
> distinct d0keys, 300 distinct d0keys and 100 distinct d2keys.
>
> The next step is creating an index as follows :
>
> CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;
>
> Whichunfortunatly takes about 20m ( which I think is a bit slow )
>
> Here is my relevant .cnf configuration : ( I am using 3.23.39 compiled from
> source with gcc 2.96 on Mandrake 8.0 )
>
> [mysqld]
> port = 3306
> socket = /tmp/mysql.sock
> skip-locking
> set-variable = key_buffer=16M
> set-variable = max_allowed_packet=1M
> set-variable = table_cache=100
> set-variable = sort_buffer=10M
> set-variable = join_buffer=16M
> set-variable = record_buffer=5M
> set-variable = myisam_sort_buffer_size=32M
> set-variable = thread_cache=8
>
> any suggestions ? ( as I would love to create indexes faster ! )
>
> regards
>
> Mark
>
Hi,
Try with a bigger key_buffer.
You will get better performance if key_buffer is greater than your index.
Regards
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
