RE: General Implementation Questions - Chris Means - com.mysql.lists.win32

14 messages in com.mysql.lists.win32RE: General Implementation Questions

From	Sent On	Attachments
Chris Means	20 Dec 1999 19:11
Sinisa Milivojevic	21 Dec 1999 04:52
Chris Means	21 Dec 1999 06:51
Hood Gardner	21 Dec 1999 07:09
sin...@mysql.com	21 Dec 1999 07:13
Chris Means	21 Dec 1999 07:18
Chris Means	21 Dec 1999 07:22
Hood Gardner	21 Dec 1999 07:36
sin...@mysql.com	21 Dec 1999 07:56
Chris Means	21 Dec 1999 08:13
Paul DuBois	21 Dec 1999 08:27
Steve Ruby	21 Dec 1999 08:31
sin...@mysql.com	21 Dec 1999 08:34
Chris Means	21 Dec 1999 08:40

Subject:	RE: General Implementation Questions
From:	Chris Means (cme...@intfar.com)
Date:	12/21/1999 07:22:53 AM
List:	com.mysql.lists.win32

Thanks...I'm only using the Windows version of MySQL, and have no real experience with Linux or UNIX (yet)...the blub on the book doesn't mention the Windows implementation...is it written reasonably platform agnostic, or am I going to get lost in references I won't understand?

Thanks.

-----Original Message----- From: Hood Gardner [mailto:hoo...@laurie.net] Sent: Tuesday, December 21, 1999 9:10 AM To: cme...@intfar.com Cc: MySQL Subject: RE: General Implementation Questions

You may want to consider picking up a copy of "MySQL and mSQL" from O'Reilly & Assoc. It's a good introduction and reference. Here's the link... http://www.oreilly.com/catalog/msql/

Happy Holidays!

At 08:51 AM 12/21/99 -0600, Chris Means wrote:

So are you saying that you feel MySQL would be a GOOD fit for this 'application' (an offline reporting database that's updated hourly)?

Just saying that you (and the other developers etc.) don't think record/page locks are a good idea, does nor really tell me how MySQL handles situations where a person is updating a record, and another person want to read it...I'm comfortable with record locking and it makes sense to me, especially in our applications, I do however like to keep an open mind...what are your arguments against it?

Could you point me to an anchor in the manual that describes what is going on inside MySQL in this particular scenario?

Thanks.

-----Original Message----- From: Sinisa Milivojevic [mailto:sin...@mysql.com] Sent: Tuesday, December 21, 1999 6:53 AM To: cme...@intfar.com; Chris Means; MySQL Subject: Re: General Implementation Questions

On Tue, 21 Dec 1999, Chris Means wrote:

Hi,

I've finally got a couple of basic tables working in MySQL, and have used the mm JDBC driver to pull the data out...very fast...nice!

I've certainly got more reading ahead of me to know and understand MySQL further, but I'd like to see if you "people in the know" have some pointers for me.

I'm looking to use MySQL as an 'offline reporting database' to support our current OLTP system.

Though it would primarily be used for SELECTs, I've obviously got to get the data into the database...and I'd like to do it on a regular basis...maybe as much as once an hour.

I've not found yet how (if) MySQL does record/page level locking, and I'm not sure what would happen if one process were trying to read records that another process was (replacing or modifing).

Could someone tell me how MySQL works in that kind of setting...or is this not a good way to use the current version of MySQL. I know it's not Oracle, and we certainly don't need Oracles' data integrity features in this application.

Note: We would probably be using the MyODBC interface to MySQL as the client would most likely be running either Crystal Reports or MS Access.

Any info. would be appreciated.

Thanks.

Hi!

MySQL does not have record/page locks, only table locks. But we at MySQL, do think that it is not wise to use ANY kind of locks. In most setups It is possible to avoid locks. For the cases where it is not possible, you could use GET_LOCK() function, which is an application lock, and it locks simply a name. I do not know whether your version of MySQL supports it, but you could try.