Hello, I work with a MySQL server version 3.23 and MyIsam tables where records are inserted real time, betweek 10 and 50 records per second until the table reaches 10 million records, where one other table is started.
I already have a PRIMARY KEY on this table and the current index "size" is around 300 Megs on disk for 10 millions records. I am willing to add 3 other indexes, but they won't be unique indexes, and for one of them the field will be NULL for 25% of the records, meaning that the index may be weird and that insertion may need some time to find where to insert this NULL key in the index. The new index file size is 500 Megs when built from scratch. I had huge problems on a Microsoft SQL server some years ago doing this because it was "overflowing index pages", does someone has some experience on MyISAM ? Any idea about performance impact of this change ? The server is a dual P3, 1 gig RAM, with hardware raid, only doing this. Regards, -- Benoît Grangé Directeur réseau, Tiscali Télécom 37 rue Greneta, 75002 Paris (plan) tel: +33 1 45 08 24 68 fax: +33 1 45 08 20 01 --------------------------------------------------------------------- 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
