Hardware Requirements - Revision history

Carli: /* Micro-Benchmark */

2024-05-18T20:41:25Z

Micro-Benchmark

@@ Line 81: / Line 81: @@
 === Micro-Benchmark ===
 Here's a micro benchmark for putting HTTP load on memcp on Raspberry Pi: behind a 100 MBit/s ethernet. The request is a rather simple one.
   $ ab -n 1000000 -c 1000 '<nowiki>http://192.168.178.73:4321/sql/test/select%20*%20from%20a'</nowiki>
   This is ApacheBench, Version 2.3 <$Revision: 1879490 $>
@@ Line 138: / Line 140: @@
 %   9758 (longest request)
 Raspberry Pi manages to do about 1,000 requests per second while modern x86_64 computers are able to serve 12,000 requests and more.

Carli: /* Running on Raspberry Pi */

2024-05-18T16:41:11Z

Running on Raspberry Pi

@@ Line 15: / Line 15: @@
 * AMD Ryzen (in various forms)
 * HPE Superfome Flex (https://www.hpe.com/us/en/servers/superdome.html)
 == Running on Raspberry Pi ==
@@ Line 21: / Line 79: @@
 * Avoid <code>ENGINE=safe</code>. To have a long life for your flash drive, you should choose <code>ENGINE=sloppy</code>. (<code>ENGINE=logging</code> would be a compromise between <code>safe</code> and <code>sloppy</code>) - for more information see [[Persistency and Performance Guarantees]]
 * Raspberry Pis have very limited RAM. In most cases, the RAM is sufficient though since most databases only take a few megabytes of RAM. For bigger data, you should wait for MMaped shards, see also: [[Current Status and open issues]]

Carli at 16:31, 18 May 2024

2024-05-18T16:31:49Z

← Older revision		Revision as of 18:31, 18 May 2024
Line 7:		Line 7:
	* To have a decent working set, take the RAM requirements x3, so a 5 GiB MySQL database should run on 3 GiB RAM		* To have a decent working set, take the RAM requirements x3, so a 5 GiB MySQL database should run on 3 GiB RAM
	* MemCP needs at least 1 CPU core, more is better ;)		* MemCP needs at least 1 CPU core, more is better ;)

			== Running on Big SMP Machines ==
			MemCP runs best on machiens that have a lot of RAM and CPU cores.

			We tested on:

			* AMD Ryzen (in various forms)
			* HPE Superfome Flex (https://www.hpe.com/us/en/servers/superdome.html)

			== Running on Raspberry Pi ==
			These are our recommendations to run MemCP on Raspberry Pi:

			* Avoid <code>ENGINE=safe</code>. To have a long life for your flash drive, you should choose <code>ENGINE=sloppy</code>. (<code>ENGINE=logging</code> would be a compromise between <code>safe</code> and <code>sloppy</code>) - for more information see [[Persistency and Performance Guarantees]]
			* Raspberry Pis have very limited RAM. In most cases, the RAM is sufficient though since most databases only take a few megabytes of RAM. For bigger data, you should wait for MMaped shards, see also: [[Current Status and open issues]]

Carli: Created page with "MemCP can run on any hardware that is supported by the `go` compiler. To find the right hardware dimensions, you need to consider the following: * The process itself needs at least 8 MiB of RAM * The size of a 5 GiB MySQL database fits into ~1 GiB of RAM * To have a decent working set, take the RAM requirements x3, so a 5 GiB MySQL database should run on 3 GiB RAM * MemCP needs at least 1 CPU core, more is better ;)"

2024-05-17T12:52:56Z

Created page with "MemCP can run on any hardware that is supported by the <code>go</code> compiler. To find the right hardware dimensions, you need to consider the following: * The process itself needs at least 8 MiB of RAM * The size of a 5 GiB MySQL database fits into ~1 GiB of RAM * To have a decent working set, take the RAM requirements x3, so a 5 GiB MySQL database should run on 3 GiB RAM * MemCP needs at least 1 CPU core, more is better ;)"

New page

MemCP can run on any hardware that is supported by the <code>go</code> compiler.

To find the right hardware dimensions, you need to consider the following:

* The process itself needs at least 8 MiB of RAM
* The size of a 5 GiB MySQL database fits into ~1 GiB of RAM
* To have a decent working set, take the RAM requirements x3, so a 5 GiB MySQL database should run on 3 GiB RAM
* MemCP needs at least 1 CPU core, more is better ;)