EPICS Home

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  2018  2019  2020  2021  2022  2023  2024  Index 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  <20062007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  2023  2024 
<== Date ==> <== Thread ==>

Subject: Re: Logging to MySql / relational databases
From: Don Dohan <[email protected]>
To: [email protected]
Cc: [email protected]
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.
[email protected]
_________________________________
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  2018  2019  2020  2021  2022  2023  2024 
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  2018  2019  2020  2021  2022  2023  2024