《MySQL性能调优与架构设计》推荐序-From 石展
即使Oracle收购SUN,将MySQL这只小海豚归于麾下,也未必是件很糟糕的事情,MySQL和Oracle面对的客户群体不同,一个偏重中低端、互联网数据库市场,一个偏重高端、大型企业级数据库市场,有太多的理由相信这一收购不会是MySQL的终点,相反MySQL将会是Oracle产
即使Oracle收购SUN,将MySQL这只小海豚归于麾下,也未必是件很糟糕的事情,MySQL和Oracle面对的客户群体不同,一个偏重中低端、互联网数据库市场,一个偏重高端、大型企业级数据库市场,有太多的理由相信这一收购不会是MySQL的终点,相反MySQL将会是Oracle产品线的良好补充,也许不久即成为埃里森手中的另一张王牌。
目前MySQL装机量接近1200万,占有全球数据库25%市场份额,互联网公司80%的市场份额,特别近几年的Web 2.0兴起,更是引爆了MySQL的应用。但这些MySQL数据库大部分由开发工程师或系统工程师兼职维护着,国内专职MySQL DBA屈指可数,更别说是MySQL DBA团队。随着MySQL应用的逐步成熟,国内一些重量级互联网公司早已看到其潜力并进行大规模使用,更有一些公司磨刀霍霍却苦于该领域技术人才难求,百度、淘宝等知名的互联网公司都有大半年招不到一名合适MySQL DBA的经历。而系统介绍MySQL的中文书籍非常之少,值得一读的MySQL中文书籍更是少之又少。现在MySQL技术领域确实需要一批从理论与实践中锤炼出来的著作来造就更多更优秀的MySQL技术大师。
从作者撰写此书开始,我就一直关注着,时而与其深夜相遇于MSN,呼之,答曰:写书ing。白天在工作中实践,夜里在灯光下沉淀。当时我就迫不急待地想提前一睹,现有幸如愿,阅后颇有感慨,字里行间可见作者对MySQL理解之深!特别是优化篇的“Query优化”(第8章)和架构篇的“数据切分”(第14章)节,“Query优化”章节结合作者多年的DBA实战经验总结了Query优化的十大原则和优化思路,阐述MySQL Query Optimizer的工作机制,并通过Explain和Profiling进行实例解析,清晰易懂,见解独到。“数据切分”章节提供了垂直切分和水平切分等多种数据量膨胀解决方案,并深入分析了不同方案的优缺点,为提升数据库集群的扩展性,解决数据库瓶颈提供了极有价值的借鉴参考。
相信此书会成为你通往MySQL技术大牛道路上的正确选择。
吴诗展
百度 高级MySQL DBA
http://dbaview.cn
于2009年4月
注:此推荐序版权归 吴诗展 所有
原文地址:《MySQL性能调优与架构设计》推荐序-From 石展, 感谢原作者分享。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

NVIDIA 4060 graphics card driver version recommended. When choosing a graphics card driver version on a laptop, it is generally recommended to choose the version recommended by the official website or the latest version. For the Intel HD Graphics 4060 graphics card, it is recommended to choose the latest driver released on Intel's official website for update and installation. The specific steps are as follows: "Words Play Flowers" is a popular word puzzle game with new levels launched every day. One of the levels is called Nostalgic Cleaning. We need to find 12 elements in the picture that are inconsistent with the era. Today, I will bring you a guide to clearing the nostalgic cleansing level of "Word Play Flowers" to help players who have not passed it successfully pass the level. Let’s take a look at the specific steps! VisitIntel

1. Processor When choosing a computer configuration, the processor is one of the most important components. For playing games like CS, the performance of the processor directly affects the smoothness and response speed of the game. It is recommended to choose Intel Core i5 or i7 series processors because they have powerful multi-core processing capabilities and high frequencies, and can easily cope with the high requirements of CS. 2. Graphics card Graphics card is one of the important factors in game performance. For shooting games such as CS, the performance of the graphics card directly affects the clarity and smoothness of the game screen. It is recommended to choose NVIDIA GeForce GTX series or AMD Radeon RX series graphics cards. They have excellent graphics processing capabilities and high frame rate output, and can provide a better gaming experience. 3. Memory power

