Re: I use MySQL connectorl and after some time it stops. PLEASE HELP

[Chuck Bell]

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.