[mythtv-users] mythconverg database server migration
Mark Perkins
perkins1724 at hotmail.com
Thu Mar 30 10:32:58 UTC 2017
..snip..
> It should have completed long ago. Something is wrong with your system
> and/or MySQL configuration. Even if you let it run to completion, you'll
> probably have terrible performance once it's loaded because whatever is
> slowing the restore will slow the DBMS, itself. So you really need to identify
> and fix the configuration issue that's slowing your MySQL.
>
> The unfortunate thing is, though, that identifying the configuration issue is
> going to be a challenge (read, "will take lots of systematic trial and error--or a
> lucky guess by you or someone on list").
>
> Mike
Would something like mysqltuner.pl help diagnose? I don't recall the OS of the OP but I think it ships with Ubuntu so something like:
sudo apt-get install mysqltuner
sudo mysqltuner
may generate something.
More information about the mythtv-users
mailing list