[mythtv-users] mysqlcheck has recently found corrupt database tables
Leo Butler
leo.butler81 at googlemail.com
Tue May 2 14:54:08 UTC 2023
On Mon, May 01 2023, Peter Carlsson <peter.jm.carlsson at gmail.com> wrote:
> Hello,
>
> I have recently starting to get the following from mysqlcheck.
>
> WARNING: mysqlcheck has found corrupt tables
>
> ERROR 130 (HY000) at line 1: Incorrect file format 'filemarkup'
>
> Improperly closed tables are also reported if clients are accessing
> the tables *now*. A list of current connections is below.
>
> +-----+------------------+-----------+-------------+---------+------+----------+------------------+----------+
> | Id | User | Host | db | Command | Time | State | Info | Progress |
> +-----+------------------+-----------+-------------+---------+------+----------+------------------+----------+
> | 86 | mythtv | localhost | mythconverg | Sleep | 0 | | | 0.000 |
> | 165 | debian-sys-maint | localhost | | Query | 0 | starting | show
> | processlist | 0.000 |
> +-----+------------------+-----------+-------------+---------+------+----------+------------------+----------+
> Uptime: 2 Threads: 3 Questions: 339 Slow queries: 0 Opens: 163 Open
> tables: 156 Queries per second avg: 169.500
>
> It still seems to work without any noticable problems but could anyone
> tell me how to fix this problem?
You are looking for mysql{check,optimize}
https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html
Alternatively, there is a perl wrapper in the myth package:
https://www.mythtv.org/wiki/User_Manual:Periodic_Maintenance
(skip to "Optimize the Database").
Leo
>
> Best regards,
> Peter Carlsson
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
More information about the mythtv-users
mailing list