Mysql Database Size Performance

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 ...

The initial key value comparison, MongoDB victory faster, and this has always been our goal to give the database system MySQL dragster the speed of the disk as its biggest obstacle, this really can make sense? Let's just make an obstacle, what about the solution? If an obstacle limits your dragster, you can choose to bypass it faster or improve on the computer. For example: Avoid the use of disk, as much as possible memory in lieu of faster disk (such as SSD) in fact, this is not good analogy, because the limit from the disk is like ...

MySQL optimization is very important. The most common and most needed optimization is limit. 　　The limit of MySQL brings great convenience to paging, but when the amount of data is large, the performance of limit is reduced dramatically. The same is 10 data select * FROM Yanxue8_visit limit 10000,10 and select * from Yanxue8_visit limit 0,10 is not a quantitative level ...

As the most popular open source database, MySQL is widely used in Web applications and other small and medium-sized projects. However, in many large IT companies, MySQL has gradually deviated from the original open source version after being highly optimized and customized, more like a branch, such as the Webscalesql of Facebook, which was not long ago open source. 　　Recently, Mr. Xiong has published a blog post, from the perspective of large-scale web site architecture development of the changes in MySQL application, here for you to share. This article mainly describes the different and ...

MySQL is an open source relational database management system, the developer for the Swedish MySQL AB company, is now part of sun company. Oracle announced the acquisition of Sun Company in 2009, so MySQL may become Oracle's products. Because of its high performance, low cost and good reliability, MySQL has become the most popular open source database and is widely used in small and medium Web sites on the Internet. As MySQL matures, it is increasingly used for more large-scale ...

"Editor's note" WiX has been operating the site for a long time, and after the launch of the WYSIWYG web platform based on HTML5, users have established more than 54 million sites in the company, and most of these sites have less than 100 solar PV. Since the PV of each page is low, the traditional caching strategy does not apply. Even so, however, the company has done so with only 4 Web servers. Recently, WiX chief back-end engineer Aviran Mordo in "...

Many business owners with only more than 10 to dozens of employees ask if they don't want to spend thousands or even million to buy a database software and ask if there are any free database software available. In fact, there are a lot of small business owners in this type of enterprise, their company needs a small database software to statistics the company's some product data and the information of the storage, the amount of data is really small. As I've seen before, some small businesses use office-brought access small databases, but still feel less convenient. Here, the editor recommends several open source databases for small business use ...

It is well known that the system reads data from memory hundreds of times times faster than it does from the hard disk. So now most of the application system, will maximize the use of caching (in memory, a storage area) to improve the system's operational efficiency. MySQL database is no exception. 　　Here, the author will combine their own work experience, with you to explore the MySQL database Cache management skills: How to properly configure the MySQL database cache, improve cache hit rate. 　　When will the application get the data from the cache? Database read from server ...

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.

The following article is mainly on the MySQL limit query optimization of the specific content, we all know that the MySQL database optimization is very important. The other most common and most desirable optimization is limit. The MySQL limit to paging has brought great convenience, but when the amount of data, limit the performance dropped sharply. The same is to take 10 data select * from yanxue8_visit l ...