You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2020/05/09 08:01:04 UTC
[GitHub] [incubator-doris] WingsGo opened a new issue #3534: [Proposal]FE audit plugin should support filter useless audit log
WingsGo opened a new issue #3534:
URL: https://github.com/apache/incubator-doris/issues/3534
When I use audit plugin, Ifound there are lots of useless audit log is loaded, such as
```
| 99abc4853e764830-902855994b12b6f8 | 2020-05-09 15:56:25 | 10.136.26.23:61708 | default_cluster:doris_monitor | | EOF | 3 | 0 | 0 | 1 | 125226 | 0 | 10.136.26.23 | /* mysql-connector-java-5.1.39 ( Revision: 3289a357af6d09ecc1a10fd3c26e95183e5790ad ) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@language AS language, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_buffer_length AS net_buffer_length, @@net_write_timeout AS net_write_timeout, @@query_cache_size AS query_cache_size, @@query_cache_type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@tx_isolation AS tx_isolation, @@wait_timeout AS wait_timeout
| 12ec8649222f48e8-ba13e65ca81a1849 | 2020-05-09 15:55:25 | 10.136.26.23:61594 | default_cluster:doris_monitor | | OK | 0 | 0 | 0 | 0 | 125217 | 0 | 10.136.26.23 | SET autocommit=1 |
| 12ec8649222f48e8-ba13e65ca81a1849 | 2020-05-09 15:55:25 | 10.136.26.23:61594 | default_cluster:doris_monitor | | OK | 0 | 0 | 0 | 0 | 125216 | 0 | 10.136.26.23 | SET character_set_results = NULL |
| 84dd74f57d5640bd-9d03cd3c217a7589 | 2020-05-09 15:55:25 | 10.136.26.23:61594 | default_cluster:doris_monitor | | EOF | 2 | 0 | 0 | 1 | 125219 | 0 | 10.136.26.23 | select current_timestamp()
```
So, I think we should support some filter rule for audit log
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman commented on issue #3534: [Proposal]FE audit plugin should support filter useless audit log
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #3534:
URL: https://github.com/apache/incubator-doris/issues/3534#issuecomment-626437183
It's OK?
What's your plan? Define the rule in `conf`?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman commented on issue #3534: [Proposal]FE audit plugin should support filter useless audit log
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #3534:
URL: https://github.com/apache/incubator-doris/issues/3534#issuecomment-626436572
It's OK?
What's your plan? Define the rule in `conf`?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] WingsGo commented on issue #3534: [Proposal]FE audit plugin should support filter useless audit log
Posted by GitBox <gi...@apache.org>.
WingsGo commented on issue #3534:
URL: https://github.com/apache/incubator-doris/issues/3534#issuecomment-626265116
> How a about just filtered them by SQL?
Filter them by SQL is OK, but I wonder if we can pre-register some filter rule in audit plugin to avoid record some abvious useless audit log, so that we don't need to writer different sql to get what we want?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] morningman commented on issue #3534: [Proposal]FE audit plugin should support filter useless audit log
Posted by GitBox <gi...@apache.org>.
morningman commented on issue #3534:
URL: https://github.com/apache/incubator-doris/issues/3534#issuecomment-626169519
How a about just filtered them by SQL?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org