Re: Why is Mysqld is crashing every few hours
this is what i found in slow query log
# Time: 2018-04-26T07:48:13.345261Z
# User@Host: root[root] @ localhost [] Id: 7902948
# Query_time: 1.155653 Lock_time: 0.000027 Rows_sent: 2 Rows_examined: 4
SET timestamp=1524728893;
SELECT id, content_id, hash, title, tags, category, category_name, sub_category, sub_category_name, size, seeders, leechers, upload_date, uploader, uploader_level, comments_count FROM content WHERE MATCH(title) AGAINST('+the +good +doctor +s01' IN BOOLEAN MODE) ORDER BY seeders DESC LIMIT 0, 30;
/usr/sbin/mysqld, Version: 5.7.22-log (MySQL Community Server (GPL)). started with:
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
# Time: 2018-04-26T07:48:27.285763Z
# User@Host: root[root] @ localhost [] Id: 72
# Query_time: 1.005508 Lock_time: 0.000015 Rows_sent: 30 Rows_examined: 816
use production;
SET timestamp=1524728907;
SELECT id, content_id, hash, title, tags, category, category_name, sub_category, sub_category_name, size, seeders, leechers, upload_date, uploader, uploader_level, comments_count FROM content WHERE MATCH(tags) AGAINST('+puzzle' IN BOOLEAN MODE) ORDER BY upload_date DESC LIMIT 30, 30;