On Wednesday 21 March 2007 16:31, Paul J. Boyes wrote:
> Hello,
>
> I have a fairly sizeable aggregate table that is built from a large
> amount of data that is going to receive a large volume of reads. I am
> looking at possibly using the rename to swap the table out regularly
> with an updated on
On Wednesday 27 December 2006 17:12, Ashley M. Kirchner wrote:
> Chris Comparini wrote:
> > Try something like this:
> >
> > select hour(time) as the_hour, avg(temp_f) as average_temp_f
> > from data
> > where time > now() - interval 24 hour
> >
On Wednesday 27 December 2006 16:24, Ashley M. Kirchner wrote:
>[...]
>
> I want to display a graph for the last 24 hours by averaging each
> hour. Since I get (at most) 60 readings per hour, I need to average
> them out to get a number for that hour. Do I have to do this averaging
> outside
On Friday 15 December 2006 11:53, Steve Edberg wrote:
> At 11:12 AM -0800 12/15/06, Chris Comparini wrote:
> >Hello,
> >
> >Say I wanted to log some various server status variables to
> >a table. What I'd like to do, ideally, is something like
> >this:
&g
On Friday 15 December 2006 11:23, Mikhail Berman wrote:
> Hi Chris,
>
> If you are running on *Nix you could write a script generally structured
> like:
>
> do
> - show status | grep 'what_ever_string_you_want_to_see'
> - insert into table
> - sleep [seconds]
> done
>
Yes, we are
Hello,
Say I wanted to log some various server status variables to
a table. What I'd like to do, ideally, is something like
this:
insert into SomeLogTable (Threads) show status like 'Threads_running';
MySQL does not allow this, of course. But, is there some other way
to see the "Threads_runn
On Tuesday 03 October 2006 10:57, Feliks Shvartsburd wrote:
> Does anybody know how can I see what queries are currently being
> executed?
From the mysql commandline, use "show processlist;"
There is also a program called mytop which shows what's
executing.
-Chris
--
MySQL General Mailing Li
