Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: performance_schema
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Table AscendingDescending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation
accounts 1,000 PERFORMANCE_SCHEMA utf8_general_ci
cond_instances 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_stages_current 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_stages_history 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_stages_history_long 10,000 PERFORMANCE_SCHEMA utf8_general_ci
events_stages_summary_by_account_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_stages_summary_by_host_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_stages_summary_by_thread_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_stages_summary_by_user_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_stages_summary_global_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_statements_current 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_statements_history 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_statements_history_long 10,000 PERFORMANCE_SCHEMA utf8_general_ci
events_statements_summary_by_account_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_statements_summary_by_digest 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_statements_summary_by_host_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_statements_summary_by_thread_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_statements_summary_by_user_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_statements_summary_global_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_waits_current 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_waits_history 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_waits_history_long 10,000 PERFORMANCE_SCHEMA utf8_general_ci
events_waits_summary_by_account_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_waits_summary_by_host_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_waits_summary_by_instance 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_waits_summary_by_thread_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_waits_summary_by_user_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
events_waits_summary_global_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
file_instances 1,000 PERFORMANCE_SCHEMA utf8_general_ci
file_summary_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
file_summary_by_instance 1,000 PERFORMANCE_SCHEMA utf8_general_ci
hosts 1,000 PERFORMANCE_SCHEMA utf8_general_ci
host_cache 1,000 PERFORMANCE_SCHEMA utf8_general_ci
mutex_instances 1,000 PERFORMANCE_SCHEMA utf8_general_ci
objects_summary_global_by_type 1,000 PERFORMANCE_SCHEMA utf8_general_ci
performance_timers 5 PERFORMANCE_SCHEMA utf8_general_ci
rwlock_instances 1,000 PERFORMANCE_SCHEMA utf8_general_ci
session_account_connect_attrs 1,000 PERFORMANCE_SCHEMA utf8_bin
session_connect_attrs 1,000 PERFORMANCE_SCHEMA utf8_bin
setup_actors 0 PERFORMANCE_SCHEMA utf8_general_ci
setup_consumers 12 PERFORMANCE_SCHEMA utf8_general_ci
setup_instruments 1,000 PERFORMANCE_SCHEMA utf8_general_ci
setup_objects 0 PERFORMANCE_SCHEMA utf8_general_ci
setup_timers 4 PERFORMANCE_SCHEMA utf8_general_ci
socket_instances 1,000 PERFORMANCE_SCHEMA utf8_general_ci
socket_summary_by_event_name 1,000 PERFORMANCE_SCHEMA utf8_general_ci
socket_summary_by_instance 1,000 PERFORMANCE_SCHEMA utf8_general_ci
table_io_waits_summary_by_index_usage 1,000 PERFORMANCE_SCHEMA utf8_general_ci
table_io_waits_summary_by_table 1,000 PERFORMANCE_SCHEMA utf8_general_ci
table_lock_waits_summary_by_table 1,000 PERFORMANCE_SCHEMA utf8_general_ci
threads 1,000 PERFORMANCE_SCHEMA utf8_general_ci
users 1,000 PERFORMANCE_SCHEMA utf8_general_ci
52 tables Sum 74,021 InnoDB utf8_general_ci

Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): MySQL server has gone away

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'herp\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'herp\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'herp\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
NULL,
integer 0,
boolean false,
)
./libraries/DatabaseInterface.class.php#570: PMA_DatabaseInterface->fetchResult(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'herp\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
array,
NULL,
NULL,
)
./libraries/Util.class.php#4791: PMA_DatabaseInterface->getTablesFull(
string 'herp',
boolean false,
boolean false,
NULL,
integer 0,
boolean true,
string 'Name',
string 'ASC',
NULL,
)
./db_structure.php#26: PMA_Util::getDbInfo(
string 'herp',
string '',
)
Warning in ./libraries/dbi/DBIMysqli.class.php#261
mysqli_query(): Error reading result set's header

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'herp\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'herp\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'herp\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
NULL,
integer 0,
boolean false,
)
./libraries/DatabaseInterface.class.php#570: PMA_DatabaseInterface->fetchResult(
string ' SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` COLLATE utf8_bin IN (\'herp\') ORDER BY Name ASC LIMIT 250 OFFSET 0',
array,
NULL,
NULL,
)
./libraries/Util.class.php#4791: PMA_DatabaseInterface->getTablesFull(
string 'herp',
boolean false,
boolean false,
NULL,
integer 0,
boolean true,
string 'Name',
string 'ASC',
NULL,
)
./db_structure.php#26: PMA_Util::getDbInfo(
string 'herp',
string '',
)
Warning in ./libraries/dbi/DBIMysqli.class.php#261
Error while sending QUERY packet. PID=1857396

Backtrace

./libraries/dbi/DBIMysqli.class.php#261: mysqli_query(
object,
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
integer 0,
)
./libraries/DatabaseInterface.class.php#246: PMA_DBI_Mysqli->realQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
)
./libraries/DatabaseInterface.class.php#2106: PMA_DatabaseInterface->tryQuery(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
object,
integer 0,
boolean false,
)
./libraries/navigation/Nodes/Node.class.php#814: PMA_DatabaseInterface->fetchResult(
string 'SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`=\'root\' GROUP BY `db_name`',
string 'db_name',
string 'count',
object,
)
./libraries/navigation/NavigationTree.class.php#280: Node->getNavigationHidingData()
./libraries/navigation/NavigationTree.class.php#830: PMA_NavigationTree->_buildPath()
./libraries/navigation/Navigation.class.php#44: PMA_NavigationTree->renderState()
./libraries/Header.class.php#433: PMA_Navigation->getDisplay()
./libraries/Response.class.php#263: PMA_Header->getDisplay()
./libraries/Response.class.php#276: PMA_Response->_getDisplay()
./libraries/Response.class.php#397: PMA_Response->_htmlResponse()
PMA_Response::response()