In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Method 1: change the my.cnf configuration file
Vi / usr/local/kkmail/config/mysql/my.cnf uncomment the following two lines and restart mysql#general_log = 1#general_log_file = / tmp/kkmail_mysql.log
# set general log save path
# it seems that you can only save to / tmp or / var folder.
Method 2: operate in the mysql command console
# root user is required to have access to this file mysql > show global variables like'% general%' +-- + | Variable_name | Value | +- +-- + | general_log | OFF | | general_log_file | / usr/local/kkmail/data/mysql/default/localhost.log | +- -+-+ 2 rows in set (0.00 sec) mysql > set global general_log_file='/tmp/kkmail_mysql.log' Query OK, 0 rows affected (0.00 sec) mysql > set global general_log=on;Query OK, 0 rows affected (0.05 sec) mysql > show global variables like'% general%' +-+-+ | Variable_name | Value | +-+-+ | general_log | ON | | general_log_ File | / tmp/kkmail_mysql.log | +-+-- + 2 rows in set (0.00 sec) mysql > set global general_log=off Query OK, 0 rows affected (0.00 sec) mysql > show global variables like'% general%' +-+-+ | Variable_name | Value | +-+-+ | general_log | OFF | | general_log_file | | / tmp/kkmail_mysql.log | +-+-- + 2 rows in set (0.00 sec) |
Method 3: save the log in the general_log table of the mysql database
Mysql > set global log_output='table';Query OK, 0 rows affected (0.00 sec) mysql > show global variables like'% general%' +-+-+ | Variable_name | Value | +-+-+ | general_log | OFF | | general_log_file | | / tmp/kkmail_mysql.log | +-+-+ 2 rows in set (0.00 sec) mysql > set global general_log=on | Query OK, 0 rows affected (0.00 sec) mysql > show global variables like'% general%' +-+-+ | Variable_name | Value | +-+-+ | general_log | ON | | general_log_ File | / tmp/kkmail_mysql.log | +-+-+ 2 rows in set (0.01sec) mysql > use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with-ADatabase changedmysql > select * from general_log
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
Deployment of tnsname.orafal_clientfal_serverdata guard *
© 2024 shulou.com SLNews company. All rights reserved.