In the process of using Taobao, we will often be recommended by some friends we may know. Here is an introduction to how to turn off this function. Friends who are interested should take a look. After opening the "Taobao" APP on your mobile phone, click "My Taobao" in the lower right corner of the page to enter the personal center page, and then click the "Settings" function in the upper right corner to enter the settings page. 2. After coming to the settings page, find "Privacy" and click on this item to enter. 3. There is a "Recommend friends to me" on the privacy page. When it shows that the current status is "on", click on it to close it. 4. Finally, in the pop-up window, there will be a switch button behind "Recommend friends to me". Click on it to set the button to gray.

A Java emulator is software that can run Java applications on a computer or device. It can simulate the Java virtual machine and execute Java bytecode, enabling users to run Java programs on different platforms. Java simulators are widely used in software development, learning and testing. This article will introduce five useful and practical Java emulators that can meet the needs of different users and help users develop and run Java programs more efficiently. The first emulator was Eclipse. Ecl

Go to Recommend Silent Gaming Keyboard If you want to enjoy a quiet experience while gaming, you may consider buying a silent gaming keyboard. Recommended products include CherryMXSilent, LogitechG915 and SteelSeriesApexPro. These keyboards are low-noise, lightweight and responsive. In addition, it is recommended to choose a keyboard with features such as adjustable backlight brightness, programmable functions, and comfortable feel to meet better usage needs. Recognized as the quietest keyboard "Duga K320", it is a much-loved electronic product. It is known for its excellent performance and features, making it an ideal choice for many people. Whether it is gaming, entertainment or office work, Duga K320 can provide excellent performance. it

From Beginner to Expert: Five Essential C Compiler Recommendations With the development of computer science, more and more people are interested in programming languages. As a high-level language widely used in system-level programming, C language has always been loved by programmers. In order to write efficient and stable code, it is important to choose a C language compiler that suits you. This article will introduce five essential C language compilers for beginners and experts to choose from. GCCGCC, the GNU compiler collection, is one of the most commonly used C language compilers

Glodon Software is a software company focusing on the field of building informatization. Its products are widely used in all aspects of architectural design, construction, and operation. Due to the complex functions and large data volume of Glodon software, it requires high computer configuration. This article will elaborate on the computer configuration recommendations of Glodon Software from many aspects to help readers choose a suitable computer configuration processor. Glodon Software requires a large amount of data calculation and processing when performing architectural design, simulation and other operations. Therefore, the requirements for the processor are higher. It is recommended to choose a multi-core, high-frequency processor, such as Intel i7 series or AMD Ryzen series. These processors have strong computing power and multi-thread processing capabilities, and can better meet the needs of Glodon software. Memory Memory is affecting computing

Huang Quan's light cone can effectively increase the character's critical hit damage and attack power in battle. The light cones recommended by Huang Quan are: Walking on the Passing Shore, Good Night and Sleeping Face, Rain Keeps Falling, Just Wait, and Determination Like Beads of Sweat. Shine, below the editor will bring you recommendations for the Underworld Light Cone of the Collapsed Star Dome Railway. Huangquan Light Cone Recommendation 1. Walking on the Passing Bank 1. Huangquan's special weapon can increase the explosive damage. Attacking the enemy can put the enemy into a bubble negative state, which increases the damage caused. The damage of the finishing move is additionally increased. There are both negative states and The damage is increased, it has to be said that it is a special weapon. 2. The exclusive light cone is very unique among many ethereal light cones. It directly increases direct damage, has high damage and improves the critical damage attribute. 3. Not only that, the light cone also provides a negative status effect, which can cause Huangquan itself to react.
