Main Page - Revision history

Carli: /* Optimizations */

2026-09-07T20:48:47Z

Optimizations

← Older revision		Revision as of 22:48, 7 September 2026
Line 290:		Line 290:
	==== Optimizations ====		==== Optimizations ====

	* [[Benchmarks]]		* [[Benchmark MemCP vs. MariaDB on Wordpress\|Benchmarks]]
	* [[Query Planner and Physical Lowering]]		* [[Query Planner and Physical Lowering]]
	* [[In-Memory Compression, Columnar Compression Techniques]]		* [[In-Memory Compression, Columnar Compression Techniques]]

Carli: /* Optimizations */

2026-09-07T20:48:15Z

Optimizations

← Older revision		Revision as of 22:48, 7 September 2026
Line 290:		Line 290:
	==== Optimizations ====		==== Optimizations ====

			* [[Benchmarks]]
	* [[Query Planner and Physical Lowering]]		* [[Query Planner and Physical Lowering]]
	* [[In-Memory Compression, Columnar Compression Techniques]]		* [[In-Memory Compression, Columnar Compression Techniques]]

Wikiservice: Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

2026-08-28T10:14:06Z

Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

← Older revision		Revision as of 12:14, 28 August 2026
Line 23:		Line 23:

	<div style="padding:1rem 1.15rem; margin:1rem 0 2rem; border:1px solid #b7c99a; border-radius:9px; background:#f5f8f0; color:#17202a;">		<div style="padding:1rem 1.15rem; margin:1rem 0 2rem; border:1px solid #b7c99a; border-radius:9px; background:#f5f8f0; color:#17202a;">
	'''Observed performance profile:''' MemCP has achieved '''~~up to~~ 10× ~~the performance of~~ MariaDB/PostgreSQL''' in OLAP and search-oriented workflows, where RecSets and compressed column scans avoid wide row materialization. Isolated OLTP paths currently take about '''1.3–2.0× as long''', but in complete WordPress- and wiki-style page builds this has made '''no significant difference to overall page-loading time''' in the measured application workflows~~. Filtered-list queries over roughly one million documents, by contrast, have taken around '''30 seconds on PostgreSQL'''~~. These are workload observations, not universal guarantees; [[Performance Measurement\|reproduce them on your data]].		'''Observed performance profile:''' MemCP has achieved '''speedups of 10× and more over MariaDB/PostgreSQL''' in measured OLAP and search-oriented workflows, where RecSets and compressed column scans avoid wide row materialization. In one filtered-list workflow over roughly one million documents, the same query took around '''30 seconds on PostgreSQL''' and '''1.6 seconds on MemCP'''. Isolated OLTP paths currently take about '''1.3–2.0× as long''', but in complete WordPress- and wiki-style page builds this has made '''no significant difference to overall page-loading time''' in the measured application workflows. These are workload observations, not universal guarantees; [[Performance Measurement\|reproduce them on your data]].
	</div>		</div>

Line 86:		Line 86:
	=== Run with Docker ===		=== Run with Docker ===

	<~~syntaxhighlight lang="bash"~~>		<pre>
	docker run --name memcp \		docker run --name memcp \
	-e ROOT_PASSWORD='choose-a-password' \		-e ROOT_PASSWORD='choose-a-password' \
Line 92:		Line 92:
	-v memcp-data:/data \		-v memcp-data:/data \
	carli2/memcp:latest		carli2/memcp:latest
	</~~syntaxhighlight~~>		</pre>

	Then open <code>http://localhost:4321</code> and connect a MySQL application to <code>127.0.0.1</code> on port '''3307'''. The volume mounted at <code>/data</code> retains persistent table data across container replacement. See [[Install MemCP with Docker\|the complete Docker guide]] before deploying it as a service.		Then open <code>http://localhost:4321</code> and connect a MySQL application to <code>127.0.0.1</code> on port '''3307'''. The volume mounted at <code>/data</code> retains persistent table data across container replacement. See [[Install MemCP with Docker\|the complete Docker guide]] before deploying it as a service.
Line 98:		Line 98:
	=== Build from source ===		=== Build from source ===

	<~~syntaxhighlight lang="bash"~~>		<pre>
	git clone https://github.com/launix-de/memcp		git clone https://github.com/launix-de/memcp
	cd memcp		cd memcp
