php and freetds

[erezep@gmail.com]

I'm running a site balanced between 5 apache servers running on FC3,
apache 2.0.53,php 4.3.4,freetds 0.63.

I have this strange problem that sometimes, not even times of load, the
connections table at the sql server gets to a very high value (about
1000) my average is below 200.

I don't know how to solve this, but I know that if I restart the
process of all my apache servers, everything turns ok,

This happens at random times, sometimes 2 times a day, and sometimes
even 10.


Do you know what might be the problem?



Thanks In Advance.



Erez

[Jerry Stuckle]

Re: php and freetds

erezep@gmail.co m wrote:[color=blue]
> I'm running a site balanced between 5 apache servers running on FC3,
> apache 2.0.53,php 4.3.4,freetds 0.63.
>
> I have this strange problem that sometimes, not even times of load, the
> connections table at the sql server gets to a very high value (about
> 1000) my average is below 200.
>
> I don't know how to solve this, but I know that if I restart the
> process of all my apache servers, everything turns ok,
>
> This happens at random times, sometimes 2 times a day, and sometimes
> even 10.
>
>
> Do you know what might be the problem?
>
>
>
> Thanks In Advance.
>
>
>
> Erez
>[/color]

And your PHP question is?

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[erezep@gmail.com]

Re: php and freetds

i dont know, i thought it might be related to php, or some of the guys
here may know...
should i post somewhere else?

[Jerry Stuckle]

Re: php and freetds

erezep@gmail.co m wrote:[color=blue]
> i dont know, i thought it might be related to php, or some of the guys
> here may know...
> should i post somewhere else?
>[/color]

Well, perhaps you could start out by determining what the connections
are. Depending on what you have on your system, they could be PHP,
Apache, Unix or some batch program running.

We know even less about your system than you do. How should we be able
to help with your problem?

But since this is related to MySQL, I might recommend a MySQL newsgroup.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[erezep@gmail.com]

Re: php and freetds

these are all connection to the ms-sql server, from the web server
serving with apache.
i dont know why at random times they go to such a high level

[Jerry Stuckle]

Re: php and freetds

erezep@gmail.co m wrote:[color=blue]
> these are all connection to the ms-sql server, from the web server
> serving with apache.
> i dont know why at random times they go to such a high level
>[/color]

But again - what is the source? Is it Apache? PHP? Something else?

You really need to do some diagnosis on the problem before someone else
can help you.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[erezep@gmail.com]

Re: php and freetds

do you know of other program than freetds, i suspect it might be the
problem.....

[Jerry Stuckle]

Re: php and freetds

erezep@gmail.co m wrote:[color=blue]
> do you know of other program than freetds, i suspect it might be the
> problem.....
>[/color]

I've heard about it, but never used it. If you think that's the
problem, you should follow up on their mailing list.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[Uber Geschlissen]

Re: php and freetds

Jerry are you just a dickhead or do you have multiple personalities?

FreeTDS is used with PHP.

Duh!


Jerry Stuckle wrote:[color=blue]
> erezep@gmail.co m wrote:[color=green]
>> I'm running a site balanced between 5 apache servers running on FC3,
>> apache 2.0.53,php 4.3.4,freetds 0.63.
>>
>> I have this strange problem that sometimes, not even times of load, the
>> connections table at the sql server gets to a very high value (about
>> 1000) my average is below 200.
>>
>> I don't know how to solve this, but I know that if I restart the
>> process of all my apache servers, everything turns ok,
>>
>> This happens at random times, sometimes 2 times a day, and sometimes
>> even 10.
>>
>>
>> Do you know what might be the problem?
>>
>>
>>
>> Thanks In Advance.
>>
>>
>>
>> Erez
>>[/color]
>
> And your PHP question is?
>[/color]

[Uber Geschlissen]

Re: php and freetds

erezep@gmail.co m wrote:[color=blue]
> i dont know, i thought it might be related to php, or some of the guys
> here may know...
> should i post somewhere else?
>[/color]

FreeTDS has a connection pooling capability, check the docs at www.freetds.org

[Jerry Stuckle]

Re: php and freetds

Uber Geschlissen wrote:[color=blue]
> Jerry are you just a dickhead or do you have multiple personalities?
>
> FreeTDS is used with PHP.
>
> Duh!
>
>
> Jerry Stuckle wrote:
>[color=green]
>> erezep@gmail.co m wrote:
>>[color=darkred]
>>> I'm running a site balanced between 5 apache servers running on FC3,
>>> apache 2.0.53,php 4.3.4,freetds 0.63.
>>>
>>> I have this strange problem that sometimes, not even times of load, the
>>> connections table at the sql server gets to a very high value (about
>>> 1000) my average is below 200.
>>>
>>> I don't know how to solve this, but I know that if I restart the
>>> process of all my apache servers, everything turns ok,
>>>
>>> This happens at random times, sometimes 2 times a day, and sometimes
>>> even 10.
>>>
>>>
>>> Do you know what might be the problem?
>>>
>>>
>>>
>>> Thanks In Advance.
>>>
>>>
>>>
>>> Erez
>>>[/color]
>>
>> And your PHP question is?
>>[/color]
>[/color]

Go to hell.

I just asked what his PHP question was. Sure FreeTDS is used with PHP.
So are MySQL, Oracle, ODBC, Apache, OSCommerce, PhpBBS and dozens of
other packages and tools. Does this mean any question on any of these
are "on topic"?

The fact here is - he has a problem. It's not at all clear this is
related to PHP. And if it is a FreeTDS problem, FreeTDS has its own
mailing list where he can get much better help from the experts. Ask in
the right place and you get better answers.

And don't top post.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[Uber Geschlissen]

Re: php and freetds

F*** OFF AND DIE DICKHEAD

Who the f*** are you to pontificate and run people. Like you are
the moderator of the newsgroup? Ha! As if you had any power
you little twit. And to even suggest somebody not top-post, is
this the domain of pubescent little children who obsess over
the rules that they make up. I imagine you have all kinds of
little rules for sh** that doesn't matter. Whiner.

STFU and crawl back into your little hole.

People don't need to be pushed away that are asking for help. Smart
people that have answers think outside the box, obviously you want
to stay inside yours because you can't.


Jerry Stuckle wrote:[color=blue]
> Uber Geschlissen wrote:[color=green]
>> Jerry are you just a dickhead or do you have multiple personalities?
>>
>> FreeTDS is used with PHP.
>>
>> Duh!
>>
>>
>> Jerry Stuckle wrote:
>>[color=darkred]
>>> erezep@gmail.co m wrote:
>>>
>>>> I'm running a site balanced between 5 apache servers running on FC3,
>>>> apache 2.0.53,php 4.3.4,freetds 0.63.
>>>>
>>>> I have this strange problem that sometimes, not even times of load, the
>>>> connections table at the sql server gets to a very high value (about
>>>> 1000) my average is below 200.
>>>>
>>>> I don't know how to solve this, but I know that if I restart the
>>>> process of all my apache servers, everything turns ok,
>>>>
>>>> This happens at random times, sometimes 2 times a day, and sometimes
>>>> even 10.
>>>>
>>>>
>>>> Do you know what might be the problem?
>>>>
>>>>
>>>>
>>>> Thanks In Advance.
>>>>
>>>>
>>>>
>>>> Erez
>>>>
>>>
>>> And your PHP question is?
>>>[/color]
>>[/color]
>
> Go to hell.
>
> I just asked what his PHP question was. Sure FreeTDS is used with PHP.
> So are MySQL, Oracle, ODBC, Apache, OSCommerce, PhpBBS and dozens of
> other packages and tools. Does this mean any question on any of these
> are "on topic"?
>
> The fact here is - he has a problem. It's not at all clear this is
> related to PHP. And if it is a FreeTDS problem, FreeTDS has its own
> mailing list where he can get much better help from the experts. Ask in
> the right place and you get better answers.
>
> And don't top post.
>[/color]

[Jerry Stuckle]

Re: php and freetds

Uber Geschlissen wrote:[color=blue]
> F*** OFF AND DIE DICKHEAD
>
> Who the f*** are you to pontificate and run people. Like you are
> the moderator of the newsgroup? Ha! As if you had any power
> you little twit. And to even suggest somebody not top-post, is
> this the domain of pubescent little children who obsess over
> the rules that they make up. I imagine you have all kinds of
> little rules for sh** that doesn't matter. Whiner.
>
> STFU and crawl back into your little hole.
>
> People don't need to be pushed away that are asking for help. Smart
> people that have answers think outside the box, obviously you want
> to stay inside yours because you can't.
>[/color]

