From: Yue L. <yu...@ma...> - 2003-10-15 22:34:41
|
Thanks for the clarification. Yue ----- Original Message ----- From: "Mary Edie Meredith" <mar...@os...> To: "Yue Luo" <yu...@ma...> Cc: "Mark Wong" <ma...@os...>; "osdldbt-general" <osd...@li...> Sent: Wednesday, October 15, 2003 4:48 PM Subject: Re: [osdldbt-general] question about standalone driver > What we do for sapdb is run one or two drivers per physical CPU. With > zero think time it is similar to having a transaction monitor > concentrate all the connections on the app server over a few connections > to the database server. > > > We tried running the workload in the other configuration (one driver > with multiple threads) and we found that multiple threads connecting to > the sapdb database would not work correctly. One thread (per driver) > would connect and run fine, but the others just hung. Mark probably > remembers more detail... > > > On Wed, 2003-10-15 at 14:06, Yue Luo wrote: > > Yes. I am trying to set up an oltp program in a simulator. Getting rid of > > the client and making thinking/keying time 0 makes life a lot simpler for > > me. > > > > I am just curious. Without client concentrating the connections, isn't it > > unfair for SapDB? > > > > Yue > > > > > > ----- Original Message ----- > > From: <ma...@os...> > > To: <yu...@ma...> > > Cc: <osd...@li...> > > Sent: Wednesday, October 15, 2003 3:17 PM > > Subject: Re: [osdldbt-general] question about standalone driver > > > > > > > Oh, I think you're right. It looks like each terminal will open a > > > database connection. :) Sorry about the misinformation. > > > > > > Were you more interesting in running the driver without the client? > > > > > > Thanks, > > > Mark > > > > > > On 15 Oct, Yue Luo wrote: > > > > Thanks. > > > > But db_threadpool_init() is not used in terminal/driver.c. Line 230-234 > > are > > > > commented out. So I guess that -dbc doe not have any effect in > > standalone > > > > mode. Right? > > > > > > > > Yue > > > > ----- Original Message ----- > > > > From: <ma...@os...> > > > > To: <yu...@ma...> > > > > Cc: <osd...@li...> > > > > Sent: Wednesday, October 15, 2003 2:44 PM > > > > Subject: Re: [osdldbt-general] question about standalone driver > > > > > > > > > > > >> It's in client/db_threadpool.c in the function db_threadpool_init() on > > > >> line 142. > > > >> > > > >> Hope that helps, let me know if you have any more questions. > > > >> > > > >> Mark > > > >> > > > >> On 15 Oct, Yue Luo wrote: > > > >> > Could you point to me the line of code that actually need the client > > > > code? > > > >> > I compiled the driver in standalone mode with postgresql without > > linking > > > >> > client code after commenting out the -dbc option in terminal/main.c. > > > >> > > > > >> > Yue > > > >> > > > > >> > > > > >> > ----- Original Message ----- > > > >> > From: <ma...@os...> > > > >> > To: <yu...@ma...> > > > >> > Cc: <osd...@li...> > > > >> > Sent: Wednesday, October 15, 2003 1:02 PM > > > >> > Subject: Re: [osdldbt-general] question about standalone driver > > > >> > > > > >> > > > > >> >> Yeah, if I remember correctly, piece of the client code get compiled > > > >> >> into the driver in the standalone mode. So then the driver opens a > > > >> >> fixed number of connections to the database using the -dbc option. > > > >> >> > > > >> >> Mark > > > >> >> > > > >> >> On 14 Oct, Yue Luo wrote: > > > >> >> > I am trying to use the standalone mode with postgresql. But I > > am > > > >> > confused > > > >> >> > by the "-dbc" option to the driver. (terminal/main.c line > > 315-316). > > > > Is > > > >> > this > > > >> >> > db_connections really used in standalone mode? > > > >> >> > > > > >> >> > I suppose that none of the files in client/ directory is needed > > in > > > >> >> > standalone mode. Is it correct? > > > >> >> > > > > >> >> > Thanks. > > > >> >> > > > > >> >> > Yue > > > >> >> > > > > >> >> > > > > >> >> > ----- Original Message ----- > > > >> >> > From: <ma...@os...> > > > >> >> > To: <yu...@ma...> > > > >> >> > Cc: <osd...@li...> > > > >> >> > Sent: Tuesday, October 14, 2003 5:11 PM > > > >> >> > Subject: Re: [osdldbt-general] question about standalone driver > > > >> >> > > > > >> >> > > > > >> >> >> No, there is a client. We just never did any extensive testing > > > > using a > > > >> >> >> client with SAP DB. Similarly, we never did any extensive > > testing > > > > with > > > >> >> >> the standalone stuff with PostgreSQL. I would hope they would > > work, > > > > we > > > >> >> >> just never really tried it. :) > > > >> >> >> > > > >> >> >> Mark > > > >> >> >> > > > >> >> >> On 14 Oct, Yue Luo wrote: > > > >> >> >> > Do you mean that for SapDB there is no client to concentrate > > the > > > >> >> >> > connections? But the document talks about the client system. > > > >> >> >> > Thanks. > > > >> >> >> > > > > >> >> >> > Yue > > > >> >> >> > > > > >> >> >> > ----- Original Message ----- > > > >> >> >> > From: <ma...@os...> > > > >> >> >> > To: <yu...@ma...> > > > >> >> >> > Cc: <osd...@li...> > > > >> >> >> > Sent: Tuesday, October 14, 2003 3:45 PM > > > >> >> >> > Subject: Re: [osdldbt-general] question about standalone driver > > > >> >> >> > > > > >> >> >> > > > > >> >> >> >> You're correct about what STANDALONE is supposed to do. I > > > > haven't > > > >> >> >> >> tested the standalone mode with postgresql yet, but it's still > > > > being > > > >> >> >> >> mantained for SAP DB, since that's how we drive that database. > > > >> >> >> >> > > > >> >> >> >> Mark > > > >> >> >> >> > > > >> >> >> >> On 14 Oct, Yue Luo wrote: > > > >> >> >> >> > Hi, > > > >> >> >> >> > dbt2, postgresql backend. > > > >> >> >> >> > I found many #ifdef STANDALONE in the driver source code. > > I > > > >> >> > suppose > > > >> >> >> >> > that if STANDALONE is defined, then the driver will connect > > to > > > > the > > > >> >> >> >> > database directly instead of going through the client. Is > > this > > > >> >> > correct? > > > >> >> >> >> > Does the standalone mode work with postgresql? Is > > standalone > > > > mode > > > >> >> > sill > > > >> >> >> >> > being maintained? > > > >> >> >> >> > Thanks. > > > >> >> >> >> > > > > >> >> >> >> > Yue > > > > > > > > > > > > ------------------------------------------------------- > > > This SF.net email is sponsored by: SF.net Giveback Program. > > > SourceForge.net hosts over 70,000 Open Source Projects. > > > See the people who have HELPED US provide better services: > > > Click here: http://sourceforge.net/supporters.php > > > _______________________________________________ > > > osdldbt-general mailing list > > > osd...@li... > > > https://lists.sourceforge.net/lists/listinfo/osdldbt-general > > > > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SF.net Giveback Program. > > SourceForge.net hosts over 70,000 Open Source Projects. > > See the people who have HELPED US provide better services: > > Click here: http://sourceforge.net/supporters.php > > _______________________________________________ > > osdldbt-general mailing list > > osd...@li... > > https://lists.sourceforge.net/lists/listinfo/osdldbt-general > -- > Mary Edie Meredith <mar...@os...> > Open Source Development Lab > > |