问题描述
我试图弄清旧版应用程序对我们的mysql数据库（复数）有什么影响，因为我需要完全重构/替换其中的一部分，而无需关心它的工作方式。我只是对结果感兴趣。
I am trying to figure out what a legacy app does to our mysql databases (plural) as I need to refactor/replace a part of it completely without caring how it does it. I'm just interested in the result.
当前，我正在使用和通过添加 $ ENV {DBI_PROFILE} =！Statement / DBI :: ProfileDumper; 。在命令行上运行 dbiprof dbi.prof 时，这显示了很多查询，但这似乎有些奇怪。
Currently I am working with DBI::Profile and DBI::ProfileDumper by adding $ENV{DBI_PROFILE} = "!Statement/DBI::ProfileDumper";. That shows me a bunch of queries when running dbiprof dbi.prof on the commandline, but it seems a little odd.
可能是我读错了报告。
Might be I am reading the report wrong.
#####[ 3 ]###########################################################
Count : 4
Total Time : 0.018930 seconds
Longest Time : 0.018881 seconds
Shortest Time : 0.000005 seconds
Average Time : 0.004732 seconds
Key 1 :
INSERT INTO orders (foo, bar) VALUES (1, 2)
为什么显示 4 作为计数？它正在 orders 表中创建两行，而不是4。此外，它还显示了它正在执行的第一个插入的值。对于其他一些人，它会将？保留在查询字符串中。
Why is it showing 4 as Count? It is creating two rows in the orders table, not 4. Also, it is showing the values of the first insert it is doing. For some others, it keeps the ? in the query string.
也许分析是错误的方法。我一直在考虑用猴子补丁DBI来记录查询，但是我不确定该去哪里。可能我可以在 prepare 中添加日志记录功能，并在 execute 中添加获取查询字符串以及参数
Maybe profiling is the wrong approach. I've been thinking about monkey-patching DBI to log the query, but I am not sure where to go with that. Might be I could add a logging function to prepare, and to execute to get the query strings as well as the parameters.
是否已经可以使用类似的东西了？当然有人要这样做吗？或者是另一种方法？
Is there something similar already that I can use? Surely someone wanted to do this? Or maybe another approach?
我愿意接受任何建议。
推荐答案
您要在级别2上使用跟踪：
You want to use tracing at level 2:https://metacpan.org/pod/DBI#TRACING
这篇关于如何使DBI记录包括参数的所有查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！