I run mysql on a SuSe 7.3 and a FreeBSD 4.5 server. The FreeBSD mysql version is 3.23.49. The linux mysql version is 3.23.33.
I just copied a large table using mysqldump | mysql from the linux server to the FreeBSD server. An explain statement on a select on this table shows different row counts on both systems: #SUSE: mysql> explain select id from boardmessages where board=4301 and parent=0 order by id desc limit 0,20; +---------------+------+---------------+-------+---------+-------+-------+----------------------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---------------+------+---------------+-------+---------+-------+-------+----------------------------+ | boardmessages | ref | board,parent | board | 4 | const | 16671 | where used; Using filesort | +---------------+------+---------------+-------+---------+-------+-------+----------------------------+ #FREEBSD: mysql> explain select id from boardmessages where board=4301 and parent=0 order by id desc limit 0,20; +---------------+------+---------------+-------+---------+-------+-------+----------------------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---------------+------+---------------+-------+---------+-------+-------+----------------------------+ | boardmessages | ref | board,parent | board | 4 | const | 13629 | where used; Using filesort | +---------------+------+---------------+-------+---------+-------+-------+----------------------------+ Can anyone explain this strange deviation? s.m. --------------------------------------------------------------------- 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
