I had a similar problem while connecting to mysql 4.0.21 throuhg MyODBC
3.51.11.
If so you must upgrade mysql to 4.1 or downgrade MyOdbc to 3.51.06
Jason Williard wrote:
Hello,
Today, I started experiencing some issues on our website with max
connections exceeded errors. In looking into th
Jason Williard wrote:
Hello,
Today, I started experiencing some issues on our website with max
connections exceeded errors. In looking into this, I found that we had too
many sleeping processes. I was not even able to login to the mysql server
from a command line. Is there a way to set a time
On Monday 06 June 2005 10:58, Gleb Paharenko wrote:
> Does this weird behavior remain if you're connecting trough UNIX socket
> to local instance of MySQL?
it does.
At the moment, I try to approach the problem Carl proposed and starting from
scratch. It works fine - hence the problem is not mysql
Does this weird behavior remain if you're connecting trough UNIX socket
to local instance of MySQL?
Ronny Melz <[EMAIL PROTECTED]> wrote:
>
> Thanks so far for your advice,
>
>> Is it possible that your application doesn't close connection properly?
> that is exactly what also I think
e 06, 2005 3:58 AM
Subject: Re: Re: sleeping processes
>
> Hi Carl,
>
> thank you for your reply.
> did you have a look at my original posting where I included the code?
>
> your code (omitting the error routines) is essentially like this:
> sock=mysql_init(0))
> mysql_re
Hi Carl,
thank you for your reply.
did you have a look at my original posting where I included the code?
your code (omitting the error routines) is essentially like this:
sock=mysql_init(0))
mysql_real_connect(sock,ipNumber,userName,password,gvDatabase,3306,NULL,0)
mysql_select_db(sock,g
d for some things, not good for other ones.) But, for the
appropriate applications, it is very fast.
2. You have to free the result set after every select.
By the way, this code came right out of Googling.
Thanks and good luck,
Carl
- Original Message -
From: "Ronny Mel
Thanks so far for your advice,
> Is it possible that your application doesn't close connection properly?
that is exactly what also I think is the problem's cause, but I am unable to
locate the place where it actually does happen. My code seems straightforward
and I had looked over it some other
Hello.
Is it possible that your application doesn't close connection properly?
Check with netstat the states of connections between your application
and server. Run netstat on the server. Do you see some sleeping processes
with ps utility or 'mysqladmin processlist' command?
Ronny Mel
Mike Morton said:
> Dan:
>
> Thanks for the suggest. I will check it out. The strange thing is that
> as I mentioned, the PHP code that I am using is straightforward, and I
> have never had any problems with the database not disconnecting properly
> with PHP, but that being said, the possibility
Dan:
Thanks for the suggest. I will check it out. The strange thing is that as
I mentioned, the PHP code that I am using is straightforward, and I have
never had any problems with the database not disconnecting properly with
PHP, but that being said, the possibility that it is a db connector pro
Is it possible that some portions of your code do not disconnect thier db connections
when they are done? I've seen issues like this with platforms that do not use db pool
managers to ensure release of db connections when they are idle for a while.
Particularly if there are error scenerios whe
Wouter de Jong writes:
> On Tue, Jun 12, 2001 at 02:16:27PM +0300, Sinisa Milivojevic wrote:
> We are running 2.4.5-ac4 currently on the server. Could you tell me why your binary
>should run better ? Cause I tried it, and it dind't make a lot of difference.
>
> --
> Met vriendelijke groet/With
On Tue, Jun 12, 2001 at 02:16:27PM +0300, Sinisa Milivojevic wrote:
>
> To solve SMP problems with Linux, you should use latest kernel 2.4.*
> and our binary.
We are running 2.4.5-ac4 currently on the server. Could you tell me why your binary
should run better ? Cause I tried it, and it dind't
To solve SMP problems with Linux, you should use latest kernel 2.4.*
and our binary.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larn
On Sun, Jun 10, 2001 at 01:15:38PM +0300, Sinisa Milivojevic wrote:
> > Hello,
> >
> > I'm a database administrator for a hosting provider, and we have currently 2 SMP
>MySQL-database servers. The one that is causing me problems, has at least 900
>databases running on it. That's an dual PIII-55
Wouter de Jong writes:
> Hello,
>
> I'm a database administrator for a hosting provider, and we have currently 2 SMP
>MySQL-database servers. The one that is causing me problems, has at least 900
>databases running on it. That's an dual PIII-550, with 1024MB memory, running RedHat
>6.2, with L
17 matches
Mail list logo
