Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - phenigma

Pages: 1 ... 61 62 [63] 64 65 ... 69
Installation issues / Re: 0810 and Hauppauge HVR-4000
« on: November 26, 2009, 10:24:31 pm »
Sounds like a udev rules issue.  Unfortunately that's all the insight I can offer because I've never had the need to investigate udev rules myself.

My understanding is that udev populates the links automatically based on detected hardware and may simply not be aware of what to do with your card.  I believe you may simply have to tell udev what to do with your card...  But again I've never investigated this further.  Something to investigate.


How are you determining the amount of cache space consumed by the query?

You can monitor the status of the query cache like this:
Code: [Select]
mysql> SHOW STATUS LIKE 'Qcache%';
| Variable_name           | Value    |
| Qcache_free_blocks      | 16       |
| Qcache_free_memory      | 13297728 |
| Qcache_hits             | 57112    |
| Qcache_inserts          | 5118     |
| Qcache_lowmem_prunes    | 0        |
| Qcache_not_cached       | 31260    |
| Qcache_queries_in_cache | 1951     |
| Qcache_total_blocks     | 3978     |
8 rows in set (0.00 sec)

And with out the filter you can see more mysql information.
Code: [Select]
I would have assumed that the query to create the collection of files would not have also retrieved the artwork. Only once Orbiter determines how many and which files are needed for the onscreen grid would it then query and return the artwork for those files only. In which case the artwork assigned shouldn't matter.....

Yes, you are correct as far as I can tell.  I don't see this being artwork related with the behaviour I'm observing.


Okay, the two queries are large but I see what they're doing, they're too large to post here so I've put them on pastebin.

The audio query results from mysql-slow.log show each query took 6 seconds to execute:
# Time: 091117 19:44:46
# User@Host: root[root] @ localhost []
# Query_time: 6  Lock_time: 0  Rows_sent: 627  Rows_examined: 117280

The video query from mysql-slow.log:
# Time: 091117 19:44:56
# User@Host: root[root] @ localhost []
# Query_time: 6  Lock_time: 0  Rows_sent: 8594  Rows_examined: 954413

The audio query results of the EXPLAIN EXTENDED & SHOW WARNINGS>
The video query results of the EXPLAIN EXTENDED & SHOW WARNINGS>

The audio and video query results clearly show temporary tables being used rather than indexes.


Predominantly my Windows Orbiter.

The behaviour:
device, time uncached, time cached
WinOrbiter, ~7s, <1s (UI1)
Nokia N800, ~10s, ~3s (UI1)
WebDT 366, ~7s, ~2s (UI1)
p42.8 Core, ~7s, <1s (UI2 mask)
Zotac ION MD, ~7, <1s (UI2 mask)

When the query is executed and not present in the cache, top shows mysql using 90-100% of the processor for nearly the entire 7s time period, and it doesn't even show up as a blip in top when the query is in the cache.  I'm about to investigate some of the slow query logging options Viking pointed out and see what I can find out.


Artwork may be a contributing factor then, almost all of my media has artwork.  I can see the memory being allocated for the query in mysql when I select Audio or Video button in orbiter (takes ~7s).  The Audio query occupies a about 570Kb in the cache on my system.  I return to the home menu and select audio, the artists now display in about 0.5s.  As I monitor the cache in mysql after a couple minutes a 570kb chunk is freed from the cache memory.  Selecting audio again takes ~7s and about 570kb is added to the query_cache.  Mysql is abosolutely removing the query from the cache every few minutes on my system.  I'm not home from work yet but I'm going to dig around a bit more when I get home.


Thanks Viking, I'll do some more investigating when I get home from work.


Without actually looking, I think I have about 600 videos and around 800 or 900 artists in my audio folders.

The response time is the same regardless of the orbiter I use (n800,webdt,onscreen), UI1 or 2, core or MD.  It takes about 7 seconds from click/touch to display of the datagrid.  When I do this the query is cached by query_cache in mysql and choosing audio/video again immediately is very responsive from click/touch to display of the datagrid, 0.5 seconds on my windows orbiter to about 3 seconds on my WebDT.  Response is the same now as it was under 0710, I'm currently running 0810 Alpha 2.37.

The responsiveness lasts for a couple minutes, until the query is removed from the cache, and then it takes about 7 seconds to re-rerun the query and re-store the results in mysql query_cache for another couple of minutes.  I can only assume that UpdateMedia is writing to the table but I'm speculating.


I was looking at query_cache a little last night.  Most of the use/config seems transparent and efficiencies come by writing less frequently to tables.  Essentially a cached query is dropped from the cache when a write is made to a table used in the cached query.

Example: Queries that bring up the Audio/Video file lists from orbiter execute in about 7s when not in the query_cache and in about 0.5s when they are in the query_cache (on my system).  Some of these large queries are not cached for enough time (because of a write to a table used in the query) to make them really useful (like the audio/video file lists).  Update media may be writing to the media tables even when media has not changed, which is clearing these queries from the cache (I havn't even begun to look at updatemedia).

I have not looked past this yet but was intrigued by the initial improvements from Viking's index additions and did a little bit of poking around.


Installation issues / Re: beta-problem with MD
« on: November 16, 2009, 04:41:43 pm »
Any idea when the 810 beta 2 will be released? As I understand it that version is supposed to fix some of the issues that are in the 810 beta relating to MKV playback.

The devs have been working extremely hard to quash some large bugs and overcome issues introduced by changes in third party repositories.  I am certain that as soon as a viable dvd install is ready the next beta will be announced and released.


I tried this on my production system with about 41000 rows in the pluto_media table.

The indexes have reduced the period of time mysqld pegs my processor at 100%.

I monitor my core with monitorix and rrdtool, it's a P4 2.8G hyperthreaded cpu with 1GB ram.  It looks like adding the indexes created an average reduction of ~7% kernel usage, load average has dropped from about 1.0-1.1 average to 0.6-0.7 average.  IOWaits have also been cut in half of what they were.  The one day change is noticeable looking at my week and month summary charts.  I'm going to keep my eye on it to see if it's consistent.


Users / Re: MD Question
« on: November 14, 2009, 06:19:10 pm »
Just as Andrew says.

I really like my Zotac ION 330, VGA, DVI, HDMI, Optical Digital.  I have not tried the HDMI video or Audio myself but others have here on the forums.  Netboots without a HD, quiet (the 330 DOES have a heatsink fan,  but its quieter than my PS3 at idle), low power consumption (~24Watts idle, ~26 Watts in 1080P decode with VDPAU).  I highly recommend it.

The Acer Aspire Revo is a really nice unit in a great VESA mountable form factor with a hard drive and ION graphics, the only reason I didn't go with the Revo was that it did not support the optical digital output I currently use for audio.

I highly recommend an ION based system for a Media Director for use with HD content in a small form factor.


Installation issues / Re: DVD vs CD Installation
« on: November 14, 2009, 05:57:21 pm »
How should I install a core system with the new linuxMCE distribution (I have some previous experience in installing 710 version).

There is currently no option to install a core only system.  You may be able to install a complete hybrid and then turn off the media-director portion of the system in pluto.conf.  I think that many people are simply installing a hybrid with UI1.


Users / Re: takes a lot of CPU
« on: November 13, 2009, 06:18:45 pm »
I have noticed that on my system /usr/pluto/bin/ takes a lot of CPU.

Have you checked to see if more than one copy of the script is running?  I had this issue after an update about a month ago and found that 2 copies of the script were launched.  I did a 'sudo kill xxxx' to kill the 2nd process and my CPU usage dropped to normal levels.  I think I performed a re-install and the problem did not return afterwards so I am unsure what caused the 2nd script to be executed in the first place.  If I recall correctly I had 2 copies of many things that launched erroneously on boot during that time period.


Users / Re: Some technical questions about the graphical resolution.
« on: November 13, 2009, 01:53:01 pm »
Would there be any incompatibility using the 2.28 kernel (from jaunty)? On another partition i tested kubuntu 8.10 with 2.28 kernel and got hdmi audio working.....
TIA, Paulo

I don't know enough about your graphical issues/questions to comment right now, but I am running kernel 2.6.31 on an MD and have had no problems/issues/conflicts of any kind.


Users / Re: Mythtv problems in 810 beta
« on: November 03, 2009, 11:21:15 pm »
2009-11-03 15:12:53.708 Source 1 configured to use only the broadcasted guide data. Skipping.

Run mythtv-setup from the computing menu and make sure you have your source configured properly.  Mythfilldatabase doesn't think you have an external epg source defined.


Pages: 1 ... 61 62 [63] 64 65 ... 69