competence-rs.com / localhost

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

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

Processes	ID	User	Host	Database	Command	Time	Status	SQL query
Kill	2897	pma	localhost	None	Sleep	287	---	---
Kill	2899	root	localhost	herp	Sleep	287	---	---
Kill	3717	pma	localhost	phpmyadmin	Sleep	174	---	---
Kill	3718	root	localhost	hmis	Sleep	174	---	---
Kill	5237	pma	localhost	None	Sleep	0	---	---
Kill	5238	root	localhost	hmis	Query	0	closing tables	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5283	pma	localhost	phpmyadmin	Sleep	0	---	---
Kill	5284	root	localhost	hmis	Query	0	Writing to net	SELECT COUNT(*) FROM `hmis`.`finalbill_bed_details`
Kill	5298	pma	localhost	None	Sleep	0	---	---
Kill	5299	root	localhost	hmis	Query	0	Opening tables	SELECT COUNT(*) FROM `hmis`.`emr_fhnotes`
Kill	5311	pma	localhost	None	Sleep	1	---	---
Kill	5312	root	localhost	hmis	Query	1	Sending data	SELECT COUNT(*) FROM `hmis`.`drugissue_amounts`
Kill	5341	pma	localhost	phpmyadmin	Sleep	0	---	---
Kill	5343	root	localhost	hmis	Query	0	---	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5348	pma	localhost	None	Sleep	0	---	---
Kill	5351	root	localhost	herp	Query	0	Writing to net	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5361	pma	localhost	phpmyadmin	Sleep	0	---	---
Kill	5362	root	localhost	herp	Query	0	Opening tables	SELECT COUNT(*) FROM `herp`.`cstest_estimation_bom_details`
Kill	5377	pma	localhost	None	Sleep	0	---	---
Kill	5378	root	localhost	hmis	Query	0	---	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5397	pma	localhost	phpmyadmin	Sleep	0	---	---
Kill	5398	root	localhost	hmis	Query	0	---	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5437	pma	localhost	None	Sleep	0	---	---
Kill	5438	root	localhost	herp	Query	0	Opening tables	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5453	pma	localhost	phpmyadmin	Sleep	0	---	---
Kill	5454	root	localhost	hmis	Query	0	Opening tables	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5499	pma	localhost	phpmyadmin	Sleep	0	---	---
Kill	5500	root	localhost	hmis	Query	0	---	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5549	pma	localhost	None	Sleep	5	---	---
Kill	5550	root	localhost	hmis	Query	1	Opening tables	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5551	pma	localhost	None	Sleep	0	---	---
Kill	5555	root	localhost	mysql	Query	0	checking permissions	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5559	pma	localhost	phpmyadmin	Sleep	3	---	---
Kill	5560	root	localhost	hmis	Query	3	Opening tables	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5563	pma	localhost	None	Sleep	0	---	---
Kill	5564	root	localhost	information_schema	Query	0	checking permissions	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5567	pma	localhost	None	Sleep	0	---	---
Kill	5568	root	localhost	hmis	Sleep	0	---	---
Kill	5569	pma	localhost	phpmyadmin	Sleep	0	---	---
Kill	5570	pma	localhost	None	Sleep	1	---	---
Kill	5571	root	localhost	hmis	Query	0	---	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5572	root	localhost	performance_schema	Query	0	checking permissions	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5573	pma	localhost	phpmyadmin	Sleep	0	---	---
Kill	5574	pma	localhost	None	Sleep	0	---	---
Kill	5575	root	localhost	mysql	Query	0	Opening tables	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`
Kill	5576	root	localhost	None	Sleep	0	---	---
Kill	5577	pma	localhost	None	Sleep	0	---	---
Kill	5578	root	localhost	mysql	Query	0	init	`SHOW PROCESSLIST`
Kill	5579	pma	localhost	None	Sleep	0	---	---
Kill	5580	root	localhost	mysql	Query	0	---	SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME`

Processes

2897

pma

localhost

None

Sleep

287

---

