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. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Table of Contents 1 Chapter 1. Introduction Firebird uses a page cache to hold pages in memory. It is much quicker to retrieve pages from RAM than to go out onto the disc

Der Firebird Cache-Buffer Norman Dunbar, Martin Köditz Version 1.2-de, 28. Mai 2020 Inhaltsverzeichnis 1. Einleitung . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 2. Der Firebird-Cache. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Inhaltsverzeichnis 1 Kapitel 1. Einleitung Firebird nutzt einen Seiten-Cache (engl. page cache), um die Seiten im Speicher vorzuhalten. Diese sind deutlich schneller aus dem Arbeitsspeicher

file @2 -239 335544496 logb_small Log block too small at offset @1 in log file @2 -239 335544691 cache_too_small Insufficient memory to allocate page buffer cache -239 335544693 log_too_small Log size use Write-ahead Log -257 335544566 start_cm_for_wal WAL defined; Cache Manager must be started first -260 335544690 cache_redef Cache redefined -260 335544692 log_redef Log redefined -261 335544695 not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache or log file name -600 335544680 crrp_data_err Sort error: corruption in data structure -601 335544646

file %s -239 335544496 logb_small Log block too small at offset %ld in log file %s -239 335544691 cache_too_small Insufficient memory to allocate page buffer cache -239 335544693 log_too_small Log size use Write-ahead Log -257 335544566 start_cm_for_wal WAL defined; Cache Manager must be started first -260 335544690 cache_redef Cache redefined -260 335544692 log_redef Log redefined Firebird 2.0 Error not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache or log file name -600 335544680 crrp_data_err Sort error: corruption in data structure -601 335544646

relnotdef Table is not defined -239 335544691 cache_too_small Insufficient memory to allocate page buffer cache -260 335544690 cache_redef Cache redefined -281 335544637 no_stream_plan Table not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache or log file Firebird 1.5 Error Codes Updated 04/30/04 p. 8 name -600 335544680 crrp_data_err Sort bad_checksum Bad checksum -836 335544517 except Exception -837 335544518 cache_restart Restart shared cache manager -838 335544560 shutwarn Database shutdown in seconds -841

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 340 6.8. EXECUTE BLOCK. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . triggers) only, but in more recent releases they were surfaced in Dynamic SQL as well (see EXECUTE BLOCK). Embedded SQL defines the DSQL subset supported by Firebird gpre, the application which allows of comments. Firebird supports two types of comments: block and in-line. Syntax ::= <block comment> | <block comment> ::= /* [ …] */

0 码力 | 778 页 | 3.43 MB | 1 年前

3

хранимые процедуры ....................................................................... 319 EXECUTE BLOCK ................................................................................................. и триггерах), но сравнительно недавно они стали также доступны в Динамическом SQL (смотри EXECUTE BLOCK). Встроенный SQL определяет подмножество DSQL, поддерживаемое средством Firebird GPRE. GPRE — пр типа комментариев: блочные и однострочные. Синтаксис: ::= <block comment> | <block comment> ::= Структура языка 27 /*[ …]*/

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255 6.8. EXECUTE BLOCK. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . triggers) only, but in more recent releases they were surfaced in Dynamic SQL as well (see EXECUTE BLOCK). Embedded SQL defines the DSQL subset supported by Firebird gpre, the application which allows of comments. Firebird supports two types of comments: block and in-line. Syntax ::= <block comment> | <block comment> ::= /* [ …] */

0 码力 | 521 页 | 2.30 MB | 1 年前

3

. . . . . . . . . . . . . . . . . . . . . . . . . . . 328 Inhaltsverzeichnis 6 6.8. EXECUTE BLOCK. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Trigger) verfügbar, aber in neueren Versionen wurden sie auch in Dynamic SQL aufgetaucht (siehe EXECUTE BLOCK). Embedded SQL definiert die DSQL-Untermenge, die von Firebird gpre unterstützt wird, der Anwendung unterstützt zwei Arten von Kommentaren: block und in-line. Chapter 2. SQL Sprachstruktur 22 Syntax ::= <block comment> | <block comment> ::= /* [

connec- tion, each with its own cache. Less re- source use if the number of connections is low. Single server process with a separate thread for each connection. Shared cache space. More efficient if the of them is NULL. In an “if...then” context, NULL behaves like FALSE. So the 'then' block is skipped, and the 'else' block executed. • if (a <> b) then MyVariable = 'Not equal'; else MyVariable = 'Equal'; a database to use asynchronous data writes – whereby modified or new data are held in the memory cache for periodic flushing to disk by the operating system's I/O subsystem. The common term for this configuration