User contributions for Carli
Jump to navigation
Jump to search
21 August 2026
- 17:1117:11, 21 August 2026 diff hist +11,921 Current Status and Open Issues No edit summary current
- 16:2316:23, 21 August 2026 diff hist +7,296 Main Page No edit summary current
- 13:2713:27, 21 August 2026 diff hist +254 Main Page No edit summary Tag: Visual edit
- 13:1813:18, 21 August 2026 diff hist +55 Main Page →Navigation Tag: Visual edit
- 13:0413:04, 21 August 2026 diff hist +1,092 N Dashboard and Operations Created page with "The <code>/dashboard</code> interface provides CPU/memory/request metrics, database and table browsing, shard/compression details, SQL/Scheme consoles, users and grants, runtime settings, process inspection, service state, and configured logs. <code>SHOW [FULL] PROCESSLIST</code>, dashboard process controls, <code>KILL QUERY</code>, and <code>KILL CONNECTION</code> expose active work and cancellation. Graceful shutdown stops new requests and waits up to <code>ShutdownDr..." current Tag: Visual edit: Switched
- 13:0313:03, 21 August 2026 diff hist +1,027 N Triggers Created page with "MemCP supports persistent BEFORE and AFTER triggers for INSERT, UPDATE, and DELETE. Trigger bodies can read <code>OLD</code> and <code>NEW<</code>, assign permitted <code>NEW</code> values, run conditional BEGIN/END bodies, and execute supported DML including <code>INSERT … SELECT</code>. Multiple triggers execute by registered priority. AFTER work may be configured as asynchronous, in which case its completion and failure are not identical to the originating statemen..." current Tag: Visual edit
- 13:0213:02, 21 August 2026 diff hist +1,024 N Memory Management and Eviction Created page with "MemCP tracks persisted shard columns, indexes, temporary columns, keytables, cache-engine objects, and string dictionaries in a global memory manager. The overall budget defaults to 50% of system RAM. A separate persisted-data budget defaults to 30%. Exact byte limits override percentages. If system available memory falls too low, MemCP can evict before its own configured budget is exhausted. Eviction is LRU-like and type-aware. Persistent shard eviction releases only..." current Tag: Visual edit
- 13:0113:01, 21 August 2026 diff hist +1,260 N Transactions and Isolation Created page with "Every SQL statement runs in an implicit transaction unless the session already has an explicit <code>BEGIN</code>/<code>COMMIT</code>/<code>ROLLBACK</code> transaction. The default cursor-stability mode applies writes directly with undo masks, gives statement atomicity, and rolls back on errors. MemCP also contains an ACID mode with snapshot visibility and optimistic commit conflict detection. Savepoints are used internally for nested trigger/error recovery. Transactio..." current Tag: Visual edit
- 12:5812:58, 21 August 2026 diff hist +14,007 N Query Planner and Physical Lowering Created page with "MemCP compiles SQL into executable Scheme code. The planner first converts SQL into a logical representation, decorrelates subqueries, and chooses a join order. Only after those semantic decisions are complete does the physical lowerer select scans, indexes, caches, RecSets, computed columns, and other storage-engine operators. This separation is important: two queries that mean the same thing should reach the same logical representation even when they use different..." current Tag: Visual edit
9 March 2026
- 14:2014:20, 9 March 2026 diff hist +82 Persistency and Performance Guarantees →Persistency Guarantees current Tag: Visual edit
- 14:1614:16, 9 March 2026 diff hist +275 Persistency and Performance Guarantees →Persistency Guarantees Tag: Visual edit
- 14:1314:13, 9 March 2026 diff hist +16 Persistency and Performance Guarantees →Persistency Guarantees Tag: Visual edit
- 14:1314:13, 9 March 2026 diff hist +450 Persistency and Performance Guarantees No edit summary Tag: Visual edit
27 February 2026
- 04:2104:21, 27 February 2026 diff hist +53 Main Page No edit summary Tag: Visual edit
- 04:1904:19, 27 February 2026 diff hist +28 N File:Memcp-Load.png No edit summary current
26 January 2026
- 08:3908:39, 26 January 2026 diff hist +29 Main Page No edit summary Tag: Visual edit
- 08:3908:39, 26 January 2026 diff hist +1,272 Data Auto Sharding and Auto Indexing No edit summary current Tag: Visual edit
- 02:0602:06, 26 January 2026 diff hist +97 Supported SQL →Statements current Tag: Visual edit
- 02:0602:06, 26 January 2026 diff hist −1,290 Auto Sharding Blanked the page current Tags: Blanking Visual edit
- 02:0102:01, 26 January 2026 diff hist +1,160 Advanced SQL Tutorial No edit summary current Tag: Visual edit
- 02:0002:00, 26 January 2026 diff hist +2,078 N Performance Measurement Created page with " == Performance Testing Framework == MemCP includes an auto-calibrating performance test framework for regression detection and benchmarking. === Running Performance Tests === <code># Run performance tests (uses calibrated baselines) PERF_TEST=1 make test # Calibrate for your machine (run ~10 times to reach target) PERF_TEST=1 PERF_CALIBRATE=1 make test # Freeze row counts for bisecting regressions PERF_TEST=1 PERF_NORECALIBRATE=1 make test # Show query exe..." current Tag: Visual edit
- 01:5801:58, 26 January 2026 diff hist +18 Auto Sharding No edit summary Tag: Visual edit
- 01:5701:57, 26 January 2026 diff hist +1,272 N Auto Sharding Created page with "## Parallel Sharding MemCP automatically creates parallel shards for optimal query performance across multiple CPU cores. ### Bulk Insert Optimization When inserting large amounts of data, MemCP automatically: 1. **Splits bulk inserts into chunks** of 60,000 rows (configurable via ShardSize) 2. **Creates new shards on-the-fly** when the current shard fills up 3. **Rebuilds full shards in parallel** using background goroutines This enables insertion of millions of ro..."
5 October 2025
- 00:3700:37, 5 October 2025 diff hist +1 Persistency and Performance Guarantees No edit summary Tag: Visual edit
- 00:3400:34, 5 October 2025 diff hist +43 Settings No edit summary current Tag: Visual edit
22 September 2025
- 13:5213:52, 22 September 2025 diff hist +1,914 Main Page No edit summary
- 13:3913:39, 22 September 2025 diff hist −4,996 Main Page No edit summary Tag: Visual edit: Switched
4 September 2025
- 14:4014:40, 4 September 2025 diff hist +39 Comparison: MemCP vs. MySQL No edit summary current Tag: Visual edit
- 14:4014:40, 4 September 2025 diff hist +2,328 N MySQL is too slow Created page with " =MemCP — Faster alternative when "MySQL is too slow"= '''Short description:''' MemCP is an in-memory, column-oriented database optimized for high throughput OLAP and OLTP workloads. It is designed to deliver much faster aggregation and query performance than traditional row-based engines like MySQL. ==Overview== MemCP is a blazing-fast, in-memory, columnar database with built-in REST APIs and a lightweight SQL frontend. It is intended for modern workloads where MySQL..." current Tag: Visual edit
- 14:3814:38, 4 September 2025 diff hist +40 Main Page →🚀 Meet MemCP – The MySQL Alternative You've Been Waiting For Tag: Visual edit
31 August 2025
- 23:5723:57, 31 August 2025 diff hist +275 Cluster Monitor →How it works current Tag: Visual edit
- 22:2722:27, 31 August 2025 diff hist +212 Cluster Monitor No edit summary Tag: Visual edit
- 20:5920:59, 31 August 2025 diff hist +195 File System No edit summary current Tag: Visual edit
- 20:5820:58, 31 August 2025 diff hist +550 N File System Created page with "In the file system persistency layer, each subfolder of your data folder is a database. Each folder has the following files: * schema.json - list of all tables, columns, keys and shards; is updated every time a shard is added or removed or the schema changes * schema.json.old - fallback file for crash recovery * [uuid]-[columnname] - the content of a column (in case the ENGINE is not MEMORY) * [uuid].log - transaction log in c..." Tag: Visual edit
- 20:5520:55, 31 August 2025 diff hist +737 Cluster Monitor No edit summary Tag: Visual edit
- 20:5120:51, 31 August 2025 diff hist +108 Cluster Monitor No edit summary Tag: Visual edit
- 20:5020:50, 31 August 2025 diff hist +495 N Cluster Monitor Created page with "The cluster monitor lets you scale out MemCP over multiple nodes. Here is what you can achieve: * '''Multiple users''': each user has his own database * '''One big user''': Big tables are spread over multiple nodes * A mixture of both variants Each database and each shard (the piece where a part of a table's data is stored) can be placed either: * '''COLD''': only in storage backend * '''SHARED''': read-only on multiple nodes (e.g. the access table) * '''WRITE''': exc..." Tag: Visual edit
- 20:3720:37, 31 August 2025 diff hist +22 Main Page →Persistency Backends (= Storage) Tag: Visual edit
- 20:3720:37, 31 August 2025 diff hist +97 Main Page No edit summary Tag: Visual edit
25 August 2025
- 20:1020:10, 25 August 2025 diff hist +7,819 N Storage Created page with "= Storage = The '''Storage''' module provides functions to manage databases, tables, columns, keys, partitions, and large data operations in SCM. ← Back to Full SCM API documentation == scan == Performs an unordered parallel filter-map-reduce on a table '''Allowed number of parameters:''' 6–10 '''Parameters:''' * '''schema''' (<code>string|nil</code>): database name * '''table''' (<code>string|list</code>): table name(s) * '''filterColumns''' (<code>list</c..." current
- 20:0920:09, 25 August 2025 diff hist +3,539 N IO Created page with "= IO = The '''IO''' module provides functions for input and output operations, environment handling, file streaming, server control, and argument parsing in SCM. ← Back to Full SCM API documentation == print == Prints values to stdout (only in IO environment) '''Allowed number of parameters:''' 1–1000 '''Parameters:''' * '''value...''' (<code>any</code>): values to print '''Returns:''' <code>bool</code> == env == returns the content of a environment vari..." current Tag: Visual edit: Switched
- 18:4418:44, 25 August 2025 diff hist +228 Main Page No edit summary Tag: Visual edit
- 18:0618:06, 25 August 2025 diff hist +214 N Full SCM API documentation Created page with "= Documentation = * SCM Builtins * Arithmetic / Logic * Strings * Streams * Lists * Associative Lists / Dictionaries * Date * Vectors * Parsers * Sync * IO * Storage" current
- 18:0318:03, 25 August 2025 diff hist +65 Main Page →How things work in MemCP Tag: Visual edit
- 18:0218:02, 25 August 2025 diff hist −7,609 Introduction to Scheme →Deeper Topics into Scheme current Tag: Visual edit
22 August 2025
- 21:0621:06, 22 August 2025 diff hist +1,520 N Dictionary Compression Created page with "Strings are the nightmare of every database. You never know their exact size and you have to either reference them in a separate storage or reserve enough character space to store them in-table. Columnar databases can do better. But that's not guaranteed, you have to put a bit of extra effort into it. Here's how: At first, memcp converts strings into dictionaries. If you have a large list consisting of [Male, Male, Male, Female, Male, Female, Male, Male], you only have..." current Tag: Visual edit
15 June 2025
- 14:5914:59, 15 June 2025 diff hist +204 N Add custom SQL operators to MemCP Created page with "Some special applications need user defined custom functions. You can define them in scheme like: (sql_builtins "ADD_1" (lambda (x) (+ x 1))) Now you can call the function by: SELECT ADD_1(4) AS result" current Tag: Visual edit
- 14:5714:57, 15 June 2025 diff hist +39 Main Page →SQL Frontend Tag: Visual edit