Timeline for How to write marker messages into the MySQL general_log?
Current License: CC BY-SA 3.0
9 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jul 29, 2015 at 2:16 | vote | accept | Fran K. | ||
Jul 2, 2015 at 15:06 | comment | added | Fran K. | The system I am building has many moving parts, so it is not sufficient to only apply your scripts to a test database, I have to verify that it will work everywhere. That said, it looks like a good solution so far! | |
Jul 2, 2015 at 15:01 | comment | added | Fran K. | I'll mark it as the answer when I have it working. After decades of working in software I've noticed that having data to back up my claims is the best situation. So I always wait until I have proof that a concept is working before claiming it works in public. | |
Jul 2, 2015 at 4:47 | comment | added | RolandoMySQLDBA | @FranK. why not write that as an answer ? | |
Jul 1, 2015 at 18:48 | comment | added | Fran K. |
Even better, thanks! And It just occurred to me that I can mark my message in the select: SELECT NOW(), "message with X marker";
|
|
Jul 1, 2015 at 18:44 | comment | added | RolandoMySQLDBA |
In MySQL it is simply SELECT NOW(); .
|
|
Jul 1, 2015 at 18:43 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
added 236 characters in body
|
Jul 1, 2015 at 18:43 | comment | added | Fran K. |
I think that might work well. It occurred to me that I can send SELECT NOW() FROM DUAL; which will not only appear in the general_log, but will return the timestamp for that particular entry. I will try having my JMeter pause for a bit then send that between every segment. I'm off to try it out, thanks!
|
|
Jul 1, 2015 at 18:38 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |