Thank you very much.
This now explains a lot.
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: 18 December 2009 10:05 AM
To: machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: RE: Innodb buffer pool size filling up
Machiel,
That is how it is supposed to
Machiel,
That is how it is supposed to work.
You assign a certain amount of memory(RAM) to it and the database engine
then manages it. It is highly desirable that this buffer is fully used, and
if the growing curve is slow it is because it is not undersized. If you
really need more ram for other us
:)
- Message d'origine
De : David Griffiths <[EMAIL PROTECTED]>
À : Julien Marchand <[EMAIL PROTECTED]>
Cc : mysql@lists.mysql.com
Envoyé le : Vendredi, 22 Juin 2007, 23h31mn 27s
Objet : RE: Re : InnoDB: Assertion failure - MySQL keeps crashing
It doesn't look like a
It doesn't look like a memory issue, but only you can tell (turn some of your
parameters to make sure). What does "top" tell you? It's not just how much
memory your machine has, but how much free memory there is.
Did you compile from source, or use a binary distribution? If you picked a
binary
L PROTECTED]>
Cc : mysql@lists.mysql.com
Envoyé le : Vendredi, 22 Juin 2007, 16h31mn 15s
Objet : Re: Re : InnoDB: Assertion failure - MySQL keeps crashing
I had this issue, so just wanted to know, even if you have the same error
message.
regards
anandkl
On 6/22/07, Julien Marchand <[EMAIL
I had this issue, so just wanted to know, even if you have the same error
message.
regards
anandkl
On 6/22/07, Julien Marchand <[EMAIL PROTECTED]> wrote:
No, I don't have this error :/ And not any file system full issue...
- Message d'origine
De : Ananda Kumar <[EMAIL PROTECTED]>
À
I haven't tried moving things about with the server running, but have
tried to clean up a hosed InnoDB installation after moving files about
during an upgrade (trial run on a test system thankfully).
You're probably right about the inode thing Jerry.
George-Cristian - is it possible that the *.f
Per Andreas Buer <[EMAIL PROTECTED]> wrote:
Hello Heikki,
>
>"Heikki Tuuri" writes:
>
>> I think a 'null' alter table operation:
>>
>> ALTER TABLE innodbtable TYPE=INNODB;
>>
>> does the defragmentation with just one build of the table. And I thi
On Thursday 12 December 2002 01:45, Jing Dai wrote:
> I tried on delete cascade, it didn't work either.
First of all , if you create table as you described in your previous mail,
foreign key will not be created. You can check it with SHOW TABLE STATUS.
Why? Because you specify
.. FOREIGN
At 12:44 +0200 10/25/02, Natale Babbo wrote:
i tried it ... but nothing to do!
when mysql parse the foreign key in the create table i
get the error.
perhaps i'm wronging in restoring tables/db!
i use this method:
shell> mysql -u -p <
is it wrong?
Depends.
- DId you add the SET FOREIGN_KEY_
Natale,
Friday, October 25, 2002, 1:44:19 PM, you wrote:
NB> i tried it ... but nothing to do!
NB> when mysql parse the foreign key in the create table i
NB> get the error.
NB> perhaps i'm wronging in restoring tables/db!
NB> i use this method:
shell> mysql -u -p <
NB> is it wrong?
What vers
i tried it ... but nothing to do!
when mysql parse the foreign key in the create table i
get the error.
perhaps i'm wronging in restoring tables/db!
i use this method:
shell> mysql -u -p <
is it wrong?
thanks.
Natale Babbo
--- Victoria Reznichenko
<[EMAIL PROTECTED]> ha scritto: >
Natale,
Natale,
Friday, October 25, 2002, 10:08:00 AM, you wrote:
NB> ok ... that's right for data (insert into ...) ... but
NB> i get the error before ... when mysql try to create
NB> child table:
NB> CREATE TABLE ... idParent BIGINT, INDEX idpar_ind
NB> (idParent), FOREIGN KEY (idParent) REFERENCES
NB>
Hi Heikki,
Thank you for responding.
> > > (http://www.innodb.com/ibman.html#InnoDB_tuning), but am getting bit
> > > when the log files are full and the buffer pool is checkpointed.
>
> InnoDB does 'fuzzy checkpoints'. That means modified database pages in the
> buffer pool are flushed to disk
Thanks for your feedback (and your general untiring devotion to the
cause...)
On Thu, Aug 01, 2002 at 04:30:10PM -0700, Jeremy Zawodny wrote:
> > about what we can do to alleviate this? Instead of having three 150mb
> > log files, would we be better off with 30 15mb log files?
>
> It shouldn't
Weaver,
Friday, June 07, 2002, 11:28:41 PM, you wrote:
W> I believe the autoextend functionality won't be available until 4.0.2.
autoextend is only supported since 3.23.50
Anyway it's not available in 4.0.1
W> --Walt Weaver
W> Bozeman, Montana
W> -Original Message-
W> From: vlady [ma
Alexandre,
Monday, June 03, 2002, 8:08:14 PM, you wrote:
AZ> Maybe this thread has already been solved. If so im sorry for the disturb.
AZ> Here is my problem:
AZ> I want to use InnoDB transactionnal table types with mysql on Windows 2000 .
AZ> I set my ini file correctly, start the console a
Mysql Row Locking
On Wed, 13 Feb 2002 [EMAIL PROTECTED] wrote :
> Your message cannot be posted because it appears to be
> either spam or
> simply off topic to our filter. To bypass the filter
> you must include
> one of the following words in your message:
>
> sql,query
>
> If you just repl
18 matches
Mail list logo
