Project:MySQL: Revision history

From MaRDI portal

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

28 October 2024

  • curprev 16:3416:34, 28 October 2024 Schubotz talk contribs 1,479 bytes +750 No edit summary
  • curprev 14:3114:31, 28 October 2024 Larissa talk contribs 729 bytes +24 No edit summary Tag: Visual edit
  • curprev 14:2714:27, 28 October 2024 Larissa talk contribs 705 bytes +705 Created page with "== Heading text == How to use the slow query log Set the slow query log to "on", by doing one of these things: For a permanent solution, edit `my.cnf` and set: slow_query_log = 1 slow_query_log_file = /var/lib/mysql/slow.log long_query_time = 1 #your time in seconds, the lower it is, the more will be logged For a temporary solution, log in to mysql as root and execute: SET GLOBAL slow_query_log = 'ON'; SET GLOBAL slow_query_log_file = '/var/lib/mysql/slow.log'; SET GLOBA..."