cnd performance tips

You have completed your brand's new application, and everything works like a charm. To use your network. Everyone is happy.Then, suddenly, an explosive user killed your MySQL server and your website was closed. What's wrong? How can you stop it?The following are some tips for MySQL performance optimization, which will help you and your database.Focus on In the early stages of development, you should know th

First, when doing the Java interface Performance test, the scene appears in the operation: Code-60990 error:two communication error:function Two_way_comm_post_message/two_way_ COMM_POST_MESSAGE_EX failed. Errorand Code-10343 error:communication Error:cannot send the message since reached the shared memory buffer max size error, general resolution of the party Law is as follows:Possible reasons to be closed:The shared memory cache overflows, causing pr

|grep "model name"Second, using Tcmalloc to optimize the performance of NginxThree, nginx kernel parameter optimizationThe optimization of Nginx kernel parameters is mainly based on the optimization of kernel parameters for Nginx application in Linux system.An example of optimization is given below for reference:Net.ipv4.tcp_max_tw_buckets = 6000Net.ipv4.ip_local_port_range = 1024 65000Net.ipv4.tcp_tw_recyle = 1Net.ipv4.tcp_tw_reuse = 1Net.ipv4.tcp_s

Thanks to the delivery of gadenstarNews source: Simplified translation + ModificationWebsite performance is a key factor for any successful website. Today, WordPress is becoming more popular than ever before. The 11 tips mentioned here to improve WordPress speed and performance may be useful to you. 1. Upgrade Wordpress to the latest version (excluding beta --#

1. TraceView1) When using the TraceView plugin in Ddms, you can increase the cache size in the settings, which increases the tracking time of the tracevew.　　　　2) do not recommend the selection of intermittent sampling, the results are often not allowed　　　　2. Developer Tools--Show surface updatesIf the interface has a cyclic redraw problem, turn it on to find that the interface is flashing continuously.　　3. Debugtool ProjectThis is our own tool for viewing real-time

Tips: How to improve MySQL Performance (1) (2 ). 5. NOT we often use some logical expressions in the where clause during queries, such as greater than, less than, equal to, and NOT equal to. we can also use and (and), or (or) and not (not 5. NOT When querying, we often use some logical expressions in the where clause, such as greater than, less than, equal to, and not equal to. we can also use and (and), o

multiple data members are needed for frequent lookups or visits.2 Sets and lists (list)The union,intersection,difference operation of set is faster than the iteration of the list, so if a list intersection is involved, the set, or the bad problem can be converted to set to operateFinding the intersection of listsFrom time Import timeT = time ()LISTA=[1,2,3,4,5,6,7,8,9,13,34,53,42,44]LISTB=[2,4,6,9,23]Intersection=[]For I in Range (1000000):For a in Lista:For B in Listb:If a = = B:Intersection.a

block elements can be solved, but according to my own test, plus with this method is invalid, if there is no doctype even add width to the element can not let the block element center.Principle analysis: Missing DOCTYPE declaration.IE8 under Input[button submit] settings Margin:auto cannot be centeredOccurrence: Under IE8, if a label such as button (such as button input[type= "button"] input[type= "Submit") set {display:block; margin:0 auto;} If you don't set the width, you can't center.Workaro

, connection pooling (C3P0, DBCP)11, Database data classification storageStore frequently accessed data and low-frequency data, respectively, into different partitions, or even to different database servers, in order to fit into the allocation of hard disk I/O and system I/O.12. Cache PolicyIf some data is to be read from the database frequently, and the data does not change frequently, the data can be cached in the system and read the cache directly, instead of frequently accessing the database

Label:About the effect of SQL condition matching on execution efficiency test First, create a scalar functionCreate function Ff_test ()returns intAsBeginDECLARE @i int=0while (@iSet @i+=1Return @iEnd Next, select a random table, where you use the business table Mt_delegate Observe the following two types of situations 1. Select * from mt_delegate where procid=-1 or dbo.ff_test () >10000 2. Select * from Mt_delegate where dbo.ff_test () >10000 or Procid=-1 The result is that the order of the Wher

didTimeout return a Boolean value that indicates whether the specified time expires. This means that if the callback function is triggered by a specified time expiration, you will get two results. The Timeremaining method returns 0 Didtimeout property equals True Therefore, if the callback function executes, there are two reasons: the current frame has idle time, or the specified time is up.function Mynonessentialwork (deadline) {while ((deadline.timeremaining () > 0 | | dead

not ' t your own and you ' re unable to use an attribute, a jsonconverter can still be used B Y creating your own icontractresolver. Public classConvertercontractresolver:defaultcontractresolver { Public New Static ReadOnlyConvertercontractresolver Instance =NewConvertercontractresolver (); protected Overridejsoncontract createcontract (Type objectType) {jsoncontract contract=Base. Createcontract (ObjectType); //This'll is called once and then cached if(ObjectType = =typeof(Date

limit on key and value data storage length. 3. Space shrinkageUnfortunately, map does not shrink the "no longer used" space. Even if you delete all the key values, it still retains memory space for later use.Even if all the data is emptied, the space is still not released. The workaround is to cancel the 23-line comment, or replace it with a new map object. Tip: If you use a Map object for a long time (for example, as a cache container), it might be better to occasionally replace

Three Tips for improving web page performance and improving web page skills1. Set the display attributeFirst, set the element to display:None(Needs to be re-painted once), Then perform 100 operations on the node, and then restore the display (one re-arrangement and re-painting are required ). In this way, you can use two re-renders to replace up to 100 re-renders. The display attribute of the element is vis

PHP development tips for improving performance 1. use commas to connect strings instead of periods Echo "aaa". "bbb" Echo "aaa", "bbb "; 2. double quotation marks are used when a string contains a variable. 3. require is faster than require_once 4. calculate the cycle length in advance 5. use the foreache loop instead of the while active for loop (execution speed: foreache 6. for fil

, connection pooling (C3P0, DBCP)11, Database data classification storageStore frequently-visited data and low-frequency data to separate partitions. Even to different database servers to allocate hard disk I/O and system I/O in a fit.12. Cache PolicySuppose that some data is often read from the database. At the same time, these data do not change very often, the data can be cached in the system, the use of the direct reading of the cache. Without frequent access to the database to read data.Cac

After using the Lightroom for a period of time, feel more and more slowly, or because of a wide range of work, hoping to improve the efficiency of LR? Here are 10 tips from the founder of SLR Lounge, a foreign website, without installing programs that can directly enhance the speed and efficiency of LR software (for reading convenience, Order of Change slightly): 　　(i) Increased speed of pick-up (cache) To edit–> preference, in the pop-u

Here are some tips I've summed up, just for reference. The following code is basically in the jquery source can be seen, if the wrong place, please point out. Use the source method as much as possible JavaScript is an explanatory language and is slower to execute than a compiled language. The way the browser has been implemented, don't go through it again. In addition, the browser has implemented a number of methods in the algorithm has done a lot

Tags: Practice login 16px between multiple connect shut down database SQL business logic　　The end of 2016 was the stage where I learned to understand the entire front end, backend, and database programming. During the practice programming process, notice that there is a scene between the server and the database: Start linking Database SQL--- $loginin =mysql_connect ("192.168.10.253:3306", "root", "123456"); To the end of the entire business logic, do not add a channel that closes the SQL linked

configuration. Linux is rich, powerful, and flexible, and you can do a variety of tasks with it, and in this article we'll discuss some tips for improving the performance of Linux servers.1. Tuning the Linux kernel elevator algorithm for disk I/OAfter selecting the file system, there are some kernel and mount options that may affect its performance, one of which