Hi, I wrote a simple program in Lazarus that queries a remote MySQL database repeatedly over and over again every 10 seconds. After letting it run for about an hour, I noticed that the values I was receiving didn't match the current values in the database and at times the connection to the database from Lazarus program would completely disconnect. I don't understand.
Is this because of too many cached threads in the memory overloading the MySQL Server?
Could it be memory leak?
Do I have to clear the cache every time?
Or should I wait longer before initiating another MySQL Query?
Any hints or clues or help will be extremely appreciated. Thank you.
Sorry what you describe is a bit out of the normal behavior.
As far as I know there is no limit on how many times or how often a query can be executed.
In some situations, depending on the transaction isolation level and the time the query is open you might get values that are out of sync with the database but that should never happen in a newly executed query unless you are using a single transaction for all your queries in which case try to use different transaction for each query.
In any case please provide a small sample application that demonstrates the problem so we can analyse and see where is the problem.
Recent
