Re: InnoDB Row Lock test (A query maybe?)

2005-02-22 Thread Begumisa Gerald M
Hi Shawn, Thanks for taking time to respond to this. > [...]Usually the database sets and releases locks like that in > response to a series of statements on the order of sub-seconds, not > for the several seconds to minutes that may be required of an > application-level lock). A

InnoDB Row Lock test (A query maybe?)

2005-02-21 Thread Begumisa Gerald M
Hi, I'm writing an application that uses InnoDB tables to provide transactional integrity. The front-end is a web-based interface. I'd like to know - is there a way one can issue a query to test whether a particular set of rows (or row) has already been locked by another session - rather than th

Re: Using both embedded and 'normal' server in a client

2003-10-16 Thread Begumisa Gerald M.
On Thu, 16 Oct 2003, Serge Cohen wrote: > [...] > Now I'd like to use the libmysqld, so that I can have a an embedded > server, still this same application should be able to connect to a DB > server (over internet). > From what I've read and tried, the libmysqld library does not provide > the fun

Re: Scalability question

2003-09-25 Thread Begumisa Gerald M.
On Thu, 25 Sep 2003 [EMAIL PROTECTED] wrote: > [...] > Which is likely to be slower. Wow! > [...] Just give it lots of Ram so that it can cache its indexes in > mamory, and it will perform very well. Thanks for taking time to answer this. Cheers, Gerald -- MySQL General Mailing List For list

Scalability question

2003-09-25 Thread Begumisa Gerald M.
Hi, Imagine I had a table with 50,000,000 rows, would it improve search speeds if I split it up into smaller tables of 10,000,000 rows each? This means if I had to search for a record, I'd have to query the 5 tables one after the other. I'd greatly appreciate any help. Gerald. -- MySQL General

Re: Memory and C API...

2003-09-23 Thread Begumisa Gerald M.
gt; It might be helpful to say, that I'm running linux... > > Lars > > Am Die, 2003-09-23 um 14.47 schrieb Begumisa Gerald M.: > > Hi, > > > > Could you post your definitions for 'dbase' and 'err'... > > > > Gerald. > > >

Re: Memory and C API...

2003-09-23 Thread Begumisa Gerald M.
Hi, Could you post your definitions for 'dbase' and 'err'... Gerald. On Tue, 23 Sep 2003, Lars Wenderoth wrote: > Hello there! > > I have a problem with a little C program i am writing.. It uses > SSL-encrypted connections to a special server. This server needs > information from a MySQL databa