Simple MySQL Test Command, I'm going crazy here.

I swear I have seen a simple MySQL on Linux test command, possibly
included with MySQL distributions which just times the basic
operations, perhaps on a given database, gives you the amount of time
it took to run each type of command, like
-----------------------
|SELECT | 30ms |
----------------------
| INSERT | 300ms|
--------------------------
| DROP | 594ms|
----------------------------------
ALTER TABLE | 261ms |
------------------------------------

and so on and so on, I vaugley remember one of the tests being "big
insert" or "large select" something, but I just cannot fnid this
command or script anywhere!

I tried googling for two hours, all I find is creating test suites
using the benchmark suite and mysqlslap, I don't think it is either of
those.

I cannot find mysql-test or mysql-test-run.pl on my debian 3 system
running binary package MySQL 4,1, not sure if thats what they are
anyway as I can't find any examples of output from the command I saw,
I've lost the link.

Please, any help would be appreiciated.

On 28 Feb, 13:37, boole <geo...@gmail.com> wrote:
> I swear I have seen a simple MySQL on Linux test command, possibly
> included with MySQL distributions which just times the basic
> operations, perhaps on a given database, gives you the amount of time
> it took to run each type of command, like
> -----------------------
> |SELECT | 30ms |
> ----------------------
> | INSERT | 300ms|
> --------------------------
> | DROP | 594ms|
> ----------------------------------
> ALTER TABLE | 261ms |
> ------------------------------------
>
> and so on and so on, I vaugley remember one of the tests being "big
> insert" or "large select" something, but I just cannot fnid this
> command or script anywhere!
>
> I tried googling for two hours, all I find is creating test suites
> using the benchmark suite and mysqlslap, I don't think it is either of
> those.
>
> I cannot find mysql-test or mysql-test-run.pl on my debian 3 system
> running binary package MySQL 4,1, not sure if thats what they are
> anyway as I can't find any examples of output from the command I saw,
> I've lost the link.
>
> Please, any help would be appreiciated.

I put
mysql test files timings
into Google. Try it.

Thanks Captain Paralytic for the common sense advice, but I have spent
two hours plus on google using all keywords and phrases I can think
of, nothing results in the thing I remembered (including the search
you gave me), if only I had bookmarked that page..

I am particularly looking for the test command or script which simply
executes all the basic SQL statements and times them, showing the
output in MySQL command line client, not the test framework (i've read
through pages of MySQL doc) or the mysql-test-run script, which gives
completley different types of results to the one I am looking for.

Question still unanswered people!

On 28 Feb, 14:07, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> On 28 Feb, 13:37, boole <geo...@gmail.com> wrote:
>
>
>
> > I swear I have seen a simple MySQL on Linux test command, possibly
> > included with MySQL distributions which just times the basic
> > operations, perhaps on a given database, gives you the amount of time
> > it took to run each type of command, like
> > -----------------------
> > |SELECT | 30ms |
> > ----------------------
> > | INSERT | 300ms|
> > --------------------------
> > | DROP | 594ms|
> > ----------------------------------
> > ALTER TABLE | 261ms |
> > ------------------------------------
>
> > and so on and so on, I vaugley remember one of the tests being "big
> > insert" or "large select" something, but I just cannot fnid this
> > command or script anywhere!
>
> > I tried googling for two hours, all I find is creating test suites
> > using the benchmark suite and mysqlslap, I don't think it is either of
> > those.
>
> > I cannot find mysql-test or mysql-test-run.pl on my debian 3 system
> > running binary package MySQL 4,1, not sure if thats what they are
> > anyway as I can't find any examples of output from the command I saw,
> > I've lost the link.
>
> > Please, any help would be appreiciated.
>
> I put
> mysql test files timings
> into Google. Try it.

On 28 Feb, 14:49, boole <geo...@gmail.com> wrote:
> Thanks Captain Paralytic for the common sense advice, but I have spent
> two hours plus on google using all keywords and phrases I can think
> of, nothing results in the thing I remembered (including the search
> you gave me), if only I had bookmarked that page..
>
> I am particularly looking for the test command or script which simply
> executes all the basic SQL statements and times them, showing the
> output in MySQL command line client, not the test framework (i've read
> through pages of MySQL doc) or the mysql-test-run script, which gives
> completley different types of results to the one I am looking for.
>
> Question still unanswered people!
>
> On 28 Feb, 14:07, Captain Paralytic <paul_laut...@yahoo.com> wrote:
>
> > On 28 Feb, 13:37, boole <geo...@gmail.com> wrote:
>
> > > I swear I have seen a simple MySQL on Linux test command, possibly
> > > included with MySQL distributions which just times the basic
> > > operations, perhaps on a given database, gives you the amount of time
> > > it took to run each type of command, like
> > > -----------------------
> > > |SELECT | 30ms |
> > > ----------------------
> > > | INSERT | 300ms|
> > > --------------------------
> > > | DROP | 594ms|
> > > ----------------------------------
> > > ALTER TABLE | 261ms |
> > > ------------------------------------
>
> > > and so on and so on, I vaugley remember one of the tests being "big
> > > insert" or "large select" something, but I just cannot fnid this
> > > command or script anywhere!
>
> > > I tried googling for two hours, all I find is creating test suites
> > > using the benchmark suite and mysqlslap, I don't think it is either of
> > > those.
>
> > > I cannot find mysql-test or mysql-test-run.pl on my debian 3 system
> > > running binary package MySQL 4,1, not sure if thats what they are
> > > anyway as I can't find any examples of output from the command I saw,
> > > I've lost the link.
>
> > > Please, any help would be appreiciated.
>
> > I put
> > mysql test files timings
> > into Google. Try it.

Well I found the mysql-bench RPM's which I can install with Alien, so
I guess I'll have to use those for testing, but thanks anyway!