Table of Contents

15.1. Introduction

15.2. Overview

15.3. Creating Storage Engine Source Files

15.4. Creating the handlerton

15.5. Handling Handler Instantiation

15.6. Defining Filename Extensions

15.7. Creating Tables

15.8. Opening a Table

15.9. Implementing Basic Table Scanning

15.9.1. Implementing the store_lock() Function

15.9.2. Implementing the external_lock() Function

15.9.3. Implementing the rnd_init() Function

15.9.4. Implementing the info() Function

15.9.5. Implementing the extra() Function

15.9.6. Implementing the rnd_next() Function

15.10. Closing a Table

15.11. Adding Support for INSERT to a Storage Engine

15.12. Adding Support for UPDATE to a Storage Engine

15.13. Adding Support for DELETE to a Storage Engine

15.14. Supporting Non-Sequential Reads

15.14.1. Implementing the position() Function

15.14.2. Implementing the rnd_pos() Function

15.15. Supporting Indexing

15.15.1. Indexing Overview

15.15.2. Getting Index Information During CREATE TABLE Operations

15.15.3. Creating Index Keys

15.15.4. Parsing Key Information

15.15.5. Providing Index Information to the Optimizer

15.15.6. Preparing for Index Use with index_init()

15.15.7. Cleaning up with index_end()

15.15.8. Implementing the index_read() Function

15.15.9. Implementing the index_read_idx() Function

15.15.10. Implementing the index_next() Function

15.15.11. Implementing the index_prev() Function

15.15.12. Implementing the index_first() Function

15.15.13. Implementing the index_last() Function

15.16. Supporting Transactions

15.16.1. Transaction Overview

15.16.2. Starting a Transaction

15.16.3. Implementing ROLLBACK

15.16.4. Implementing COMMIT

15.16.5. Adding Support for Savepoints

15.17. API Reference

15.17.1. bas_ext

15.17.2. close

15.17.3. create

15.17.4. delete_row

15.17.5. delete_table

15.17.6. external_lock

15.17.7. extra

15.17.8. index_end

15.17.9. index_first

15.17.10. index_init

15.17.11. index_last

15.17.12. index_next

15.17.13. index_prev

15.17.14. index_read_idx

15.17.15. index_read

15.17.16. info

15.17.17. open

15.17.18. position

15.17.19. records_in_range

15.17.20. rnd_init

15.17.21. rnd_next

15.17.22. rnd_pos

15.17.23. start_stmt

15.17.24. store_lock

15.17.25. update_row

15.17.26. write_row