Hi,
I have test two systems with mysql Linux Slackware 7.1 kernel 2.2.16 and
FreeBSD-4.2-STABLE. I have mysql 3.23.36 only running on this two hosts and hosts are
the same (PIII 800 Mhz Ami MegaRaid RAID 1 18.2 Go 1 Go RAM).
I copy the database from FreeBSD to Linux and I launch a same select on this two hosts.
Results on FreeBSD:
mysql> select count(*) from transat;
+----------+
| count(*) |
+----------+
| 3394568 |
+----------+
1 row in set (0.00 sec)
mysql> select * from transat where id='HGUI';
(...)
| HGUI | 2001-04-20 17:35:03 | 79.7 | 8 | 0 |
| 0 | |
+-------------+---------------------+------------+-------------+-----------------+-----------------+------+
3951 rows in set (1.29 sec)
Results on Linux:
mysql> select count(*) from transat;
+----------+
| count(*) |
+----------+
| 3394568 |
+----------+
1 row in set (0.00 sec)
mysql> select * from transat where id='HGUI';
(...)
| HGUI | 2001-04-20 17:35:03 | 79.7 | 8 | 0 |
| 0 | |
+--------------+---------------------+------------+-------------+-----------------+-----------------+------+
3951 rows in set (0.16 sec)
I don't know why there is a big difference between this two systems. Somebody can
explain me why ?
Please reply to [EMAIL PROTECTED]
Thank you.
spe.
--
[EMAIL PROTECTED]
