Set up a local firewall that denies connections to TCP port 3306. Your load
will drop like a stone.
Alternatively, find out what's happening on the server, and start optimizing
from there.
On Tue, Mar 30, 2010 at 8:54 AM, F.A.I.Z.A.L wrote:
> Hi All
>
> please help me to reduce m
Hi All
please help me to reduce mysqld cpu load.
mysql 4.1 running on solaris 10 with 4gb ram. front end apps is php (apache
server). everyday mysql reach about 100% cpu load. can one help to fix this
issue...
thank you.
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
;m looking at it.
- Original Message
From: Kyong Kim
To: Lawrence Robertson
Cc: mysql@lists.mysql.com
Sent: Monday, September 21, 2009 4:25:34 PM
Subject: Re: 100% CPU load problem
Is the status information correct?
> mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)
Are you using
>Is the status information correct?
>> mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)
>Are you using some sort of vm?
I'm not using a VM at all. It's a simple PC with CentOS 4 and MySql.
Don't know why is that Ver 14.12 Distrib 5.0.27, for Win32 (ia32). But the
> | version_compile_os
Is the status information correct?
> mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)
Are you using some sort of vm?
Kyong
On Mon, Sep 21, 2009 at 12:23 PM, Lawrence Robertson
wrote:
> Hi.
>
> We have some MySql servers in a circular replication, and one of the servers
> is having some performa
Hi.
We have some MySql servers in a circular replication, and one of the servers is
having some performance issues for some weeks. I tried with mysqlcheck and
nothing is wrong. I'm logging the slow queries and there's nothing wrong.
The complete database in this server is like 1GB when it's G
At 09:45 AM 12/10/2007, thomas Armstrong wrote:
Hi
Using MySQL 4.1.19 on Linux, my server's CPU load is very high. I want
to cut it down but I don't know which parameters I might modify to do
it.
Post the "Show Full Processlist" and maybe we can figure out what MySQL is
Hi
Using MySQL 4.1.19 on Linux, my server's CPU load is very high. I want
to cut it down but I don't know which parameters I might modify to do
it.
These are my server's data:
back log50
basedir /usr/
bdb cache size 8,388,600
bdb home/var/lib
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 19 November 2002 23:34, Steven Roussey wrote:
> OK, it seems to be working. The load is not spiraling out of control. :)
Thanks! This is very reassuring. I will start building 4.0.5a Linux binaries
right away.
Bye,
LenZ
- --
For
OK, it seems to be working. The load is not spiraling out of control. :)
Sincerely,
Steven Roussey
http://Network54.com/
> -Original Message-
> From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
> Before I make a 4.0.5a release of the Linux binaries (and finally
announce
> 4.0.5), could som
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 19 November 2002 12:19, Lenz Grimmer wrote:
> On Monday 18 November 2002 19:52, Steven Roussey wrote:
> > :( Sadly, 4.0.5 does _not_ fix this issue. I just tried it and our load
> >
> > went from 1 to 145 in 20 seconds...
>
> Thanks for the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 18 November 2002 19:52, Steven Roussey wrote:
> :( Sadly, 4.0.5 does _not_ fix this issue. I just tried it and our load
> went from 1 to 145 in 20 seconds...
Thanks for the info! I don't get it. We will investigate, why this problem has
su
> > With 3.23.53a everything works fine.
>
> MySQL 4.0.4 was compiled against a wrongly built glibc, which leads to
the
> above mentioned behaviour. Please download MySQL 4.0.5, which has just
been
> released and should fix this problem:
:( Sadly, 4.0.5 does _not_ fix this issue. I just tried it
;
> After a while, the number of threads rises up to 60-80 and the CPU load
> increases up to similar values. The response is incredibly slow and
> I have to restart mysql. "show processlist" doesn't show anything
> supspicious.
>
> With 3.23.53a everything works fine.
Hello list,
since I've upgraded to 4.0.4 I'm experiencing serious problems.
When mysql starts up, everything is fine (~50 req/sec, ~10 threads)
and the system load is about 1.0.
After a while, the number of threads rises up to 60-80 and the CPU load
increases up to similar values. Th
When MYSQL is being heavily used on a windows cpu, In Task Manager does the
memory & cpu load increase show the use for mysqld or another process like
Explorer?
-
Before posting, please check:
http://www.mysql.com/manual
sql spam filter
Hi
I'm running MySQL-3.23.37 on a cobalt raq. I have a table with approx
40,000 records and a dozen users running simple queries and updates -
names, addresses that kinda thing, but every time a query is run mysql
takes everything it can get and the box freezes:
10:33am up
On Wed, May 08, 2002 at 10:12:10AM -0400, adam nelson wrote:
>
> I am not having any troubles on 4.5 using plain mysql. Our
> transaction is lower than some (but certainly higher than others) at
> 4 queries/sec avg.
It seems to be unrelated to load. I've seen this happen on a relatively
lightly
From: "Joe Maimon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 9:28 AM
Subject: Mysqld runs with high cpu load on freebsd 4.4
> Hey All,
>
> We recently picked up a box running a web site with mysql on freebsd.
> The cpu load gets peg
Hey All,
We recently picked up a box running a web site with mysql on freebsd.
The cpu load gets pegged high realy quickly under its normal load. This
wasnt always the case.My designers do not believe it to be the queries
shown in the slow query log, which return quickly on development
of 3 or to version 4? Or should I scrap MySQL and try PostgreSQL?
- Original Message -
From: Bruno Prior <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 21, 2001 10:05 PM
Subject: Stalled MySQL process causing high CPU load
> I am a MySQL novice, so
I am a MySQL novice, so there may be a simple explanation for this. But I
have been unable to find one in the list archives, although several people
seem to have had similar problems.
I am running MySQL 3.23.36 from the package that comes with Mandrake linux
8.0. I am using linux software-RAID mi
22 matches
Mail list logo
