re: Mysql versions, disks, speed, FTS, and EXPLAIN feature request (SELECT [CALC_RESOURCES])

2002-12-25 Thread Victoria Reznichenko
YMMV! Just a note > on how FTS can really read a lot of data and how moving it can really > clear things up. Which brings me to: > > EXPLAIN feature request: to have EXPLAIN RESOURCES SELECT or something > similar to be able to show resource usage instead of query/index plan

Mysql versions, disks, speed, FTS, and EXPLAIN feature request (SELECT [CALC_RESOURCES])

2002-12-20 Thread Steven Roussey
me to: EXPLAIN feature request: to have EXPLAIN RESOURCES SELECT or something similar to be able to show resource usage instead of query/index plan. Resources like CPU, disk read, and disk write. Likely it should not actually be EXPLAIN, since it would do the operation (where explain does not). So maybe S

Re: EXPLAIN feature request

2002-03-20 Thread Sinisa Milivojevic
Ken Menzel writes: > Hi Guys, >I would like to request an additional feature with EXPLAIN. > EXPLAIN does not run the query guesses on how the query would be run. > This is not always accurate. The slow-log however logs the actual > information the query was run with (like explain only the tru

EXPLAIN feature request

2002-03-20 Thread Ken Menzel
Hi Guys, I would like to request an additional feature with EXPLAIN. EXPLAIN does not run the query guesses on how the query would be run. This is not always accurate. The slow-log however logs the actual information the query was run with (like explain only the truth!). Could we have an option