When I use the statement:
EXPLAIN SELECT * FROM workunits WHERE Sent>0
It returns
+-----------+------+---------------+--------+---------+--------+---------+--
----------+
| table | type | possible_keys | key | key_len | ref | rows |
Extra |
+-----------+------+---------------+--------+---------+--------+---------+--
----------+
| workunits | ALL | [NULL] | [NULL] | [NULL] | [NULL] | 2297055 |
where used |
+-----------+------+---------------+--------+---------+--------+---------+--
----------+
Which is the same as performing:
EXPLAIN SELECT * FROM workunits
But If I
SELECT * FROM `workunits` WHERE Sent>0
I Get:
+----------------+-------+--------+-------+--------+-------+--------+------+
----------------+----------------+----------------+
| wuid | ETilt | ETilt2 | MTilt | MTilt2 | STilt | STilt2 | Sent |
ProcessByHost1 | ProcessByHost2 | ProcessByHost3 |
+----------------+-------+--------+-------+--------+-------+--------+------+
----------------+----------------+----------------+
| 2222.11.6267.1 | 22 | 22.1 | 1.6 | 2 | 6 | 7.1 | 2 |
2 | 1 | 0 |
| 2222.11.6267 | 22 | 22.1 | 1.6 | 2 | 6 | 7 | 2 |
2 | 1 | 0 |
| 2222.11.6266.9 | 22 | 22.1 | 1.6 | 2 | 6 | 6.9 | 2 |
2 | 1 | 0 |
| 2222.11.6266.8 | 22 | 22.1 | 1.6 | 2 | 6 | 6.8 | 2 |
2 | 1 | 0 |
| 2222.11.6266.7 | 22 | 22.1 | 1.6 | 2 | 6 | 6.7 | 1 |
2 | 0 | 0 |
| 2222.11.6266.6 | 22 | 22.1 | 1.6 | 2 | 6 | 6.6 | 1 |
2 | 0 | 0 |
+----------------+-------+--------+-------+--------+-------+--------+------+
----------------+----------------+----------------+
Only 6 rows in set
I am using MySQLd 3.23.44
If I should upgrade which is probably a good idea, what version should I
get?
Chris
Attachment: [text/html]
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.5.2 - Release Date: 28/02/2005
