随笔分类 -  高性能MySQL笔记

高性能MySQL笔记-第5章Indexing for High Performance-005聚集索引
摘要：一、聚集索引介绍 1.什么是聚集索引？ InnoDB’s clustered indexes actually store a B-Tree index and the rows together in the same structure. 2.为什么一张表只能一个聚集索引？ When a tab 阅读全文
posted @ 2016-04-12 18:32 shamgod 阅读(462) 评论(0) 推荐(0)
高性能MySQL笔记-第5章Indexing for High Performance-004怎样用索引才高效
摘要：一、怎样用索引才高效 1.隔离索引列 MySQL generally can’t use indexes on columns unless the columns are isolated in the query. “Isolating” the column means it should n 阅读全文
posted @ 2016-04-12 16:38 shamgod 阅读(247) 评论(0) 推荐(0)
高性能MySQL笔记-第5章Indexing for High Performance-003索引的作用
摘要：一、 1. 1). Indexes reduce the amount of data the server has to examine.2). Indexes help the server avoid sorting and temporary tables.3). Indexes turn 阅读全文
posted @ 2016-04-12 11:14 shamgod 阅读(234) 评论(0) 推荐(0)
高性能MySQL笔记-第5章Indexing for High Performance-002Hash indexes
摘要：一、 1.什么是hash index A hash index is built on a hash table and is useful only for exact lookups that use every column in the index. For each row, the st 阅读全文
posted @ 2016-04-12 10:43 shamgod 阅读(198) 评论(0) 推荐(0)
高性能MySQL笔记-第5章Indexing for High Performance-001B-Tree indexes(B+Tree)
摘要：一、 1.什么是B-Tree indexes？ The general idea of a B-Tree is that all the values are stored in order, and each leaf page is the same distance from the root 阅读全文
posted @ 2016-04-12 09:31 shamgod 阅读(231) 评论(0) 推荐(0)
高性能MySQL笔记-第4章Optimizing Schema and Data Types
摘要：1.Good schema design is pretty universal, but of course MySQL has special implementation details to consider. In a nutshell, it’s a good idea to keep 阅读全文
posted @ 2016-04-11 21:55 shamgod 阅读(183) 评论(0) 推荐(0)
高性能MySQL笔记-第1章MySQL Architecture and History-001
摘要：1.MySQL架构图 2.事务的隔离性 事务的隔离性是specific rules for which changes are and aren’t visible inside and outside a transaction (1)READ UNCOMMITTED In the READ UN 阅读全文
posted @ 2016-04-02 20:51 shamgod 阅读(401) 评论(0) 推荐(0)

haha