At 01:21 PM 12/1/2009, David Shere wrote:
select distinct a.PartNumber as 'Part Number', (
select count(1)
from Transactions b
where b.PartNumber = a.PartNumber) as 'No. Sold'
from listings a
order by a.PartNumber
It currently takes 30 seconds to run. Transactions has 1200 records and
>-Original Message-
>From: machiel.richards [mailto:machiel.richa...@gmail.com]
>Sent: Tuesday, December 01, 2009 6:17 AM
>To: 'Claudio Nanni'
>Cc: mysql@lists.mysql.com
>Subject: RE: Innodb buffer pool size filling up
>
>The size was at 2Gb and was recently changed to 3Gb in size during th
On 12/1/09 2:21 PM, "David Shere" wrote:
> select distinct a.PartNumber as 'Part Number', (
> select count(1)
> from Transactions b
> where b.PartNumber = a.PartNumber) as 'No. Sold'
> from listings a
> order by a.PartNumber
>
> It currently takes 30 seconds to run. Transactions has
select distinct a.PartNumber as 'Part Number', (
select count(1)
from Transactions b
where b.PartNumber = a.PartNumber) as 'No. Sold'
from listings a
order by a.PartNumber
It currently takes 30 seconds to run. Transactions has 1200 records and
listings has 7000.
Multiple listings can
I'm trying to edit one of my stored procedures using MySQL Query Browser
and this is what I get back as a listing when I select Edit All
Procedures:
DROP PROCEDURE IF EXISTS `kwbo4418_2008bookworminventory`.`UpdateStock`
$$
/*!50003 SET @TEMP_SQL_MODE=@@SQL_MODE, SQL_MODE='' */ $$
(null) $$
/*!500
Hi Jim,
Only difference is auto increment in the field.
You cannot have two auto increment in a single table also auto
increment field must be the key.
On 11/30/09, Jim Lyons wrote:
> I created dummy tables for Roles and Users specifying the primary keys as
> 'serial' and then tried the below sy
The Innodb Buffer Pull usually follow a growth over time that resembles an
horizontal asintot (
http://www.maecla.it/bibliotecaMatematica/go_file/MONE_BESA/grafico.gif)
This to leverage all its size!
So should not be a problem!
Cheers
Claudio
2009/12/1 machiel.richards
> The size was at 2Gb
The size was at 2Gb and was recently changed to 3Gb in size during the last
week of November (around the 23rd / 24th) and as of this morning was already
sitting at 2.3gb used.
The total database size is about 750Mb.
Regards
Machiel
From: Claudio Nanni [mailto:claudio.na...@gmail.co
That is basically its use,
the buffer pool is the collection of all mysql innodb buffers,
and after warm up it goes to keep all cacheable data.
How big is your INNODB_BUFFER_POOL_SIZE ?
Cheers
Claudio
2009/12/1 machiel.richards
> There are no errors in the logs at all.
>
>We have a s
