MySQL 优化(五)

7.3 锁

7.3.1 锁机制

当前MySQL已经支持 ISAM, MyISAM, MEMORY (HEAP) 类型表的表级锁了,BDB 表支持页级锁,InnoDB 表支持行级锁。

MySQL 优化(四)

7.2.9 MySQL 如何优化 ORDER BY

在一些情况下,MySQL可以直接使用索引来满足一个 ORDER BYGROUP BY 子句而无需做额外的排序。

MySQL 优化(三)

7.2.2 估算查询性能

在大多数情况下,可以通过统计磁盘搜索次数来估算查询的性能。对小表来说,通常情况下只需要搜索一次磁盘就能找到对应的记录(因为索引可能已经缓存起来了)。对大表来说,大致可以这么估算,它使用B树做索引,想要找到一条记录大概需要搜索的次数为:log(row_count) / log(index_block_length / 3 * 2 / (index_length + data_pointer_length)) + 1

MySQL 优化(二)

7.2.1 EXPLAIN 语法(得到SELECT 的相关信息)

EXPLAIN tbl_name


EXPLAIN SELECT select_options

EXPLAIN 语句可以被当作 DESCRIBE 的同义词来用,也可以用来获取一个MySQL要执行的 SELECT 语句的相关信息。

  • EXPLAIN tbl_name 语法和 DESCRIBE tbl_nameSHOW COLUMNS FROM tbl_name 一样。

Capgemini Selects MySQL Cluster for Great Britain Seat Reservation System

come from:

Capgemini Develops "Look-to-Book" Travel Solution to Serve Enquiries
from Sales Points, Internet and Call Centers


IBM & EMC Join the MySQL Network Certified Partner Program

come from:

Enterprise Vendors Provide Products & Services that Support Users of the World's Most Popular Open Source Database


MySQL Joins the Eclipse Foundation

come from:

SANTA CLARA, Calif. -- March 20, 2006 -- MySQL AB, developer of the world's most popular open source database, today announced it has joined the Eclipse Foundation as an Add-In Provider. The company plans to contribute work to the Eclipse Data Tools Platform project and collaborate with Zend Technologies and others on the Eclipse PHP IDE project. The announcement was made in advance of the EclipseCon 2006 conference, being held here this week.


Recognized Database Experts Join MySQL AB

come from:

InterBase Creator Jim Starkey Joins New co-CTO Taneli Otala -- Expanding Veteran Tech Experience at Open Source Database Leader

CUPERTINO, Calif. — February 27, 2006 — MySQL AB, developer of the world's most popular open source database, today announced the addition of two well-respected database veterans to its senior engineering management team. Relational database pioneer Jim Starkey, the creator of InterBase, has joined MySQL AB as Senior Software Architect. In addition, the company has appointed Mr. Taneli Otala as co-Chief Technical Officer, a position he will share with MySQL co-founder Michael "Monty" Widenius.


Improving Database Performance with Partitioning

come from:

A few years ago, I wrote an article entitled "The Foundation of Excellent Performance" (still available at where I argued against the notion that SQL code was the number one contributor to performance in a database-driven system. Instead, I stated in the article that I firmly believed how good physical database design was far and away the leading component of superior database performance. In addition, I showed that Oracle's own research illustrated how poor design was the main culprit behind database downtime (planned or unplanned). In the years since then, I've not changed my stance and still think that any DBA who wants a high-performance database has got to invest in intelligent and savvy physical design to produce the kind of response times that make end users smile instead of scream.


MySQL 优化(一)

7 MySQL 优化




Subscribe to iMySQL | 老叶茶馆 - Oracle MySQL ACE Director,专注MySQL RSS