Shulou(Shulou.com)05/31 Report--

This article introduces the "MySQL operation log view of the actual steps," the relevant knowledge, in the actual case of the operation process, many people will encounter such a dilemma, and then let the editor lead you to learn how to deal with these situations! I hope you can read it carefully and be able to achieve something!

Set up the my.ini file, my MySQL installation environment is xp sp2, this file is in the CRV.. Next, open the file for modification

[MySQLd]

Basedir=E:/MySQL 4.0.12

# bind-address=192.168.15.196

Datadir=E:/MySQL 4.0.12/data

# language=E:/MySQL 4.0.12/share/your language directory

# slow query log#=slowqueris.log

# tmpdir#=

# port=3306

# set-variable=key_buffer=16M

Long_query_time = 1-- refers to how long the sql will be executed by log, which is 1 second.

Log-slow-queries=slowqueris.log-returns the query to slower statements for recording

Log-queries-not-using-indexes = nouseindex.log-literally, query that does not use an index under log

Log=mylog.log-record all execution statements

When the above parameters are enabled, the performance of MySQL may be affected. It is recommended to disable it in production environment.

This is the end of the content of "the actual steps for viewing the MySQL operation log". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.