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

InnoDB Falcon MySQL PowerPoint PPT Presentation


  • 111 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

:

:

87


MySQL


MySQL

  • MySQL

  • MySQL

    • (view)

    • (store procedure)


(Storage Engine)

  • MySQL

    • SQL:

    • Storage:

  • MySQL 5.1


MySQL

MySQL


()

    • Sorting

    • Group by

    • Limit

  • MySQL

  • ( Kickfire)

    • query


      • 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( )

Transaction

Transaction

2001 MySQL-3.23.34a

ISAM

MyISAM

BDB (BerkeleyDB)

InnoDB

Falcon


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 10

  • :

  • SQL

    • ACID

    • MVCC(multi-version concurrency control )

    • ( )

  • Fuzzy Checkpointing


InnoDB

    • MySQL

      • log

    • SELECT ( Oracle)

  • ROLLBACK




LIMIT



LIMIT


INDEX



INDEX



LIMIT



LIMIT



()

  • InnoDB

    • CPU

    • 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



  • Login