Database Index Performance

The concept of blockchain to technology has been around for a long time, but with the heat of the past two years, it has gradually become known by the market and many technicians.

In peacetime is asked the most questions about the MySQL database performance optimization issues, so recently intended to write a MySQL database performance optimization of the series of articles, I hope that the junior high level MySQL DBA and other interested in MySQL performance of friends to help. Databases are IO-intensive applications whose primary responsibility is data management and storage. And we know that the time to read a database from memory is the microsecond level, and reading an IO from a common hard disk is at the millisecond level, both ...

As a software developer or DBA, one of the essential tasks is to deal with databases, such as MS SQL Server, MySQL, Oracle, PostgreSQL, MongoDB, and so on. As we all know, MySQL is currently the most widely used and the best free open source database, in addition, there are some you do not know or useless but excellent open source database, such as PostgreSQL, MongoDB, HBase, Cassandra, Couchba ...

I first http://www.aliyun.com/zixun/aggregation/7415.html "> Self-introduction, I engaged in IT industry 10, years ago is an architect, now in an internet company as product manager, below is personal experience , as well as with some cloud computing architects to exchange the experience of the summary, the following on the Beijing-East Cloud Database For example, there are improper please forgive me. What is a shared database talking about "shared database", what puzzles us most is "...

With the advent of cloud computing, there are many new nouns, such as cloud database, cloud storage, elastic expansion, resource isolation and so on. 　　The following is the hot "shared database" for everyone to explain what is called "shared database". I introduce myself first, I am engaged in IT industry 10, was an architect many years ago. 　　Below is a personal experience, as well as with some Google, BAT, Jingdong and other companies cloud computing architects to get the summary of the experience, for you to analyze what is a "shared database." What is shared data ...

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall of the current web2.0 program, a big bottleneck is the database swallow metric." 　　However, how to determine the bottleneck of the system is a database, because only to determine the database is the bottleneck of the entire system, we have to optimize him, after all, there are so many needs to wait for us to do. 　　How do I determine that a database is a bottleneck? ...

Designing 1 applications doesn't seem to be difficult, but it's not easy to achieve the optimal performance of the system. There are many choices in development tools, database design, application structure, query design, interface selection, and so on, depending on the specific application requirements and the skills of the development team. This article takes SQL Server as an example, discusses the application performance optimization techniques from the perspective of the background database, and gives some useful suggestions. 1 database design to achieve optimal performance in a good SQL Server scenario, the key is to have 1 ...

Editor's note: This article from Liouville Contribution (micro-blog @ Liouville Life Road), engaged in the cloud computing industry for many years, from personal experience, and with some Google, Jingdong and other companies cloud computing architects to share the experience of the summary, for you to analyze what is a "shared database." What is a shared database talking about "shared databases", what puzzles us most is "sharing" three words. "Sharing" lets us think of the antonym "exclusivity". Yes, the shared database is a comparison of the exclusive database of the user resource ownership of the database title, it is the companion ...

1.1: Increase the secondary data file from SQL SERVER 2005, the database does not default to generate NDF data files, generally have a main data file (MDF) is enough, but some large databases, because of information, and query frequently, so in order to improve the speed of query, You can store some of the records in a table or some of the tables in a different data file. Because the CPU and memory speed is much larger than the hard disk read and write speed, so you can put different data files on different physical hard drive, so that the execution of the query, ...

After more than eight years of practice, from Taobao's collection business to today to support all of Alipay's core business, and in the annual "Double Eleven Singles Day" continue to create a world record for the transaction database peak processing capacity.