diff options
| author | schneefux <schneefux+commit@schneefux.xyz> | 2017-06-05 14:45:33 +0200 |
|---|---|---|
| committer | schneefux <schneefux+commit@schneefux.xyz> | 2017-06-05 14:45:33 +0200 |
| commit | ccceab5c2b5f4b6f635b6e679570f44d54399fbb (patch) | |
| tree | 49b7fd54306e47764bb994f87d70c7210296fa0b | |
| parent | ef0fe75535fd15cbb4a1d33b88d8f3c7d575680e (diff) | |
| download | vaindock-ccceab5c2b5f4b6f635b6e679570f44d54399fbb.tar.gz vaindock-ccceab5c2b5f4b6f635b6e679570f44d54399fbb.zip | |
increase mariadb performance
| -rw-r--r-- | docker-compose.yml | 7 | ||||
| -rw-r--r-- | mariadb/performance_tuning.cnf | 3 |
2 files changed, 9 insertions, 1 deletions
diff --git a/docker-compose.yml b/docker-compose.yml index 70d2beb..c320e43 100644 --- a/docker-compose.yml +++ b/docker-compose.yml @@ -44,6 +44,7 @@ services: image: tianon/true depends_on: - vaindock_nginx + - vaindock_queue - php-fpm - vaindock_db-web - vaindock_phpmyadmin @@ -257,6 +258,8 @@ services: - RABBITMQ_URI=amqp://processor:processor@vaindock_queue/ - DATABASE_URI=mysql://vainweb:vainweb@vaindock_db-web/vainweb - QUEUE=process + - ANALYZE_QUEUE=analyze + - DOANALYZEMATCH=true vaindock_processor_brawl: build: ../processor @@ -330,6 +333,8 @@ services: - vaindock_db-web-data:/var/lib/mysql ports: - "3306:3306" + volumes: + - ./mariadb:/etc/mysql/conf.d environment: MYSQL_DATABASE: vainweb MYSQL_USER: vainweb @@ -361,7 +366,7 @@ services: MYSQL_ALLOW_EMPTY_PASSWORD: 1 vaindock_phpmyadmin: - image: phpmyadmin/phpmyadmin:4.6 + image: phpmyadmin/phpmyadmin:edge-4.7 environment: - PMA_ARBITRARY=1 ports: diff --git a/mariadb/performance_tuning.cnf b/mariadb/performance_tuning.cnf new file mode 100644 index 0000000..a3d739c --- /dev/null +++ b/mariadb/performance_tuning.cnf @@ -0,0 +1,3 @@ +[mysqld] +innodb_buffer_pool_size = 12G +innodb_flush_log_at_trx_commit=2 |