[mythtv-users] mythconverg database server migration

[Erik Karlin]

On Thu, Mar 30, 2017 at 09:57:24AM -0400, Erik Karlin wrote:
> On Thu, Mar 30, 2017 at 10:32:58AM +0000, Mark Perkins wrote:
> > 
> > ..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.
> 
> I'm on an up-to-date debian jessie. I've since killed the database load
> but haven't had a chance to dig any further. I know I've not made any
> changes to the mysql configs but I do see mysqltuner in the debian repo.
> I will have a look at it. Hopefully it doesn't require a database
> already loaded to tune. Probably does though.
> 
> Thanks for all the suggestions so far!
> 

So, it turned out to be much more basic...out of disk space on the new
server. After moving /var/lib/mysql and binding a new mount the database
loads in about 6 minutes from a drop/recreate db. Just for the record

$ gzip -l /nas/backup/mythconverg-1317-20170330073640.sql.gz
         compressed        uncompressed  ratio uncompressed_name
          120660857           730397588  83.5% /nas/backup/mythconverg-1317-20170330073640.sql


I did go ahead and look at https://www.mythtv.org/wiki/Tune_MySQL and
mysqltuner but this was once again a stupid-user-mistake.


Thanks