My parent get a big chuckle out of it still; they really got me good with that one.
;)
Boysenberry
boysenberrys.com | habitatlife.com | selfgnosis.com
On Feb 10, 2006, at 2:20 PM, Mark Galbreath wrote:
<x-tad-bigger>That's alright...it's Friday and no one was sending any jokes, anyway. And I was getting a chuckle out of your name.</x-tad-bigger>
<x-tad-bigger> </x-tad-bigger>
<x-tad-bigger>mark</x-tad-bigger>
<x-tad-bigger>>>> Boysenberry Payne <[EMAIL PROTECTED]> 10-Feb-06 13:30:46 PM >>></x-tad-bigger>
<x-tad-bigger>Sorry about the extra posts I was having email difficulties that day...</x-tad-bigger>
<x-tad-bigger>Everything is working fine now though. The AutoCommit = 0 fixed it </x-tad-bigger>
<x-tad-bigger>all...</x-tad-bigger>
<x-tad-bigger>Thanks again for all of the help,</x-tad-bigger>
<x-tad-bigger>Boysenberry</x-tad-bigger>
<x-tad-bigger>boysenberrys.com | habitatlife.com | selfgnosis.com</x-tad-bigger>
<x-tad-bigger>On Feb 8, 2006, at 11:55 AM, Boysenberry Payne wrote:</x-tad-bigger>
<x-tad-bigger>> I took out the flags and the disconnect. I also set:</x-tad-bigger>
<x-tad-bigger>> $Apache::DBI::DEBUG = 2;</x-tad-bigger>
<x-tad-bigger>> to get debugging output.</x-tad-bigger>
<x-tad-bigger>></x-tad-bigger>
<x-tad-bigger>> I'm not getting any connection errors. (going to set mysql's max </x-tad-bigger>
<x-tad-bigger>> connections to 150 per server)</x-tad-bigger>
<x-tad-bigger>></x-tad-bigger>
<x-tad-bigger>> What I'm seeing is 37 mysql threads being created for 7 apache </x-tad-bigger>
<x-tad-bigger>> children. It would seem as</x-tad-bigger>
<x-tad-bigger>> though I would need to create a 5/1 ratio of mysql connections to </x-tad-bigger>
<x-tad-bigger>> apache children. Is that normal?</x-tad-bigger>
<x-tad-bigger>></x-tad-bigger>
<x-tad-bigger>> Thanks,</x-tad-bigger>
<x-tad-bigger>> Boysenberry</x-tad-bigger>
<x-tad-bigger>></x-tad-bigger>
<x-tad-bigger>> boysenberrys.com | habitatlife.com | selfgnosis.com</x-tad-bigger>
<x-tad-bigger>></x-tad-bigger>
<x-tad-bigger>> On Feb 8, 2006, at 9:59 AM, Perrin Harkins wrote:</x-tad-bigger>
<x-tad-bigger>></x-tad-bigger>
<x-tad-bigger>>> Boysenberry Payne wrote:</x-tad-bigger>
<x-tad-bigger>>>> What do I need to do to fix it?</x-tad-bigger>
<x-tad-bigger>>></x-tad-bigger>
<x-tad-bigger>>> You probably just need to raise the maximum number of connections on </x-tad-bigger>
<x-tad-bigger>>> your MySQL servers.</x-tad-bigger>
<x-tad-bigger>>></x-tad-bigger>
<x-tad-bigger>>> If you use two different database servers then you should be seeing a </x-tad-bigger>
<x-tad-bigger>>> total number of connections on each one that matches the number of </x-tad-bigger>
<x-tad-bigger>>> child processes running on your mod_perl server.</x-tad-bigger>
<x-tad-bigger>>></x-tad-bigger>
<x-tad-bigger>>>> $self->{flags} = { 'AutoCommit' => 1, 'RaiseError' => 1 } unless</x-tad-bigger>
<x-tad-bigger>>>> $self->{flags};</x-tad-bigger>
<x-tad-bigger>>></x-tad-bigger>
<x-tad-bigger>>> Connecting with different options sometimes will lead to opening more </x-tad-bigger>
<x-tad-bigger>>> connections rather than using an existing one. You may want to </x-tad-bigger>
<x-tad-bigger>>> always connect with the same flags and then change them on the </x-tad-bigger>
<x-tad-bigger>>> returned connection instead. You can use the Apache::DBI debugging </x-tad-bigger>
<x-tad-bigger>>> switch to see if connections are being reused or not.</x-tad-bigger>
<x-tad-bigger>>></x-tad-bigger>
<x-tad-bigger>>>> if( $self->{db} ) {</x-tad-bigger>
<x-tad-bigger>>>> my $h = $self->{db}->{dbh};</x-tad-bigger>
<x-tad-bigger>>>> $h->disconnect if $h;</x-tad-bigger>
<x-tad-bigger>>></x-tad-bigger>
<x-tad-bigger>>> That is pointless, since Apache::DBI doesn't allow disconnects.</x-tad-bigger>
<x-tad-bigger>>></x-tad-bigger>
<x-tad-bigger>>> - Perrin</x-tad-bigger>
<x-tad-bigger>>></x-tad-bigger>
<x-tad-bigger>>></x-tad-bigger>
<x-tad-bigger>></x-tad-bigger>
<x-tad-bigger>></x-tad-bigger>
<x-tad-bigger>></x-tad-bigger>
