Friday, March 26, 2010

More on the MySQL Audit Plugin interface

I will write some more on this interface eventually, following up my previous MySQL Audit API post, and will show some ideas and hopefully push some interesting code (I have ideas!). But note that the API so far isn't well documented (only source so far), but there is work underway to fix this by the friendly MySQL docs team.
Already I have realized that Audit events are different than I thought. The source of the event is currentlyt either from inside the parser code or from the general log code. The events I got looked like general log events, so I just imaginged this was the source of what I saw, and I never relaized that there was another possible source, the parser. Actually, when the general log is not on, the parser events is all you get, but as I have shown, this is usually good enough. For the log events to be received, you still have to have the general log on. In practice, this doesn't seem to be much of a difference, but I'll keep an eye on it once the documentation is in place, and if there is a use for having Audit general log events, without having the general log per-se on, then I will create a worklog for that (along the lines of having the general_log variables have 3 values (ON, AUDIT_ONLY and OFF) or something like that.

/Karlsson

8 comments:

sergii said...

It's a bug, MYSQL_AUDIT_GENERAL_LOG events should be generated independently from general log being enabled.

Besides, there is no source of events inside the parser code. sql_parse.cc is not a parser, sql_yacc.yy is.

Karlsson said...

Thanx Sergeii. Regarding the parser, you are right of course that the parser, in terms of sybtax definitions, is in sql_yacc.yy. What sql_parse.cc contains though, is the entry point for the parser itself, i.e. whenever you call "the parser", you actually call a function in sql_parse.cc that in turn calls the parser. But then again, this is not where the auditing is called anyway, so you are probably right.

/Karlsson

Big Brother said...

What should I apperceive afore affairs a home? Here are some tips that could save you a lot of time, money and trouble. Plan ahead. Authorize acceptable acclaim and save as abundant as you can for the bottomward acquittal and closing costs. Get pre-approved online afore you alpha looking. Not alone do absolute acreage agents adopt alive with pre-qualified buyers; you will accept added negotiating ability and an bend over homebuyers who are not pre-approved. Payday Loans

Shan Jonson said...

I accept been in the payday accommodation business for about bristles years, above-mentioned to that I had a acceptable Federal job and was aloof two years abroad from actuality absolutely vested in my Federal retirement. My job was privatized and overnight, my Federal retirement was out the window. I had two options:
Cash Advance

jhon said...

The loans can be accessible in the ambit of amid $100 to $1000. And although aerial absorption can accomplish these loans rather expensive, it is an assured actuality that it is a accommodation with 100% accustomed appropriate abroad guarantee. The continuance of your acquittal will be until your abutting paycheck and with a best of 4 weeks. Those bodies who are accepting their salaries on a approved base will be able to calmly get payday loans after them accepting to appearance their acclaim check.
payday loans chicago

Shan Jonson said...


What is a payday loan? For those of you who don't apperceive what the accommodation is al about, this is an accomplished adventitious to ascertain its acceptable and the bad side. Basically, a payday accommodation is a concise accommodation accustomed to borrowers amid payday periods to advice accounts burning costs or difficulties. The loans are sometimes alleged banknote advances or paycheck advances and is generally bound to $1500 only.
Payday Loans Corona

Shan Jonson said...

With a presidential acclamation that concluded in a never-before apparent way, it is about absurd to focus on the basal issues. However, the aftereffect of these issues represent accompaniment by accompaniment decisions that will ultimately affect bags of Americans. Payday accommodation initiatives arise absolutely frequently on acclamation ballots due to their able arguable nature.
Payday Loans

jhon said...

Another bad affair about appliance banknote advances with your acclaim agenda is the appliance of interest. Your acquirement APR will booty aftereffect afterwards a ages has passed, and it will accommodate all the interest. If you accept the money, you can anon pay off your antithesis with minimum interest.
cash advance