RE: [EXTERNAL] MySQL auditing and tracing options

From: Khan, Muhammad <MKhan16_at_northwell.edu>
Date: Fri, 20 Mar 2020 14:40:28 +0000
Message-ID: <BLAPR19MB4354E07F7631B887387A5106BBF50_at_BLAPR19MB4354.namprd19.prod.outlook.com>



You are very limited if you are relying on community ed. You can forget auditing till then.

You still have general log which can give you query data etc so just take a deeper dive in that

Btw enterprise license is one of the least expensive (around $3K), very often companies don’t know that and that’s why keep trying to avoid it.

-Saad

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris King Sent: Friday, March 20, 2020 10:35 AM
To: oracle-l_at_freelists.org
Subject: [EXTERNAL] MySQL auditing and tracing options

External Email. Use Caution.
I'm new to MySQL (but not Oracle). I have a very complex system where data comes in and out and is shared between multiple applications. I would like to trace the data thru the system to help diagnose a severe performance issue. If in Oracle, I'd use auditing and tracing. I'm looking for something similar in MySQL. So far I've found that MySQL Enterprise Edition commercial editions has an audit add-on. But we don't use this edition. We don't want to add triggers because the reason I want to trace is to nail down a serious performance issue, and triggers will make that worse.

What other options are there for auditing and tracing in MySQL? Thanks in advance!
-ck

The information contained in this electronic e-mail transmission and any attachments are intended only for the use of the individual or entity to whom or to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this communication is not the intended recipient, or the employee or agent responsible for delivering this communication to the intended recipient, you are hereby notified that any dissemination, distribution, copying or disclosure of this communication and any attachment is strictly prohibited. If you have received this transmission in error, please notify the sender immediately by telephone and electronic mail, and delete the original communication and any attachment from any computer, server or other electronic recording or storage device or medium. Receipt by anyone other than the intended recipient is not a waiver of any attorney-client, physician-patient or other privilege.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 20 2020 - 15:40:28 CET

Original text of this message