Master logs for all the operations performed on mysql DB

Operating Systems Linux Red Hat Master logs for all the operations performed on mysql DB

11-24-2012

Registered User

286, 4

Join Date: Nov 2011

Last Activity: 13 February 2016, 2:18 AM EST

Location: Bangalore, INDIA

Posts: 286

Thanks Given: 126

Thanked 4 Times in 4 Posts

thing is i dont want to enable logging now. i wanted to check the logs for the things which are run on db for past two days... is it possible to find that? or does server has inbuilt logging for all the operations performed on it...?
i checked the link you sent and chattr command is for setting file permission right.
also i have checked in /var/log/mysqld.log but it shows only error traced during mysql start and stop. it wont show mysql operations performed :-(

somehow few entries in DB of my server are missing. i wanted to find out how it happened or who did that. so trying to find to out is there any logs where i could trace out this thing. note that this servers are rebooted a couple of times. :-(

vivek d r

View Public Profile for vivek d r

Find all posts by vivek d r

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

If I ran perl script again,old logs should move with today date and new logs should generate.

Appreciate help for the below issue. Im using below code.....I dont want to attach the logs when I ran the perl twice...I just want to take backup with today date and generate new logs...What I need to do for the below scirpt.............. 1)if logs exist it should move the logs with extention...

2. UNIX Desktop Questions & Answers

How can I replicate master master and master master MySQL databse replication and HA?

I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database. For this I have created two...

3. UNIX for Dummies Questions & Answers

System administration tasks performed from a menu driven interface

I need to write a shell script that allows some system-administration tasks to be preformed automatically from a menu-driven interface. Automate the following tasks: � Copy directory tree � Delete files or directories � Output Information But I don't understand the question. What is a "menu...

4. Shell Programming and Scripting

How to grep the content performed by an User

I want to grep the content performed by an User from a file. Suppose that i have a following file HYD-HMS-2$ ls -lrt -rw-r--r-- 1 sdfrun sdf 31726356 Aug 1 13:04 journal.03.01082012.19.csv I could able to grep the content performed by a user by "sed" command as follows HYD-HMS-2$...

5. UNIX for Dummies Questions & Answers

logs of commands performed by users

Hi, when 2 users are logged as root , how can i find witch one had perform witch command? Thanks,

6. AIX

smit see comand performed ??

i in smit , press F6 , smit fs , Change / Show Characteristics of an Enhanced Journaled File System then F6 to see the comand , how can i see the command performed ?? x() { │ │ LIST= ...

7. Web Development

MySQL Master-Slave Configuration: Don't Replicate a Row of a Table?

Anyone have a clue about this? I have checked the MySQL documentation and it does not seem possible to exclude a row of a table from replication between Master and Slave. It seems that replication in MySQL can only be managed at the table level, not at the row level. Does anyone know a work...

8. Shell Programming and Scripting

Grep yesterday logs from weblogic logs

Hi, I am trying to write a script which would go search and get the info from the logs based on yesterday timestamp and write yesterday logs in new file. The log file format is as follows: """"""""""""""""""""""""""...

LEARN ABOUT PHP

udm_find

UDM_FIND(3)								 1							       UDM_FIND(3)

udm_find - Perform search

SYNOPSIS

       resource udm_find (resource  $agent, string  $query)

DESCRIPTION

	Performs a search.

	The search itself. The first argument - session, the next one - query itself. To find something just type words you want to find and press
       SUBMIT button. For example, "mysql odbc". You should not use quotes " in query, they are written here only to divide  a	query  from  other
       text.  mnoGoSearch  will find all documents that contain word "mysql" and/or word "odbc". Best documents having bigger weights will be dis-
       played first. If you use search mode ALL, search will return documents that contain both (or more) words you entered. In case you use  mode
       ANY,  the  search  will	return	list of documents that contain any of the words you entered. If you want more advanced results you may use
       query language. You should select "bool" match mode in the search from.

PARAMETERS

	      o $agent
		- A link to Agent, received after call to udm_alloc_agent(3).

	      o $query
		- mnoGoSearch understands the following boolean operators:  & - logical AND. For example, "mysql & odbc".  mnoGoSearch	will  find
		any  URLs  that  contain  both "mysql" and "odbc".  | - logical OR. For example "mysql|odbc". mnoGoSearch will find any URLs, that
		contain word "mysql" or word "odbc".  ~ - logical NOT. For example "mysql & ~odbc". mnoGoSearch will find URLs that  contain  word
		"mysql"  and  do  not  contain word "odbc" at the same time. Note that ~ just excludes given word from results. Query "~odbc" will
		find nothing!  () - group command to compose more complex queries. For example "(mysql | msql) &  ~postgres".  Query  language	is
		simple and powerful at the same time. Just consider query as usual boolean expression.

RETURN VALUES

	Returns a result link identifier on success or FALSE on failure.

PHP Documentation Group 													       UDM_FIND(3)

Red Hat