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

This article introduces you how to understand the MySQL SQL Profiler performance analyzer, the content is very detailed, interested friends can refer to, hope to be helpful to you.

MySQL SQL Profiler performance Analyzer

See a lot of friends ask MySQL's performance analyzer.

Because MySQL is not good at this, or maybe I don't know.

No SQL Profiler for Microsoft, no Audit and AWR for Oracle

Therefore, it is difficult for us to get some statistics of SQL statements, which makes it difficult for us to tune.

What is more difficult is to track MySQL.

I've written one before, but after reading a bash script on mysql, I think my own is nothing.

Now I want to share it with you. It's very simple.

# get all the operations on the Nic eth0

CODE:

Time tcpdump-I eth0-s 1500-w 20060427-db-traffic-01.dmp

On how to understand the MySQL SQL Profiler performance analyzer to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.