EPICS Home EPICS Controls Argonne National Laboratory

Experimental Physics and
Industrial Control System

Format page
for printing


Search Tech-talk
1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  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  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  <2018>  2019  2020  2021  2022  2023  2024 
<== Date ==> <== Thread ==>
Subject: Question about store array in MySQL by using RDB Channel Archive
From: lzf neu <[email protected]>
To: "[email protected]" <[email protected]>
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  <2018>  2019  2020  2021  2022  2023  2024 
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  <2018>  2019  2020  2021  2022  2023  2024 
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 ·