SQL-Browser
Suche
Suchbegriff(e):
Suchoptionen
eine Spalte muss alle Suchbegriffe enthalten (UND-Suche)
eine Spalte muss mindestens einen Suchbegriff enthalten (ODER-Suche)
ein Datensatz muss alle Suchbegriffe enthalten, diese können aber in beliebigen Spalten sein (Rechenintensiv!)
Suche in Tabelle:
ALL_PLUGINS
APPLICABLE_ROLES
CHARACTER_SETS
CHECK_CONSTRAINTS
COLLATIONS
COLLATION_CHARACTER_SET_APPLICABILITY
COLUMNS
COLUMN_PRIVILEGES
ENABLED_ROLES
ENGINES
EVENTS
FILES
GLOBAL_STATUS
GLOBAL_VARIABLES
KEYWORDS
KEY_CACHES
KEY_COLUMN_USAGE
PARAMETERS
PARTITIONS
PLUGINS
PROCESSLIST
PROFILING
REFERENTIAL_CONSTRAINTS
ROUTINES
SCHEMATA
SCHEMA_PRIVILEGES
SESSION_STATUS
SESSION_VARIABLES
STATISTICS
SQL_FUNCTIONS
SYSTEM_VARIABLES
TABLES
TABLESPACES
TABLE_CONSTRAINTS
TABLE_PRIVILEGES
TRIGGERS
USER_PRIVILEGES
VIEWS
GEOMETRY_COLUMNS
SPATIAL_REF_SYS
CLIENT_STATISTICS
INDEX_STATISTICS
INNODB_SYS_DATAFILES
USER_STATISTICS
INNODB_SYS_TABLESTATS
INNODB_LOCKS
INNODB_MUTEXES
INNODB_CMPMEM
INNODB_CMP_PER_INDEX
INNODB_CMP
INNODB_FT_DELETED
INNODB_CMP_RESET
INNODB_LOCK_WAITS
TABLE_STATISTICS
INNODB_TABLESPACES_ENCRYPTION
INNODB_BUFFER_PAGE_LRU
INNODB_SYS_FIELDS
INNODB_CMPMEM_RESET
INNODB_SYS_COLUMNS
INNODB_FT_INDEX_TABLE
INNODB_CMP_PER_INDEX_RESET
user_variables
INNODB_FT_INDEX_CACHE
INNODB_SYS_FOREIGN_COLS
INNODB_FT_BEING_DELETED
INNODB_BUFFER_POOL_STATS
INNODB_TRX
INNODB_SYS_FOREIGN
INNODB_SYS_TABLES
INNODB_FT_DEFAULT_STOPWORD
INNODB_FT_CONFIG
INNODB_BUFFER_PAGE
INNODB_SYS_TABLESPACES
INNODB_METRICS
INNODB_SYS_INDEXES
INNODB_SYS_VIRTUAL
INNODB_TABLESPACES_SCRUBBING
INNODB_SYS_SEMAPHORE_WAITS
Die Suche nach "
" in der Tabelle "
PROCESSLIST
" lieferte folgende Treffer:
Blättern: vor=ALT+V, zurück=ALT+C
#
ID
USER
HOST
DB
COMMAND
TIME
STATE
INFO
TIME_MS
STAGE
MAX_STAGE
PROGRESS
MEMORY_USED
MAX_MEMORY_USED
EXAMINED_ROWS
QUERY_ID
INFO_BINARY
TID
1.
92028
burkhard
localhost:45536
Query
0
Filling schema table
SELECT * FROM `information_schema`.`PROCESSLIST` LIMIT 0,21
0.841
0
0
0.000
83216
83216
0
9979664
SELECT * FROM `information_schema`.`PROCESSLIST` LIMIT 0,21
22748
2.
92027
burkhard
localhost:45532
Sleep
0
2.304
0
0
0.000
69616
378128
0
9979663
22714
3.
16330
burkhard
localhost
fhem
Sleep
17640
17640060.683
0
0
0.000
69736
228392
0
9643206
812
4.
253
burkhard
localhost
fhem
Sleep
24
24955.167
0
0
0.000
69736
2179144
0
9977577
1716
5.
5
system user
Daemon
0
InnoDB shutdown handler
0.000
0
0
0.000
17552
17552
0
0
796
6.
4
system user
Daemon
0
InnoDB purge worker
0.000
0
0
0.000
17552
17552
0
0
792
7.
3
system user
Daemon
0
InnoDB purge worker
0.000
0
0
0.000
17552
17552
0
0
791
8.
2
system user
Daemon
0
InnoDB purge worker
0.000
0
0
0.000
17552
17552
0
0
790
9.
1
system user
Daemon
0
InnoDB purge coordinator
0.000
0
0
0.000
17552
17552
0
0
789