Use of mysqlsla, a log tool for slow database query, which is more powerful than mysqldumpslow.
Install mysqlslaSource code path: https://github.com/daniel-nichter/hackmysql.comSource code storage path:/usr/local/src1. Get source codeIf you do not have the git command, install git first.Yum install git
Cd/usr/local/src
Git clone https://github.com/daniel-nichter/hackmysql.com.git
Cp-Rf hackmysql.com/opt/mys
Bean-Query a Java tool library that converts an object to MapA fully tested Java tool class is just open-source. The current Code has undergone a complete test and is being applied to be placed on Maven central Repository.Bean-query
Click Here for English version.
BeanQuery is a Java
.
There are two solutions.
First, use the Module Docs toolThis tool is a method that comes with Python gui idle to query help files. You can use the form of web pages and local functions of the local machine to provide a simulated online query method. It can open a webpage with all functions displayed and standardized classification. it is clear, but it is in
Flash genius is a flash parameter query tool that can quickly identify flash chip manufacturers, product categories, operating voltage, storage capacity, chip versions, feature types, and so on.The software is green, small, and easy to operate. It is a good assistant to electronic enthusiasts and digital maintenance personnel.
Update history:
V3.4 supports query
Flash genius is a flash parameter query tool that can quickly identify flash chip manufacturers, product categories, operating voltage, storage capacity, chip versions, feature types, and so on.The software is green, small, and easy to operate. It is a good assistant to electronic enthusiasts and digital maintenance personnel.
Update history:
V3.4 supports query
Today introduced an Ad Object information query tool Adexplorer, from the perspective of the function of the object view, he made up for aduc a lot of shortcomings. First, start Adexplorer.650) this.width=650; "style=" Float:none; "title=" 1.JPG "src=" http://s3.51cto.com/wyfs02/M01/70/DF/ Wkiom1xaknuxor3maaavxwiojti999.jpg "alt=" Wkiom1xaknuxor3maaavxwiojti999.jpg "/>After you open adexplorer, you need to
[View system settings for slow queries]Mysql>Show variables like '%slow%';+---------------------------+--------------------------------+|Variable_name|Value|+---------------------------+--------------------------------+|Log_slow_admin_statements| OFF ||Log_slow_slave_statements| OFF ||Slow_launch_time| 2 ||Slow_query_log| OFF ||Slow_query_log_file| /Data/Mysql/localhost-Slow.Log |+------
Document directory
Background in desktop gadgets Development
By Terry Li-gbin1.com
Friends who use Vista and win7 may have used Windows Gadgets more or less. These gadgets can be freely added to the desktop and quickly implement certain functions, such as weather forecasts, stock futures, and dates, remote Desktop and other very useful tools, in fact, have similar functions in the old version of Windows desktop, at that time called desktop Web applications, you can add some web pages to you
MySQL performance profiling tool (pt-query-digest)
This tool is also from percona-toolkitOther tools in this tool setTroubleshooting of abnormal shutdown of MySQL Slave (pt-slave-restart)Verify MySQL master-slave consistency (pt-table-checksum pt-table-sync)It can analyze various logs to analyze performance issuesIncl
Label:Before Windows mysql5.6.20 using mysqldumpslow.pl to analyze slow logs, today saw a tool pt-query-digest, originally intended to be installed on Windows, resulting in the execution of C: \ on Windows Program Files\mysql\mysql Server 5.6\bin>pt-query-digest.pl F:\mysql\im-slow.log > F:\mysql\slow_ Report.log, waiting for half an hour will not come out result
For the purchase of advertising site webmaster, in fact, most of the stationmaster is with can give their own website to bring certain traffic, although sometimes not much, but better than none. And the ultimate goal of the purchase link is also to improve the ranking to get more traffic. So, traffic is the ultimate destination of the website. It is really useful to analyze the site's overall situation from the site's traffic. And a lot of adsense in the buy ads, are particularly concerned about
Host command
Function descriptionThe host command is a common domain name query tool, and the nslookup, dig functions are basically the same, using the following:
host [parameters] [options]
Common parameters
Options
Description
-A
Querying DNS details is equivalent to-V-T
-C (Type)
Specify the
can be followed by parameters: All or cpu,block io,page faults and so on.You can also query directly in the Information_schema.profiling database table:Select State,sum (Duration) as Total_r,round (100*sum (Duration)/(select SUM (duration) from Information_ schema.profiling where [email protected]_id), 2) as Pct_r,count (*) as Calls,sum (duration)/count (*) as "R/call" from inform ation_schema.profiling where [email protected]_id GROUP BY state ORDE
So that MySoft. Data can also have Discuz! NT database query and analysis tool, mysoft. datadiscuz
Run Discuz in Debug mode! During the NT project, we will find a Data Query and analysis tool at the bottom of the page, which is very convenient. When running a page, you can view SQL operations at a glance. Of course, so
Reference: 5 kinds of MySQL log analysis tools to compete http://blog.csdn.net/gzh0222/article/details/103844751.mysql-log-filter Tool Script Usage instructions:An analysis tool found on Google code. Two executable scripts for Python and PHP are available. http://code.google.com/p/mysql-log-filter/(need to move ladder climbing wall), 51cto download Link:How to use: (This is the only way to use Python)Python
MySQL Performance Profiling Tool (pt-query-digest) is also from percona-toolkit
Other tools in this tool set
Troubleshooting of abnormal shutdown of MySQL Slave (pt-slave-restart)
Including
1. slow log (default)
2. tcpdump
3. general log
4. binlog
5. show processlist
The experiment simulates a certain amount of pressure through tpcc, and enables binlog, gene
Label:Learning to focus on Nodejs for some time, recently in learning Nodejs related applications. Work often query database, data validation, involving Sqlserver,mysql, and so on, although there are client tools, but the total feeling is not convenient, occasionally contact the Sqlpad, feel is a good tool, can support a variety of databases, the common query sav
of 30%, then Baidu traffic is expected to say nothing more. On this basis, and Baidu traffic related is webmaster tools to evaluate Baidu weight is even more nonsense.
second, today included:
The author has encountered two questions about Baidu today:
1. Added today, the actual total is not increased:
Example 1: Website www.***.cn, with the SEO tool query today included 49,400, as shown:
Baidu
# Name: PHP + Ajax website SEO Query Tool# Author: years # Homepage: http://master8.netInstructions for use:1. The server must support at least one of allow_url_fopen, curl, and fsockopen. For details, contact the server administrator.2. Respect others' labor achievements! You can modify and use this program at will, but it cannot be publicly published after modification! Spread this program should also mai
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.