Speaking of Perl scripts that do this: http://codenode.com/mysqlreport
I almost never use SHOW STATUS directly anymore since most the
values have to be transformed one way or another to really be meaningful.
-Daniel
Sid Lane wrote:
I don't know if you can do it directly in a mysql shell like t
> -Original Message-
> From: Sid Lane [mailto:[EMAIL PROTECTED]
> Sent: 16 August 2005 14:54
> To: mysql@lists.mysql.com
> Subject: Re: Can I use the information from "SHOW STATUS" in
> a SELECT statment ?
>
> I don't know if you can do it direc
I don't know if you can do it directly in a mysql shell like that
(like you would with v$, dba_ in Oracle) but if you call a show
command from PERL (via DBI) it hashes the result just like it were
from a select.
may not be the most elegant solution but its the best I've come up
with though I'll ha
Hello to everyone on [EMAIL PROTECTED],
In 2 words, what I wish to do is something like :
mysql> SELECT @@Qcache_queries_in_cache / @@Qcache_hits;
Is it possible ?
Thank you.
--
Cheers,
Maxim Vexler (hq4ever).
Do u GNU ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.
