MySQL Test Parameters

Measures commit requests, connected threads, insert requests, key buffer efficiency, open files, open tables, select requests, slow queries, table lock efficiency, total requests, traffic in, traffic out, update requests, write buffer efficiency.

Credential/Configuration Settings

Create a shared or device-specific credential/configuration for MySQL Performance testing by entering the following values:

TCP Port - Enter the port against which to execute the test. The default MySQL port is 3306.
Login Username - Enter your MySQL username.
Login Password - Enter your MySQL password.
Database Name - Enter the name of the MySQL database against which you want to execute the tests.

Test Parameters

Word 80% / HTML 80%

Field	Description
Test Name	Enter or modify the name of the test.
Interval	Use the drop-down menu to specify the interval at which Traverse executes the test.
Thresholds (warn/critical)	Enter/modify the threshold levels that cause the test to change to (a state of) Warning or Critical, respectively.
Units	Varies depending on the test.
Action Profile	Use the drop-down menu to select an action profile for the test. See Administrator Configured Action Profiles and Thresholds for more information.
As test value rises, severity:	Use the drop-down menu to specify the relationship between test value and severity: Auto: If you select this option, Traverse sets this option based on the Warning and Critical thresholds for this test. If the Critical threshold is higher, as test value rises, severity ascends. If the Warning threshold is higher, as test value rises, severity descends. Ascends: As the value of the test result rises, severity rises. Descends: As the value of the test result rises, severity falls. Discrete: Specify a list of integers or ranges of numbers using the syntax: 1,3,5,10-25. Specify different values for warning and critical. Any returned value that does not match a value in either list means the device is OK. Bidirectional: You can set a "range" of numbers for each threshold and if the value crosses either of these two boundaries of the range, it will set the severity to Warning or Critical