This is supposed to be an easy, universal solution, although the problem is currently related to the IIS CGI application, which should record the timeline of events (second resolution) to troubleshoot a situation where a later query ends in the MySQL database BEFORE the previous query!
Thus, it comes down to logging debug statements in a single text file.
I could write a service that manages the queue, as suggested in this thread: The problem of writing a single file to a web service in .NET, but deploying the service on each machine is a pain
or I could use a global mutex, but for this each instance would have to open and close the file for each entry
or I could use a database that would handle this for me, but it doesn't make sense to use a database like MySQL to try to fix a history issue. SQLite is another feature, but this thread
http://www.perlmonks.org/?node_id=672403
Suggests that this is also a bad choice.
I'm really looking for a simple approach, something as rude as writing separate files for each process and consolidating them using a planned application. I do not want to do this, and do not spend a week on this. This is only necessary from time to time.
Suggestions?
source share