I'm using "portable" Mysql(not installed and should be started by batch file) "@echo off @color B echo Starting the MySQL mysql5\bin\mysqld.exe --console --max_allowed_packet=64M"

it has inside 2db, and I want to log any queries for only one db. But I can't find the config(lol) It has 5 configs inside: my-huge, my-innodb-heavy-4G, my-large and so on. What config should I edit?

  • 1
    what do you mean by portable? Ignore the config files, they are largely unchanged since 1999. What is the mysqld version (beyond "5")? What types of tables (myisam/vs innodb) are in use? There no easy way to log all queries for only one db, is logging the updates/inserts/deletes sufficient? What is the aim of logging? Welcome to DBA, please edit the question to include this requested information.
    – danblack
    Jul 11, 2020 at 0:56
  • v there's is 2 db: one DB is very dynamic and used to save user's data every second, 2-nd DB is not dynamic at all and used mostly as read only database, filled mostly with "constants" - it has tables both InnoDb and myisam. I am editing 2-nd tab and I need to log every update, so I can apply them to our git as a commit.
    – Vorgul
    Jul 11, 2020 at 11:57
  • MariaDB has something like that; MySQL does not.
    – Rick James
    Aug 31, 2020 at 5:48


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.