testsuite.perf

Class RetrievalPerfTest

java.lang.Object

testsuite.BaseTestCase

testsuite.perf.RetrievalPerfTest

public class RetrievalPerfTest
extends BaseTestCase

Simplistic test for performance regression.

Nested Class Summary

Nested classes/interfaces inherited from class testsuite.BaseTestCase

BaseTestCase.MockConnectionConfiguration

Field Summary

Fields

Modifier and Type	Field and Description
private static int	NUM_ROWS
private static int	NUM_TESTS

Fields inherited from class testsuite.BaseTestCase

conn, dbClass, dbName, dbUrl, isOpenSSL, mainConnectionUrl, pstmt, rs, serverVersion, stmt, timeZoneFreeDbUrl

Constructor Summary

Constructors

Constructor and Description
RetrievalPerfTest()

Method Summary

Modifier and Type	Method and Description
void	setUp()
void	testRetrievalCached() Tests retrieval from the query cache
void	testRetrievalHeap() Tests retrieval from HEAP tables
void	testRetrievalMyIsam() Tests retrieval speed from MyISAM type tables

Methods inherited from class testsuite.BaseTestCase

appendRequiredProperties, assertByteArrayEquals, assertConnectionsHistory, assertEqualsFSAware, assertNonSecureConnection, assertResultSetLength, assertResultSetsEqual, assertSecureConnection, assertSecureConnection, assertSessionStatusEquals, assertThrows, assertThrows, assertThrows, assertThrows, cleanupTempFiles, createDatabase, createDatabase, createFunction, createFunction, createProcedure, createProcedure, createSchemaObject, createSchemaObject, createTable, createTable, createTable, createTable, createUser, createUser, createView, createView, currentTimeMillis, dropDatabase, dropDatabase, dropFunction, dropFunction, dropProcedure, dropProcedure, dropSchemaObject, dropSchemaObject, dropTable, dropTable, dropUser, dropUser, dropView, dropView, fillPrimitiveDefaults, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getConnectionWithProps, getEncodedHostFromTestsuiteUrl, getEncodedHostPortPairFromTestsuiteUrl, getFailoverConnection, getFailoverConnection, getHostFreePropertiesFromTestsuiteUrl, getHostFreePropertiesFromTestsuiteUrl, getHostFromTestsuiteUrl, getInstanceNumber, getLoadBalancedConnection, getLoadBalancedConnection, getLoadBalancedConnection, getMysqlVariable, getMysqlVariable, getNewConnection, getNoDbUrl, getPort, getPortFreeHostname, getPortFromTestsuiteUrl, getPropertiesFromTestsuiteUrl, getPropertiesFromUrl, getRowCount, getSingleIndexedValueWithQuery, getSingleIndexedValueWithQuery, getSingleValue, getSingleValueWithQuery, getSourceReplicaReplicationConnection, getSourceReplicaReplicationConnection, getSourceReplicaUrl, getSourceReplicaUrl, getUnreliableFailoverConnection, getUnreliableFailoverConnection, getUnreliableLoadBalancedConnection, getUnreliableLoadBalancedConnection, getUnreliableMultiHostConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, getUnreliableReplicationConnection, isClassAvailable, isCommunityEdition, isEnterpriseEdition, isMysqlRunningLocally, isRunningOnJRockit, isServerRunningOnWindows, isSysPropDefined, logDebug, newTempBinaryFile, randomString, removeHostRelatedProps, removeSqlMode, runLongTests, setUpBase, supportsLoadLocalInfile, supportsTestCachingSha2PasswordKeys, supportsTestCertificates, supportsTestSha256PasswordKeys, supportsTimeZoneNames, supportsTLSv1_2, tearDownBase, versionMeetsMinimum, versionMeetsMinimum

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

NUM_TESTS

private static final int NUM_TESTS

See Also:

Constant Field Values

NUM_ROWS

private static final int NUM_ROWS

See Also:

Constant Field Values

Constructor Detail

RetrievalPerfTest

public RetrievalPerfTest()

Method Detail

setUp

@BeforeEach
public void setUp()
                       throws java.lang.Exception

Throws:

java.lang.Exception

testRetrievalCached

@Test
public void testRetrievalCached()
                               throws java.lang.Exception

Tests retrieval from the query cache

Throws:

java.lang.Exception

testRetrievalHeap

@Test
public void testRetrievalHeap()
                             throws java.lang.Exception

Tests retrieval from HEAP tables

Throws:

java.lang.Exception

testRetrievalMyIsam

@Test
public void testRetrievalMyIsam()
                               throws java.lang.Exception

Tests retrieval speed from MyISAM type tables

Throws:

java.lang.Exception