Label:First, the operating system configuration optimization:1. On the network side, modify the/etc/sysctl.conf file, increase the number of TCP supported queues, reduce the resource recovery when disconnected.2. Limit the number of open files. Modify the/etc/security/limits.conf file to add a bit of content to modify the limit on the number of open files.3. Turn off firewall software such as Iptables,selinux. Second, System configuration optimization
Optimization of database hardwareHow do I select a CPU?Would you prefer a faster single-core CPU or a higher number of cores?
MySQL has some work that only uses single-core CPUs
MySQL does not support CPU cores more and more faster
Recommendation: mysql5.5 Use a server that does not exceed 32 cores. It is also recommended that the single core frequency be faster CPU.Disk IO optimizationIntroduction to Common RAID levelsRAID0: Also become a
fragmentation and re-create the index. You can use the SQL server Manager to re-create the index, or use the following SQL statement:Copy codeThe Code is as follows:-- Displays the index fragmentation of the testIndexOrder table.Dbcc showcontig (testIndexOrder)-- Re-create the index of the table-- The first parameter can be the table name or table ID.-- The second parameter. If it is '', it indicates that all indexes of the table are affected.-- The third parameter is the fill factor, that is,
Mysql Database SQL Optimization-subquery optimization and mysql Database SQL Optimization1. What are subqueries and table join queries:Subquery: The select statement is used in the select or where clause of the primary SQL statement; select. name, (select B. name from B where B. id =. id) from a where. name lik 'a %'Table join query: a joint query of multiple tables; select. name, B. name from a, B where. i
modification. In addition, SQL server limits the number of indexes and the length of indexes. For more information, see
5) re-indexing as necessaryAfter running SQL server for a period of time, some index fragments will be formed. At this time, indexes need to be re-built. Sometimes re-indexing can have unexpected results.
View the index fragmentation and re-create the index. You can use the SQL server Manager to re-create the index, or use the following SQL statement:
-- Displays the index fra
The author has done some optimization work in the iOS development process, has some superficial understanding to the iOS performance optimization, has been wanting to own these experiences, summarizes briefly.As the first of the series, I intend to summarize some of the general principles of iOS optimization. Because I think whether the list smoothness
Many people have no idea about the optimization of web pages, and many people in the industry have little or no idea about the optimization of web pages. Speaking of my understanding of web page optimization, I once searched for "Web page optimization" topics on various search engines. The results were all articles abo
ObjectiveIn this section we will delve into the main optimization methods in visual slam-graph optimization (graph-based optimization). In the next section, we describe a very popular graph optimization library: G2O.As for G2O, I wrote a document in 13, but as I deepened my understanding, I felt more dissatisfied. In t
Code Optimization has many benefits, but it does not mean that all code needs to be optimized. sometimes excessive optimization is counterproductive. DonaldKnuth, the originator of modern computer science, once said that early optimization is the source of all evil, because: making the right program faster... "> Code Optimiza
Today in the forum to read an article on "SEO master" only rely on the theory is far from tenable posts, suddenly some sentiment, oneself do SEO optimization already five years, say long also not long, say short also not short, today will talk with you about what is SEO optimization and webmaster eye SEO optimization bar. Website
Mention SEO site optimization is nothing but the station and outside the station. Is the so-called economic base to determine the superstructure, SEO industry is not an exception, site optimization is the core of the structure of the site optimization, all know that the site structure optimization is the foundation of
The HTTP Archieve has a statistic that the picture content is 62% of the total Internet content, which means more than half of the traffic and time is used to download pictures. From the perspective of performance optimization, the picture is definitely the focus of optimization and one of the key, Google Pagespeed or Yahoo's 14 performance optimization rules all
some summarization on the optimization of hive performance
Note that this article 90% from this article: Hive performance optimization, very grateful to the author of the careful collation, some of which I have done supplements and additions, if there is anything wrong to write, please leave a message, thank you Preface
Today, the phone interview was suddenly involved in the hive has done what
First spit slot, now most of the SEO staff live in the bottom of the Internet, can be said to be in dire straits. On the one hand, the company's low wages, but asked SEO staff will be HTML, will be programmed, will be data analysis, will be SEO, will be bidding, website design, Web site production, will PS, will reload the computer, will be the database, will user experience building, will manage the domain name, will maintain the server and so on and so on, that is really, skills everything pro
In front of a series of " site Optimization Tutorial: navigation optimization and structural optimization " and " site Optimization series two: URL and site map optimization ", today, the third lesson "station optimization Series
PHP performance optimization and php Optimization
The figure below shows 100 concurrent requests with 1000 target addresses
Test
Two most important parameters: Requests per second: Number of Requests received per second. Here, 101 Requests are received per second.
Time per request: the Time consumed by a request, which is 9 milliseconds
The larger the first parameter, the better. The smaller th
there are usually several ways to tune a database:
1) Manual tuning.
The
main reliance on people, inefficient, requiring the operator to fully understand the principle of common sense depends on, but also the application, database management system, operating system and hardware have a broad and deep understanding.
2) Case-based tuning .
This
paper summarizes the recommended configuration values of database parameters and the design of
In Android applications, image resources are the most memory-consuming resources. In addition, in the Android system, when reading bitmap, the size of the image stack assigned to the virtual machine is only 8 Mb. If the size exceeds the threshold, an outofmemory exception occurs. Therefore, image memory optimization is an important part in Android application development.
1) reclaim the bitmap memory in time
The bitmap class has a recycle () method.
Mysql database performance optimization 1. mysql Performance Optimization
Today, database operations are increasingly becoming the performance bottleneck of the entire application, especially for Web applications. Concerning the database performance, this is not just something that DBAs need to worry about, but it is something that our programmers need to pay attention. When designing the database table str
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.