HOW TO MAKE CHANGES AVAILABLE AFTER EACH INSERT AND UPDATE
my application requires changes to be available at once. waiting for the server to be stopped and started does not work for me. thank you for your assistance. mike
Answer Answered by Jan Steinman in this comment.
Can you explain further?
Inserts and updates to tables are normally instantly available, and do not require the server to be "stopped and started."
If these inserts and updates are inside a transaction, you must wait for the rest of the transaction to complete before the result of the insert or update can be seen. That's correct behaviour, and isn't going to change.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
