Hi!
Our logging in drizzle differs from MySQL, but the below are good
ideas for ours.
Cheers,
--Brian
Begin forwarded message:
From: cosmih <[email protected]>
Date: March 4, 2009 2:50:45 PM PST
To: [email protected]
Subject: Re: Re: [PATCH] new feature for General Log (PCI compliance)
Hi,
What is the status with this patch ?
Can you make it available online ?
It can be applied on mysql 4.1.22 ?
I asking about it because I am very interested on it.
Thank you,
--
cosmih
Adam Liverman wrote:
Hi,
My company is working on PCI compliance and a situation arose where
we need logging
enabled on our MySQL servers. To my knowledge the only way to do
this is to turn on the
General query log.
Unfortunately doing this would cause all sorts of performance hits
as the database
servers handle a lot of queries from the website and makes
maintaining/scanning through
them a real issue. (1-2gigabyte file in an hour or so)
To alleviate these issues I changed the source to allow two new
options:
#Comma separated list of accounts at hosts (ex: r...@stripped) to
ignore from the
general query log.
general_query_log_ignore_accounts =
"someacco...@stripped;someacco...@stripped"
#Ignore replication logs in general log
general_query_log_ignore_replication
The first option allows you to configure a group of accounts at a
certain host/ip to
be ignored from the log. For us our website uses a specific
account, thus we add that
account to the first part of the list.
The second option disables the writing to the log from the primary
slave thread.
If an account is setup to be ignored, it is ignored, except on an
unsuccessful login
attempt. That is logged regardless of if the account is ignored or
not.
Performance hit for enabling the features is minimal, 1-2% increase
in load.
Would this be a useful addition to the MySQL base?
-Adam Liverman
Software Developer
Fire Mountain Gems
--
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe: http://lists.mysql.com/[email protected]
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
