Skip to main content

Viewing MySQL Data Storage Specifications

Garrick Guillory
Updated

MySQL system variables control how the database server handles connections, communication, and data transfers.

Use this article to view the current max_allowed_packet and net_buffer_length values using MySQL Workbench.

Before You Begin

Before reviewing the MySQL settings:

  • Confirm that MySQL Workbench is installed.
  • Confirm that you can connect to the MySQL server used by WebReports.
  • Have the appropriate MySQL administrator credentials available.

This article explains how to view the current MySQL values. If you need to change max_allowed_packet, see Configure MySQL Data Storage Settings for WebReports.

Open MySQL Workbench

  1. Open MySQL Workbench.
  2. Select the MySQL connection used by WebReports.

mceclip2.png

MySQL Workbench connection screen

Connect to the MySQL Server

  1. Select the configured MySQL server.
  2. Enter the MySQL administrator password when prompted.
  3. Connect to the server.

mceclip3.png

Connecting to the MySQL server

Open Status and System Variables

After connecting to MySQL:

  1. Locate the Management section in the left navigation panel.
  2. Select Status and System Variables.

mceclip4.png

Status and System Variables in MySQL Workbench

Open the System Variables Tab

Select the System Variables tab.

The page displays the system variables currently configured for the MySQL server.

mceclip5.png

System Variables tab in MySQL Workbench

View max_allowed_packet

  1. In the Filter field, enter max_allowed_packet. 
  2. Locate max_allowed_packet in the results. 
  3. Review the value shown in the Value column.

max_allowed_packet defines the maximum size of a communication packet that can be transferred between the MySQL server and a client.

This setting may be relevant when troubleshooting large WebReports reports, exports, or queued jobs.

MySQL displays this value in bytes.

View net_buffer_length

  1. In the Filter field, enter net_buffer_length.
  2. Locate net_buffer_length in the results.
  3. Review the value shown in the Value column.

net_buffer_length defines the initial size of the connection buffer used by MySQL.

MySQL can automatically increase this buffer as needed, up to the max_allowed_packet limit.

mceclip1.png

Current net_buffer_length value in MySQL Workbench

WebReports does not normally require net_buffer_length to be increased. Only change this setting if directed by BridgeWorks Support or your database administrator.

Change MySQL Data Storage Settings

If you determine that max_allowed_packet needs to be increased, do not change it from this procedure.

See:

Configure MySQL Data Storage Settings for WebReports

That article explains how to:

  • Check the current value from the MySQL Command Line Client.
  • Increase max_allowed_packet.
  • Verify the updated value.
  • Make the setting persistent after a MySQL service restart.
  • Verify WebReports after the change.

Troubleshooting

If you cannot locate the MySQL variables:

  • Confirm that you selected the System Variables tab.
  • Clear any existing search or filter text.
  • Search for the exact variable name.
  • Confirm that you are connected to the correct MySQL server.

If WebReports continues to experience large-report or packet-size errors, review the MySQL configuration and WebReports logs.

Contact BridgeWorks Support if the issue continues.

Related Articles

Related articles

Comments

0 comments

Please sign in to leave a comment.