• Archives for mysql (5)

Difference Between InnoDB and MyISAM

Categories: 服务器相关
Tags: , ,
Comments: No Comments
Published on: 2013 年 05 月 30 日
  • The big difference between MySQL Table Type MyISAM and InnoDB is that InnoDB supports transaction
  • InnoDB supports some newer features: Transactions, row-level locking, foreign keys
  • InnoDB is for high volume, high performance

Most people use MyISAM if they need speed and InnoDB for data integrity. You can use more than one or any combination of these table types in your database. Remember to asses the needs of your application before building it. Even though MyISAM is faster than InnoDB in the MySQL world, InnoDB is fast compared to any database engine.With InnoDB you get transactions, speed and integrity three features not usually used in the same sentence.

InnoDB has been designed for maximum performance when processing large data volumes. Its CPU efficiency is probably not matched by any other disk-based relational database engine.

Fully integrated with MySQL Server, the InnoDB storage engine maintains its own buffer pool for caching data and indexes in main memory. InnoDB stores its tables and indexes in a tablespace, which may consist of several files (or raw disk partitions). This is different from, for example, MyISAM tables where each table is stored using separate files. InnoDB tables can be of any size even on operating systems where file size is limited to 2GB.

So, what do you think about those engines?? Please feel free to discuss it.

For more information visit http://dev.mysql.com/


Categories: 数据库, 服务器相关
Comments: No Comments
Published on: 2012 年 05 月 11 日



Categories: 数据库, 网站相关
Comments: No Comments
Published on: 2011 年 12 月 21 日

一直用了那么久的mysql,虽然了解了一些优化方法,但是都是比较简单的一些应用,这次就系统的了解一下。 (more...)

Pages: 1 2 3 4 5


Categories: 工具语言, 数据库
Comments: 3 Comments
Published on: 2011 年 12 月 14 日

首先去MySQL官网下载MySQL connector/C++
下载第二个包,windows32位非安装版(个人觉得这个包干净)。目前的版本是Connector/C++ 1.0.5。 (more...)


Categories: 数据库, 网站相关
Comments: No Comments
Published on: 2010 年 11 月 09 日

MYSQL常用命令 (more...)

page 1 of 1
« 七    
sina weibo

Welcome , today is 星期三, 2019 年 03 月 20 日