inotify not installing in rocky8 linux [closed]

Question

I am trying to install inotify-tools.x86_64 in a rocky8 linux machine. I am getting the following error. Any leads are much appreciated

~yum install inotify-tools.x86_64 Last metadata expiration check: 1:09:43 ago on Thu 19 May 2022 04:50:55 PM UTC. No match for argument: inotify-tools.x86_64 Error: Unable to find a match: inotify-tools.x86_64

I tried to install it using dnf command but resulted in the same error.

I also tried to install it by cloning it from git but the autogen and configure shell script is not running in rocky8.

Answer 1

My preferred method for single-row upsert is:

BEGIN TRANSACTION;

UPDATE dbo.t WITH (HOLDLOCK, SERIALIZABLE)
  SET ...
  WHERE [key] = @key;

IF @@ROWCOUNT = 0
BEGIN
  INSERT dbo.t ...
END

COMMIT TRANSACTION;

If you believe you will much more often be performing an insert, you can swap the logic around so you try that first:

BEGIN TRANSACTION;
 
INSERT dbo.t ...
  SELECT @key, ...
  WHERE NOT EXISTS
  (
    SELECT 1 FROM dbo.t WITH (UPDLOCK, SERIALIZABLE)
      WHERE [key] = @key
  );
 
IF @@ROWCOUNT = 0
BEGIN
  UPDATE dbo.t SET val = @val WHERE [key] = @key;
END
 
COMMIT TRANSACTION;

Some background:

• Please stop using this UPSERT anti-pattern
• Checking for potential constraint violations before entering TRY/CATCH
• So, you want to use MERGE, eh?

Answer 2

What you describe is often called an "UPSERT" (in case you need a Google term for further research).

We use MERGE statements, since they allow us to specify both actions in one statement.

However, the syntax is a bit complex and there are some gotchas (don't forget to use HOLDLOCK, etc.), so we have abstracted away the actual SQL generation into an InsertOrUpdate(table, fieldsAndValuesToUpdate, keyFieldsAndValues) helper method in our source code. This also allows us to change the implementation later, if required.

When writing SQL code manually, I use IF...EXISTS (inside a transaction and also with HOLDLOCK), since it's easier to read and easier to write.

Answer 3

That depends on the situation.
Suppose you would write an insert with a where not exists clause and when @@rowcount = 0 you would do an update because this row already seems to exist.

If this is the most performant way to do it, that depends on your data.

if you would know that for example in 80% of the cases the insert would succeed, then this approach would actually perform very good.
If it seems that most of the times an update is needed, then you could turn the code around, do the update and then check the @@rowcount.

This only works off course if you can determine before you start if you will have mostly updates or mostly inserts.

The advantage of this method (certainly when you do update first) is that you do not need to check each row first with an if...exists first, you just do you insert/update and find out after if it worked or not. And because you know before that the insert or update will succeed most of the times, you gain performance