"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-variable
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 about tuning MySQL server parameters, it
Hlo,
We have all our tables as Innodb type. As I understand the variable
key_buffer_size is used only for MyISAM tables. Currently we have this var set
to 256M on a 4GB RAM machine. Only the Temporary tables created using (CREATE
TEMPORARY TABLE) will be of MyISAM type. And there are a lot of
3.4% (twenty MB or
so in my case) of memory it is not indeed true and actually the usage
for every thread is less than `ps` shows as I understand it?
KJ> Also its very easy to set key_buffer_size , just add up the
KJ> total size of your indexes in the mysql data dir ( *.MYI files) and
KJ&g
read_buffer
join_buffer
read_rnd_buffer
and global_buffers includes:
key_buffer
innodb_buffer_pool
innodb_log_buffer
innodb_additional_mem_pool
net_buffer
Also its very easy to set key_buffer_size , just add up the total size of
your indexes in the mysql data dir ( *.MYI files) and
Please explain to me how mysqld's "key buffer" uses memory under Linux
(kernel 2.4, glibc 2.3, mysql 4.1).
I'd want to know for sure if every mysqld thread (forked upon an
incoming connection) uses its own memory for key buffer (key_buffer_size)
or key buffer is
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 fu
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
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
Hi,
After reading through the example my.cnf files (large, huge, etc), I
started to wonder what the difference was between the isam key_buffer_size and
the innodb innodb_buffer_pool_size.
I realize that they are two different table types, but some of the docs says
to set the
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: really big key_buffer_size (> 4GB)?
I'm running 4.0.25 on NetBSD 3 on an amd64. It appears that the
key_buffer_size is being truncated to 4GB, even though I've set it
larger.
Could someone give me a hint about where to look? I&#x
Chris Wells wrote:
Chris Kantarjiev wrote:
I'm running 4.0.25 on NetBSD 3 on an amd64. It appears that the
key_buffer_size is being truncated to 4GB, even though I've set
it larger.
Could someone give me a hint about where to look? I'm a little
suspicious of ha_resize_key_c
Chris Kantarjiev wrote:
I'm running 4.0.25 on NetBSD 3 on an amd64. It appears that the
key_buffer_size is being truncated to 4GB, even though I've set
it larger.
Could someone give me a hint about where to look? I'm a little
suspicious of ha_resize_key_cache() which is using l
I'm running 4.0.25 on NetBSD 3 on an amd64. It appears that the
key_buffer_size is being truncated to 4GB, even though I've set
it larger.
Could someone give me a hint about where to look? I'm a little
suspicious of ha_resize_key_cache() which is using longs internally
to hold t
solaris box with 16 Gbytes of memory
os using 5.8, mysql at 4.0.20_64bit
with key_buffer_size set to 6144m, the mysqld crashes
and re-starts (mysql_safe) under heavy load (1day to 1week).
prior to this, key_buffer_size set to 1.5G and no crashes since
early 2004.
the process size is 2G even
Chambon <[EMAIL PROTECTED]> wrote:
> Can somebody tell me if 'key_buffer' and 'key_buffer_size' are the same variables ?
Yes. _size is deprecated.
> Perhaps it is just a question of syntax, I mean, in the my.cnf
>you write key_buffer=100M
> or you
Hi,
Can somebody tell me if 'key_buffer' and 'key_buffer_size' are the same variables ?
Perhaps it is just a question of syntax, I mean, in the my.cnf
you write key_buffer=100M
or you write set-variable = key_buffer_size=100M
Same question for
sort_buffer and sort_buffer
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
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?
Thx,
Tripp
__
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital
Thomas wrote:
>
> Hello all,
>
> My mySQL 4.1.0 server is currently set to use a key_buffer_size of 32M. My
> server has 1GB of RAM, and is now using only InnoDB tables.
>
> The manual says that 'Key_reads/Key_read_request ratio should normally be <
> 0.01&#
Hello all,
My mySQL 4.1.0 server is currently set to use a key_buffer_size of 32M. My
server has 1GB of RAM, and is now using only InnoDB tables.
The manual says that 'Key_reads/Key_read_request ratio should normally be <
0.01'; mine is ~ 0.12; the manual also says 'Key_write/
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 th
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?
Thx
Alexis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
> I'm using the same MySQL version on debian and have no problem
> setting the key_buffer size. I take it you are setting
> "key_buffer" and not "key_buffer_size" in the my.cnf file ?
> eg.
> set-variable= key_buffer=32M
Yes, this is what I'm d
Hi,
I'm using the same MySQL version on debian and have no problem
setting the key_buffer size. I take it you are setting
"key_buffer" and not "key_buffer_size" in the my.cnf file ?
eg.
set-variable= key_buffer=32M
I don't know why it has a different nam
t redo the slave database, so I took
a fresh snapshot of the master (now with the larger key_buffer_size),
scp'ed to the slave, shutdown mysqld on the slave, untarred it into
the mysql dirs, deleted master.info, confirmed my.cnf was how I
wanted it (with the larger buffer specified), started up mys
he status and variable settings (detailed below) and
>> the MySQL online manual, I decided that I needed to up the
>> key_buffer_size. Unfortunately, I've not been successful in doing
>> this.
>>
>> I tried setting it at the command line:
>> mysql&
(detailed below) and the
> MySQL online manual, I decided that I needed to up the key_buffer_size.
> Unfortunately, I've not been successful in doing this.
>
> I tried setting it at the command line:
> mysql> set key_buffer_size=32M;
> ERROR 1064: You have an error in y
cided that I needed to up the key_buffer_size.
Unfortunately, I've not been successful in doing this.
I tried setting it at the command line:
mysql> set key_buffer_size=32M;
ERROR 1064: You have an error in your SQL syntax near 'key_buffer_size=32M' at line 1
I tried setting
Hi.
On Fri, Feb 16, 2001 at 03:05:35AM -0500, [EMAIL PROTECTED] wrote:
> Hello, I have a large database with a lot of queries and was trying to
> tune MySQL to get the best performance. I was reading the manuals and it
> said to set the key_buffer_size to the best value, you take the fi
Hello, I have a large database with a lot of queries and was trying to
tune MySQL to get the best performance. I was reading the manuals and it
said to set the key_buffer_size to the best value, you take the first
two of the following values and divide by each other. I believe it said
you should
37 matches
Mail list logo
