groonga storage engine ClearCode Inc. Kouhei Sutou - - PowerPoint PPT Presentation

▶

Jan 30, 2024 16 likes •270 views

groonga storage engine ClearCode Inc. Kouhei Sutou OSC2011.DB/OSSDB MySQL 2011/11/5 groonga storage engine Powered by Rabbit 1.0.5 About me The president of ClearCode Inc. The author of Rabbit A developer of groonga A developer of

SLIDE 1

groonga storage engine Powered by Rabbit 1.0.5

groonga storage engine

Kouhei Sutou

ClearCode Inc.

OSC2011.DB/OSSDB MySQL 2011/11/5

SLIDE 2

groonga storage engine Powered by Rabbit 1.0.5

About me

The president of ClearCode Inc. The author of Rabbit A developer of groonga A developer of groonga storage engine

1/24

SLIDE 3

groonga storage engine Powered by Rabbit 1.0.5

groonga storage engine?

A storage engine of MySQL Fast fulltext search Fast geo search Real-time update

2/24

SLIDE 4

groonga storage engine Powered by Rabbit 1.0.5

Storage engine

A storage engine of MySQL Fast fulltext search Fast geo search Real-time update

3/24

SLIDE 5

MySQL server SQL handler MyISAM storage engine InnoDB groonga storage engine MySQL client SQL C++ API

An alternative

MyISAM,InnoDB and so on

SLIDE 6

groonga storage engine Powered by Rabbit 1.0.5

Fast fulltext search

A storage engine of MySQL Fast fulltext search Fast geo search Real-time update

5/24

SLIDE 7

SLIDE 8

groonga storage engine Powered by Rabbit 1.0.5

Fast geo search

A storage engine of MySQL Fast fulltext search Fast geo search Real-time update

7/24

SLIDE 9

SLIDE 10

groonga storage engine Powered by Rabbit 1.0.5

Real-time update

A storage engine of MySQL Fast fulltext search Fast geo search Real-time update

Fast update Lock free

9/24

SLIDE 11

groonga storage engine Powered by Rabbit 1.0.5

Fast update

A storage engine of MySQL Fast fulltext search Fast geo search Real-time update

Fast update Lock free

10/24

SLIDE 12

SLIDE 13

groonga storage engine Powered by Rabbit 1.0.5

Lock free

A storage engine of MySQL Fast fulltext search Fast geo search Real-time update

Fast update Lock free

12/24

SLIDE 14

SLIDE 15

groonga storage engine Powered by Rabbit 1.0.5

Caution

No transaction ALTER TABLE is unsupported

It will be supported in the next release

Geo supports only POINT

14/24

SLIDE 16

groonga storage engine Powered by Rabbit 1.0.5

Transaction support

groonga storage engine + InnoDB

ALTER TABLE is unsupported

It will be supported in the next release

Geo supports only POINT

15/24

SLIDE 17

MySQL server SQL handler MyISAM InnoDB groonga storage engine MySQL client SQL storage engine C++ API

Adds fast fulltext search to MyISAM, InnoDB and so on

C++ API process only fulltext search

SLIDE 18

groonga storage engine Powered by Rabbit 1.0.5

Fast fulltext search

A storage engine of MySQL Fast fulltext search Fast geo search Real-time update

17/24

SLIDE 19

SLIDE 20

groonga storage engine Powered by Rabbit 1.0.5

Fast geo search

A storage engine of MySQL Fast fulltext search Fast geo search Real-time update

19/24

SLIDE 21

SLIDE 22

groonga storage engine Powered by Rabbit 1.0.5

Real-time update

A storage engine of MySQL Fast fulltext search Fast geo search Real-time update

Fast update Lock free

21/24

SLIDE 23

SLIDE 24

SLIDE 25

groonga storage engine Powered by Rabbit 1.0.5

Conclusion

A fast fulltext search for all MySQL users!

http://mroonga.github.com/ 24/24