MySQL Administrator Health

The Health section of MySQL Administrator displays the real-time status of the MySQL server in graphically monitor mode. Some status diagrams are shown here. Of course, you can easily create your own status diagrams and combine them into custom pages or groups.

The default graphical information displays the current performance, load, and memory usage information of the MySQL server. All server variables are displayed on other pages, which can be divided into status variables and system variables ). Note: Click status pages to open an additional connection to the MySQL Server) when viewing the thread and user, you will see.

We will begin with overwriting various pre-made status graphs and describe how to create your own status chart. Finally, we will focus on describing various States (various status) and system variables (system variables) under the Health option ).
10.2. Connection Health (Connection Health)

This tab page provides the connection information of the MySQL server. The following three pre-made graphs charts are displayed:

*

Connection Usage: displays the percentage of the current number of customer connections to the maximum number of connections. (Threads connected/max_connections ). If this value is close to 100%, it means you need to increase the maximum number of connections (max_connections) on the server. The setting of this number of connections is in the Startup Variables (Startup variable) section. The maximum number of connections is displayed as soon as MySQL Administrator is started. For more information about server connections, see show variables and Too many connections in reference manual) error.
*

Traffic (Traffic): This variable reflects the status of bytes_sent (status variable ). It does not represent the total number of bytes since the server was started, but the number of bytes currently sent. (Here the bytes_sent variable is a cumulative value ). The initial maximum value of this image is 102400, and the value will automatically increase as needed.
*

Number of SQL Queries (Number of SQL Queries): This is the representation OS of THE com_select state variable ). This indicates the number of queries currently, rather than the number of all queries started from the server. (The com_select variable is a cumulative value ). The initial maximum value of this graph is 10, but the maximum value increases with the increase in usage.

10.3. Memory Health (Memory Health)

This tab page provides information about memory caches, which determines the performance of the MySQL server. For each cache, the current connection rate or usage of the cache is displayed, which is in the last few minutes.

*

Query Cache Hitrate: in use, the query cache of the MySQL server stores the SELECT Query text and the results sent from the server to the client. If two identical statements are executed successively, the server will find the query result from the query cache instead of breaking down and executing the SQL statement. This ratio reflects the ratio of the buffered query to the unbuffered query. The higher the ratio, the better the server's SELECT query performance. For more information, see MySQL Query Cache.
*

Key Efficiency (key buffer Efficiency): This horizontal graph bar shows the number of Key buffer allocated ). If the key buffer is a considerable percentage, you can add value to the key_cache_size setting in the Startup Variables (Startup variable) section. This chart indicates the number of key_read_requests, so the actual key_reads is generated. The higher the ratio, the more effective your primary key buffer is. If this ratio is low, you need to increase the keycache size.

10.4. Creating Custom Health Graphs (create a Custom Health Chart)

Although the default chart provides some information about the MySQL server status, you may want to see other information tracks in the chart. The MySQL Administrator Health section allows you to add other tabs and charts that you want to track and view. They are included in Status Variables (Status Variables.

The first step to Creating a Custom Health Chart (Creating Custom Health Graphs) is to create a new page in the Health section to store your images. To create a new Page, right-click the workspace and select Add a Page. It prompts you the page name and description, and then creates a new page.

If you have created a new page, you need to create a group. All charts are in groups. For example, the Key buffer usage and Key buffer hitrate charts are both in the Key Efficiency group. To create a Group, right-click the page you created and select Add a Group.

To create a custom chart, right-click a group and select Add a graph. The following dialog box is displayed:

Figure 10.1. The Graph Settings dialog (Chart Setting dialog Box)
The Graph Settings dialog

Line-Graph is suitable for displaying trend over time, while Bar-Graph is more suitable for displaying percentage information. If you choose to create a bar-graph, you need to select a title for your graph. However, for line charts (line-graphs), titles are not allowed.

Use Value Formula to set the data on the chart. You can use any variable on the Status Variables and System Variables tabs pages to create a rule. To use the value of a variable, place the variable in square brackets. (For example, [com_select]). If you want to use the relative value of the variable (relative value), you can add a ^ character before square brackets.

For example, if we want to use charts to display temporary tables on the hard disk, we can use the following rules:

[Created_tmp_disk_tables]/[created_tmp_tables]

If we want to track some continuous elements in the temporary table, we can use the following rules:

^ [Created_tmp_tables]

After creating a rule, select the Value Unit that best represents your data. You can select Percentage, Count, Byte, or Seconds. In our instance, we will use Percentage as the first example and Count as the second example. You can assign a title to this value.

Once you specify a rule, you should configure Max. Value and Min. Value for the chart so that your data can be scaled evenly on the chart. You can set any Value based on the estimation of the data, or view the Autoextend Max. Value option to allow MySQL Administrator to automatically add the Max Value setting to prevent your data from being extended to the image.

You can set the Max. Value option through the rules assigned in the Max Formular area. These rules will be used in the Value Formula region. For example, if you have created bar graph for some temporary tables, you can use [created_tmp_disk_tables] As Value Formula and [created_tmp_tables] as Max. Formular.

10.5. Status Variables (Status variable)

This tab page provides information about the status variables of the MySQL server. In the left box of the working area, you find on the left side of the workspace, you can find these categories and subcategories ). Double-click these categories to expand or collapse the subclass.

For each category and subcategory, state variables and their values are listed in the box on the right of the workspace and a brief explanation of the item. This STATUS variable has a trusted description in the show status section of the reference manual.

The Refresh button allows MySQL Administrator to retrieve the variables and their values again.

Right-click the box on the right to copy your variables to the clipboard.

10.6. System Variables (System Variables)

This tab page provides information about the system variables of the MySQL server. In the left box of the workspace, you can find these categories and their subcategories ). Double-click the type name to expand or collapse its subclass.

The boxes on the right of the workspace are listed for each type and subclass, system variables, their values, and brief explanations. For detailed descriptions of system VARIABLES, see the show variables section in the reference manual.

System variables that can be set at runtime are marked as editable, and there is a chart in front of it, which is used to distinguish variables that cannot be set at runtime. Double-click an editable variable to open a dialog box. You can specify another value for this variable. Click OK to save the changes. Click the Abort button to ignore the changes. Changes made in this manner will only persist until the server is restarted, after which the server will revert to it's startup settings. in MySQL Administrator, system variables are set to global. Note: To change global variables, you need the corresponding permissions. For more information about global variables, see SET Syntax.

Use the Refresh button to ask MySQL Administrator to obtain the variable and its value again.

Right-click the box on the right to allow you to copy the variable to the clipboard.

 

This article is from babaobao"