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