mysql insert values not updating after some hours?

To solve this problem we need see to issue timeout period of mysql and closing jdbc connections correctly which was opened in programs like ajax pages ..

1)
" put these lines in /etc/mysql/my.conf
under
[mysqld]
#waiting time increase to 24 hour------------
interactive_timeout=86400
wait_timeout=86400 "

This way increase your inactive time to 24*60*60 seconds=1 day

2)

In the ajax pages the data continuously updates to the page by opening the database connection ,we should close this connection after use otherwise it will become leak and total heap will occupy finally blocks you to run the java application

To analyse the leaks use any heap analyser tools example eclipse workbench memory analyser(mat)

download from this link http://www.eclipse.org/mat/downloads.php

and analyse the heap fix the leaks

This steps solved by problem

Browse More Popular Posts

Leave a Comment