Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).

Article Goal: Adjust the size of the MySQL data storage.

In this article we are going to adjust the size of the MySQL data storage for queuing / downloading reports in WebReports.

Where Do You Adjust the MySQL Data Storage?

Launch the MySQL Command line and login using the root password that was created during the MySQL setup process.

Steps to Adjust the MySQL Data Storage.

1. Launch the MySQL Command Line Client.

2. Enter the rootpassword that was created in the Install MySQL article (step 9), then press enter.

Note: To paste copied passwords into the client, click in the title bar of the client and then right click on the password.

3. Once successfully logged in, copy the commands below and paste them into the client, then press Enter.

Note: If the data storage needs to be larger, add some zeros.

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

OPTIONAL: If you are experiencing slower than expected rendering times for finished reports and visualize, you may need to up the default InnoDB Buffer Pool Size. Please see the documentation below for more information on changing the setting.

- How MySQL Uses Memory

- Configuring InnoDB Buffer Pool Size

Note: The recommended setting is at 50% of the physical memory. Be aware that if the allocation exceeds what the OS can spare, MySQL will fail to start. A trial-and-error approach may be necessary to determine the optimal allocation.