-
I was shocked to see the size of the users file on our WordPress site. There are 3100 members at the moment. About 500 of them currently have access to videos. Then I realised that a lot of it is put there by FV Player to enable the user to know where they left-off watching a video.
I am hoping you can suggest a way of reducing this data – perhaps when it’s older than twelve months (currently entries date back to 2013).
Below is an example of the viewing data of a typical viewer – multiply this by 500, and you will see what I mean!Best wishes,
Andysubscriber","","XXXXXXXXX","","true","false","fresh","0","true","","","","{""subscriber"":true}","0","","","","","","","","","","","","","","","","","","","","","","{""level"":1370627555,""level1"":1370627555}","81.204.125.129","93","","[{""date"":""2013-06-07"",""time"":1370627686,""ltime"":1370627686,""file"":""TB-Driving\/TB-Driving-01-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-07"",""time"":1370628105,""ltime"":1370628105,""file"":""TB-Driving\/TB-Driving-02-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-07"",""time"":1370628537,""ltime"":1370628537,""file"":""TB-Driving\/TB-Driving-02-ST-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-07"",""time"":1370628600,""ltime"":1370628600,""file"":""TB-Driving\/TB-Driving-03-ST-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-08"",""time"":1370676567,""ltime"":1370676567,""file"":""TB-Driving\/TB-Driving-03-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-08"",""time"":1370676588,""ltime"":1370719053,""file"":""TB-Driving\/TB-Driving-03-ST-720-2250-128.mp4"",""counter"":2},{""date"":""2013-06-08"",""time"":1370677297,""ltime"":1370677297,""file"":""TB-Basic-Training\/TB-Golden-Rule-360-1600-96b.mp4"",""counter"":1},{""date"":""2013-06-08"",""time"":1370677330,""ltime"":1370677330,""file"":""TB-Basic-Training\/TB-Golden-Rule-ST-360-1600-96b.mp4"",""counter"":1},{""date"":""2013-06-08"",""time"":1370677733,""ltime"":1370719232,""file"":""TB-Driving\/TB-Driving-01-ST-720-2250-128.mp4"",""counter"":2},{""date"":""2013-06-08"",""time"":1370678334,""ltime"":1370718630,""file"":""TB-Driving\/TB-Driving-02-ST-720-2250-128.mp4"",""counter"":2},{""date"":""2013-06-08"",""time"":1370679025,""ltime"":1370679025,""file"":""TB-Basic-Training\/TB-Calm-01-360.1600-96a.mp4"",""counter"":1},{""date"":""2013-06-08"",""time"":1370679041,""ltime"":1370679041,""file"":""TB-Basic-Training\/TB-Calm-01-ST-360-1600-96a.mp4"",""counter"":1},{""date"":""2013-06-08"",""time"":1370680507,""ltime"":1370695885,""file"":""TB-Outrun\/TB-Outrun-01-360-1600-96a.mp4"",""counter"":2},{""date"":""2013-06-08"",""time"":1370680510,""ltime"":1370695893,""file"":""TB-Outrun\/TB-Outrun-01-ST-360-1600-96a.mp4"",""counter"":2},{""date"":""2013-06-08"",""time"":1370695541,""ltime"":1370695541,""file"":""TB-Driving\/TB-Driving-01-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-08"",""time"":1370718623,""ltime"":1370718623,""file"":""TB-Driving\/TB-Driving-02-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-08"",""time"":1370719618,""ltime"":1370719618,""file"":""TB-Basic-Training\/TB-Give-Sheep-Space-01-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-08"",""time"":1370719635,""ltime"":1370719635,""file"":""TB-Basic-Training\/TB-Give-Sheep-Space-01-ST-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-09"",""time"":1370798588,""ltime"":1370798668,""file"":""TB-Driving\/TB-Driving-01-720-2250-128.mp4"",""counter"":2},{""date"":""2013-06-09"",""time"":1370798590,""ltime"":1370801115,""file"":""TB-Driving\/TB-Driving-01-ST-720-2250-128.mp4"",""counter"":3},{""date"":""2013-06-09"",""time"":1370801113,""ltime"":1370801113,""file"":""TB-Driving\/TB-Driving-02-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-09"",""time"":1370801132,""ltime"":1370801150,""file"":""TB-Driving\/TB-Driving-02-ST-720-2250-128.mp4"",""counter"":2},{""date"":""2013-06-09"",""time"":1370801193,""ltime"":1370801214,""file"":""TB-Driving\/TB-Driving-03-ST-720-2250-128.mp4"",""counter"":2},{""date"":""2013-06-09"",""time"":1370801250,""ltime"":1370801276,""file"":""TB-Basic-Training\/TB-Calm-01-ST-360-1600-96a.mp4"",""counter"":2},{""date"":""2013-06-09"",""time"":1370801311,""ltime"":1370801311,""file"":""TB-Outrun\/TB-Outrun-01-360-1600-96a.mp4"",""counter"":1},{""date"":""2013-06-09"",""time"":1370801322,""ltime"":1370801347,""file"":""TB-Outrun\/TB-Outrun-01-ST-360-1600-96a.mp4"",""counter"":2},{""date"":""2013-06-09"",""time"":1370801385,""ltime"":1370801385,""file"":""TB-Farm-Work\/TB-Close-Work-01-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-09"",""time"":1370801393,""ltime"":1370801418,""file"":""TB-Farm-Work\/TB-Close-Work-01-ST-720-2250-128.mp4"",""counter"":2},{""date"":""2013-06-09"",""time"":1370801444,""ltime"":1370802241,""file"":""TB-Farm-Work\/TB-Close-Work-02-ST-360-1600-96z.mp4"",""counter"":3},{""date"":""2013-06-09"",""time"":1370802217,""ltime"":1370802217,""file"":""TB-Farm-Work\/TB-Close-Work-02-360-1600-96z.mp4"",""counter"":1},{""date"":""2013-06-09"",""time"":1370802283,""ltime"":1370802303,""file"":""TB-Aids\/TB-Whistle-01-ST-720-2250-128.mp4"",""counter"":2},{""date"":""2013-06-09"",""time"":1370802335,""ltime"":1370802787,""file"":""TB-Aids\/TB-Training-Stick-ST-720-2250-128.mp4"",""counter"":3},{""date"":""2013-06-09"",""time"":1370802394,""ltime"":1370802394,""file"":""TB-Basic-Training\/TB-Give-Sheep-Space-01-ST-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-09"",""time"":1370802779,""ltime"":1370802779,""file"":""TB-Aids\/TB-Training-Stick-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-10"",""time"":1370892182,""ltime"":1370892182,""file"":""TB-Farm-Work\/TB-Close-Work-01-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-10"",""time"":1370892184,""ltime"":1370892184,""file"":""TB-Farm-Work\/TB-Close-Work-01-ST-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-11"",""time"":1370937373,""ltime"":1370937373,""file"":""TB-Aids\/TB-Whistle-01-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-11"",""time"":1370937380,""ltime"":1370937380,""file"":""TB-Aids\/TB-Whistle-01-ST-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-11"",""time"":1370948126,""ltime"":1370948126,""file"":""TB-Farm-Work\/TB-Close-Work-01-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-11"",""time"":1370948138,""ltime"":1370948138,""file"":""TB-Farm-Work\/TB-Close-Work-01-ST-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-11"",""time"":1370948715,""ltime"":1370948715,""file"":""TB-Farm-Work\/TB-Close-Work-02-ST-360-1600-96z.mp4"",""counter"":1},{""date"":""2013-06-16"",""time"":1371390687,""ltime"":1371390687,""file"":""TB-Driving\/TB-Driving-01-ST-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-16"",""time"":1371390715,""ltime"":1371390715,""file"":""TB-Driving\/TB-Driving-03-ST-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-21"",""time"":1371817686,""ltime"":1371817686,""file"":""TB-Basic-Training\/TB-Give-Sheep-Space-01-720-2250-128.mp4"",""counter"":1},{""date"":""2013-06-21"",""time"":1371817705,""ltime"":1371817705,""file"":""TB-Basic-Training\/TB-Give-Sheep-Space-01-ST-720-2250-128.mp4"",""counter"":1},{""date"":""2014-04-05"",""time"":1396725035,""ltime"":1396726938,""file"":""TSDT-Sheepdog-Trials-01-640x360-140403.mp4"",""counter"":3},{""date"":""2014-04-05"",""time"":1396726999,""ltime"":1396727043,""file"":""TS-Learn-Your-Commands-01.mp4"",""counter"":2},{""date"":""2014-04-05"",""time"":1396727097,""ltime"":1396727118,""file"":""TS-The-Dogs-Confidence-01.mp4"",""counter"":2},{""date"":""2014-04-05"",""time"":1396727158,""ltime"":1396727185,""file"":""TS-Teaching-Whistle-Commands-01.mp4"",""counter"":2},{""date"":""2014-04-05"",""time"":1396727233,""ltime"":1396727269,""file"":""TS-My-Dogs-No-Good-01.mp4"",""counter"":2},{""date"":""2014-04-05"",""time"":1396727344,""ltime"":1396727344,""file"":""TB-Coming-Out-140123.mp4"",""counter"":1},{""date"":""2014-04-05"",""time"":1396727356,""ltime"":1396727375,""file"":""TB-Coming-Out-01-ST-140123.mp4"",""counter"":2},{""date"":""2014-04-05"",""time"":1396727473,""ltime"":1396727493,""file"":""TB-How-Often-How-Long-01-ST-140111.mp4"",""counter"":2},{""date"":""2014-04-05"",""time"":1396727532,""ltime"":1396727564,""file"":""TB-Sheepdogs-Time-Out-ST.mp4"",""counter"":2},{""date"":""2014-04-05"",""time"":1396727601,""ltime"":1396727626,""file"":""TB-Pack-Behaviour-Insights-131212.mp4"",""counter"":2},{""date"":""2014-04-05"",""time"":1396727663,""ltime"":1396727678,""file"":""TB-Starting-Strong-Dog-01-ST-131209.mp4"",""counter"":2},{""date"":""2014-05-21"",""time"":1400670685,""ltime"":1400670685,""file"":""TSDT-Sheepdog-Trials-02-ST-140506.mp4"",""counter"":1},{""date"":""2014-06-24"",""time"":1403637383,""ltime"":1403637383,""file"":""Circling\/TB-Circling-01-140528.mp4"",""counter"":1},{""date"":""2014-06-24"",""time"":1403637386,""ltime"":1403637386,""file"":""Circling\/TB-Circling-01-ST-140528.mp4"",""counter"":1},{""date"":""2014-06-24"",""time"":1403637988,""ltime"":1403637988,""file"":""Circling\/TB-Circling-02-140618.mp4"",""counter"":1},{""date"":""2014-06-24"",""time"":1403637995,""ltime"":1403637995,""file"":""Circling\/TB-Circling-02-ST-140618.mp4"",""counter"":1},{""date"":""2014-08-11"",""time"":1407789100,""ltime"":1407789100,""file"":""TB-How-Often-How-Long-01-140111.mp4"",""counter"":1},{""date"":""2014-08-11"",""time"":1407789116,""ltime"":1407789116,""file"":""TB-How-Often-How-Long-01-ST-140111.mp4"",""counter"":1},{""date"":""2014-08-26"",""time"":1409060638,""ltime"":1409061159,""file"":""What-Next\/TB-What-Shall-I-Do-Next-140826.mp4"",""counter"":3},{""date"":""2014-08-26"",""time"":1409060644,""ltime"":1409061178,""file"":""What-Next\/TB-What-Shall-I-Do-Next-ST-140826.mp4"",""counter"":3},{""date"":""2014-08-31"",""time"":1409513773,""ltime"":1409514262,""file"":""Backwards\/TB-Backwards-140702.mp4"",""counter"":6},{""date"":""2014-08-31"",""time"":1409514300,""ltime"":1409514300,""file"":""TSDT-Sheepdog-Trials-02-140520.mp4"",""counter"":1},{""date"":""2014-08-31"",""time"":1409514310,""ltime"":1409514373,""file"":""TSDT-Sheepdog-Trials-02-ST-140506.mp4"",""counter"":2},{""date"":""2014-08-31"",""time"":1409514538,""ltime"":1409514538,""file"":""Circling\/TB-Circling-01-140528.mp4"",""counter"":1},{""date"":""2014-08-31"",""time"":1409514548,""ltime"":1409514640,""file"":""Circling\/TB-Circling-01-ST-140528.mp4"",""counter"":3},{""date"":""2014-08-31"",""time"":1409514573,""ltime"":1409515211,""file"":""Circling\/TB-Circling-02-ST-140618.mp4"",""counter"":3},{""date"":""2014-09-07"",""time"":1410080585,""ltime"":1410081438,""file"":""Complete-Sessions\/Educating-Gloria-140904a.mp4"",""counter"":7},{""date"":""2014-09-07"",""time"":1410080593,""ltime"":1410081031,""file"":""Complete-Sessions\/Educating-Gloria-ST-140904a.mp4"",""counter"":4},{""date"":""2014-09-07"",""time"":1410083343,""ltime"":1410083343,""file"":""TI-Shedding-01-131213.mp4"",""counter"":1},{""date"":""2014-10-10"",""time"":1412970147,""ltime"":1412970254,""file"":""Complete-Sessions\/Eve-at-the-pen-141008.mp4"",""counter"":2},{""date"":""2014-10-10"",""time"":1412970153,""ltime"":1412970258,""file"":""Complete-Sessions\/Eve-at-the-pen-ST-141008.mp4"",""counter"":2},{""date"":""2014-12-16"",""time"":1418746300,""ltime"":1418746300,""file"":""Shorts\/Excuses-01-141129.mp4"",""counter"":1},{""date"":""2015-06-13"",""time"":1434199239,""ltime"":1434200022,""file"":""Shorts\/Woolly-Jumpers-150530a.mp4"",""counter"":8},{""date"":""2015-06-13"",""time"":1434199293,""ltime"":1434200028,""file"":""Shorts\/Woolly-Jumpers-ST-150530a.mp4"",""counter"":8},{""date"":""2015-06-13"",""time"":1434200316,""ltime"":1434200316,""file"":""Bronwen-and-Scylla\/Bronwen-and-Scylla-01-150430.mp4"",""counter"":1},{""date"":""2015-06-13"",""time"":1434200324,""ltime"":1434200324,""file"":""Bronwen-and-Scylla\/Bronwen-and-Scylla-01-ST-150430.mp4"",""counter"":1},{""date"":""2015-09-06"",""time"":1441543716,""ltime"":1441544042,""file"":""Bronwen-and-Scylla\/Bronwen-and-Scylla-01-150430.mp4"",""counter"":3},{""date"":""2015-09-06"",""time"":1441543886,""ltime"":1441543886,""file"":""Bronwen-and-Scylla\/Bronwen-and-Scylla-02-150521.mp4"",""counter"":1},{""date"":""2015-09-06"",""time"":1441543917,""ltime"":1441543917,""file"":""Bronwen-and-Scylla\/Bronwen-and-Scylla-02-ST-150521.mp4"",""counter"":1},{""date"":""2015-09-06"",""time"":1441543944,""ltime"":1441543944,""file"":""Bronwen-and-Scylla\/Bronwen-and-Scylla-01-ST-150430.mp4"",""counter"":1},{""date"":""2015-09-23"",""time"":1443033116,""ltime"":1443034128,""file"":""Outrun\/Outrun-03-Slingshot-150920.mp4"",""counter"":2},{""date"":""2015-09-23"",""time"":1443033136,""ltime"":1443034136,""file"":""Outrun\/Outrun-03-Slingshot-ST-150920.mp4"",""counter"":2},{""date"":""2016-02-07"",""time"":1454855820,""ltime"":1454856632,""file"":""Circling\/TB-Circling-02-140618.mp4"",""counter"":2},{""date"":""2016-02-07"",""time"":1454855834,""ltime"":1454857205,""file"":""Circling\/TB-Circling-02-ST-140618.mp4"",""counter"":3},{""date"":""2016-02-07"",""time"":1454857426,""ltime"":1454857426,""file"":""Sheepdog\/Sheepdog-160101.mp4"",""counter"":1},{""date"":""2016-02-07"",""time"":1454857434,""ltime"":1454857434,""file"":""Sheepdog\/Sheepdog-ST-160101.mp4"",""counter"":1},{""date"":""2016-02-20"",""time"":1455997982,""ltime"":1455997982,""file"":""Circling\/TB-Circling-02-ST-140618.mp4"",""counter"":1},{""date"":""2016-02-20"",""time"":1455998040,""ltime"":1455998220,""file"":""Bronwen-and-Scylla\/Bronwen-and-Scylla-05-160213.mp4"",""counter"":2},{""date"":""2016-02-20"",""time"":1455998048,""ltime"":1455999881,""file"":""Bronwen-and-Scylla\/Bronwen-and-Scylla-05-ST-160213.mp4"",""counter"":3},{""date"":""2017-05-28"",""time"":1495989968,""ltime"":1495990283,""file"":""Basics\/Flank-both-ways-170522.mp4"",""counter"":2},{""date"":""2017-05-28"",""time"":1495989975,""ltime"":1495989975,""file"":""Basics\/Flank-both-ways-ST-170522.mp4"",""counter"":1},{""date"":""2018-08-31"",""time"":1535707019,""ltime"":1535707019,""file"":""Stop\/Stop-01-140227.mp4"",""counter"":1},{""date"":""2018-08-31"",""time"":1535707288,""ltime"":1535707288,""file"":""Stop\/Stop-02-perfect-stop-170224.mp4"",""counter"":1},{""date"":""2018-08-31"",""time"":1535707294,""ltime"":1535707294,""file"":""Stop\/Stop-02-perfect-stop-ST-170224.mp4"",""counter"":1},{""date"":""2018-09-02"",""time"":1535896054,""ltime"":1535896904,""file"":""Stop\/Stop-02-perfect-stop-170224.mp4"",""counter"":3},{""date"":""2018-09-02"",""time"":1535896311,""ltime"":1535896311,""file"":""Basics\/Coming-out-140123.mp4"",""counter"":1},{""date"":""2018-09-02"",""time"":1535896340,""ltime"":1535896340,""file"":""Basics\/Coming-out-ST-140123.mp4"",""counter"":1},{""date"":""2018-09-02"",""time"":1535900613,""ltime"":1535900613,""file"":""Confidence\/Sometimes-nice-is-not-enough-150709.mp4"",""counter"":1},{""date"":""2018-09-25"",""time"":1537893049,""ltime"":1537893049,""file"":""What-Next\/What-next-01-140226.mp4"",""counter"":1},{""date"":""2018-10-21"",""time"":1540133536,""ltime"":1540133606,""file"":""Balance\/Balance-01-151211.mp4"",""counter"":2},{""date"":""2018-10-21"",""time"":1540134064,""ltime"":1540134064,""file"":""Basics\/Training-ring-01-180817.mp4"",""counter"":1},{""date"":""2018-11-03"",""time"":1541271710,""ltime"":1541271710,""file"":""Basics\/Training-ring-02-181031.mp4"",""counter"":1}]","","","","","","","","","","","","","","","workingsheepdog.co.uk","Demoted by s2Member: Mon Jul 8, 2013 5:59 pm UTC Demoted by s2Member: Wed Oct 26, 2022 10:27 am UTCBest wishes,
Andy
Viewing 6 replies - 1 through 6 (of 6 total)
-
-
Hello Andy,
What you pasted does not belong to FV Player.
However you are right that the FV Player user video position is stored in
wp_usermetatable and that it can grow over time.That’s why in FV Player 8 we will convert these entries to a custom database table. We have build that conversion routine and we are testing FV Player 8 on our video websites to make sure it’s ready for public release.
Thanks,
MartinMy apologies. I saw a huge number of entries like:
meta_key__fv_wp_flowplayer_saw_59″,”meta_key__fv_wp_flowplayer_position_180″,
And assumed that those other entries were yours, too as they relate to video.
Is there a way to safely delete (or reduce) this information from our User File?
Best wishes,
AndyHello Andy,
Following wp_usermeta rows belong to FV Player – the meta_key must be one of:
- fv_wp_flowplayer_playerplaylist*
- fv_wp_flowplayerposition*
- fv_wp_flowplayersaw*
- fv_wp_flowplayer_topposition*
These will be moved to a new database table in FV Player 8. That will reduce the number of database data moved around, specially if you allow your users to post comments on the articles.
Do you seem them anywhere in that exact form as you wrote?
meta_key__fv_wp_flowplayer_saw_59 meta_key__fv_wp_flowplayer_position_180Thanks,
MartinI copied and pasted what was there, Martin.
When you say they will be MOVED, do you mean they will be removed from wp_usermeta and taken to a new table?
Or will a new table be started and these files will stay where they are?Best wishes,
AndyJust to clarify…
I exported the wp_usermeta as csv.
I cannot open it properly with Apple Numbers as the spreadsheet has a limit of 1000 columns, but it DID show:
meta_key__fv_wp_flowplayer_saw_59
meta_key__fv_wp_flowplayer_position_180
in the headers (of the spreadsheet).
AndyHello Andy,
We will copy these FV Player video positions from usermeta to the new table. This conversion routine took 1 hour on one of the big video websites where we were testing this new feature. It would free almost 1GB of space in the wp_usermeta table as there are tens of thousands users.
If you did some CSV export for a database tool then I guess that’s what added that
meta_key_part to these column headings. In that case the actualmeta_keywas likely just_fv_wp_flowplayer_saw_59– which belongs to FV Player and will be moved in that conversion routine in FV Player 8.Thanks,
Martin
Viewing 6 replies - 1 through 6 (of 6 total)
