Innodb falcon mysql
This presentation is the property of its rightful owner.
Sponsored Links
1 / 27

InnoDB Falcon MySQL PowerPoint PPT Presentation


  • 103 Views
  • Uploaded on
  • Presentation posted in: General

????? ?????. ????? ???????? ????? ???? ?? MySQL????? ?? ???? ??? ? ??????????? ????? ?????? ???????????? ????????????????????. 2. MySQL ?????? ??????? ?????????? ?????????? ????????? ????? ????? ???????? ????? MySQL???? ??? (view)???? ???????? ????? ???(store procedure)???? ?????????

Download Presentation

InnoDB Falcon MySQL

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Innodb falcon mysql

InnoDB Falcon MySQL

:

:

87


Innodb falcon mysql

MySQL


Innodb falcon mysql

MySQL

  • MySQL

  • MySQL

    • (view)

    • (store procedure)


Innodb falcon mysql

(Storage Engine)

  • MySQL

    • SQL:

    • Storage:

  • MySQL 5.1


Innodb falcon mysql

MySQL

MySQL


Innodb falcon mysql

()

    • Sorting

    • Group by

    • Limit

  • MySQL

  • ( Kickfire)

    • query


Innodb falcon mysql

      • Innodb, Falcon, PBXT, Maria (future)

      • MyISAM, ISAM (dead),Maria(current)

    • NDB, ScaleDB (CloseSource)

    • Memory, Federated, Archive,Blackhole, CSV, NitroDB(CS), SphinxSE , InfoBright(CS), Queue, Graph(CS)


Mysql

MySQL( )

Transaction

Transaction

2001 MySQL-3.23.34a

ISAM

MyISAM

BDB (BerkeleyDB)

InnoDB

Falcon


Myisam

MyISAM

CREATE TABLE articles (articleIDint not null auto_increment primary key,title varchar (2MERGE),body text,fulltext (title,body));

SELECT titleFROM articleWHERE MATCH (title, body) AGAINST ('miniprogrammer');

  • FullText Searching

    • stemming


Innodb

InnoDB

  • InnoDB 10

  • :

  • SQL

    • ACID

    • MVCC(multi-version concurrency control )

    • ( )

  • Fuzzy Checkpointing


Innodb1

InnoDB

    • MySQL

      • log

    • SELECT ( Oracle)

  • ROLLBACK


Innodb falcon mysql


Innodb falcon mysql


Limit

LIMIT


Innodb falcon mysql


Limit1

LIMIT


Index

INDEX


Innodb falcon mysql


Index1

INDEX


Innodb falcon mysql


Limit2

LIMIT


Innodb falcon mysql


Limit3

LIMIT


Innodb falcon mysql


Innodb falcon mysql

()

  • InnoDB

    • CPU

    • MySQL


Innodb falcon mysql

  • Bannon, Chin, Kassam, and Roszko, InnoDB Concrete Architecture. Waterloo, Ontario: Software Architecture Group, University of Waterloo, 2002

  • Leon Atkinson, Core MySQL, Prentice Hall PTR,ISBN 0-13-00661902, 2002.

  • Silberschatz, H. Korth and S. Sudarshan, Database system concepts, Mc Graw Hill 4th Edition, ISBN 0-07-112268-0, 2002.

  • MySQL reference manual, available at http://www.mysql.org.

  • Atkinson, Leon. Core, MySQL: The Serious Developers Guide. New Jersey: Prentice Hall Publishing, 2002.

  • http:// www.innoDB.com


Innodb falcon mysql


  • Login