"Jim" <[EMAIL PROTECTED]> writes:
> On the following page and in the example ini files installed with MySQL
> it's suggested that key_buffer_size is an option that affects MyISAM
> performance.
>
> http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
>
> But on the following page ab
This would clear your doubt about which memory is shared by all threads and
which memory is used by individual threads ..
min_memory_needed_by_mysql = (global_buffers + ((thread_buffers )*
max_connections)))
where thread_buffers includes the following:
sort_buffer
myisam_sort_buffer
read_bu
innodb_buffer_pool_size + key_buffer_size +
max_connections*(sort_buffer_size + read_buffer_size +
binlog_cache_size) + max_connections*2MB
is what I was told recently on this list.
-Sheeri Kritzer
On 1/16/06, Grant Giddens <[EMAIL PROTECTED]> wrote:
> I don't know if I still fully understand.
>
I don't know if I still fully understand.
Say I have a database with a good mix of myisam and innodb type tables. If
my server has 1 gig of ram and I set key_buffer_size=256M and
innodb_buffer_pool_size=256M then wouldn't mysql be constrained to 512M of the
ram and leave the remaining 5
The difference in recommendation size comes from the different
techniques each storage engine uses for caching data. myisam
(key_buffer_size) only stores indexes where innodb_buffer_pool_size
stores both indexes and data. mysiam relies on the operating system to
cache data in ram which is why you d
At 9:45 -0700 4/19/04, Emmett Bishop wrote:
Is the key_buffer_size server variable useful for
tuning databases that only have innodb tables or do I
need to use the innodb_buffer_pool_size variable for
this?
The buffer controlled by key_buffer_size is used only
for MyISAM and ISAM tables.
--
Paul Du
At 14:12 -0700 9/30/03, Jeremy Zawodny wrote:
On Tue, Sep 30, 2003 at 09:11:59PM +0100, [EMAIL PROTECTED] wrote:
Mysql database have only innodb tables. I'm not using MyISAM.
Really?
Unless I'm smoking crack, there used to be code in InnoDB that refused
to convert the mysql.* tables to InnoDB.
I
13
To: [EMAIL PROTECTED]
Cc: Misaochankun; [EMAIL PROTECTED]
Subject: Re: Key_buffer_size
On Tue, Sep 30, 2003 at 09:11:59PM +0100, [EMAIL PROTECTED] wrote:
>
> Mysql database have only innodb tables. I'm not using MyISAM.
Really?
Unless I'm smoking crack, there used to be code i
On Tue, Sep 30, 2003 at 09:11:59PM +0100, [EMAIL PROTECTED] wrote:
>
> Mysql database have only innodb tables. I'm not using MyISAM.
Really?
Unless I'm smoking crack, there used to be code in InnoDB that refused
to convert the mysql.* tables to InnoDB.
If that's changed, I'd love to know why.
nal Message-
-->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, September 30, 2003 1:12 PM
-->To: Misaochankun
-->Cc: [EMAIL PROTECTED]
-->Subject: RE: Key_buffer_size
-->
-->
-->Mysql database have only innodb tables. I'm not using MyISAM.
--&
ber 30, 2003 12:35 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Key_buffer_size
>
> On Tue, Sep 30, 2003 at 08:17:20PM +0100, [EMAIL PROTECTED] wrote:
> >
> >
> > Hi all :)
> >
> > I'm working with InnoDB tables only, and i re
Most likely your mysql database is still MyISAM, right?
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:35 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Key_buffer_size
On Tue, Sep 30, 2003 at 08:17:20PM +0100, [EMAIL
On Tue, Sep 30, 2003 at 08:17:20PM +0100, [EMAIL PROTECTED] wrote:
>
>
> Hi all :)
>
> I'm working with InnoDB tables only, and i read that the Key_buffer_size is only
> used for MyISAM tables. Is it true?
> If yes, i can put this variable to 0?
Why not leave it at the default value? If MySQL
13 matches
Mail list logo