Can you give us the output of `uname -a` from your mysql hosts?
There's a difference if you are running a 2.4 kernel vs. 2.6 kernel
(Linux).
In 2.4 kernel, try "ps -ef", and in 2.6 kernel, "ps -Lef". You may
notice that PPID is the same for all PIDs except one, usually.
-Paul
On Thu, 2008-08-14
Yes,
mysql12940 0.0 27.3 324124 264672 ? SAug06 0:12
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
mysql12941 0.0 27.3 324124 264672 ? S
r they all runing on the same port
On 8/14/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> But some of the mysql server(mysql server on debian) shows only one mysql
> process.
>
> On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David <
> [EMAIL PROTECTED]> wrote:
>
> > I may be talking rub
But some of the mysql server(mysql server on debian) shows only one mysql
process.
On Thu, Aug 14, 2008 at 12:56 PM, Ellison, David <
[EMAIL PROTECTED]> wrote:
> I may be talking rubbish here, but is it not threading?
>
> I have seen Linux processes before create more than one PID etc when it
> n
On Thu, 14 Aug 2008 10:27:29 +0530, Krishna Chandra Prajapati wrote:
> Please help me that what should i do.
Nothing. It's just multi-threaded. Everything's fine.
--
Matthias Urlichs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
I may be talking rubbish here, but is it not threading?
I have seen Linux processes before create more than one PID etc when it
needs to handle multiple requests. This may be not true for MySQL.
However when looking at my test server is shows more than one. If you
use a command called htop, simila
Is it possible to shutdown and restart mysql again, if its not in
production.
regards
anandkl
On 8/14/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I am running mysql on debian. I didn't understand why there is a lots of
> mysql process running. There should be only on
On Monday, 26 September 2005 at 9:29:32 +0200, mark carson wrote:
> Joeffrey Betita wrote:
>> hi
>> do you have any idea why the mysql process is 99.9 percent? when i click
>> one hyperlink it takes more than 1 minute to load the page. thank you very
>> much.
>
> Most readers in this list expect
Joeffrey Betita wrote:
hi Jasper
the linux distribution is redhat 9, mysql-4.0.15a-log, apache-2.0.47, php-4.3.3 etc.
just clicking one hyperlink and searching for any item.
OK, would you mind providing the SQL query that's being executed when
you click that hyperlink?
You see, MySQL doesn'
Hi
Most readers in this list expect OS and MySQL server information etc
before responding.
In our experience this is usually caused by poor SQL query construction
e.g. large result set e.g. x million rows and/or index choice, database
table design and/or MySQL server setup.
Turn-on logging
Joeffrey Betita wrote:
do you have any idea why the mysql process is 99.9 percent?
No.
when i click one hyperlink it takes more than 1 minute to load the
page. thank you very much.
Maybe if you provided some details then someone would be able to help
you. We're not psychic. What programming
uot;
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 06, 2003 7:22 AM
To: Jobs PHP Workshop; [EMAIL PROTECTED]
Subject: Re: MySQL process increasing problem..
Hi,
Yes, in top, those are threads not processes, as Gerald already said.
Not that it reall
Hi,
Yes, in top, those are threads not processes, as Gerald already said.
Not that it really matters. :-)
Your connections in PROCESSLIST are sleeping (e.g. idle). What are the
clients? It looks like you may be using persistent connections with a
Web app.
If you want to get rid of the sleeping t
On Wed, Nov 05, 2003 at 10:38:05PM +0530, Jobs PHP Workshop wrote:
> Hi,
>
> Problem is, Mysql server in our production machine keeps spawning child
> processes and it reaches to a level where mysql hangs and the only
> solution is to restart our mysql server.
That sucks.
> I have checked all the
Those are threads, not processes.
Each connection gets a thread.
Many connections waiting for disk space will give you this problem.
Jobs PHP Workshop wrote:
Hi,
Problem is, Mysql server in our production machine keeps spawning child
processes and it reaches to a level where mysql hangs and the on
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 15, 2002 4:51 PM
Subject: mysql process keeps references to files after conn.close()
> Hi.
>
> I am doing a simple programmatic task. I am opening a connection to a
> database using
>
> co
Oh...
Isn't ModAuthMySQL used for HTTP authentication against a mysql database
? I can't see how that could influence queries running from within a
mod_perl/CGI script...
P
On Mon, 26 Feb 2001, Simon Green wrote:
> Hi there Kiran
> We had the same problme and we found that updating ModAuthMy
As far as I know, this is on the wishlist, but has not been implemented
- ie, a thread should die if the client disconnects. You'll probably
need to run mysqladmin kill xxx, where is the offending thread id.
regards,
P
On
26 Feb 2001 [EMAIL PROTECTED] wrote:
> Hi Everybody,
> I am a
Hi there Kiran
We had the same problme and we found that updating ModAuthMySQL solved the
problem..
Hope this helps...
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 26 February 2001 13:27
To: [EMAIL PROTECTED]
Subject: mysql process running
Hi Everyb
19 matches
Mail list logo