MySQL Forums :: Connector/Arduino :: I use MySQL connectorl and after some time it stops. PLEASE HELP


Advanced Search

Re: I use MySQL connectorl and after some time it stops. PLEASE HELP
Posted by: Chuck Bell ()
Date: November 07, 2016 08:18PM

Hi,

Answers assuming context...

1) Use a trigger.

2) The timing will depend on many factors. 5-10 seconds should be enough, but again, consider using slower sampling rates. Think minutes instead of seconds and consider using the connect/disconnect technique.

3) Yes. 500-1000 should be Ok. Start out slow then increase (decrease the delay) the speed as your sketch becomes stable over time.

4) On the surface, it looks fine but again, you should consider storing only the values you need and move all calculations to the database server.

5) Not really. You can use a technique to soft boot the Arduino. See http://playground.arduino.cc/Main/ArduinoReset.

6) No issue there, but that is an initial state. Memory leaks can cause sketches to lockup too. You should consider monitoring memory using a technique like http://playground.arduino.cc/Code/AvailableMemory.

7) I don't understand this question. It would help if there were an example posted to see what is happening. As a guess (only a guess), it is possible your query is sending the data incorrectly. Again, narrowing the size of the query string itself will help. Hint: don't use a column list.

Options: ReplyQuote


Subject Views Written By Posted
I use MySQL connectorl and after some time it stops. PLEASE HELP 326 César Sebastián Silva Proaño 10/31/2016 03:42PM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 249 Chuck Bell 10/31/2016 05:58PM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 192 César Sebastián Silva Proaño 11/01/2016 05:57AM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 251 César Sebastián Silva Proaño 11/01/2016 07:27AM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 190 Chuck Bell 11/07/2016 08:21PM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 166 Chuck Bell 11/07/2016 08:18PM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 140 Daniel Wee 12/10/2016 10:25AM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 179 Chuck Bell 12/12/2016 12:51PM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 111 Daniel Wee 02/04/2017 04:48AM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 105 Daniel Wee 02/04/2017 05:26AM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 117 Chuck Bell 02/07/2017 09:02AM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 74 Daniel Wee 02/07/2017 11:01AM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 67 Daniel Wee 02/12/2017 05:11AM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 15 Chuck Bell 04/20/2017 11:39AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.