The newly introduced mutexes and semaphores are similar to OS-level synchronization objects like those in the Win32 API or the POSIX counterparts.

Question: Are they somehow based on OS-level mutexes and semaphores?

(I'm quite sure the answer is "no", at least I have not discovered according OS objects when creating mutexes and semaphores in the database.)

  • If the answer is "yes" this might allow for IPC between database threads and other (possibly database-unaware) processes. (*)
  • If the answer is "no", well, one is still free to use external functions to access OS-level synchronization objects:)

(*) As an example, we have used Win32 events for years to "automatically" run SQL Remote on the consolidated database when system data has been modified over night, i.e. the maintenance task in the database (a user-defined database EVENT, not to confuse with an OS-level event!) would set an according Win32 event, and a thread in a different process would "wake up" and run SQL Remote then.


Besides that, it's apparent that the database objects allow for synchronization between different machines as long as they are connected to the same database.

asked 23 Nov '15, 02:41

Volker%20Barth's gravatar image

Volker Barth
30.6k306456663
accept rate: 32%

edited 23 Nov '15, 02:48


You assumption is correct. The answer is NO, the mutexes and semaphores are implemented within the server and do not use any OS level primitives.

permanent link

answered 23 Nov '15, 08:53

Mark%20Culp's gravatar image

Mark Culp
23.0k9130270
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×85
×4
×4

question asked: 23 Nov '15, 02:41

question was seen: 303 times

last updated: 23 Nov '15, 08:53