General Log Analysis is ordered per two hour block, paid when ordered, to look for anything to expedite completion of your queries, including release of resources. 1 unit of 2 HOURS is the minimum to be ordered for this effort. Please make Skype TALK or telephone contact prior to ordering this service to review your scope of analysis requirements.
Please, include initial SHOW FULL PROCESSLIST; in your data submitted. This should be acquired just BEFORE you SET GLOBAL general_log=1;
You select 400 lines (or 15 SECONDS general_log for release of resources analysis) for analysis. Discard head and tail prior to submission.
Please, include ending SHOW FULL PROCESSLIST; in your data submitted. This should be acquired just AFTER you SET GLOBAL general_log=0; (for OFF and never forget to turn off GL to avoid filling your media).
Please, include your error log for the complete day's activities, in your email to firstname.lastname@example.org, please.
If we are trying to verify release of resources, please provide your PHP or Java or whatever code is used to 'connect' to MySQL through the 'end of the cycle' serving your customer. In PHP after connect, processing requests, close function should be paired by the time you are done with your client's activities.
Post all data to be considered to pastebin.com or similar text storage facility and provide just the links in your email, please.