select problem...???

[Tatyana]

Hi All,
I have a medium sized InnoDB table with about 5 million rows. Each row is timestamped with a "insertion_datetime" datetime entry. but while executing:

select insertion_datetime from mytable order by insertion_datetime limit 1;

i.e. ok, but with:

select min(insertion_datetime) from mytable;

the query doesn't complete. While running, mysqld consume little in the way of processor resources, but system iowait is through the roof. Any ideas? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Ivy]

As aggregate functions are not particularly well optimised. so, consider upgrading to the latest 4.1 release, since performance has been improved in a variety of ways, along with a large number of bug fixes. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --