I don't know, but it does seem a lot of data given the number of channels and EPG-days-per-channel.Is the problem 31300 rows of data? That seems a lot.
Yeah, that's never going to work.I copied the data files and folders over from the 5.1 folder, but I get this when attempting to start it.
The least technically challenging way to transfer would be to export (ie. TV Server Configuration->import/export) from TV Server with MySQL 5.1, then configure TV Server to use 5.6 and create a new database, then import the 5.1 export.
Sky?how many channels do you have: 59
If yes, is this the standard version of TV Server? (ie. not the "DJBlu" version)
Some of the slow queries are associated with 192.168.0.7 while others are associated with 192.168.1.100. What's the deal with that?