CREATE SCHEMA test;
USE test;
CREATE TABLE t1 (
id BIGINT UNSIGNED AUTO_INCREMENT,
message VARCHAR(20) NOT NULL,
PRIMARY KEY (id)
);
# INSERT INTO t1 (message) VALUES ('Hello, World!');
# SELECT message, COUNT(message) as 'count' FROM t1 GROUP BY message;Duplicate the following files and add the correct values:
naive-spring-boot/src/main/resources/application.tmpl.properties => naive-spring-boot/src/main/resources/application.properties
and
naive-node-express/mysqlConnectionSettings.tmpl.json => naive-node-express/mysqlConnectionSettings.json
| Endpoint | Load | Description |
|---|---|---|
| /noop | "CPU" Bound | Return a constant string. |
| /cpu | CPU Bound | Calculate Fibonacci sequence for random number [30, 37]. Not cached, not optimized. |
| /sleep | "I/O" Bound | Sleeps for 500ms then returns. |
| /write | I/O Bound | Writes a random record to a MySQL DB then returns the resulting JSON including the auto increment id. |
| /read | I/O Bound | Runs a GROUP BY aggregation over all records in the table. Not cached. No index. |
Uses out of the box spring-boot-starter-web (NOT Reactive) and spring-boot-starter-jdbc Spring Boot starters.
Note that this implementation does use PreparedStatements for the /write endpoints which does
provide some amount of optimized performance.
Uses out of the box express and mysql npm modules.
I used siege for performance testing.
./short-perf.sh
./perf.sh