Line 104:		Line 104:
	make		make
	./memcp --api-port=4321 --mysql-port=3307 lib/main.scm		./memcp --api-port=4321 --mysql-port=3307 lib/main.scm
	</~~syntaxhighlight~~>		</pre>

	Connect with MySQL tooling:		Connect with MySQL tooling:

	<~~syntaxhighlight lang="bash"~~>		<pre>
	mysql -h 127.0.0.1 -u root -p -P 3307		mysql -h 127.0.0.1 -u root -p -P 3307
	# Enter the password selected for this data directory.		# Enter the password selected for this data directory.
	</~~syntaxhighlight~~>		</pre>

	The development default for a fresh data directory is <code>admin</code>. Change it before exposing MemCP to another machine. MemCP can also be supervised with PM2:		The development default for a fresh data directory is <code>admin</code>. Change it before exposing MemCP to another machine. MemCP can also be supervised with PM2:

	<~~syntaxhighlight lang="bash"~~>		<pre>
	pm2 start ./memcp --name memcp -- \		pm2 start ./memcp --name memcp -- \
	--no-repl -data ./data --api-port=4321 --mysql-port=3307 lib/main.scm		--no-repl -data ./data --api-port=4321 --mysql-port=3307 lib/main.scm
	</~~syntaxhighlight~~>		</pre>

	Background deployments must use <code>--no-repl</code> so that closing standard input does not terminate the interactive console and stop the server. See [[Compile MemCP from Source\|Build from Source]], [[Deployment]] and [[MemCP Console]].		Background deployments must use <code>--no-repl</code> so that closing standard input does not terminate the interactive console and stop the server. See [[Compile MemCP from Source\|Build from Source]], [[Deployment]] and [[MemCP Console]].

Wikiservice: Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

2026-08-28T09:59:42Z

Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference

Show changes

Carli at 06:47, 27 August 2026

2026-08-27T06:47:12Z

← Older revision		Revision as of 08:47, 27 August 2026
Line 234:		Line 234:
	* [[Lists]]		* [[Lists]]
	* [[Associative Lists / Dictionaries]]		* [[Associative Lists / Dictionaries]]
			* [[Window Functions]]
	* [[Date]]		* [[Date]]
			* [[Timezone]]
	* [[Vectors]]		* [[Vectors]]
	* [[Parsers]]		* [[Parsers]]
Line 240:		Line 242:
	* [[IO]]		* [[IO]]
	* [[Storage]]		* [[Storage]]
			* [[Transactions]]
	* [[JIT in Scheme\|JIT]]		* [[JIT in Scheme\|JIT]]

Carli: /* Scheme documentation */

2026-08-27T06:14:58Z

Scheme documentation

← Older revision		Revision as of 08:14, 27 August 2026
Line 240:		Line 240:
	* [[IO]]		* [[IO]]
	* [[Storage]]		* [[Storage]]
			* [[JIT in Scheme\|JIT]]

	==== Optimizations ====		==== Optimizations ====

Carli at 14:23, 21 August 2026

2026-08-21T14:23:48Z

Show changes

Carli at 11:27, 21 August 2026

2026-08-21T11:27:06Z

← Older revision		Revision as of 13:27, 21 August 2026
Line 6:		Line 6:

	----		----

			== Quickstart ==
			docker run --name memcp \
			-e ROOT_PASSWORD='choose-a-password' \
			-p 4321:4321 -p 3307:3307 \
			carli2/memcp:latest
			Then open http://localhost:4321 and connect your MySQL application via 127.0.0.1 port '''3307'''.

	== Key Features ==		== Key Features ==

Carli: /* Navigation */

2026-08-21T11:18:36Z

Navigation

← Older revision		Revision as of 13:18, 21 August 2026
Line 177:		Line 177:
	*[[Shards, RecordIDs, Main Storage, Delta Storage]]		*[[Shards, RecordIDs, Main Storage, Delta Storage]]
	*[[Columnar Storage]]		*[[Columnar Storage]]
	*[[Transactions]]		*[[Transactions and Isolation]]
	*[[Full SCM API documentation]]		*[[Full SCM API documentation]]
			*[[Query Planner and Physical Lowering]]

	===== SCM Documentation =====		===== SCM Documentation =====

Carli at 02:21, 27 February 2026

2026-02-27T02:21:08Z

← Older revision		Revision as of 04:21, 27 February 2026
Line 3:		Line 3:
	'''MemCP is a high-performance, in-memory, column-oriented database designed for modern workloads.'''		'''MemCP is a high-performance, in-memory, column-oriented database designed for modern workloads.'''
	It provides a lightweight, developer-friendly alternative to traditional relational databases such as MySQL, with a focus on speed, compression, and direct API integration.		It provides a lightweight, developer-friendly alternative to traditional relational databases such as MySQL, with a focus on speed, compression, and direct API integration.
			[[File:Memcp-Load.png\|center\|frameless\|1600x1600px]]

	----		----