...
- MySQL 5.6 (may not work with 5.7 - project needs updated JDBC driver)
- Optimize settings in my.ini or my.cnf (%PROGRAMDATA%/MySQL/MySQL Server 5.6 on Windows)
- innodb_flush_log_at_trx_commit=0
- ** For dev database, this can be set to 0, set to 1 for prod deployment
- innodb_log_buffer_size=64M
- innodb_buffer_pool_size=2048M
- innodb_log_file_size=500M
- innodb_file_per_table=1
- join_buffer_size=32M
- max_allowed_packet=100M
- Nginx - not needed for a local development environment
- Tomcat 8+ or Jetty 9+
...