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

Home Posts Topics Members FAQ

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 4472
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
1557
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 some free time before installing things on my larger systems. I am trying to do a fresh install of MySQL 4.0.14 (I removed the previous 3.23.56...
0
1359
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 reinstallation I found the machine was not as responsive as before. (It's not very slow, but some lagging is noticed) I was running Mysql-max...
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...
14
4020
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 documentation that says how to get to these installed packages. I would like to just start using them, but not sure where to start. Any hints to get up...
4
6623
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. --------------------------------------------------------------- ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)...
57
25495
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
4098
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, tried installing sun java 1.4.1 (or .2 - not sure) no help. THen I tried booting to a non-SMP kernel - same error, tried using the LD_ASSUME_KERNEL...
1
2303
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
3036
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
7719
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
8044
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. ...
1
7808
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...
0
8096
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6450
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5616
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
3739
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3749
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2238
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.