• notice
  • Congratulations on the launch of the Sought Tech site

MySQL opens universal query and slow query

Open the general query log: record all query logs.The log path defaults to/var/lib/mysqlNext.The name defaults to "machine name.log"

vi/etc/my.cnf

[mysqld]

...

log

...

Open slow query log: record all slow query logs (the valve is 2 seconds in this example).

vi/etc/my.cnf

[mysqld]

...

log-slow-queries=/var/log/mysqlslowquery.log

long_query_time=2

.....

Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

buy lipitor online cheap & lt;a href="https://lipiws.top/"& gt;buy lipitor 40mg online cheap& lt;/a& gt; order lipitor sale

Juofit

2024-03-08

Leave a Reply

+