Want to get all Sql queries during the page load.
can any one help me on How to log all Magento 2 SQL queries ?
asked Mar 3, 2017 at 10:14
Add a comment
|
3 Answers
In your app/etc/di.xml, replace the line:
<preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\Quiet"/>
with
<preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\File"/>
<type name="Magento\Framework\DB\Logger\File">
<arguments>
<argument name="logAllQueries" xsi:type="boolean">true</argument>
<argument name="debugFile" xsi:type="string">log/sql.log</argument>
</arguments>
</type>
Flush Magento cache (in backend, or by executing bin/magento cache:flush) after this.
Log file is located here: var/log/sql.log
-
6I am not sure, but this might not work anymore in 2.2 ; at least it doesnt in my case.– FelixNov 14, 2017 at 16:45
-
2In latest version of magento (i'm checking on 2.3.1) You can use this: php bin/magento dev:query-log:enable --include-all-queries=1 --query-time-threshold=1 --include-call-stack=false (as mentioned by @Felix below) Jun 12, 2019 at 7:44
bin/magento dev:query-log:enable
. (copied my answer from Magento 2 log database queries)
-
3This is the correct answer for Magento 2.2 and beyond. As mentioned in the DevDocs page, the queries get logged to
var/debug/db.log(not a file invar/log) Nov 7, 2019 at 16:31
Alternative (to the answer of Siju Joseph),
if you don't want to change your magento config, you can also configure mysql itself: activate slow.log and set it to 0 seconds.
Therefore edit /etc/mysql/my.cnf and set slow_query_log to 'on' and long_query_time to '0'.
This will result in all mysql queries getting logged.
-
-
in the my.cnf. Just set slow_query_log to 'on' and long_query_time to '0' Nov 9, 2017 at 13:26