Serious Slowdown

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 1:16 pm

ok i will do that is there a quick way to wipe them out or do i have to do it the hardway (ie i need to keep a week and a bit but the rest can go)

I will stop those filters when done, but if they or mysql were a problem wouldnt the ybe showing up in top?

Post by **zoneminder** » Wed Dec 07, 2005 1:19 pm

Try stopping zmaudit and zmfilter as the first things as they are the elements that browse the db and filesystem. They may not show up in top if they are just waiting for queries to report or something else in the kernel to return.

The quickest way to delete events is via the DB (though you will need zmaudit running to tidy up the files).

Phil

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 1:23 pm

im looking now at the console of it and i have approx 72000 events listed (all mocord or record events)
load 16.39 Dsik 95%

It is working and not dropping but it has no idle time.
Im gonna try the things you said but i thought id add a little more info

Im gonna build another monster to replace this one (this time amd) to compare and to see if its a machine issue. But im only gonna put 320Gb in this one instead od 1000Gb.

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 5:20 pm

Code: Select all

Command history 
> /usr/bin/zmdc.pl stop zmfilter.pl
Can't find process with command of 'zmfilter.pl'
> /usr/bin/zmdc.pl stop /usr/bin/zmfilter.pl
Invalid daemon '/usr/bin/zmfilter.pl' specified at /usr/bin/zmdc.pl line 118.

I cant seem to stop these filters. But i think your right as i changed the purge when full to 50% and it got worse i assume having to run through all the events

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 5:29 pm

now this..

Code: Select all

> /usr/bin/zmdc.pl stop zmaudit.pl
DBI connect('database=zm;host=localhost','viseon',...) failed: Lost connection to MySQL server during query at /usr/bin/zmdc.pl line 66
Can't call method "prepare_cached" on an undefined value at /usr/bin/zmdc.pl line 68.
BEGIN failed--compilation aborted at /usr/bin/zmdc.pl line 76.

i is getting scared! Lol

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 7:53 pm

ok then this is wierd i have put all monitors to none and the zma and zmc stayed in the queue
I stopped and started zm and they disappeared
But my proc is still only 1.8% idle
but the load is down to 4
i am gonna leave the montors to non and see what happens
i thinj its a zmaudit issue as zm filter kept on dleting events and db contains about 2 days worth now but the disks are still at 96%

ill give it 10 mins

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 9:59 pm

should i be worried about this

> iostat -k
Linux 2.6.12-oci4.mdk-i686-up-4GB (localhost) 12/07/05

avg-cpu: %user %nice %sys %iowait %idle
20.63 0.01 15.43 63.58 0.35

Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
hda 85.38 295.11 167.18 1882557 1066488
hdc 70.92 271.25 97.05 1730340 619120
md0 385.05 1113.30 427.62 7101813 2727796
sda 72.38 276.86 96.52 1766132 615684
sdb 72.34 277.30 95.19 1768924 607204

I have disabled all monitors and deleted most of the events and am now waiting for zmaudit to clean the drives??

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 10:27 pm

im starting to think my problem is very poor disk through put, i have manually deleted a load of events and im waiting for that to complete and accoring to iostat im shifting 1000k per second which has got to be wrong ...surely

victor_diago · Post by **victor_diago** » Wed Dec 07, 2005 10:29 pm

In this case you should check the disk parameters with hdparm.

What do hdparm say ?

Victor Diago

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 10:31 pm

if i knew what they were id let you know....

What hdparm?

victor_diago · Post by **victor_diago** » Wed Dec 07, 2005 10:39 pm

Ok .

man hdparm.

Hdparm is a tool that can configure some lowlevel parameters of the HD, like how much sectors to read at once and set those to get higher performance.

try to look http://www.linuxdevcenter.com/pub/a/lin ... dparm.html

This should help you.

Also, ensure that you are using a good filesystem. i use reiserfs and have no problem at this.

I will also ask you as ive saw that you understand a lot about cameras... i have a color ccd camera with a stabilized power supply that provide 12v and 500ma to only one camera. My image is pretty under television but when i put it in the BTTV capture card, man the image is terrible.

i got lines dancing on the image horizontally and the image is pretty dark. i also have other 3 cameras BW in the same capture card and the image of them is VERY good.

Do you have a clue about what could it be ?

Thanks for now

Victor Diago

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 10:42 pm

my first suspect would be the input on the card
also you say the image is dark, id check that it is temrinated correctly ie 75 Ohm and not double terminated somewhere.

But onto the first have you plugged anything else into that port on the card just to test the port. And did you reterminate the coax after removing it from the tv?

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 10:46 pm

ok then did the hdparm thing

> hdparm -Tt /dev/md0

/dev/md0:
Timing cached reads: 908 MB in 2.03 seconds = 447.14 MB/sec
Timing buffered disk reads: 276 MB in 3.01 seconds = 91.65 MB/sec

now then im quite impressed by 92 meg a second but maybe im reading it wrong

victor_diago · Post by **victor_diago** » Wed Dec 07, 2005 11:16 pm

Hi, i know that im bit stuppid, but.

How damn i terminate that ? what is terminate ? its a kind of magic ?

Thanks for now

Victor Diago

jameswilson · Post by **jameswilson** » Wed Dec 07, 2005 11:24 pm

all composite cameras must be 'terminated' at both end at 75 Ohms (impedance not resistance)
The camera will already have its 75 ohm termination.
then the last device in the chain should also be terminated, thats why on professional kit you will see looping connections (video in / out ) and a termination switch (usally marked 75 ohm and Hi z for un terminated. If you have 2 devices that are terminated it will seriously mess with the video signal. I think that the capture cards have termination in them (i dont know yet how to turn it off without a soldering iron)

But simply if you have 1 camera going to 1 input on a capture card and no other devices in the way (monitor tv, switcher etc) you should be ok. Double check your bnc is made of correctly but if it worked on your telly id suspect the card