Hi! When running a query like: LOAD DATA CONCURRENT INFILE '...' REPLACE INTO TABLE l_data FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' (list_id,email,f1,f2,f3)
mysql seems to forget to invalidate the query cache, because added rows are not displayed in following SELECT statements. this happens for sure when there are some existing rows in the table that get updatet by this query. however the index kardinalities are updated! table structure: CREATE TABLE l_data ( id int(10) unsigned NOT NULL auto_increment, list_id int(10) unsigned NOT NULL default '0', email varchar(200) NOT NULL default '', f1 varchar(255) NOT NULL default '', f2 varchar(255) NOT NULL default '', f3 varchar(255) NOT NULL default '', sent int(10) unsigned NOT NULL default '0', timestamp timestamp(14) NOT NULL, PRIMARY KEY (id), UNIQUE KEY combo2 (list_id,email) ) TYPE=MyISAM; fix: just run a 'RESET QUERY CACHE' after the insert statement above. following select statements now do show all records as expected. so it seems like a mysql bug and should be fixed. corin --------------------------------------------------------------------- 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
