how to improve database performance

Technical old iron, work tired, we will come together to relax! Lao Zhang I is a fan of Jin Yong, in Jin Yong novels, the Dragon 18 palm of the peak drilling, its power can be imagined. Now son, Lao Zhang to give you introduce 18 moves, to

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.Because the Data warehouse system stores a large amount of historical data and current data, and the data volume is increasing, in order to

1. mysql different storage engine supports different lock mechanismTalking about MySQL's Storage engine (table type)2, MySQL lock detailedMySQL Details--lockMySQL locking mechanism introduction Here's a good explanation of the INNODB locking

First, what is the storage engineLibrary ===> folder created in MySQLTable ===> files created in the libraryThere are different types of files that we use to store data in real life, and each file type corresponds to a different processing mechanism:

The story of PostgreSQL and its friends-RedisRead and write Redis directly in PostgreSQL.Many benefits, can reduce the complexity of application layer design, reduce the number of interactions, reduce Rt.Examples of application scenarios:.1. Improve

One, configuration fileThe service side and the client's character encoding is different, may cause garbled display and so on, in order to unify the character encoding at both ends, can be implemented through the configuration file, of course, such

1, why do I need MySQL replication technology, what is the use?The ability of a single database server is always limited. Based on the experience of professionals, a 8-core 32G configuration server that withstands 50~200 concurrent connection

MySQL Index basics Basic concepts: An index is a special database structure that can be used to quickly query specific records in a database table. Indexes are an important way to improve database performance. An index is created on a

1 The rise of database splittingIn the past few years, the concept of database splitting has become more and more popular with the large increase of business application database transaction volume and the increase of database size. The success of

Before writing this program you need to create a Java project, which is the premiseThen add the MySQL driver package, I use the database is version 5.1, so the driver package is also 5.1 version, JDK is 1.7Create DATABASE bit mybatis, table fame

The customer gives the suggestion proposal: Always listen to the client side said Mycat this east, confused, this is what east, only heard that MySQL do not know mycat, instantly be despised n times. Customer mentions that

As mentioned earlier, the database server consists of two parts: instance and database.Where the database is used to store data, and the instance is used to access the data in the database.The instance includes a set of memory structures and

a , read-only table space650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/4B/5F/wKiom1Qq0iHgzt1NAAFwVpIK3jg452.jpg "title=" 1.png " alt= "Wkiom1qq0ihgzt1naafwvpik3jg452.jpg"/>A read-only table space can only be a select operation, and the

What is the index of the Chinese Dictionary of the Directory page (index) analogy: Just as Chinese characters are stored by page, the data records in SQL Server are stored on pages, and the capacity of each page is typically 4K. In order to speed up

In SQL Server, indexing a database table can be (C). Index: is an internal method of SQL Server orchestration data, which is a direct channel for retrieving data in a tableThe role of indexing: greatly improve the database retrieval speed, improve

When you create a table, you can improve database performance by selecting the appropriate data type for the column.1. Select the appropriate data type to avoid data type conversions. For example, a date, someone using a string to hold the date,

1. About SQL query efficiency, 100w data, query as long as 1 seconds, to share with you:Machine conditionp4:2.4Memory: 1 GOs:windows 2003Database: MS SQL Server 2000Objective: To query performance tests and compare the performance of two types of

relational database, compact embeddable, processing massive amounts of data, supporting C, Java, Perl, PHP, Python, Ruby, TCL, etc., embedded in the application as a product componentThe main contents of this book: Deploy SQLite as a database

1. About SQL query efficiency, 100w data, query as long as 1 seconds, to share with you:Machine conditionp4:2.4Memory: 1 GOs:windows 2003Database: MS SQL Server 2000Objective: To query performance tests and compare the performance of two types of

1. servlet Execution ProcessThe client issues an HTTP request, the Web server forwards the request to the servlet container , the servlet container resolves the URL and finds the corresponding servlet based on Web. XML, and passes the requests,