11-24-2012
Hi,
if you mean to enable general query log, you may find hints at:
MySQL query logging
but be aware that this kind of logging is generally intended for debugging purposes (it can slow down your db and/or clog disk space).
For the problem of appending-only, you may try a trick if you are on a linux host with 'chattr' command, i.e. see the end of the post:
How To Set File Attributes In Linux Using Chattr Command | All about Linux
Anyway, be aware that this may lead to space consumption as well (setup preliminary tests on non-production system in order to be safe).
see ya
fra
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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:
""""""""""""""""""""""""""... (3 Replies)
Discussion started by: harish.parker
3 Replies
2. Web Development
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... (5 Replies)
Discussion started by: Neo
5 Replies
3. AIX
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= ... (5 Replies)
Discussion started by: prpkrk
5 Replies
4. UNIX for Dummies Questions & Answers
Hi,
when 2 users are logged as root , how can i find witch one had perform witch command?
Thanks, (1 Reply)
Discussion started by: prpkrk
1 Replies
5. Shell Programming and Scripting
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$... (0 Replies)
Discussion started by: duppalav
0 Replies
6. UNIX for Dummies Questions & Answers
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... (2 Replies)
Discussion started by: femchi
2 Replies
7. UNIX Desktop Questions & Answers
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... (0 Replies)
Discussion started by: Palak Sharma
0 Replies
8. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: Sanjeev G
1 Replies
LEARN ABOUT REDHAT
uri::url
URI::URL(3) User Contributed Perl Documentation URI::URL(3)
NAME
URI::URL - Uniform Resource Locators
SYNOPSIS
$u1 = URI::URL->new($str, $base);
$u2 = $u1->abs;
DESCRIPTION
This module is provided for backwards compatibility with modules that depend on the interface provided by the "URI::URL" class that used to
be distributed with the libwww-perl library.
The following differences compared to the "URI" class interface exist:
o The URI::URL module exports the url() function as an alternate constructor interface.
o The constructor takes an optional $base argument. The "URI::URL" class is a subclasses of "URI::WithBase".
o The URI::URL->newlocal class method is the same as URI::file->new_abs
o URI::URL::strict(1)
o $url->print_on method
o $url->crack method
o $url->full_path; same as ($uri->abs_path || "/")
o $url->netloc; same as $uri->authority
o $url->epath, $url->equery; same as $uri->path, $uri->query
o $url->path and $url->query pass unescaped strings.
o $url->path_components; same as $uri->path_segments (if you don't consider path segment parameters).
o $url->params and $url->eparams methods.
o $url->base method. See URI::WithBase.
o $url->abs and $url->rel have an optional $base argument. See URI::WithBase.
o $url->frag; same as $uri->fragment
o $url->keywords; same as $uri->query_keywords;
o $url->localpath with friends map to $uri->file
o $url->address and $url->encoded822addr; same as $uri->to for mailto URI.
o $url->groupart method for news URI.
o $url->article; same as $uri->message
SEE ALSO
URI, URI::WithBase
COPYRIGHT
Copyright 1998-2000 Gisle Aas.
perl v5.8.0 2002-05-09 URI::URL(3)