Is it possible to make logging of all mysql queries so that log files are created daily?

Question

Laravel

we have too big sql query logging file. In a few days, 40-50 gigs are typed. At the same time, executed requests get into the logs, but instead of the transferred values, a question mark "?"

Is it possible to set up logging of this channel in Laravel so that a log with a new file is created every day and to see the request in full - along with the parameters passed to the request?

Answer 1

You can log without problems yourself https://laravel.com/docs/9.x/database#listening-fo...
It is worth looking for a ready-made package that already has all the required functionality.