om:* Rob Wultsch [mailto:wult...@gmail.com]
> *Sent:* 02 July 2010 10:46 AM
>
> *To:* Machiel Richards
> *Cc:* mysql@lists.mysql.com
> *Subject:* Re: Mysql connections not released
>
>
>
> A bad assumption I make these days is that everyone has skip resolve off.
> If th
RDC_Logo
From: Rob Wultsch [mailto:wult...@gmail.com]
Sent: 02 July 2010 10:46 AM
To: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Mysql connections not released
A bad assumption I make these days is that everyone has skip resolve off. If
that is the case DNS issues will not impac
hy and how to resolve this.
>
>
>
>
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>
> *From:* Rob Wultsch [mailto:wult...@gmail.com]
> *Sent:* 02 July 2010 9:42 AM
> *To:* Mac
o: Machiel Richards
Cc: mysql@lists.mysql.com
Subject: Re: Mysql connections not released
On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards
wrote:
Good morning all
A few days ago i posted some questions relating to mysql
threads running out and not being able to restart th
On Thu, Jul 1, 2010 at 11:58 PM, Machiel Richards wrote:
> Good morning all
>
>
>
> A few days ago i posted some questions relating to mysql
> threads running out and not being able to restart the database.
>
>
>
> We had the same again this morning however this ti
Good morning all
A few days ago i posted some questions relating to mysql
threads running out and not being able to restart the database.
We had the same again this morning however this time I had a
bit of a heads up and managed to get into the database befor
in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM:
Hi Raj,
In which path the trace file would be created.
In your current path itself.
Or just do
strace -o /tmp/mysql.strace -T mysql -u root -h host -p
The "mysql -u root -h host -ppassword" is the command which you
Thank u very much.
regards
anandkl
On 8/13/08, Raj Shekhar <[EMAIL PROTECTED]> wrote:
>
> in infinite wisdom Ananda Kumar spoke thus On 08/13/2008 04:37 PM:
>
>> Hi Raj,
>> In which path the trace file would be created.
>>
>
> In your current path itself.
>
> Or just do
> strace -o /tmp/
Hi Raj,
In which path the trace file would be created.
regards
anandkl
On 8/13/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> In infinite wisdom "Krishna Chandra Prajapati" <[EMAIL PROTECTED]>
> spoke thus:
>
> > Hi all,
> >
> > Connecting to mysql server (Production) is taking 5 to 6 seco
In infinite wisdom "Krishna Chandra Prajapati" <[EMAIL PROTECTED]> spoke thus:
> Hi all,
>
> Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
> has 16Gb ram. Previously it was using only 6GB ram. The details are as
> follows. DNS looks fine.
Is it that the database yo
You should run into out of memory scenaria. OS is keeping to free some
memory that delay mysql connection.
On 8/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
> On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens <[EMAIL PROTECTED]> wrote:
>
> > Do you have any other services running on th
On Wed, Aug 13, 2008 at 1:30 PM, Doug Bridgens <[EMAIL PROTECTED]> wrote:
> Do you have any other services running on the server, such as mail or web?
> How long does it take to connect to those services ('telnet 25',
> or telnet 80')?
No
>
> What are you using to connect to mysql? how lo
Do you have any other services running on the server, such as mail or
web? How long does it take to connect to those services ('telnet
25', or telnet 80')?
What are you using to connect to mysql? how long does 'telnet
3306' take (assuming you are on the default port and have
firewa
Hi all,
Connecting to mysql server (Production) is taking 5 to 6 seconds. Production
has 16Gb ram. Previously it was using only 6GB ram. The details are as
follows. DNS looks fine.
free -m
total used free sharedbuffers cached
Mem: 15899 15877
pril 29, 2007 3:38 PM
Subject: mysql connections - how to stop flooding?
I have an issue. Both with mysql pconnect enabled and disabled.
Randomly, between every 5 mins or ever few hours the connections will jump
by as much as 100 connections of more in the span of a a few seconds (5 - 15
seconds usua
isamchk]
key_buffer = 128M
sort_buffer = 128M
read_buffer = 64M
write_buffer = 64M
[mysqlhotcopy]
interactive-timeout
Thanks,
--
View this message in context:
http://www.nabble.com/mysql-connections---how-to-stop-flooding--tf3666522.html#a10244744
Sent from the MySQL - General mailing list archive at
hi shawn...
mysql permits you to set/modify the number of simultaneous connections via
the my.cnf file
my assumption is that this is for all the databases for a mysql instance. is
this correct? also, what issues might one run into if you have multiple
copies of mysql running on a single server?
I am not really sure why you would need this , but I am just throwing in
a possible solution..
First I would say since you need to kill connections on a specific
interface (eth0), It would be fair to assume that you have more than one
interface, if thats the case and you don't have the "--bind
On 4/28/06, Dominik Klein <[EMAIL PROTECTED]> wrote:
Hi
I'd like to know if there is anything to kill connections from a
specific client ip that came to the server on a specific interface.
I do not want to block them on layer 2 (which could easily be done with
netfilter), I would like to be abl
Hi
I'd like to know if there is anything to kill connections from a
specific client ip that came to the server on a specific interface.
I do not want to block them on layer 2 (which could easily be done with
netfilter), I would like to be able to kill active connections.
For example: I would
António Fernandes wrote:
Hello,
I'm am trying to make MySQL Server to log connections (attempts, successes,
failures) to a Syslog. I know that it's possible to log all queries but I
just want the connections. Has anyone already done this? Is there a patch
file that I can use?
Wanring - I've never
Hello,
I'm am trying to make MySQL Server to log connections (attempts, successes,
failures) to a Syslog. I know that it's possible to log all queries but I
just want the connections. Has anyone already done this? Is there a patch
file that I can use?
Thank you,
António Fernandes
--
MySQL Gene
In the last episode (Feb 09), Mike Mapsnac said:
> I have some general questions:
>
> #1 How many simultaneoulsy connection can mysql server handle?
>
> #2 Is there a limitation in how many processes can mysql handle?
As many as your OS's threads implementation can handle.
---
Dan Nels
I have some general questions:
#1 How many simultaneoulsy connection can mysql server handle?
#2 Is there a limitation in how many processes can mysql handle?
Thanks
_
Keep up with high-tech trends here at "Hook'd on Technology."
gt;
> -Original Message-
> From: Manvendra Bhangui [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 11, 2002 5:22 AM
> To: [EMAIL PROTECTED]
> Subject: How to pass mysql connections across exec()
>
>
> Hi,
>
> I have a requirement where I should be able to o
5:22 AM
To: [EMAIL PROTECTED]
Subject: How to pass mysql connections across exec()
Hi,
I have a requirement where I should be able to open connection to mysql from
a server
which is running continuously and pass the connection to a child of this
server after it
does a exec to a totally different
Hi,
I have a requirement where I should be able to open connection to mysql from a server
which is running continuously and pass the connection to a child of this server after
it
does a exec to a totally different executable. This will enable me to reuse a mysql
connection
initiated by one proc
Erich,
You need to create special "root" or "superuser" account so that you can connect
from your PC. This will allow you full access from DBtools. This is what I had
to do in order to make the connection. You'll need to log in as the 'root' or
'superuser' to execute your mysql client.
%>mysql g
Does anyone know how to "allow" other hosts to connect to a MySQL database?
I have a pretty good GUI (DBTools) that will supposedly let you do this, but
whenever I try to connect to a MySQL Server that is not local, is says that
access is denied. I cant find it anywhere in Xinetd so I am assuming
see GRANT in the manual.
Snehalata wrote:
>
> Dear Sir,
>
> We installed MySql server on one system. I have the test database, and My
> own database named Gomoos. When i using to connect to the database using
> java program with a jdbc driver i am not able to connect to my database
> "Gomoos"
Dear Sir,
We installed MySql server on one system. I have the test database, and My
own database named Gomoos. When i using to connect to the database using
java program with a jdbc driver i am not able to connect to my database
"Gomoos" .But i am able to connect to test database.
When i am usi
Kilian Looser wrote:
>
> Hi,
>
> i've the following setup:
>
> LoadBalancer -> five Webserver with Apache and mysql -> Database
>
> Now i got a problem. i've user's they insert records in the database. Now the insert
>is going throu, for example, webserver1. Now i'm doing a select throu webse
Kilian Looser wrote:
>
> Hi,
>
> i've the following setup:
>
> LoadBalancer -> five Webserver with Apache and mysql -> Database
>
> Now i got a problem. i've user's they insert records in the database. Now the insert
>is going throu, for example, webserver1. Now i'm doing a select throu webse
Hi,
i've the following setup:
LoadBalancer -> five Webserver with Apache and mysql -> Database
Now i got a problem. i've user's they insert records in the database. Now the insert
is going throu, for example, webserver1. Now i'm doing a select throu webserver2 and i
didn't get the infor
Hi,
I am currently working on a project in which we are using MySQL to store
data.
The database server (basic installation) is installed on Windows NT version
4. We
are currently doing some load testing on the software and have encountered
some
problems. The database server is hanging.
Our inten
Hello,
is there a way to limit the connection which the mysql user can do??
I have a server with 12 database users, and sometimes, one of the users
makes large number of connections because of a bulletin board he is using,
is there a way to limit the number of connections that he can do?
Regar
36 matches
Mail list logo
