Argonne National Laboratory

Experimental Physics and
Industrial Control System

1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  <20062007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  Index 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  <20062007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017 
<== Date ==> <== Thread ==>

Subject: Re: Logging to MySql / relational databases
From: Don Dohan <dohan@aps.anl.gov>
To: barleyguy@mail.sisna.com
Cc: tech-talk@aps.anl.gov
Date: Mon, 18 Dec 2006 15:56:08 -0600
Harley:

The IRMIS RDB application suite stores time stamped EPICS process variables, along with their DBD definitions. A background crawler updates the RDB after each IOC reboot.

At the APS, we use MySQL; other laboratories have run the application on Oracle. Currently we have ~|550,000 PVs.

The latest tarball can be found at the EPICS web site, click on the IRMIS tab.

Don Dohan

Harley N wrote:
I have an Epics database used for displaying a fairly large numeric dataset with a refresh time of roughly 30 seconds. I'd like to create a time based log in a relational database, preferably MySql. The old version of this system is using VSystem and VLog, which works but has bad performance when doing queries.

Are there any premade utilities for logging changes of an Epics dataset to MySql? Or could someone point me in the right direction for where to find tools for logging to a relational database?

Thanks,

Harley.
barleyguy@sisna.com
_________________________________
SISNA...more service, less money.
http://www.sisna.com/exclusive/

References:
Logging to MySql / relational databases Harley N

Navigate by Date:
Prev: Logging to MySql / relational databases Harley N
Next: Re: USB interface with EPICS Till Straumann
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  <20062007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017 
Navigate by Thread:
Prev: Logging to MySql / relational databases Harley N
Next: Channel Access and Tcl John Dobbins
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  <20062007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017 
ANJ, 02 Sep 2010 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·