Tag Info

New answers tagged

0

There are a handful of options that are Dynamic, but for the most part they have to be added to the cnf file, which means you need to restart your live databases if you want to use it.


3

That will work fine - however you need to add a delimiter to your trigger: DELIMITER $$ CREATE DEFINER=`root`@`localhost` TRIGGER `admin`.`company_AFTER_UPDATE` AFTER UPDATE ON `company` FOR EACH ROW BEGIN INSERT INTO AuditCompany select *, now() from Company where id = NEW.id; END $$ DELIMITER ; You might gain some performance benefit if you ...


0

OK, from what I can tell, Percona Audit Log Plugin, has very little in the way of configuration. I looked at McAfee Audit Plugin, but that doesn't seem to work on Debian MySQL. I also looked at MariaDB Audit Plugin, and that seems to have some level of filtering (DDL or DML). Unfortunately it requires 5.5.42 , and most of my DBs are 5.5.40. Still, on my ...


2

If you just want to know number of index updates (regardless of how many rows affected, how wide the indexes are, etc.) and as long as you can be sure the service doesn't get restarted or indexes dropped/re-created in that timeframe, then you can look at sys.dm_db_index_usage_stats now and after a couple of days. As suggested by Kin, have a look at Nacho's ...


1

When you say, "without using triggers", do you mean any triggers or just row-by-row triggers on tables? I ask because you may be able to get what you want with judicious use of the CONTEXT_INFO() function, but you would need to ensure that SET CONTEXT_INFO was called correctly before your operations take place. One place to do that might be a ...


2

Please take a look at the connect bug: https://connect.microsoft.com/SQLServer/feedback/details/622195/adding-user-hostname-application-name-and-timestamp-to-cdc-information This behavior is by design. CDC is designed to expose the following information about a change: updated columns, type of operation and transaction information. It has not been ...


2

I am not sure about CDC, but if the login has view server state permission you can use DMVs to get some information. This is given in Books Online here. I changed the query to add columns which would give you the IP address: SELECT c.session_id, c.net_transport, c.encrypt_option, c.auth_scheme, s.host_name, s.program_name, ...


0

Just a note about triggers regarding of performance: If you have an application that may work frequently with different database engines such, let us say an ERP that should accept any known database engines such as MySQl, MS SQl, ORACL, Inerbbase...etc triggers may become a problem in maintaining the code since triggers syntax is different for each database ...



Top 50 recent answers are included