Hi Taher, On Fri, Oct 9, 2009 at 10:59 AM, Taher Shihadeh <[email protected]> wrote:
> Hi Atif. > Sorry for not replying earlier, but hadn't had access to the computer for > the whole night. > Oh, I am so sorry about that. :-) > > I asume you do have 'Keep alive' and 'Chunked encoding' enabled in the > 'Advanced' section of Cherokee-Admin, right? > Yes, they are both set. Note there is no special communication between the application and the dbslayer. Just a simple GET from the shell. This layer is already helping us ( from the logs ) to see how much redundant junk is being sent to the db. Thats the thing about architechture, you add a new element and it makes the older one looks bad :-) but thats the whole point. thanks for looking into it. > Regards > > Atif Ghaffar wrote: > >> Sorry for replying directly to your email address instead of replying to >> the list. >> I was assuming that the default reply-to is set to the list address. >> >> >> ---------- Forwarded message ---------- >> From: *Atif Ghaffar* <[email protected] <mailto: >> [email protected]>> >> Date: Fri, Oct 9, 2009 at 5:33 AM >> Subject: Re: [Cherokee] DBSlayer. Persistent connections. Still cannot get >> them persisting. >> To: Taher Shihadeh <[email protected] <mailto:[email protected]>> >> >> >> >> >> I have this setup. >> >> application server -> cherokee-dbslayer -> dbserver >> I run the following code on the application server >> >> #!/usr/bin/perl >> use LWP::Simple; >> while(true){ >> getprint(" >> http://dbslayer:3307/dbslayer/ecmsdb/select%20*%20from%20user%20where%20user_id%3D1306399%20limit%201 >> "); >> } >> >> 1. I see the output of the script continously (expected behaviour) >> 2. I see the logs on the cherokee server (expected behaviour) >> 3. I dont see the persistent connection on the mysql server (not >> expected). >> >> What did I miss here? >> >> If I do a script like this >> >> #!/usr/bin/perl >> # 1. connect to database. >> # 2. do a select >> # 3. sleep for a long time >> then I do see the connection open from this script. >> >> thanks for help. >> I have many more questions but one at a time :-) >> >> best regards >> -- >> Atif >> >> >> On Thu, Oct 8, 2009 at 8:09 PM, Atif Ghaffar <[email protected]<mailto: >> [email protected]>> wrote: >> >> >> >> On Thu, Oct 8, 2009 at 7:51 PM, Atif Ghaffar >> <[email protected] <mailto:[email protected]>> wrote: >> >> >> >> On Thu, Oct 8, 2009 at 7:42 PM, Taher Shihadeh >> <[email protected] <mailto:[email protected]>> wrote: >> >> Hello. >> >> Yes. You probably want to read [1] to have some things in >> mind ;-) >> >> >> [1] >> >> http://www.cherokee-project.com/doc/modules_handlers_dbslayer.html >> >> >> Thanks Taher. >> >> >> I tried on a devserver where a perl script constantly hit the >> dbslayer with a query. >> I see the output but I do not see this connections persisting on >> the dbserver. >> >> >> Can you please elaborate on how to use the chunked encoding etc to >> get the persistence. >> thanks >> >> > > -- > [email protected] > http://unixwars.com/ > > -- best regards Atif Ghaffar
_______________________________________________ Cherokee mailing list [email protected] http://lists.octality.com/listinfo/cherokee
