mysql
文章平均质量分 81
macyang
Chance is waiting for prepared people and my Status is read the fucking source code.
展开
-
MySQL Scaling Options
- Executive SummaryMySQL is the most popular relational database in the world of web applications – be it Web 2.0sites, SaaS applications or any other web application. These types of applications原创 2012-01-07 14:56:12 · 1039 阅读 · 0 评论 -
Indexing Strategies for Optimizing Queries on MySQL
MySQL’s index begins by reviewing how indexes work, as well as their structure. Next, it reviews indexing features specific to each of the major MySQL data storage engines. This article then examines转载 2013-06-29 09:49:30 · 853 阅读 · 0 评论 -
What have been Facebook's greatest technical accomplishments?
I ran the infrastructure software team at facebook for five years, and was involved in most of the projects listed in the other answers. I consider the greatest accomplishment while I was there to b转载 2013-01-13 22:08:35 · 589 阅读 · 0 评论 -
MySQL Engines: InnoDB vs. MyISAM – A Comparison of Pros and Cons
The 2 major types of table storage engines for MySQL databases are InnoDB and MyISAM. To summarize the differences of features and performance,InnoDB is newer while MyISAM is older.InnoDB is more转载 2012-11-26 22:33:51 · 649 阅读 · 0 评论 -
Understanding B+tree Indexes and how they Impact Performance
Indexes are a very important part of databases and are used frequently to speed up access to particular data item or items. So before working with indexes, it is important to understand how indexes wo转载 2012-11-26 21:41:26 · 700 阅读 · 0 评论 -
Statement-based vs Row-based Replication
Replication as most people know it, has mostly been SQL statement propagation from master to slave. This is known as “statement-based” replication. But there is also another kind of replication that i转载 2012-11-26 21:27:57 · 1811 阅读 · 0 评论 -
MySQL索引背后的数据结构及算法原理
摘要本文以MySQL数据库为研究对象,讨论与数据库索引相关的一些话题。特别需要说明的是,MySQL支持诸多存储引擎,而各种存储引擎对索引的支持也各不相同,因此MySQL数据库支持多种索引类型,如BTree索引,哈希索引,全文索引等等。为了避免混乱,本文将只关注于BTree索引,因为这是平常使用MySQL时主要打交道的索引,至于哈希索引和全文索引本文暂不讨论。文章主要内容分为三个部分转载 2012-11-26 22:32:07 · 652 阅读 · 0 评论 -
Understanding InnoDB clustered indexes
Some people don’t probably know, but there is a difference between how indexes work in MyISAM and how they work in InnoDB, particularly when talking from the point of view of performance enhancement.转载 2012-11-26 22:09:35 · 807 阅读 · 0 评论 -
How to implement MySQL Sharding
本文主要告诉你如何选择需要做sharding的表和如何选择sharding key。Database Sharding has proven itself a very successful strategy for scaling relational databases. Almost every large web-site/SaaS solution uses sharding whe原创 2012-01-07 23:39:08 · 2119 阅读 · 0 评论 -
Scaling Out MySQL
很赞的一篇文章,值得你细细品味一下,原文地址:http://natishalom.typepad.com/nati_shaloms_blog/2008/03/scaling-out-mys.htmlWith the recent acquisition of MySQL by Sun, there has been talk about the MySQL open source转载 2012-01-06 23:28:42 · 1193 阅读 · 0 评论 -
Bitmap Index vs. B-tree Index: Which and When?
Understanding the proper application of each index can have a big impact on performance.Published 2005Conventional wisdom holds that bitmap indexes are most appropriate for columns having low转载 2013-06-29 10:14:15 · 1151 阅读 · 0 评论