> One of my favorite Borg quotes is: "Crude but effective." :-)
I like that. ;)
This got me thinking again about a feature I'd like to see in mysqld. I'd
like to add something like SQL_STATISTICS to SELECT/UPDATE/INSERT
statements. The idea would be that if this keyword was used, then mysqld
would calculate additional statistics for that query (which you could get
later with SHOW SQL_STATISTICS or something).
The statistics would include actual numbers from the processing of the
query:
# of index records read
# of data section records read
# bytes requested from file system (read & write)
[this being the most important]
# CPU time
# Disk read, write, and wait times
etc...
Such information would be extremely valuable. For example, it wasn't until I
put fulltext on separate server that I would discover what a disk read hog
it was:
Main server: 3000 q/s Disk read: 540 KB/s Load: 1
FTS server: 2 q/s Disk read: 7600 KB/s Load: 12
(taken from http://marc.theaimsgroup.com/?l=mysql&m=104042853614294&w=2)
Sadly, I will have to write my own FTS system soon. I'll be using mysql to
do it, so hopefully Serg will be able to port whatever ideas I settle on
back inside the mysqld engine (assuming they worth porting!!) I'll start by
moving the ideas of the cosine vector search from C to SQL. Then I can try a
lot of different things without constant re-compiling. I'll also get the
advantage of having it work with several languages on a record basis, rather
than a table basis...
Now if only I had a paying job, I could focus on it and get it done
quicker...
Sincerely,
Steven Roussey
http://Network54.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
