On 7/21/2010 12:16 PM, Nunzio Daveri wrote:
database is around 150GB with over 5,000 tables. To make things worse, if I
shutdown MySQL, top-c still says all the memory is still used? Is this a bug,
why would it say all the memory is used when I turn off MySQL. The weird thing
is that when I rebo
Hello Gurus, I just inhereted a Sun 2 U Server with 2 Intel Quad Core CPU's and
16 GB of ram. Here is the problem. The machine is constantly at 99% Memory
utilization and we get random row locking, we are only using InnoDB. The
database is around 150GB with over 5,000 tables. To make things wors
problem.
This server was working fine for almost a year until recently it started
crashing. Could it be some memory problem I've ran into and can you suggest
anything I can do to avoid similar problems in the future.
Thanks
Dobromir Velev
On Saturday 06 May 2006 01:23, Heikki Tuuri wrote:
>
then 2 GB. There
are no other services on this machine so the memory should not be a problem.
This server was working fine for almost a year until recently it started
crashing. Could it be some memory problem I've ran into and can you suggest
anything I can do to avoid similar problems in the
t; <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Friday, May 05, 2006 10:50 PM
Subject: Re: InnoDB Memory Problem causing mysql to crash
Well, according to my calculations:
innodb_buffer_pool_size + key_buffer_size
+ max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_s
Well, according to my calculations:
innodb_buffer_pool_size + key_buffer_size
+ max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size)
+ max_connections*2MB
(I used the default binlog_cache_size value of 32K plus your settings)
MySQL could use up to 4.991913 G of memory. Shouldn'
Hi,
I'm trying to resolve why InnoDB is crashing. It happened twice for the last
month without obvoius reason
Any help will be appreciated.
Dobromir Velev
My Server is
Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELsmp
Dual 3.2 GHz Intel Xeon
8 GB RAM
with 3 x 146GB SC
that helps.
Matt
- Original Message -
From: <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 1:23 PM
Subject: mysqldump via tcp/ip memory problem
>
> I've dumped alot of databases before using mysqldump, and am trying to
> dump a larger database than normal, abou
ion failed (gfp=0x1d2/0)
VM: killing process mysqldump
Which leads to a memory problem, or lack of... The box does have approx.
500MB of free ram...
Is it just eating it up buffering the network response from the server?
Mysqldump on client is Ver 8.22 Distrib 3.23.57
Mysqld on server i
t; Sent: Wednesday, August 20, 2003 3:57 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL 4.0.13 Memory problem under heavy load
>
>
> Hi all,
>
> I want to get your opinions on how to increase available/free
> memory and performance on a heavy volume database server.
>
>
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
In the last episode (Aug 20), Kayra Otaner said:
> 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 data
I would run the DB on a RAMDisk
http://www.ibiblio.org/mdw/linuxfocus/English/November1999/article124.html
Anyone else?
Martin
- Original Message -
From: "Kayra Otaner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 3:56 PM
Subjec
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
Try putting the following before the mysqld call but before your ulimit calls -
export LDR_CNTRL='MAXDATA=0x8000'
Also try setting ulimit -m unlimited and ulimit -s unlimited.
Hopefully this helps.
Scott Pippin
[EMAIL PROTECTED]
Hi all,
Now I'm facing a big problem and see if anyone know how to solve it. I'm
using RS6000 AIX 4.3.2 CPU*2 1G RAM with HA. And DB is MySQL 4.0.12-max.
Here is the content of my.cnf.
[client]
#password = your_password
port= 3306
socket = /tmp/mysql.sock
# Here follo
On Wed, Jun 11, 2003 at 12:22:58PM +0800, Kaming wrote:
>
> Jeremy Zawodny wrote:
>
> > On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote:
> > >
> > > Then after the checking, the table seems being fixed and then I start
> > > the MySQL again. I can run query in that table after that. Then s
Hi Jeremy,
here is the value when I typed 'ulimit -a'.
core file size (blocks) unlimited
data seg size (kbytes) 524288
file size (blocks) unlimited
max locked memory (kbytes) unlimited
max memory size (kbytes)unlimited
open files 32768
pipe size (512 bytes)
On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote:
>
> Then after the checking, the table seems being fixed and then I start
> the MySQL again. I can run query in that table after that. Then suddenly
> I saw this error message keeps coming in the mysqld.log
>
> Error Message:
> Out of memory
Hi all,
I am facing a big problem and see if anyone know how to solve it. I am
using freebsd 4.4 with mysql-4.0.12. The database server has 2G RAM in
it. Here is the content of my.cnf.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=3306
set-variable = thread_cache_size=550
a hot backup tool for MySQL
.
Subject: Innodb memory problem
From: Kaming
Date: Mon, 31 Mar 2003 17:48:46 +0800
Hi all,
I have a problem about the innodb memory usage. The following is my
config file for mysql and the version I am using is 4.0.12 in FreeBSD
4.7 stable
lease. It will use all the
memory and the performance will be dropped when it starts to use swap
space... Do anyone know how to calculate the memory mysqld use when it
starts? And also any method can be used to limit the memory usage for
innodb? I don't have memory problem when using MyI
I have a problem sharing mysql structs between processes. I am using
shared memory
to accomplish this. When my program starts, I create a shm segment.
Let's say I simply
fill it with one MYSQL struct.
// parent process setting up shm for it's children
int shmid = shmget(2181973, sizeof(MYSQL),
Hi guys,
I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches,
kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a.
After the start, mysql starts to grow memory usage. It grows until it
consumes all machine memory. After a restart it uses only 17Mb of memory, 18
hou
Hi guys,
I have a quad Xeon 550 server, 4gb RAM, with a RH Linux 6.2 + patches,
kernel 2.4.8 and mysql Ver 11.17 Distrib 3.23.49a.
After the start, mysql starts to grow memory usage. It grows until it
consumes all machine memory. After a restart it uses only 17Mb of memory, 18
hou
Hello,
we use mysql 3.23 on a redhat 7.0 system and myodbc 2.50 on a windows 2000
system. If we make
a insert, update or delete record from the windows system we have the
problem that the mysql
server on the redhat system takes memory. On each action the mysql server
takes memory until
the system
What is the memory being used for? Linux aggressively caches data, so if
most of the memory is showing up as 'cached' or 'buffered', then the high
memory usage is caused the system's normal response to lots of database
and disk activity. It's trying to keep as much data in RAM as possible.
This
Hi all,
I have a seperate linux server with just mysql running on it. But there are
alot of other things that I may need to take off. Anyway yesterday I
noticed after running TOP that the memory usage was real high. I did a
shutdown and checked it after the reboot and the memory usage was way d
There are a couple of potential things you could change.
Dan,
1. On the MySQL end, there is a configuration value or two for timing
out sleeping MySQL queries - by default the timeouts are set to be 8
hours. You can make the timeouts less in my.cnf - However, be careful.
You may have connecti
, January 02, 2002 11:33 AM
To: <
Subject: PHP memory problem
Hi everyone,
when we execute queries through MySQL using PHP, a significant amount of
memory is being used in the process. We have noticed that the memory is not
being released again for several hours. Despite attempts to force it
Hi everyone,
when we execute queries through MySQL using PHP, a significant amount of memory is
being used in the process. We have noticed that the memory is not being released
again for several hours. Despite attempts to force it to release memory in the code,
the problem is still occuring.
Elm Gysel writes:
> Hello,
>
> I have a memory problem when added records to a table.
> The situation is like this (simplyfied) :
>
> query << "select id, symbol from " << STOCKS_TABLE_NAME << std::ends;
> std::vector symbols;
> query.
Elm Gysel wrote:
>/* perform query */
>query.execute(nr, Date.str(), Op, Hi, Lo, Cl, Vo);
> The problem is in the above line I think. If I comment it out the memory
> usage doesn't explode.
> I get around 1.5MB more mem usage each time I insert 2000 records.
> I have no clue what
Hello,
I have a memory problem when added records to a table.
The situation is like this (simplyfied) :
query << "select id, symbol from " << STOCKS_TABLE_NAME << std::ends;
std::vector symbols;
query.storein(symbols);
std::vector::iterator I;
for(I = symbols.be
Hi.
Have a look at your my.cnf (and the according manual entries). There
you can specify how much memory MySQL is allowed to use.
MySQL doesn't release memory it's allowed to use for caching.
Bye,
Benjamin.
PS: There is nothing such as "linux 7.1". Linux (the kernel) exists in
versio
Dear all,
i used mysql on linux 7.1. And i discovered mysql not free the memory .
pls advise !1
1:24am up 1 day, 10:11, 2 users, load average: 1.13, 1.26, 1.31
65 processes: 63 sleeping, 2 running, 0 zombie, 0 stopped
CPU0 states: 4.2% user, 1.3% system, 0.0% nice, 93.3% idle
CPU1 stat
36 matches
Mail list logo
