Hello.
Run ps -axm on the second server, and normally you should see a lot of
mysqld threads.
Edward David wrote:
I just joined this list so I am hoping that this question is relevant to
this group.
I am running Linux AS4 Enterprise Server.
I am running Mysql Ver 14.7 Distrib
I just joined this list so I am hoping that this question is relevant to
this group.
I am running Linux AS4 Enterprise Server.
I am running Mysql Ver 14.7 Distrib 4.1.12, for pc-linux-gnu (i686)
using readline 4.3
With Client version 3.23.49.
When I go and do a ps -ax I see 18 mysqld
was working perfectly,
once I upgraded and started mysql, it started fine without any errors but
the server was steadily creating mysql processes at the rate of like 20/sec
until it reached the Max_connections limit set at 800, while it was doing
this it was serving the web clients only randomly
was steadily creating mysql processes at the rate of like 20/sec
until it reached the Max_connections limit set at 800, while it was doing
this it was serving the web clients only randomly , also the load was very
very low neither was it taking up any memory, it was just creating
and the replication was working
perfectly,
once I upgraded and started mysql, it started fine without any errors
but
the server was steadily creating mysql processes at the rate of like
20/sec
until it reached the Max_connections limit set at 800, while it was
doing
Hi All,
Last night I upgraded our Master server to 4.1.14 standard log from 4.0.17,
I upgraded the slave a week ago and the replication was working perfectly,
once I upgraded and started mysql, it started fine without any errors but
the server was steadily creating mysql processes at the rate
Hi List,
I've searched the archives and the web many times in the past for answers to the
following
questions but never really got a complete understanding of what is going on. Hopefully
someone on
the list will be able to take the time to set me straight.
I have a typical php + mysql + linux
On Friday, November 7, 2003, at 01:21 PM, Hugh Beaumont wrote:
Hi List,
I've searched the archives and the web many times in the past for
answers to the following
questions but never really got a complete understanding of what is
going on. Hopefully someone on
the list will be able to take
number of mysql processes are running becasue it
should show only single mysqld process.
any idea
sanjay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqld_safe and mysql . the mysqld
process are eleven in number with respective pids on my machine . I want to
know why there are large number of mysql processes are running becasue it
should show only single mysqld process.
any idea
sanjay
--
MySQL General Mailing
a
3306/tcp: 916 918 919 1127 1128 4774 5348 6042
6083 6214 9113 9123 9424 9445 9448 9819 9909 9984 9992 9994
10088 10095 10096 10112 10127 10228 10240
So basically I have some missing mysql processes. But if I know a pid, I
can ps it, like this:
ps 1128
PID TTY
get a
3306/tcp: 916 918 919 1127 1128 4774 5348 6042
6083 6214 9113 9123 9424 9445 9448 9819 9909 9984 9992 9994
10088 10095 10096 10112 10127 10228 10240
So basically I have some missing mysql processes. But if I know a pid,
I can ps it, like this:
ps 1128
PID
Neither of these two machines send the request.
I have 12 webservers, which send the requests.
I have 5 database servers, 1 master(for updates/inserts/deletes) and 4
slaves(for selects).
Machine A below was the current Master DB server, however it is old and was
being replaced by machine B
--
When you said you modified the scripts, are these the scripts on the 12
webservers (mysql clients) ?
If not, then these mysql clients (webservers) would still be wanting to send
to IP addres 192.168.1.71 as configured for php or in your client.
Best regards
Nils Valentin
Tokyo/Japan
2003 6
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.
The failed login attempts couldn't be from your slaves trying to login, but
you havent set them up on the master yet ?
Just a
, June 27, 2003 1:30 PM
Subject: Re: URGENT problem with mysql processes
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.
The failed login attempts couldn't be from your slaves trying
No, the slaves replicate fine and I can see their entries in the processlist
normally (as their hostname), not as unauthenticated user..
--
Keith Bussey
Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225
Quoting Nils Valentin [EMAIL PROTECTED]:
Hi Keith,
from your last e-mail I
Subject: Re: URGENT problem with mysql processes
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.
The failed login attempts couldn't be from your slaves trying to login
Quoting Nils Valentin [EMAIL PROTECTED]:
When you said you modified the scripts, are these the scripts on the 12
webservers (mysql clients) ?
Yes, when I mention modifying my scripts, I mean the scripts/pages on the 12
webservers
If not, then these mysql clients (webservers) would still be
Major problem!
I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is
- quad-xeon (500mhz each cpu)
- 3 gig RAM
- Linux Redhat 7.3
When I start up mysql, processes looking like the following begin to pile up
until it kills the server:
| 106 | unauthenticated user
Hi Keith,
The wrong IP address could only avoid a client to connect to the database
server.
If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in
config.inc.php or which ever tool you use than of course it will try to
connect to this IP address.
Best regards
Nils
hi,
I have a problem with the connections and would appreicate a lot if anyone can provide
a soln..
Our JSP application has connections to both Oracle and MySQL... In each page there are
nearly a dozen queries executing on a MySQL db. at the begining of each page, a
connection is opened and
On Thursday 17 October 2002 19:33, Sandeep Murphy wrote:
Our JSP application has connections to both Oracle and MySQL... In each
page there are nearly a dozen queries executing on a MySQL db. at the
begining of each page, a connection is opened and at the end they are
close.. Ideally, if the
Sandeep Murphy wrote:
hi,
I have a problem with the connections and would appreicate a lot if anyone can provide a soln..
Our JSP application has connections to both Oracle and MySQL... In each page there are nearly a dozen queries executing on a MySQL db. at the begining of each page, a
-Original Message-
From: Mark Matthews [mailto:mark;mysql.com]
Sent: quinta-feira, 17 de Outubro de 2002 13:05
To: Sandeep Murphy
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL processes..
Sandeep Murphy wrote:
hi,
I have a problem with the connections and would appreicate a lot if anyone can
Hi everyone,
I have a rather obscure problem with hung login connections in mysql.
I've set the wait|interactive_timeout to 120 seconds, but it has no
effect.\
If I attempt to `mysqladmin kill id`, the process is marked 'killed',
but never goes away.
Now I know the main problem is with
Is there any reason for mysqld processes not dying?
Any try to kill it result in a 'defunct' processes (accoarding to ps
aux). And what is a defunct process?
The kernel prints the message: mm: critical shortage of bounce
buffers. Any ideia what is it´s relation with Mysql?
The machine has
Ryan Shrout ([EMAIL PROTECTED]) writes:
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND=
=20
24424 mysql 18 0 6116 6116 2196 R99.9 0.5 4:05 mysqld =
This is after a mysqld restart -- It restarted, but didn't work because =
this single
This is after a mysqld restart -- It restarted, but didn't work because
this single mysqld process wouldn't die. I even tried to kill it kill
24424 and it still wouldn't go away -- not letting me restart mysqld.
What is going on here?
kill -9 24424
i.t
: Ryan Shrout [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 14, 2001 4:36 PM
To: [EMAIL PROTECTED]
Subject: Lots of spawning Mysql processes and one that won't die?
Earlier I told you all about the mysqld problem I had with my
dual-athlon server.
Well, more hunting and I find this:
6
pages as
fast as possible from a neighboring machine, over and over.
On the server I have a loop running like this:
N=1; while [ $N -ge 1 ]; do ps aux|grep mysql |wc; sleep 5; done
which shows the number of mysql processes every five seconds or so.
I had run this test earlier and over two
; done
which shows the number of mysql processes every five seconds or so.
I had run this test earlier and over two hours' time the number of
connections increased to about 22. After changing all the
mysql_pconnect() calls to mysql_connect(), and leaving the wget job
running all night
which shows the number of mysql processes every five seconds or so.
I had run this test earlier and over two hours' time the number of
connections increased to about 22. After changing all the
mysql_pconnect() calls to mysql_connect(), and leaving the wget job
running all night (the 'at' job I set up
Repost - nobody has any ideas? I've run some stress tests, sending
several thousand page requests, and the number of mysql processes
goes up and down but over time continues to rise. It's up to about
22 now. When it gets to about 30, every request from the web server
will be will fail
of mysql processes
goes up and down but over time continues to rise. It's up to about
22 now. When it gets to about 30, every request from the web server
will be will fail.
Could some of these processes be threads that are orphaned for some
reason (perhaps Apache continuing to expire its own processes
can still use the mysql shell with no problem, so MySQL is still running
but can't hear anything from PHP.
The only way to fix it is to run 'apachectl restart' or equivalent.
'graceful' doesn't do it. Im not sure if restarting MySQL instead
works. After Apache is restarted, the mysql processes
36 matches
Mail list logo
