2007/12/13
IRC [04:36] *** cacru1 parted the chat.
IRC [08:43] *** CIA-25 parted the chat.
IRC [08:52] *** CIA-26 joined the chat.
IRC [09:18] *** dekoy joined the chat.
IRC [09:36] *** partymola parted the chat.
IRC [09:40] *** partymola joined the chat.
IRC [12:03] *** daguz parted the chat.
IRC [12:08] *** daguz joined the chat.
IRC [12:39] *** holycow joined the chat.
IRC [14:04] <dekoy> hi guys anyone alive ?
IRC [14:36] <Dossy> I am, kinda.
IRC [14:37] <dekoy> dossy what does the connection in the db pool mean
IRC [14:40] <dekoy> all the examples says 1
IRC [14:40] <dekoy> does that mean if i hold on to one db handle it will start the others ?
IRC [14:40] <dekoy> i mean starve
IRC [14:41] <dekoy> or is it a persistent connection where multiple db handles use it ?
IRC [14:42] <dekoy> at the same time
IRC [15:15] <Dossy> # of handles
IRC [15:16] <Dossy> one handle per connection
IRC [15:16] <dekoy> yeah that's what i figure im hoping that i was wrong
IRC [15:17] <dekoy> we are on the point right now where aolserver is _slowing_ down just because it's getting starved of connections to the db
IRC [15:17] <dekoy> would bumping this to 20 harm anything :)
IRC [15:21] <Dossy> i use at least 100-150
IRC [15:21] <dekoy> oh
IRC [15:21] <dekoy> ns_oracle ?
IRC [15:21] <Dossy> but it depends on what your db can handle
IRC [15:21] <Dossy> mysql
IRC [15:21] <dekoy> okay
IRC [15:22] <dekoy> the thing i have multiple pools hitting the same db like query then subquery then subsubquery so they can have multiple db handles at the same time
IRC [15:22] <dekoy> i should bump this to 20 just to see how it will behave
IRC [15:23] *** cacru1 joined the chat.
IRC [15:23] <dekoy> what's your maxconnections and maxthreads ?
IRC [15:25] <Dossy> 200, 40
IRC [15:25] <dekoy> thanks
IRC [15:25] <Dossy> yeah, you need to set up some measurements and test
IRC [15:26] <Dossy> there's a reason those settings are _configurable_ :) no one setting is right for everything
IRC [15:26] <dekoy> there's one funny thing when i use nstelemetry.adp
IRC [15:26] <dekoy> it does a sig 111
IRC [15:26] <dekoy> sig 11
IRC [15:26] <dekoy> after a few tries
IRC [15:26] <dekoy> :)
IRC [15:26] <dekoy> or sometimes after it restarts and you hit nstelemetry again
IRC [15:26] <dekoy> it just sig 11's
IRC [15:26] <dekoy> kinda odd just on the production server all the test servers nstelemetry works fine
IRC [15:27] <dekoy> and they have all the same copy of aolserver
IRC [15:27] <dekoy> 4.0.10
IRC [15:27] <dekoy> but that's another problem
IRC [15:27] <dekoy> thanks for the help
IRC [15:57] *** cacru1 parted the chat.
IRC [18:12] *** dekoy parted the chat.
IRC [21:03] *** CIA-26 parted the chat.
IRC [21:05] *** CIA-32 joined the chat.
IRC [23:47] *** holycow parted the chat.