class Innobase extends Innodb

The Innobase storage engine

Properties

string $engine from StorageEngine
string $title from StorageEngine
string $comment from StorageEngine
integer $support from StorageEngine

Methods

__construct(string $engine)

Constructor

static array[]
getStorageEngines()

Returns array of storage engines

static string
getHtmlSelect(string $name = 'engine', string $id = null, string $selected = null, boolean $offerUnavailableEngines = false, boolean $addEmpty = false)

Returns HTML code for storage engine select box

static StorageEngine
getEngine(string $engine)

Loads the corresponding engine plugin, if available.

static boolean
isValid(string $engine)

Returns true if given engine name is supported/valid, otherwise false

string
getHtmlVariables()

Returns as HTML table of the engine's server variables

array
resolveTypeSize(integer $value)

Returns the engine specific handling for PMA_ENGINE_DETAILS_TYPE_SIZE type variables.

array
getVariablesStatus()

Returns array with detailed info about engine specific server variables

string
getTitle()

Reveals the engine's title

string
getComment()

Fetches the server's comment about this engine

string
getSupportInformationMessage()

Information message on whether this storage engine is supported

array
getVariables()

Returns array with variable names related to InnoDB storage engine

from Innodb
string
getMysqlHelpPage()

returns string with filename for the MySQL helppage about this storage engine

from Innodb
string
getVariablesLikePattern()

Returns the pattern to be used in the query for SQL variables related to InnoDb storage engine

from Innodb
string[]
getInfoPages()

Get information pages

from Innodb
string
getPage(string $id)

Generates the requested information page

string
getPageBufferpool()

returns html tables with stats over inno db buffer pool

from Innodb
string
getPageStatus()

returns InnoDB status

from Innodb
string
getInnodbPluginVersion()

Gets the InnoDB plugin version number

from Innodb
string
getInnodbFileFormat()

Gets the InnoDB file format

from Innodb
boolean
supportsFilePerTable()

Verifies if this server supports the innodb_file_per_table feature

from Innodb

Details

in StorageEngine at line 71
__construct(string $engine)

Constructor

Parameters

string $engine The engine ID

in StorageEngine at line 105
static array[] getStorageEngines()

Returns array of storage engines

Return Value

array[] array of storage engines

in StorageEngine at line 145
static string getHtmlSelect(string $name = 'engine', string $id = null, string $selected = null, boolean $offerUnavailableEngines = false, boolean $addEmpty = false)

Returns HTML code for storage engine select box

Parameters

string $name The name of the select form element
string $id The ID of the form field
string $selected The selected engine
boolean $offerUnavailableEngines Should unavailable storage engines be offered?
boolean $addEmpty Whether to provide empty option

Return Value

string html selectbox

in StorageEngine at line 192
static StorageEngine getEngine(string $engine)

Loads the corresponding engine plugin, if available.

Parameters

string $engine The engine ID

Return Value

StorageEngine The engine plugin

in StorageEngine at line 232
static boolean isValid(string $engine)

Returns true if given engine name is supported/valid, otherwise false

Parameters

string $engine name of engine

Return Value

boolean whether $engine is valid or not

in StorageEngine at line 247
string getHtmlVariables()

Returns as HTML table of the engine's server variables

Return Value

string The table that was generated based on the retrieved information

in StorageEngine at line 307
array resolveTypeSize(integer $value)

Returns the engine specific handling for PMA_ENGINE_DETAILS_TYPE_SIZE type variables.

This function should be overridden when PMA_ENGINE_DETAILS_TYPE_SIZE type needs to be handled differently for a particular engine.

Parameters

integer $value Value to format

Return Value

array the formatted value and its unit

in StorageEngine at line 317
array getVariablesStatus()

Returns array with detailed info about engine specific server variables

Return Value

array array with detailed info about specific engine server variables

in StorageEngine at line 362
string getTitle()

Reveals the engine's title

Return Value

string The title

in StorageEngine at line 372
string getComment()

Fetches the server's comment about this engine

Return Value

string The comment

in StorageEngine at line 382
string getSupportInformationMessage()

Information message on whether this storage engine is supported

Return Value

string The localized message.

in Innodb at line 26
array getVariables()

Returns array with variable names related to InnoDB storage engine

Return Value

array The list of variables.

in Innodb at line 346
string getMysqlHelpPage()

returns string with filename for the MySQL helppage about this storage engine

Return Value

string MySQL help page filename

in Innodb at line 124
string getVariablesLikePattern()

Returns the pattern to be used in the query for SQL variables related to InnoDb storage engine

Return Value

string SQL query LIKE pattern

in Innodb at line 134
string[] getInfoPages()

Get information pages

Return Value

string[] The list

in StorageEngine at line 454
string getPage(string $id)

Generates the requested information page

Parameters

string $id page id

Return Value

string html output

in Innodb at line 151
string getPageBufferpool()

returns html tables with stats over inno db buffer pool

Return Value

string html table with stats

in Innodb at line 330
string getPageStatus()

returns InnoDB status

Return Value

string result of SHOW ENGINE INNODB STATUS inside pre tags

in Innodb at line 356
string getInnodbPluginVersion()

Gets the InnoDB plugin version number

Return Value

string the version number, or empty if not running as a plugin

in Innodb at line 368
string getInnodbFileFormat()

Gets the InnoDB file format

(do not confuse this with phpMyAdmin's storage engine plugins!)

Return Value

string the InnoDB file format

in Innodb at line 384
boolean supportsFilePerTable()

Verifies if this server supports the innodb_file_per_table feature

(do not confuse this with phpMyAdmin's storage engine plugins!)

Return Value

boolean whether this feature is supported or not