0.000

---

Kill

2899

root

localhost

herp

Sleep

287

---

0.000

---

Kill

3717

pma

localhost

phpmyadmin

Sleep

174

---

0.000

---

Kill

3718

root

localhost

hmis

Sleep

174

---

0.000

---

Kill

5237

pma

localhost

None

Sleep

---

0.000

---

Kill

5238

root

localhost

hmis

Query

closing tables

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5283

pma

localhost

phpmyadmin

Sleep

---

0.000

---

Kill

5284

root

localhost

hmis

Query

Writing to net

0.000

SELECT COUNT(*) FROM `hmis`.`finalbill_bed_details`

Kill

5298

pma

localhost

None

Sleep

---

0.000

---

Kill

5299

root

localhost

hmis

Query

Opening tables

0.000

SELECT COUNT(*) FROM `hmis`.`emr_fhnotes`

Kill

5311

pma

localhost

None

Sleep

---

0.000

---

Kill

5312

root

localhost

hmis

Query

Sending data

0.000

SELECT COUNT(*) FROM `hmis`.`drugissue_amounts`

Kill

5341

pma

localhost

phpmyadmin

Sleep

---

0.000

---

Kill

5343

root

localhost

hmis

Query

---

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5348

pma

localhost

None

Sleep

---

0.000

---

Kill

5351

root

localhost

herp

Query

Writing to net

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5361

pma

localhost

phpmyadmin

Sleep

---

0.000

---

Kill

5362

root

localhost

herp

Query

Opening tables

0.000

SELECT COUNT(*) FROM `herp`.`cstest_estimation_bom_details`

Kill

5377

pma

localhost

None

Sleep

---

0.000

---

Kill

5378

root

localhost

hmis

Query

---

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5397

pma

localhost

phpmyadmin

Sleep

---

0.000

---

Kill

5398

root

localhost

hmis

Query

---

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5437

pma

localhost

None

Sleep

---

0.000

---

Kill

5438

root

localhost

herp

Query

Opening tables

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5453

pma

localhost

phpmyadmin

Sleep

---

0.000

---

Kill

5454

root

localhost

hmis

Query

Opening tables

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5499

pma

localhost

phpmyadmin

Sleep

---

0.000

---

Kill

5500

root

localhost

hmis

Query

---

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5549

pma

localhost

None

Sleep

---

0.000

---

Kill

5550

root

localhost

hmis

Query

Opening tables

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5551

pma

localhost

None

Sleep

---

0.000

---

Kill

5555

root

localhost

mysql

Query

checking permissions

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5559

pma

localhost

phpmyadmin

Sleep

---

0.000

---

Kill

5560

root

localhost

hmis

Query

Opening tables

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5563

pma

localhost

None

Sleep

---

0.000

---

Kill

5564

root

localhost

information_schema

Query

checking permissions

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5567

pma

localhost

None

Sleep

---

0.000

---

Kill

5568

root

localhost

hmis

Sleep

---

0.000

---

Kill

5569

pma

localhost

phpmyadmin

Sleep

---

0.000

---

Kill

5570

pma

localhost

None

Sleep

---

0.000

---

Kill

5571

root

localhost

hmis

Query

---

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5572

root

localhost

performance_schema

Query

checking permissions

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5573

pma

localhost

phpmyadmin

Sleep

---

0.000

---

Kill

5574

pma

localhost

None

Sleep

---

0.000

---

Kill

5575

root

localhost

mysql

Query

Opening tables

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

Kill

5576

root

localhost

None

Sleep

---

0.000

---

Kill

5577

pma

localhost

None

Sleep

---

0.000

---

Kill

5578

root

localhost

mysql

Query

init

0.000

SHOW PROCESSLIST

Kill

5579

pma

localhost

None

Sleep

---

0.000

---

Kill

5580

root

localhost

mysql

Query

---

0.000

SELECT *,
                    `TABLE_SCHEMA`       AS `Db`,
                    `TABLE_NAME`

SQL upload ( 0 ) x-