11 lines
277 B
Markdown
11 lines
277 B
Markdown
Les connexions actives sous MariaDB
|
|
|
|
```sql
|
|
SELECT USER, COUNT(*) AS connections, SUM(TIME) AS sum_time,
|
|
GROUP_CONCAT(DISTINCT DB) AS dbs
|
|
FROM INFORMATION_SCHEMA.PROCESSLIST
|
|
GROUP BY USER
|
|
ORDER BY connections DESC, sum_time DESC
|
|
LIMIT 50
|
|
```
|