Hi all, I'm currently in trouble with MariaDB. The server is not reachable so I've to kill the PID and restart it. When it's restarted, i made a "SHOW PROCESSLIST" and here what I see : Code: 50 ispconfig localhost:46603 dbispconfig Sleep 98 NULL 0.000 65 ispconfig localhost:46624 dbispconfig Sleep 206 NULL 0.000 88 ispconfig localhost:46667 dbispconfig Sleep 16 NULL 0.000 101 ispconfig localhost:46689 dbispconfig Sleep 49 NULL 0.000 103 ispconfig localhost:46691 dbispconfig Sleep 49 NULL 0.000 105 ispconfig localhost:46693 dbispconfig Sleep 150 NULL 0.000 106 ispconfig localhost:46694 dbispconfig Sleep 150 NULL 0.000 109 ispconfig localhost:46697 dbispconfig Sleep 150 NULL 0.000 110 ispconfig localhost:46699 dbispconfig Sleep 83 NULL 0.000 117 ispconfig localhost:46706 dbispconfig Sleep 15 NULL 0.000 204 ispconfig localhost:46782 dbispconfig Sleep 16 NULL 0.000 270 ispconfig localhost:46966 dbispconfig Sleep 83 NULL 0.000 278 ispconfig localhost:46975 dbispconfig Sleep 48 NULL 0.000 279 ispconfig localhost:46976 dbispconfig Sleep 48 NULL 0.000 280 ispconfig localhost:46977 dbispconfig Sleep 16 NULL 0.000 281 ispconfig localhost:46978 dbispconfig Sleep 16 NULL 0.000 282 ispconfig localhost:46979 dbispconfig Sleep 48 NULL 0.000 284 root localhost:46983 NULL Query 0 init SHOW PROCESSLIST 0.000 285 root localhost:46984 NULL Sleep 34 NULL 0.000 287 ispconfig localhost:46986 dbispconfig Sleep 16 NULL 0.000 288 ispconfig localhost:46987 dbispconfig Sleep 16 NULL 0.000 289 ispconfig localhost:46988 dbispconfig Sleep 16 NULL 0.000 290 ispconfig localhost:46989 dbispconfig Sleep 17 NULL 0.000 291 ispconfig localhost:46990 dbispconfig Sleep 17 NULL 0.000 292 ispconfig localhost:46991 dbispconfig Sleep 17 NULL 0.000 293 ispconfig localhost:46992 dbispconfig Sleep 17 NULL 0.000 294 ispconfig localhost:46993 dbispconfig Sleep 17 NULL 0.000 295 ispconfig localhost:46997 dbispconfig Sleep 15 NULL 0.000 296 ispconfig localhost:46998 dbispconfig Sleep 15 NULL 0.000 297 ispconfig localhost dbispconfig Sleep 16 NULL 0.000 An idea of what I can do or where it comes from? Kind regard, Stéphane
This does not has to be an error, there can be plenty of connections as all parts of the system like postfix, amavis, pure-ftpd and dovecot connect to the database with this user and they keep connections open as it uses less resources then opening and closing connections all the time. So the above number of sleeping connections should be ok.
Alright (thanks for the confirmation), do you have an idea how can i monitor witch access cause the damage or when it appear ? => The process is still running but unreachable (timeout). And the log are empty.
