Page Comparison

MySQL Configuration

Check Existing Value

Verify MySQL Parameter : `group_concat_max_len`, value should be 50000000.

1. Login to MySQL Docker : docker exec -it qmetry85_mysql_1 bash
2. Login to MySQL : mysql -u[username] -p[password] -A
3. Check the parameter value using query : SELECT @@group_concat_max_len;
4. If this value is lower than 50000000, follow the remaining steps to update this value
5. Type "exit" to exit mysql and exit again, to exit the docker.

Update if the value is set less than 50000000

1. Type df -h
2. Go to the /var/lib two directories that end with path /merged.
   • For example : cd /var/lib/docker/overlay2/<...some random text....>/merged/home
   • One of these paths will contain `my.cnf`
   • Type ls to check the file.
3. Edit the my.cnf file using command : vim my.cnf type i to go into insert mode.
4. Check for parameter : group_concat_max_len, if it does not exist, add it, or else update its value to 50000000
   • group_concat_max_len=50000000
5. Type Esc and then :wq to save and exit.
6. Restart services using below commands
   • docker stop qmetry_app_1 qmetry_rds_1
   • docker start qmetry_rds_1
   • docker start qmetry_app_1

Verify the parameter value using steps above.

Table of Contents
maxLevel 2 absoluteUrl true

Tomcat Memory Configuration

...

• Save the file using Esc and then typing :wq to save and exit the file editior.
• exit (exit the docker container)
• docker stop <docker_name>
• docker start <docker_name>

MySQL Configuration

MySQL configuration below is the default and for verification only. It is auto-configured at the time of installation.

Check Existing Value

Verify MySQL Parameter : `group_concat_max_len`, value should be 50000000.

1. Login to MySQL Docker : docker exec -it qmetry85_mysql_1 bash
2. Login to MySQL : mysql -u[username] -p[password] -A
3. Check the parameter value using query : SELECT @@group_concat_max_len;
4. If this value is lower than 50000000, follow the remaining steps to update this value
5. Type "exit" to exit mysql and exit again, to exit the docker.

Update if the value is set less than 50000000

1. Type df -h
2. Go to the /var/lib two directories that end with path /merged.
   • For example : cd /var/lib/docker/overlay2/<...some random text....>/merged/home
   • One of these paths will contain `my.cnf`
   • Type ls to check the file.
3. Edit the my.cnf file using command : vim my.cnf type i to go into insert mode.
4. Check for parameter : group_concat_max_len, if it does not exist, add it, or else update its value to 50000000
   • group_concat_max_len=50000000
5. Type Esc and then :wq to save and exit.
6. Restart services using below commands
   • docker stop qmetry_app_1 qmetry_rds_1
   • docker start qmetry_rds_1
   • docker start qmetry_app_1

Verify the parameter value using steps above.