And I think I’ve hurt my server a bit…
At least I think that’s what Id 2101
below is spending rather a lot of timecleaning up…
mysql> show full processlist;
+------+--------------+-----------------+---------------------+---------+------+--------------+-----------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+--------------+-----------------+---------------------+---------+------+--------------+-----------------------------------------------------------------------------------------------------------------------------+
| 2101 | ttrss | localhost | ttrss | Query | 623 | Sending data | DELETE FROM ttrss_entries WHERE
NOT EXISTS (SELECT ref_id FROM ttrss_user_entries WHERE ref_id = id) |
| 2166 | ttrss | localhost | ttrss | Query | 587 | statistics | SELECT data FROM ttrss_sessions WHERE id='17aavuv9nrlqlri17kgevuvi73' |
| 2215 | 3rd_site_usr | localhost | 3rd_site_db | Query | 562 | statistics | SELECT /* LCStoreDB::get 217.182.132.92 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'deps' LIMIT 1 |
| 2239 | 2nd_site_usr | localhost | 2nd_site_db | Query | 551 | Sending data | SELECT * FROM template_configuration_group |
| 2267 | 2nd_site_usr | localhost | 2nd_site_db | Query | 536 | Sending data | SELECT * FROM template_configuration_group |
| 2287 | ttrss | localhost | ttrss | Query | 526 | statistics | SELECT data FROM ttrss_sessions WHERE id='17aavuv9nrlqlri17kgevuvi73' |
| 2297 | 2nd_site_usr | localhost | 2nd_site_db | Query | 521 | Sending data | SELECT * FROM template_configuration_group |
| 2326 | 2nd_site_usr | localhost | 2nd_site_db | Query | 506 | Sending data | SELECT * FROM template_configuration_group |
| 2356 | 2nd_site_usr | localhost | 2nd_site_db | Query | 491 | Sending data | SELECT * FROM template_configuration_group |
| 2385 | 2nd_site_usr | localhost | 2nd_site_db | Query | 476 | Sending data | SELECT * FROM template_configuration_group |
| 2406 | ttrss | localhost | ttrss | Query | 465 | statistics | SELECT data FROM ttrss_sessions WHERE id='17aavuv9nrlqlri17kgevuvi73' |
| 2670 | ttrss | localhost | ttrss | Query | 323 | Sending data | SELECT schema_version FROM ttrss_version |
| 2784 | admin | localhost:42644 | NULL | Query | 0 | NULL | show full processlist |
| 2785 | ttrss | localhost | ttrss | Query | 23 | Sending data | SELECT schema_version FROM ttrss_version |
+------+--------------+-----------------+---------------------+---------+------+--------------+-----------------------------------------------------------------------------------------------------------------------------+
14 rows in set (0.00 sec)
Apart from “don’t do that again” or “don’t use mysql” or “start from scratch” - any useful hints on mitigating this little SNAFU of mine?
Or simply leave it running?