473,322 Members | 1,403 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

MySQL 4.0.14/4.0.15, RedHat9 (smp 2.4.20), memory problem

Hello Everybody!
I have a problem with MySQL servers running RedHat 9 (smp kernel 2.4.20)
on Intel and MySQL server 4.0.14 (problem also appears on binary distr
4.0.15 and on 4.0.15 I bilt myself from source).
I have few big tables with BLOBS and regular table 4.2 and 2.7 Gb
respectively, plust several smaller tables. Every time I run query
against this tables MySQL uses all available memory on server (I have
3Gb RAM on server) and it does not release that memory after query is
completed. I can understand that MySQL may use all available memory for
big queries etc., but memory IS NOT RELEASED EVEN IF I STOP MySQL server
(no mysql processes running - I verify process list every time). Is it a
problem with MySQL ? RedHat 9 ?
Anyone seen anything like this before ?

Alex.

Jul 19 '05 #1
4 4440
Amadeus wrote:
Hello Everybody!
I have a problem with MySQL servers running RedHat 9 (smp kernel 2.4.20)
on Intel and MySQL server 4.0.14 (problem also appears on binary distr
4.0.15 and on 4.0.15 I bilt myself from source).
I have few big tables with BLOBS and regular table 4.2 and 2.7 Gb
respectively, plust several smaller tables. Every time I run query
against this tables MySQL uses all available memory on server (I have
3Gb RAM on server) and it does not release that memory after query is
completed. I can understand that MySQL may use all available memory for
big queries etc., but memory IS NOT RELEASED EVEN IF I STOP MySQL server
(no mysql processes running - I verify process list every time). Is it a
problem with MySQL ? RedHat 9 ?
Anyone seen anything like this before ?

Alex.


Hmmmm. Interesting, now I think I see what is going on. Despite the fact
that "top", "/proc/meminfor", "free" show me that 98% of all memory on
server is used that memory is not really used by MySQL nor kernel (as I
can see from /proc/slabinfo). I tested it on several versions of
2.4.20-x.xx SMP kernels - same result.

I wrote simple C app. which tries to allocate as much memory as possible
calling malloc() in a loop I found how much free memory _really_
available. Looks like it is Linux reporting problem, but same time this
_only_ happen to me with memory previously used by MySQL server. I can
see memory returned back to free memory pool as soon as other
applications exit. What does MySQL uses for memory allocation /
deallocation so that all released memory is not reported back as free ?

Alex.

Jul 19 '05 #2
Amadeus wrote:
Hello Everybody!
I have a problem with MySQL servers running RedHat 9 (smp kernel 2.4.20)
on Intel and MySQL server 4.0.14 (problem also appears on binary distr
4.0.15 and on 4.0.15 I bilt myself from source).
I have few big tables with BLOBS and regular table 4.2 and 2.7 Gb
respectively, plust several smaller tables. Every time I run query
against this tables MySQL uses all available memory on server (I have
3Gb RAM on server) and it does not release that memory after query is
completed. I can understand that MySQL may use all available memory for
big queries etc., but memory IS NOT RELEASED EVEN IF I STOP MySQL server
(no mysql processes running - I verify process list every time). Is it a
problem with MySQL ? RedHat 9 ?
Anyone seen anything like this before ?

Alex.


Hmmmm. Interesting, now I think I see what is going on. Despite the fact
that "top", "/proc/meminfor", "free" show me that 98% of all memory on
server is used that memory is not really used by MySQL nor kernel (as I
can see from /proc/slabinfo). I tested it on several versions of
2.4.20-x.xx SMP kernels - same result.

I wrote simple C app. which tries to allocate as much memory as possible
calling malloc() in a loop I found how much free memory _really_
available. Looks like it is Linux reporting problem, but same time this
_only_ happen to me with memory previously used by MySQL server. I can
see memory returned back to free memory pool as soon as other
applications exit. What does MySQL uses for memory allocation /
deallocation so that all released memory is not reported back as free ?

Alex.

Jul 19 '05 #3
Amadeus wrote:
Hello Everybody!
I have a problem with MySQL servers running RedHat 9 (smp kernel 2.4.20)
on Intel and MySQL server 4.0.14 (problem also appears on binary distr
4.0.15 and on 4.0.15 I bilt myself from source).
I have few big tables with BLOBS and regular table 4.2 and 2.7 Gb
respectively, plust several smaller tables. Every time I run query
against this tables MySQL uses all available memory on server (I have
3Gb RAM on server) and it does not release that memory after query is
completed. I can understand that MySQL may use all available memory for
big queries etc., but memory IS NOT RELEASED EVEN IF I STOP MySQL server
(no mysql processes running - I verify process list every time). Is it a
problem with MySQL ? RedHat 9 ?
Anyone seen anything like this before ?

