Separate watched status per client
#16
(2018-05-28, 04:15)Klojum Wrote:
(2018-05-28, 02:15)Yanta Wrote: Lol, no. The only part of my Kodi system which is not brand new is my case.
Not true... Windows 2012 r2 server? Undecided
10 seconds for a movie listing on a brand new machine?!?
I run a MySQL 5.5.x server on a six year old Celeron 1037 with a SSD running an old Ubuntu 14.04 setup. I get movie listings within a second.
Perhaps your 2012 server needs a revision?          
Ok. Some confusion here. There are TWO computers that make up the Kodi environment.

Windows 2012 R2 Server
10 x 10TB Seagate NAS drives (oldest is May 2017 - But Movies and TV are on drives that were purchased Nov and Dec 2017) - ST10000VN004
X99 Fatail1ty Professional Gaming I7 motherboard
I7-6900K CPU @4.20 ghz
32GB Corsair LPX DDR4-3200mhz RAM
Corsair H100i v2 Cooler
Fractal Design R5 White with rear, 2xfront, bottom and side fans
ASUS GTX 1060 strix 6GB graphics
Benq 27" 2K Monitor
Logitech G105 gaming keyboard
Razer Taipan Mouse White.
Samsung 950 Pro 512 M.2 PCIe NVMe boot drive
PSU: Corsair HX850i
Usage: WSUS, IIS7.5, MySQL latest, Firebird, Coldfusion 10 server, various web sites I've created, content storage, Macrium for back ups.
External Drives: 1 x 8TB Seagate NAS drive for backups.
Connectivity: Dual LAN Intel 1Gbps connects to Netgear Managed switch (Let's call it SW#1); LBFO; No NIC teaming.

Kodi Server
MSI Z370 SLI Plus (6 weeks old)
Intel I5-8600K CPU @4.0ghz (2 hours old); Was an I5-8400 (6 weeks old) until today.
Seagate desktop drive ST1000DM008 1TB for backups. (6 weeks old)
8GB Kingston HyperX 2666mhz DDR4 memory (2 hours old)
Corsair H115i 280mm Cooler
ASUS GTX 1050 Ti Strix 4GB graphics card
PSU: Corsair TX650M (6 weeks old)
Case: NZXT Phantom 820 w/front, rear, side and bottom fans (1 year old)
Boot Drive: Samsumg NVMe PCIe M.2 SSD 960 EVO 250GB (6 weeks old)
Keyboard, Mouse and monitor are shared with Windows 2012 R2 server via a HDMI switch (ATEN)
Connectivity: Connected to SW#1 (Same switch as Win 2012 R2 server) . Total cable length Kodi <--> Win 2012 - 4 meters.
OS: Windows 10 16299.431 (1709)
Usage: MySQL 5.5 & Kodi 17.6. Macrium for back ups. All MySQL databases and Kodi data are stored on the M.2 drive.
Total Kodi entries: Movies: 3556 (Still have about 200 to add). TV Shows and documentaries = 201 series. Total episodes over 10,000.
I haven't added music or photos yet, which is another 15,000 + files. 

When I said nothing was old I was referring to the Kodi server.

All Client PCs are running either I5-8600K/16GB DDR4-3200 or I9-7900X/32GB DDR4-3200 all with Samsung 1TB 960 Evo or 960 Pro SSDs.

I cant upgrade to Windows Server 2016 because it has some very specific hardware requirements which typically are not supported on Consumer hardware. I tried it but I could not get it to install, even with hacking INF files. Eventually I will upgrade to Linux, but it's largely irrelevant as this is a content storage system. The Kodi databases and library are on the second of the above 2 PCs.
Reply
#17
(2018-05-28, 08:11)Yanta Wrote: Intel I5-8600K CPU @4.0ghz (2 hours old)
Hehe, that's indeed not old, and quite an upgrade Smile

I'm no SQL expert at all, but what about the movie_view MySQL table? How many records are in there, and what is the query time when using an external MySQL tool (Workbench, PHPMyAdmin,etc). Surely not 10 seconds as well?
I get this result from my setup. Likely not the amount of movies in your collection, but a 'simple' query like this should be fast:
Code:
08:29:07 SELECT * FROM MyVideos107.movie_view 1263 row(s) returned 0,0020 sec / 0,064 sec (Duration/Fetch)
Reply
#18
(2018-05-26, 14:02)Gade Wrote: Hi Yanta.

I have no idea about your MySQL questions.

Regarding your watched movies disappearing from the home screen recently movies list:

Go to skin.rapier/extras/playlists/HomeRecentMoviesUnwatched.xsp
Remove line 5 + 6 + 7
Save the file

Note that you need to do this each time the skin is updated, as all content of the skin folder is overwritten.
And I always encourage everyont to keep the skin updated at all times.
 @Gade : This did not work. I just watched a movie and it disappeared from my home screen recently added. here is the whole XML file..

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<smartplaylist type="movies">
    <name>HomeRecentMoviesUnwatched</name>
    <match>all</match>
    <limit>20</limit>
    <order direction="descending">dateadded</order>
</smartplaylist>
Reply
#19
(2018-05-28, 08:33)Klojum Wrote:
(2018-05-28, 08:11)Yanta Wrote: Intel I5-8600K CPU @4.0ghz (2 hours old)
Hehe, that's indeed not old, and quite an upgrade Smile

I'm no SQL expert at all, but what about the movie_view MySQL table? How many records are in there, and what is the query time when using an external MySQL tool (Workbench, PHPMyAdmin,etc). Surely not 10 seconds as well?
I get this result from my setup. Likely not the amount of movies in your collection, but a 'simple' query like this should be fast:
Code:
08:29:07 SELECT * FROM MyVideos107.movie_view 1263 row(s) returned 0,0020 sec / 0,064 sec (Duration/Fetch)
 
 I don't doubt that an SQL statement like above would be quick. The problem is it isn't real world.

I click on Movies. The screen shows background, then when loaded the posters are eventually displayed. I am using Thumbs Info view. When I switch to List view it is faster.

Having upgraded from I5-8400 to I5-8600K with faster memory it's now down to 3 seconds, which is what I see on all 8600K's.
Reply
#20
(2018-05-31, 05:51)Yanta Wrote:
(2018-05-26, 14:02)Gade Wrote: Hi Yanta.

I have no idea about your MySQL questions.

Regarding your watched movies disappearing from the home screen recently movies list:

Go to skin.rapier/extras/playlists/HomeRecentMoviesUnwatched.xsp
Remove line 5 + 6 + 7
Save the file

Note that you need to do this each time the skin is updated, as all content of the skin folder is overwritten.
And I always encourage everyont to keep the skin updated at all times.
 @Gade : This did not work. I just watched a movie and it disappeared from my home screen recently added. here is the whole XML file..

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<smartplaylist type="movies">
    <name>HomeRecentMoviesUnwatched</name>
    <match>all</match>
    <limit>20</limit>
    <order direction="descending">dateadded</order>
</smartplaylist>

Did you restart Kodi or reload the skin after you saved your changes?
Reply
#21
Yes, I did this on each client PC and on the Kodi Server several days ago. All of them have been shutdown/restarted each day.
Reply

Logout Mark Read Team Forum Stats Members Help
Separate watched status per client0