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: October 31, 2016 05:58PM

The most likely causes for lockups are, in this order:

1. Low memory from memory leaks, sketch too large, memory overrun (underrun), etc.

Try checking for memory leaks and/or monitor memory usage. Fix any memory leaks and issues with memory (e.g. arrays).

2. Data transfer rate is too high or transmitting too much data at one time.

Try slowing the sampling rate and reducing the amount of data transferred each trip. Remember, the Arduino is a very slow microprocessor and not a PC. Plus, the hardware in general is slower. For example, some WiFi and Ethernet shields are slower than you may expect. Save only the data needed such as raw data values and reserve aggregation (sum, average, etc.) for the database server.

3. Query results - there are unread query results or errors in query processing.

Make sure you read all of the results from a query that returns data before running the next query.

4. Network issues

If your network is slow or can have drops or other periods of instability, you must change your sketch to detect when the connection drops and reestablish the connection. See the docs for an example of the connect/disconnect technique.

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 248 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 250 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 66 Daniel Wee 02/12/2017 05:11AM
Re: I use MySQL connectorl and after some time it stops. PLEASE HELP 14 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.