Hi,
We upgrade one of our servers, but physical and mysql from 3.23.55-max-log to 3.23.58-max-log and run into some problems with a few queries. This is the old server: mysql> explain select count(id) from table where entered > date_sub(now(), INTERVAL 15 DAY) and DAYOFYEAR(entered) = DAYOFYEAR(date_sub(now(), INTERVAL 14 DAY)) and status in (1, 2); +--------+-------+----------------------------+---------------+---------+------+-------+------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +--------+-------+----------------------------+---------------+---------+------+-------+------------+ | table | range | IDX_orders_2,IDX_orders_12 | IDX_orders_12 | 4 | NULL | 49681 | where used | +--------+-------+----------------------------+---------------+---------+------+-------+------------+ 1 row in set (0.02 sec) What we did in the move was copy the *.frm and *.MYD and head -c 2048 on every *.MYI and then myisamchk -qr <table> On the new server the _exakt same_ explain query gives me: +--------+------+---------------+------+---------+------+---------+------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +--------+------+---------------+------+---------+------+---------+------------+ | orders | ALL | IDX_orders_12 | NULL | NULL | NULL | 1841825 | where used | +--------+------+---------------+------+---------+------+---------+------------+ 1 row in set (0.00 sec) Looking for explanations. br Robin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
