sql performance tuning steps

Original addressMySQL is a powerful open source relational database management system (RDBMS). It was posted on 1995 (20 ago). It uses Structured Query Language (SQL), which may be the most popular choice in database content management. The latest MySQL version is 5.6.25, released on May 29, 2015.An interesting fact about MySQL is that its name comes from the daughter "My" of Michael Widenius (the founder of MySQL). Although there are many interesting

memory disk Mkdir-p/mnt/ramdisk sudo mount-t tmpfs-o size=4000m tmpfs/mnt/ramdisk/ mv/var/lib/mysql/mnt/ramdisk/mysql 9. Use MYSQL in a NOSQL way B-tree is still one of the most efficient indexes, and all MYSQL is still not obsolete. Using Handlersocket to skip MySQL's SQL parsing layer, MySQL really becomes NOSQL. 10. Other A single query finally increases LIMIT 1, stopping the full table scan.Separating non-"indexed" data, such

the optimal number of threads" ) b. Increasing the cache C. Where the insert operation is performed frequently, bulk insert with native SQL (persistence layer using Eclipselink)2. Parameter adjustment A.JVM memory parameters B. Database connection pool parameters3. The function realizes the design adjustment (least wants to see)According to the actual situation to adopt appropriate means adjustment.Step ThreeDetect the

the data from disk into the Oracle buffer cache. if this happens too often the performance of the query or the entire database can suffer. typically this is caused by contention for "hot" blocks or objects so it is imperative to find out which data is being contended. once that is known this document lists several alternative methods for solving the issue. conclusion: Two or more sessions simultaneously need to load the objects in the hard disk into

1. Introduction:Javamelody can monitor Java or Java EE application servers in a running environment. It is displayed as a graph: Java memory and Java CPU usage, number of user sessions, JDBC connections, and HTTP requests, SQL requests, JSP pages and Business interface methods (EJB3, Spring, Guice), average execution time, Error percentage, and so on. Charts can be viewed by day, week, month, year, or custom time period.2. Prepare:Download Javamelody-

efficient results. Http://bbs.linuxtone.org/thread-5152-1-1.html3. Operating System-level optimizationA> A 64-bit system can allocate more memory and service tuning to a single process, disable unnecessary services, modify file descriptor restrictions, and reserve more resources for MySQL;B> File System Optimization: XFS is recommended for a separate file system for the data warehouse, which is generally more efficient and reliable.C> enable the noat

operation This is it, the next we add to SQL Server on the use of the index and dynamic index content, About indexes I believe that many people who understand database products are familiar with it, but the way in which some statements in SQL Server take advantage of the index may not be clear, our next analysis of this piece, to understand the indexing method and optimization techniques, interested in adv

Refer to the book SQL. server.2005. Technical Insider "series ConclusionThis article first to this bar, the article is short, easy to understand, follow-up on the parallel operation of a part of the content, follow-up articles, this article mainly introduces the parallel operators in the query plan, next we will add some of the SQL Server parallel operations, Then analysis of our daily write addit

mysql performance tuning considerations and Indexing One: Optimization of the database1 impact of business needsFor example, posts in the Forum statistics, and real-time updates from a functional command select count ( * from can get results if the forum generates thousands of posts per second, we don't use MyISAM The store uses the innodb storage; Even the best devices are not likely to be

statement that will form a specific plan, and the resulting specific plan is not always optimal, which is related to the content distribution, the amount of data, the type of data in the database's existing data tables, and the statistics that are used to record these details.All optimal planning choices are based on existing statistical information, and if our statistics are not updated in a timely manner, then the optimal execution plan will not be the best, and sometimes the worst.Reference

Oracle is a high-performance database software. The user can adjust the parameters to achieve the optimization of performance. Performance optimization is mainly divided into two parts: First, the database administrator through the adjustment of system parameters to achieve the goal of optimization; The second is that the developer achieves the adjustment by op

Key factors that affect Java performance 1 hardware configuration, such as CPU, memory, server architecture, etc. 2) operating system 3) database system and database server 4 JVM 5 Application Server 6 The impact of network Environment 7) system architecture and code writing follow the specification for performance tuning st