473,574 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

key_buffer_size

As anyone benchmarked if there is an advantage in setting
key_buffer_size in startup parameters. In a Linux environment, can
we not rely on Linux to cache the indecis?

I would prefer that, since then a large chunck of memory is not
dedicated to the keys, and mysql+Linux can dynamically decide how to
allocate memory.,

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-key_bu...ict165653.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=554992
Jul 20 '05 #1
1 4705
That depends...

Yes Linux can cache portions the file system (your index) in memory,
however, MySQL will still have to make system calls to access those
indices. While the time to access a "cached" file is lower, you incur
the cost of system calls when the kernel has to mediate the reads on the
index files.

If MySQL has a larger key_buffer_size , then presumably it can access
that same data in userspace and be even faster.

As far as benchmarks are concerned, it really depends on the following
parameters (in no particular order):
1. How your data is indexed and queried.
2. The speed of your file system.
3. The layout of your file system - If the index and data files
are on different disks and/or controllers then it is even
better.
4. The amount of memory you have.
5. The speed and type of processor you have.

-Misk
steve wrote:
As anyone benchmarked if there is an advantage in setting
key_buffer_size in startup parameters. In a Linux environment, can
we not rely on Linux to cache the indecis?

I would prefer that, since then a large chunck of memory is not
dedicated to the keys, and mysql+Linux can dynamically decide how to
allocate memory.,

Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1601
by: Adam Carmichael | last post by:
------=_NextPart_000_4BD9_01C34F2E.785DA9C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am trying to build a MySQL Server running FreeBSD-4.8-STABLE with = OpenSSL-0.9.7b.
0
1621
by: David Bernick | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 We're doing a select query on our INNODB database. Linux 2.4.21 on x86 (Athlon). Mysql is 4.0.13. Anyone seen this problem before? - ----- InnoDB: Error: trying to access page number 538587904 in space 0 InnoDB: which is outside the tablespace bounds. InnoDB: Byte offset 0, len 16384, i/o type...
0
1662
by: Doruk Fisek | last post by:
Hi, I am compiling MySQL 4.0.14 with GCC 3.2.3, Glibc 2.3.1 and Linux 2.4.21 on a x86. CFLAGS="-O2 -march=athlon" CXX=gcc CXXFLAGS="-march=athlon -O2 -felide-constructors" ./configure --prefix=/usr/local/mysql --with-charset=latin5 --without-docs --with-mysqld-ldflags=-all-static --disable-shared --with-client-ldflags=-all-static...
0
7517
by: Stephane Raimbault | last post by:
I've been searching the mailing list for a solution to my problem with "mysqld got signal 11;" and I haven't seen any answers that might help me. This is the situation. I have a db that is being accessed intensively about 400 connections during the wee at a time. I noticed the problem at first with 4.0.13 and tried 3.23.57 and now 4.0.14...
0
1510
by: Kayra Otaner | last post by:
Hi all, I want to get your opinions on how to increase available/free memory and performance on a heavy volume database server. I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using same MySQL version. Recently our master database server (2 AMD Cpu + 2Gb memory + 2Gb swap space) started to suffer from memory outages...
0
1667
by: kayra | last post by:
Hi all, I want to get your opinions on how to increase available/free memory and performance on a heavy volume database server. I have MySQL 4.0.13 running on RH 7.2 replicated to another RH 7.2 using same MySQL version. Recently our master database server (2 AMD Cpu + 2Gb memory + 2Gb swap space) started to suffer from memory outages...
0
2259
by: Vanquish | last post by:
Hello, I only use InndoDB table type. In this case, is it necessary (or useful) to set a big value to buffer_key_size ? I think it's better to allocate RAM to innodb_buffer_pool_size rather than buffer_key_size I'am wrong ?
3
5439
by: Matias Silva | last post by:
Hi Everyone, I wrote a for loop to build several select statements that are combined with a UNION. When I execute one of the queries separately, it works, but when I execute the query with a UNION it returns: ERROR 2013 (HY000): Lost connection to MySQL server during query I am able to run additional queries after I get the error, so the...
1
5501
by: Harita | last post by:
Hi, When I try to change the key_buffer_size to 4GB, it doesnt get effective. I don't see the key_buffer_size changing to 4GB. I am not sure why it doesnt get changed. Here is the command that I followed from this forum: mysql> SET GLOBAL key_buffer_size=4917467096; Query OK,0 rows affected(0.0 seconds) After this if I say show...
0
7794
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7710
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8040
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8225
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7800
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
1
5610
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3745
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1332
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1051
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.