1203b2fc175f/p1_1.jpg) Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 ## Table of Contents 1. Introduction ..... 2 2. Database Structure ..... 3 2.1. 2.2. Multiple File Databases ..... 3 2.3. Shadow Files ..... 3 3. Standard Database Page Header ..... 5 4. Database Header Page — Type 0x01 ..... 7 5. Page Inventory Page — Type 0x02 ..... 14 this document is to try to explain what goes on inside a Firebird database. Much of the information in this manual has been extracted from the Firebird source code — mainly on the ODS related code and headers

Firebird Interactive SQL Utility Kamala Vadlamani, Paul Vinkenoog, Norman Dunbar, Mark Rotteveel Version 1.0, 24 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 8. Connecting To A Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 8.1.3. Using Database Aliases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 9. Creating A Database. . . . . . . . . .

1880ebc897/p1_1.jpg) # Firebird Database Cache Buffer Norman Dunbar, Martin Köditz Version 1.2, 28 May 2020 ## Table of Contents 1. Introduction ..... 2 2. The Firebird Cache ..... 3 3. Using Appendix A: Document history ..... 9 Appendix B: License notice ..... 10 ### Chapter 1. Introduction Firebird uses a page cache to hold pages in memory. It is much quicker to retrieve pages from RAM than to each time they are required. The following description of how Firebird uses its cache is taken from a posting by Ann Harrison on the Firebird Support mailing list. The posting was in response to a query

 # Firebird Backup File Splitting Filter Norman Dunbar Version 1.2, 19 June 2020 ## Table of Contents 1. Introduction from the gbak utility (when backing up a database) to be split into a number of chunks, or a number of chunks to be joined together and used to restore a database. Up until Interbase 5.0, dump files were split large backup files even if gsplit is supplied with your Firebird release. Gsplit is only supplied with the Windows version of Firebird 1.5, it is not supplied with the Linux version. Linux doesn’t

 # Firebird Password File Utility Norman Dunbar Version 1.5, 18 June 2020 ## Table of Contents 1. Introduction ..... 2 Introduction Gsec is the security database manipulation utility. It allows the SYSDBA (or any privileged user) the ability to maintain user accounts for various Firebird databases. Using various options users can be added, amended or deleted from the security database. A privileged user is an account on the database server which the Firebird engine considers to be privileged enough to automatically

 # Firebird Database Housekeeping Utility Norman Dunbar, Mark Rotteveel Version 2.1, 13 November 2023 ## Table of Contents Files ..... 7 4.1. Activating Shadows ..... 7 4.2. Killing Shadows ..... 8 5. Set Database Page Buffers ..... 10 6. Limbo Transaction Management ..... 12 6.1. Listing Limbo Transactions Recovery ..... 14 7. Cache Manager ..... 15 8. Changing The Database Mode ..... 16 9. Setting The Database Dialect ..... 18 10. Database Housekeeping And Garbage Collection ..... 20 10.1. Garbage

 # Firebird Backup & Restore Utility Norman Dunbar Version 1.12, 18 June 2020 ## Table of Contents 1. Introduction Size ..... 20 6.7. Change The Page Size ..... 21 6.8. Create A Read-Only Database Clone ..... 21 6.9. Create a Database Clone Without a Dump File ..... 22 6.10. Backup & Restore With & Without Introduction Gbak is one of the database backup and restore utilities supplied with Firebird. In Firebird 1.5 it is the only supplied utility of this kind while Firebird 2.x also has the nbackup utility

## Using MySQL for Distributed Database Architectures Peter Zaitsev CEO, Percona PingCAP Infra Meetup, Shanghai, China, May 26, 2018 ## About Percona Solutions for your success with MySQL, MariaDB, of Thousands of Updates/Sec Traverse Tens of Millions of Rows/Sec Comfortably Handle Several TB Database size ## Lets Do Some Math 100.000 QPS 10 Queries per User Interaction 10.000 User Interactions/sec Computing Resource ## Paired with Replicated Data ## Where Replication Happens Storage Level ## Database Level ## Application Level ## Storage Level Replication Replication in SAN/NAS, DRBD Typically

MaterializeMySQL Database engine in ClickHouse WinterZhang(张健) ## About me • Active ClickHouse Contributor • MaterializeMySQL Database Engine • Custom HTTP Handler • MySQL Database Engine • BloomFilter ## MySQL Database Engine • Mapping to MySQL database • Fetch table list from MySQL • Fetch table struct from MySQL • Fetch data from MySQL when execute query ## MaterializeMySQL Database Engine • • Mapping to MySQL database • Consume MySQL BINLOG and store to MergeTree • Experimental feature (20.8, recommend latest stable version) ## MaterializeMySQL Database Engine MySQL $ ^{TM} $ ☐ ## MaterializeMySQL

[Image](/uploads/documents/8/1/2/f/812fdd80ba8d747e09890b43de3fb0bc/p1_1.jpg) Firebird Null Guide NULL behaviour and pitfalls in Firebird SQL Paul Vinkenoog Version 1.2, 30 June 2020 ## Table of Contents 1 4 2. NULL support in Firebird SQL ..... 6 2.1. Disallowing NULL ..... 6 2.2. Testing for NULL ..... 6 2.3. Assigning NULL ..... 7 2.4. Testing DISTINCTness (Firebird 2+) ..... 7 2.5. The NULL NULL literal ..... 8 2.5.1. Firebird 1.5 and below ..... 8 2.5.2. Firebird 2.0 and up ..... 8 3. NULL in operations ..... 9 3.1. Mathematical and string operations ..... 9 3.2. Boolean operations