Re: How can I Show my Database Global Variables and Full Process List?

Works for me:

$q = $this->Post->query("SHOW FULL PROCESSLIST");
die(debug($q));

Of course, debug needs to be enabled, and caching disabled. Have you
checked that?

On Wed, Aug 29, 2012 at 2:24 PM, andrewperk <andrewperk@gmail.com> wrote:
> Hello,
>
> I need to be able to print out some data from my database such as:
>
> "SHOW FULL PROCESSLIST"
> "SHOW GLOBAL STATUS"
> "SHOW GLOBAL VARIABLES LIKE 'hostname'"
>
> etc..
>
> How can I accomplish this? What I've been trying to do is use the query()
> method in a model to run my own custom query but that's not working:
>
> $this->query("SHOW FULL PROCESSLIST");
>
> This doesn't return anything, there is no error either, it's just empty. Any
> help would be appreciated.
>
> Thanks,
>
> --
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com.
> To unsubscribe from this group, send email to
> cake-php+unsubscribe@googlegroups.com.
> Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
>
>

--
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com.
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en-US.