Hello, MySQL stopped again this morning.
System configuration is: Debian GNU/Linux 11 x86_64(Py3.12.3) / 64 GB RAM / 16 Cores CPU
Here is the MySQL Slow log:
`l.code,
l.id,
english_name,
nt.name AS native_name,
major,
active,
default_locale,
encode_url,
tag,
lt.name AS display_name
FROM tdnrn_icl_languages l
JOIN tdnrn_icl_languages_translations nt
ON ( nt.language_code = l.code AND nt.display_language_code = l.code )
LEFT OUTER JOIN tdnrn_icl_languages_translations lt ON l.code=lt.language_code
WHERE
( lt.display_language_code = 'en'
OR (lt.display_language_code = 'en'
AND NOT EXISTS ( SELECT *
FROM tdnrn_icl_languages_translations ls
WHERE ls.language_code = l.code
AND ls.display_language_code = 'en' ) ) )
GROUP BY l.code
ORDER BY english_name ASC;
Time: 2025-06-08T22:25:44.197075Z
User@Host: sql_thefirstcoll[sql_thefirstcoll] @ localhost [] Id: 85
Query_time: 6.727249 Lock_time: 0.090269 Rows_sent: 262 Rows_examined: 287
SET timestamp=1749421544;
SELECT name, val FROM tdnrn_wfconfig WHERE autoload = 'yes';
Time: 2025-06-08T22:25:44.454885Z
User@Host: sql_thefirstcoll[sql_thefirstcoll] @ localhost [] Id: 139
Query_time: 6.851179 Lock_time: 0.024185 Rows_sent: 262 Rows_examined: 287
SET timestamp=1749421544;
SELECT name, val FROM tdnrn_wfconfig WHERE autoload = 'yes';
Time: 2025-06-08T22:25:44.888891Z
User@Host: sql_thefirstcoll[sql_thefirstcoll] @ localhost [] Id: 158
Query_time: 7.268808 Lock_time: 0.269380 Rows_sent: 65 Rows_examined: 325
SET timestamp=1749421544;
SELECT
l.code,
l.id,
english_name,
nt.name AS native_name,
major,
active,
default_locale,
encode_url,
tag,
lt.name AS display_name
FROM tdnrn_icl_languages l
JOIN tdnrn_icl_languages_translations nt
ON ( nt.language_code = l.code AND nt.display_language_code = l.code )
LEFT OUTER JOIN tdnrn_icl_languages_translations lt ON l.code=lt.language_code
WHERE
( lt.display_language_code = 'en'
OR (lt.display_language_code = 'en'
AND NOT EXISTS ( SELECT *
FROM tdnrn_icl_languages_translations ls
WHERE ls.language_code = l.code
AND ls.display_language_code = 'en' ) ) )
GROUP BY l.code
ORDER BY english_name ASC;
Time: 2025-06-08T22:25:45.295349Z
User@Host: sql_thefirstcoll[sql_thefirstcoll] @ localhost [] Id: 149
Query_time: 7.691104 Lock_time: 0.206105 Rows_sent: 1 Rows_examined: 2649
SET timestamp=1749421545;
SELECT count(*) FROM tdnrn_options WHERE option_name LIKE 'jpsq_sync-%';
/www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
Time: 2025-06-08T22:32:13.031727Z
User@Host: sql_thefirstcoll[sql_thefirstcoll] @ localhost [] Id: 16
Query_time: 4.187719 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
use sql_thefirstcoll;
SET timestamp=1749421933;
SELECT COUNT(*) FROM tdnrn_hurrytimer_evergreen;
/www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 5.7.37-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument`
