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  2011  2012  2013  2014  2015  2016  2017  <20182019  2020  Index 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  <20182019  2020 
<== Date ==> <== Thread ==>

Subject: Question about store array in MySQL by using RDB Channel Archive
From: lzf neu <lzfneu@live.com>
To: "tech-talk@aps.anl.gov" <Tech-talk@aps.anl.gov>
Date: Tue, 17 Jul 2018 02:58:46 +0000
Hi all,
    I have two questions to consult you:
    1) There is a waveform array contains 1560 double type elements, I want to store them in mysql in real-time by using ArchiveEngine. To do so, I have imported the mysql_schema.sql in the attatchment and then start the ArchiveEngine.  However, when performing "select * from sample" command in mysql, only one data are in "float_val" column. It seems mysql cannot store array directly. Could any one tell me how to store array in MySQL by using RDB Channel Archive.

    2) For testing the performance of ArchiveEngine with diffenet parameters (write_period, batch_size, buffer_reserve) versus write speed (samples per second), could any one tell me how to record the writing speed of ArchiveEngine with above parameters.

    Any help will be appreciated and thanks in advance !

    Zhefu

Attachment: mysql_schema.sql
Description: mysql_schema.sql


Replies:
Re: Question about store array in MySQL by using RDB Channel Archive Kasemir, Kay

Navigate by Date:
Prev: Re: caget randomly returns Channel connect timed out Matt Rippa via Tech-talk
Next: Re: caget randomly returns Channel connect timed out Dirk Zimoch
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  <20182019  2020 
Navigate by Thread:
Prev: EPICS Mailing Lists Configuration Changes Andrew Johnson
Next: Re: Question about store array in MySQL by using RDB Channel Archive Kasemir, Kay
Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  <20182019  2020 
ANJ, 17 Jul 2018 Valid HTML 4.01! · Home · News · About · Base · Modules · Extensions · Distributions · Download ·
· Search · EPICS V4 · IRMIS · Talk · Bugs · Documents · Links · Licensing ·