On Tue, Jul 27, 2010 at 1:56 PM, Todd E Thomas wrote:
> I'm looking for automation direction...
>
> I've found many packages that sit on top of MySQL. For the purposes of
> consistency I'd like to automate these installs.
>
> I've been able to automate the install and configuration of everything
>
I'm looking for automation direction...
I've found many packages that sit on top of MySQL. For the purposes of
consistency I'd like to automate these installs.
I've been able to automate the install and configuration of everything
except the mysql part.
I'm using CentOS 5.5. Installing/veri
In the last episode (Jul 27), Dan Nelson said:
> In the last episode (Jul 27), Mike Spreitzer said:
> > If I want to try to actually hold a 2GB table in RAM, is there anything I
> > need to set in my.cnf to enable that?
>
> Just make sure your key_buffer_size is large enough to hold the index. Y
In the last episode (Jul 27), Mike Spreitzer said:
> Does `iostat` consider GPFS mounts at all? If so, how can I tell which
> line of `iostat` output is about the GPFS mounted at /dev/gpfscf ? I do
> not see such a thing mentioned in the iostat output.
iostat works at the disk device level, no
>-Original Message-
>From: Dan Nelson [mailto:dnel...@allantgroup.com]
>Sent: Monday, July 26, 2010 11:31 PM
>To: Mike Spreitzer
>Cc: MySql
>Subject: Re: idle query
>iostat -x output would be helpful here, too, so we can see whether your
>disks are at 100% busy.
>
[JS] 100% busy would be
Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
27-Jul-2010
More Tools to Work with MySQL Databases in Visual Studio Provided by dbForge
Fusion!
Devart today releases dbForge Fusion for MySQL,
Does `iostat` consider GPFS mounts at all? If so, how can I tell which
line of `iostat` output is about the GPFS mounted at /dev/gpfscf ? I do
not see such a thing mentioned in the iostat output.
In `vmstat` output, I thought "bi" is in terms of fixed-size blocks, not
I/O commands.
Thanks,
M
try this ...
select 5 * floor(seconds/5) as start, 5 * floor(seconds/5) + 5 as end,
sum(calls) from calls group by 5 * floor(seconds/5);
This should give you an output of the type
+---+--++
| start | end | sum(calls) |
+---+--++
| 0 |5 |
Hi everyone,
i have two columns (seconds, number of calls), i need to produce a
report which will show total number of calls in intervals (let'say 10
seconds interval), i know i can do this programmability in my script but
i was wondering if it's possible to accomplish this behavior within
mysql.
