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 machiel.richa...@gmail.com
There are no errors in the logs at
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
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
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 jlyons4...@gmail.com wrote:
I created dummy tables for Roles and Users specifying the primary keys as
'serial' and then
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) $$
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
On 12/1/09 2:21 PM, David Shere dsh...@steelerubber.com 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.
-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 the last
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
