I am using Magento 2.2.3 it is in production mode. The order listing page in admin loads very slow. I have been facing this issue since long.

To debug this I have also tried enabling query log through terminal using the following command : bin/magento dev:query-log:enable and then cache:flush

But still I cannot see var/log/db.log or var/debug/db.log file.

I have also tried replacing the line in app/etc/di.xml file as shown below:

<!-- <preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\LoggerProxy"/> -->
<preference for="Magento\Framework\DB\LoggerInterface" type="Magento\Framework\DB\Logger\File"/>
<type name="Magento\Framework\DB\Logger\File">
        <argument name="logAllQueries" xsi:type="boolean">true</argument>

After this I have executed all three commands setup:upgrade; setup:di:compile; setup:static-content:deploy

But still I didn't get any such log file for queries.

  • Additional information request. Post on pastebin.com and share the links. A) RAM size of your MySQL Host server Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner.pl report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, df -h for a linux/unix free space list by device, for server workload tuning analysis. – Wilson Hauck May 24 '19 at 0:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.