| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
About Collectors
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
...
Step 1: Enabling logging (if desired)
| Info |
|---|
See more information about logging here - https://dev.mysql.com/doc/refman/8.0/en/log-destinations.html Note this study Impact of General Query Log on MySQL Performance and the performance impact of enabling logging. |
Enable global logging
| Code Block |
|---|
SET GLOBAL log_output = 'TABLE'; SET GLOBAL general_log = 'ON'; |
...
| Code Block |
|---|
SET @old_log_state = @@GLOBAL.general_log; SET GLOBAL general_log = 'OFF'; ALTER TABLE mysql.general_log ENGINE = MyISAM; ALTER TABLE mysql.slow_log ENGINE = MyISAM; ALTER TABLE mysql.general_log ADD INDEX (event_time); ALTER TABLE mysql.slow_log ADD INDEX (start_time); SET GLOBAL general_log = @old_log_state; |
...
...
Step 2: Create the Source in K
...