
May 16th, 2007, 03:24 PM
|
|
Registered User
|
|
Join Date: May 2007
Posts: 1
Time spent in forums: 6 m 16 sec
Reputation Power: 0
|
|
|
Changing MySql server settings while installation
Hi,
I have a windows application built using MFC VC++ 6.0 and using MySql as back end database. My application is multithreaded and does huge number of inserts on the database. It continuously keeps running and randomly it was throwing a run time error since the connection to the MySQL Server was being lost.
I used MySQL Administrator to adjust the connection- timeout and made it 30 sec. After that it stopped throwing that error! I do not know how it affected the issue since I make the connection only once during the start up code of the application. Once the connection is made it is never closed until the user closes the application.
However, now that I found a work around for my problem, I would like to hard code this server setting in some way, either in my C++ code or in some script that is run automatically when the customer/user installs the MySQL server, so that it doesnt have to be changed manually later.
Please give me some suggestions as soon as possible.
Thank you very much.
|