And you're stupid. You don't even have the brains to follow newsgroup
conventions - which in this case is NOT top posting, asshole.

You're the dickhead who started this. I was trying to steer Erez to the
place where he could get some *real* help.

You haven't even tried that, you stupid moron. No, you just break into
the middle of a conversation where you're not wanted, attack me because
I didn't help Erez to *your* satisfaction. (I have yet to see *you*
contribute anything to help him solve his problem!).

Fucking moron.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===

[erezep@gmail.com]

Re: php and freetds


Jerry Stuckle wrote:[color=blue]
> Uber Geschlissen wrote:[color=green]
> > F*** OFF AND DIE DICKHEAD
> >
> > Who the f*** are you to pontificate and run people. Like you are
> > the moderator of the newsgroup? Ha! As if you had any power
> > you little twit. And to even suggest somebody not top-post, is
> > this the domain of pubescent little children who obsess over
> > the rules that they make up. I imagine you have all kinds of
> > little rules for sh** that doesn't matter. Whiner.
> >
> > STFU and crawl back into your little hole.
> >
> > People don't need to be pushed away that are asking for help. Smart
> > people that have answers think outside the box, obviously you want
> > to stay inside yours because you can't.
> >[/color]
>
> And you're stupid. You don't even have the brains to follow newsgroup
> conventions - which in this case is NOT top posting, asshole.
>
> You're the dickhead who started this. I was trying to steer Erez to the
> place where he could get some *real* help.
>
> You haven't even tried that, you stupid moron. No, you just break into
> the middle of a conversation where you're not wanted, attack me because
> I didn't help Erez to *your* satisfaction. (I have yet to see *you*
> contribute anything to help him solve his problem!).
>
> Fucking moron.
>
> --
> =============== ===
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.[/color]
[color=blue]
> jstucklex@attgl obal.net[/color]


guys i just need some help for a problem that's realy disturbing me
there's no need to fight[color=blue]
> =============== ===[/color]

[Jerry Stuckle]

Re: php and freetds

erezep@gmail.co m wrote:[color=blue]
> Jerry Stuckle wrote:
>[color=green]
>>Uber Geschlissen wrote:
>>[color=darkred]
>>>F*** OFF AND DIE DICKHEAD
>>>
>>>Who the f*** are you to pontificate and run people. Like you are
>>>the moderator of the newsgroup? Ha! As if you had any power
>>>you little twit. And to even suggest somebody not top-post, is
>>>this the domain of pubescent little children who obsess over
>>>the rules that they make up. I imagine you have all kinds of
>>>little rules for sh** that doesn't matter. Whiner.
>>>
>>>STFU and crawl back into your little hole.
>>>
>>>People don't need to be pushed away that are asking for help. Smart
>>>people that have answers think outside the box, obviously you want
>>>to stay inside yours because you can't.
>>>[/color]
>>
>>And you're stupid. You don't even have the brains to follow newsgroup
>>conventions - which in this case is NOT top posting, asshole.
>>
>>You're the dickhead who started this. I was trying to steer Erez to the
>>place where he could get some *real* help.
>>
>>You haven't even tried that, you stupid moron. No, you just break into
>>the middle of a conversation where you're not wanted, attack me because
>>I didn't help Erez to *your* satisfaction. (I have yet to see *you*
>>contribute anything to help him solve his problem!).
>>
>>Fucking moron.
>>
>>--
>>============= =====
>>Remove the "x" from my email address
>>Jerry Stuckle
>>JDS Computer Training Corp.[/color]
>
>[color=green]
>>jstucklex@att global.net[/color]
>
>
>
> guys i just need some help for a problem that's realy disturbing me
> there's no need to fight
>[color=green]
>>============= =====[/color]
>
>[/color]

Sorry, I just let this idiot get a little under my skin.

You still need to do some troubleshooting . Your problem could be caused
by a lot of different things.

However, since the problem is MySQL connections, I'd suggest you start
troubleshooting with MySQL - check one of the MySQL newsgroups for help.
And if you think the problem is freetds, try the freetds mailing lists.

But there's nothing here indicating a PHP problem - and you'll get a lot
more help in more specific newsgroups.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===