472,378 Members | 1,443 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,378 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 4321
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() {
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
2
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
1
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...
0
by: jack2019x | last post by:
hello, Is there code or static lib for hook swapchain present? I wanna hook dxgi swapchain present for dx11 and dx9.
0
DizelArs
by: DizelArs | last post by:
Hi all) Faced with a problem, element.click() event doesn't work in Safari browser. Tried various tricks like emulating touch event through a function: let clickEvent = new Event('click', {...

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.