EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

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

Subject: SNS CSS Message RDB
From: John Dobbins <[email protected]>
To: EPICS Tech-Talk <[email protected]>
Date: Wed, 01 Jun 2011 12:00:58 -0400
CSS Folks,

The SNS CSS MessageRDB has MySQL sample tables found in:

org.csstudio.sns.jms2rdb/dbd/MySQL-Log-DDL.sql

This includes the following text:

# NOTE:
# The msghist tool uses subselect queries as shown below
# to do a full search for properties that are not optimized
# as MESSAGE columns.
# Those subselect statements only work in MySQL 6.x.
# MySQL 5.x will just hang forever in them as soon as there
# are a few rows in the MESSAGE* tables

I am confused about MySQL versions referenced here. The latest stable version appears to be 5.5? Can you clarify?


BTW: I was able to download and build SNS CSS sources for the purpose of trying out BEAST. Considering the number of steps involved

1) operational mysql RDB configured with Alarm tables
2) operational Java Message Service
3) working Eclipse installation
4) download Control System Studio source and build
5) configure Alarm RDB using AlarmConfigTool (a CSS product)
6) run AlarmServer (another CSS product)
7) run CSS with AlarmTree and Alarm Table plug-ins

I thought things went remarkably smoothly. So thanks for that!


John Dobbins

Cornell Laboratory for Accelerator Sciences and Education (CLASSE)
Cornell University

Replies:
Re: SNS CSS Message RDB Kasemir, Kay

Navigate by Date:
Prev: Chjannel Access Client for Twitter John Quintana
Next: RE: EPICS on Delta Tau Power PMAC Mark Rivers
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  <20112012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  2023  2024 
Navigate by Thread:
Prev: Re: EPICS on Delta Tau Power PMAC Bill Lavender
Next: Re: SNS CSS Message RDB Kasemir, Kay
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  <20112012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  2023  2024 
ANJ, 18 Nov 2013 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·