Before the system background alarm too many, simple query the following reason, mainly is the data volume is large, the number of queries and database performance is low caused. At that time, a simple analysis of the database configuration and a few tables with slow log queries added a single-column index to a long-running table, and the effect was more obvious.14 National Day during the background interface of the public number call situation is as follows, of course, this is only one of the pu
AB use Apache附带的压力测试工具ab,非常容易使用,并且完全可以摸你各种条件对Web服务器发起测试请求。ab可以直接在Web服务器本地发起测试请求,这对于需要了解服务器的处理性能至关重要,因为它不包括数据的网络传输时间以及用户PC本地的计算时间。。To perform 1000 connection, 20 times concurrent (parallel, simultaneous):Syntax: Ab-n 1000-c www.baidu.comProduce results. Here are a few points to note:§time taken for tests: how long does it take to execute a total. (Over 1000 times in total)§requests per second: The average number of connection per second that can be processed.WebbenchUp to 30,000 concurrent conne
Linux networking, but also displays performance statistics for each network device. Similar to ifconfig,IP provides a summary of the data since the start of the system. 7.2.5 SARIn addition to providing the network performance data of the link layer, the SAR can provide some basic information about the number of sockets opened by the transport layer. SAR displays statistics sent and received by all network devicesSAR shows the number of sockets7.2.6 netstatNetstat is a basic network performanc
From compilation to tools: several mysql optimization methods I. optimizing mysql during compilation
If you distribute and install mysql from the source code, note that the compilation process will have an important impact on the future target program. different compilation methods may obtain similar target files, however, the performance may vary greatly. Therefore, when compiling and installing mysql, you
MySQL performance optimization common tools:Common Performance testing toolsShow Engine InnoDB StatusShow Full ProcesslistInformation_schema.processlistExplainCREATE TABLE Innodb_table_monitor (a int) engine=innodb;Innodb_locksInnodb_lock_waitInnodb_trxZabbix MonitoringPt-tools ToolsTwo ways to optimize performance:1. Interpretation of the implementation planMysql> Explain select * from Mysql.user, +----+--
CPU -dependent strace output
%time
for the total time of all system calls, this is the percentage of time spent on this system call
Second
The total number of seconds this system call took
Calls
The total number of all calls of this type
4.2.3 LtraceLtrace is similar to the concept of strace, but it tracks the application's call to the library instead of the kernel. Although Ltrace is primarily used to provide
Mysql built-in optimization tools show profiles and mysqlprofiles
I. Overview:
Currently, the Mysql explain tool is not as powerful as the explain plan tool of Oracle, but the show profiles tool can achieve similar results. The show profiles statement is used for resource usage of the statements executed in the current session. The specific syntax is:
SHOW PROFILE [type [, type] ... ] [FOR QUERY n] [L
in the process to understand the execution efficiency.Also, the Windows Task Manager cannot detect memory leaks, and we need to use other tools.For more information, please pay attention to the first Cocos2d-x 3.2 Edition book "Cocos2d-x: C + + volume" book Exchange Discussion website: http://www.cOcoagame.netFor more exciting video courses, please follow Cocos class: http://v.51wOrk6.comWelcome to join Cocos2d-x Technical Discussion group: 257760386Welcome to Luxgen iOS Classroom public platfo
IMMEDIATE ' ALTER SESSION SET timed_statistics=true ';EXECUTE IMMEDIATE ' ALTER SESSION SET max_dump_file_size= "unlimited";EXECUTE IMMEDIATE ' ALTER SESSION SET tracefile_identifier= ' test_tracefile ';EXECUTE IMMEDIATE ' ALTER SESSION SET EVENTS ' 10046 Trace name context Forever,level 8 ";At the end, add the following statement to executeEXECUTE IMMEDIATE ' ALTER SESSION SET EVENTS ' 10046 trace name context off ';B. Use 10046 event to track other users session:Set Dbms_system.set_ev for oth
tables, so fewer resources are used.Myiasm tables can be transplanted at the binary layer on different platforms.Larger key size, larger key size limit.3.3 specify the table Type
You can specify the table type when creating a table. In the following example, create a heap table:--------------------------------------------------------------------Mysql> create table email_addresses type = heap (-> Email char (55) not null,-> Name char (30) not null,-> Primary key (email ));-----------------------
efficiency, and saves disk space.MyiasmThis is the default table Type of mysql. It is based on iasm code, but there are many useful extensions. Why is myiasm better:Myiasm tables are smaller than iasm tables, so fewer resources are used.Myiasm tables can be transplanted at the binary layer on different platforms.Larger key size, larger key size limit.3.3 specify the table Type
You can specify the table type when creating a table. In the following example, create a heap table:-------------------
Before we published an article "256 Template official website point SEO optimization analysis record" records the site some basic ranking situation, as well as the site collection, snapshots and other situations. Through the comparison of the previous site, we found that Baidu's 256 template network included in the speed or very fast, to achieve the same day can be included in the speed, in general or relatively satisfactory, below we come to specific
In an Oracle database, the need to optimize the SQL statement requires knowledge of its execution plan, which is tailored accordingly. There are several ways to get Oracle's execution plan, and here's a summary
1, the use of explain
Oracle RDBMS executes every SQL statement and must be evaluated by the Oracle Optimizer. So, understanding how the optimizer selects (searching) the path and how the index is used is a great help for optimizing SQL statements. Explain can be used to quickly and easil
PageRank prediction QueryEnterPredict the future PageRank of a web page
Rankingbooster 2.0Download outside ChinaRegistration Machine616.7kbWindows 98/ME/NT/2000/XP/2003Alexa ranking tool. A tool that is said to be able to refresh the Alexa ranking. You can choose to refresh the thread. According to its official website, it takes several hours a day to achieve the effect, and the thread is recommended to be within 4. If you are interested, you can test it.
Link Popularity check3.0Download outside
Label: HTTP for sp ef bs. Net install PHP TTBecause Yahoo's smush. It is processed online, you have to upload images or image URLs, which is very convenient for a small number of images. However, if there are too many images, it is still very inconvenient to process them.I have collected several gadgets for easy installation and use.For GIF:Http://www.lcdf.org/gifsicle/For PNG:Http://pmt.sourceforge.net/pngcrush/For JPG:Http://sylvana.net/jpegcrop/jpegtran/More comprehensive:Http://www.imagemagi
How to use JS and CSS optimization tools Minify in PHP. To reduce HTTP requests, we often need to merge and compress multiple JS and CSS files, next we will record the PHP source code for implementing this function and the usage of Minify, an open-source project. I. to reduce HTTP requests, we often need to merge and compress multiple JS and CSS files, the following is a record of the PHP source code for im
change curves in the process to understand the execution efficiency.Also, the Windows Task Manager cannot detect memory leaks, and we need to use other tools.For more information, please pay attention to the first Cocos2d-x 3.2 Edition book "Cocos2d-x: C + + volume" book Exchange Discussion website: http://www.cocoagame.netFor more exciting video courses, please follow the Cocos class: Http://v.51work6.com Welcome to join the COCOS2D-X Technical Discussion group: 257760386 Welcome to the Luxgen
vmstk
process stack size
vmexe
The virtual size of the executable memory of the program. It does not contain libraries used by processes
Vmlib
The size of the library used by the process
Example: Viewing The situation of the WebLogic process java The program code for the process is only 36k 96k 2712776k 92608 90 M vmlck indicates that no memory is locked, making it impossible to swap memory. vmrss size
The computer is used for a long time, because the memory occupies more and more, more and more, so the running speed becomes more and more slow. Want to carry on the computer's overall speed up, first carries on the Memory data optimization and the acceleration is very necessary, but carries on the memory optimization and the speed up, but also may separately from optimizes the virtual memory setting and th
the chain."
Some other data: we often see all kinds of SEO tools to check the results of the site information is not the same. That's because the SEO tool itself caches the reason. In general, Love Station cache update is slower than Chinaz, especially Chinaz now add the manual update cache function, equivalent to doing a real-time query.
The above is the Lanzhou SEO yangfan to all kinds of SEO tool use situation a summary. Overall, all kinds of SE
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.