Four Critical GBase 8s onconfig Parameters Every DBA Should Know

·1 views

GBase 8s stores all instance-level settings in a core configuration file called onconfig, which controls memory, logging, connections, and buffer behavior. Four parameters stand out as especially significant: BUFFERPOOL manages how data pages are cached in shared memory and should be sized according to workload and available RAM. LOGSIZE and LOGFILES work together to define the size and number of logical log files, directly affecting transaction processing capacity and recovery capability. SHMTOTAL caps the total shared memory the database server may use, making it critical on production systems that share resources with other applications. Administrators can inspect the active configuration at any time using the onstat -g config command, and should note that some parameters require a full instance restart to take effect while others support dynamic modification.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Loop reordering beats cache tiling in matrix multiplication benchmark

A developer benchmarked four C implementations of matrix multiplication on Apple Silicon to compare naive, loop-reordered, tiled, and BLAS approaches. The results showed that simply reordering the inner loops (ijk to ikj) delivered a 6.3x speedup over the naive version at n=1024, without any cache-blocking code. Tiling, widely promoted as the go-to optimization, never outperformed the plain reordered loop on this hardware, largely because the CPU's large L2 cache and compiler auto-vectorization already handled memory access efficiently. BLAS remained far ahead at roughly 24.5x faster than the best hand-written loop, indicating its gains come from deeper optimizations beyond cache tiling alone. The key takeaway is that hardware-specific measurement matters, and commonly recommended optimizations do not always deliver the expected gains on every platform.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Documents 48 Hours of Silent JSON Truncation Bugs on Free AI Model Endpoints

A developer ran 200 repeated prompts through a free AI model endpoint to test the reliability of structured JSON output, and discovered that failures were not random but fell into distinct patterns. The three main failure types identified were silent truncation — where responses ended mid-string with no HTTP error or metadata warning — duplicate key repetition, and missing closing brackets on nested arrays. Silent truncation was flagged as the most dangerous issue because neither the API metadata nor the HTTP response signalled that output had been cut short. To address the problem without doubling token usage through blanket retries, the developer built a small Python diagnostic utility that classifies incomplete responses by checking bracket balance and trailing characters. The findings highlight reliability concerns specific to free-tier or shared-backend model servers, where request splitting across instances may contribute to transport-level data corruption.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Network Stability, Not Speed, Is What Makes Remote Development Smooth

Developers often assume faster internet speeds will improve remote work performance, but connection stability plays a far greater role in day-to-day usability. Key factors such as latency, packet loss, jitter, and routing can make a high-bandwidth connection feel sluggish during interactive tasks like typing commands or using a remote desktop. A developer on a stable 100 Mbps connection can experience a smoother remote session than one using a 1 Gbps link with inconsistent latency. Unlike large file downloads, interactive remote work involves constant round trips between machines, making even small network irregularities noticeable over a full workday. Standard speed tests fail to capture these variables, leaving many developers unaware of the true cause of their performance issues.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Caching at Scale: Why Deciding What to Cache Matters More Than How

As platforms handling commodities, crypto, or e-commerce grow to thousands of concurrent users, repeated identical requests strain databases and downstream services unnecessarily. Caching is the common solution, but the critical architectural question is determining which data can safely be served stale and for how long. A gold price cached for two seconds may be acceptable in one system but problematic in another, while a balance used to execute a financial transaction carries far greater risk. Caching exists at multiple layers — browsers, CDNs, reverse proxies, and applications — each introducing a version of system state that may diverge from reality. The article argues that setting a TTL is straightforward, but deciding what to cache, where, and who handles invalidation is a far more consequential engineering decision.

0 comments Read more at DEV Community