Alex.

Hmmmm. Interesting, now I think I see what is going on. Despite the fact
that "top", "/proc/meminfor", "free" show me that 98% of all memory on
server is used that memory is not really used by MySQL nor kernel (as I
can see from /proc/slabinfo). I tested it on several versions of
2.4.20-x.xx SMP kernels - same result.

I wrote simple C app. which tries to allocate as much memory as possible
calling malloc() in a loop I found how much free memory _really_
available. Looks like it is Linux reporting problem, but same time this
_only_ happen to me with memory previously used by MySQL server. I can
see memory returned back to free memory pool as soon as other
applications exit. What does MySQL uses for memory allocation /
deallocation so that all released memory is not reported back as free ?

Alex.

Jul 19 '05 #4
Amadeus wrote:
Hello Everybody!
I have a problem with MySQL servers running RedHat 9 (smp kernel 2.4.20)
on Intel and MySQL server 4.0.14 (problem also appears on binary distr
4.0.15 and on 4.0.15 I bilt myself from source).
I have few big tables with BLOBS and regular table 4.2 and 2.7 Gb
respectively, plust several smaller tables. Every time I run query
against this tables MySQL uses all available memory on server (I have
3Gb RAM on server) and it does not release that memory after query is
completed. I can understand that MySQL may use all available memory for
big queries etc., but memory IS NOT RELEASED EVEN IF I STOP MySQL server
(no mysql processes running - I verify process list every time). Is it a
problem with MySQL ? RedHat 9 ?
Anyone seen anything like this before ?

Alex.

Hmmmm. Interesting, now I think I see what is going on. Despite the fact
that "top", "/proc/meminfor", "free" show me that 98% of all memory on
server is used that memory is not really used by MySQL nor kernel (as I
can see from /proc/slabinfo). I tested it on several versions of
2.4.20-x.xx SMP kernels - same result.

I wrote simple C app. which tries to allocate as much memory as possible
calling malloc() in a loop I found how much free memory _really_
available. Looks like it is Linux reporting problem, but same time this
_only_ happen to me with memory previously used by MySQL server. I can
see memory returned back to free memory pool as soon as other
applications exit. What does MySQL uses for memory allocation /
deallocation so that all released memory is not reported back as free ?

Alex.

Jul 19 '05 #5

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

Similar topics

0
by: tevans | last post by:
I'm using Slackware GNU/Linux 9.0 on an Intel PII 266 machine that's SMP capable, but only with one CPU installed, and 64MB of RAM. It's basically a small test system that I play around with in...
0
by: Rainer | last post by:
Hi folks, Yesterday I have upgraded my linux box with a pair of Xeon 1G CPU and reinstalled everything (it was a sinle Xeon 700). The default RH9 installation comes with MySQL 3.23.54. After the...
0
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...
14
by: Lou | last post by:
When I did my RedHat9 install, I choose Workstation and customized the packages I wanted install. As a part of that customization, I chose mySQL DB; however, I can't seem to find any RedHat...
4
by: blizeach | last post by:
noob here I just got slack9.0 running about a week ago. My proble is that I cant connect to mysql This is the error it gives me. ---------------------------------------------------------------...
57
by: Bing Wu | last post by:
Hi all, I am running a database containing large datasets: frames: 20 thousand rows, coordinates: 170 million row. The database has been implemented with: IBM DB2 v8.1
2
by: Ken Shaffer | last post by:
I am trying to install DB2 UDB 8.1 on linux. I get the segmentation fault on line 130 of db2jinst that others have mentioned. I tried: install on RH Fedora Core 2. got the seg fault error,...
1
by: Marcel Groner | last post by:
I have a problem with postgresql runnung on smp kernel. setup: master: ------- - Pentium 4 (hyperthreading) - 2 GB Memory - os: fedora core 1 - kernel: 2.4.22-1.2188.nptlsmp
4
by: yogesh | last post by:
mysql in c++ initialize error occurs a simple program is executed in redhat9.0 , using gcc 3.2.2 compiler version ... #include <stdio.h> #include <mysql.h> #include <string.h> int main() {
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.