[QueryExplain] element index

Package indexes

• MySQLTableReport
• default
• QueryTableParser
• Loader
• Anemometer
• AnemometerModel

__construct

QueryExplain::__construct() in QueryExplain.php

Constructor. See class documentation for explaination of the parameters

explain

QueryExplain::explain() in QueryExplain.php

If the given query is a SELECT statement, return the explain plan

get_create

QueryExplain::get_create() in QueryExplain.php

Extract the table names from a query, and return the result of SHOW CREATE TABLE tablename;

get_tables_from_query

QueryExplain::get_tables_from_query() in QueryExplain.php

Try to parse the real table names out of a sql query

get_table_status

QueryExplain::get_table_status() in QueryExplain.php

Extract the table names and the return the result of SHOW TABLE STATUS LIKE 'tablename' for each table;

QueryExplain

QueryExplain in QueryExplain.php

class QueryExplain rough utility class to get query explain plan and extract table names from abitrary sql so we can run show create table on them.

QueryExplain.php

QueryExplain.php in QueryExplain.php

result_as_table

QueryExplain::result_as_table() in QueryExplain.php

given a mysqli result handle, format a string to look like the mysql cli