General Log Analysis is ordered per four-hour block, paid when ordered, to detect possible alternatives to expedite completion of your queries, including release of resources. 1 unit of 4 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 A) SHOW FULL PROCESSLIST; and B) SHOW ENGINE INNODB STATUS; in your data submitted. This should be acquired just BEFORE you
SET GLOBAL profiling=1; to turn ON profiling while GL is on
SET GLOBAL general_log=1;
Allow 15 seconds minimum of recording to the log.
SET GLOBAL general_log=0; BEFORE you forget and FILL your media
SET GLOBAL profiling=0; to turn OFF profiling and conserve CPU
FLUSH LOGS; to clear the logging details from buffers to your file storage
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 A) SHOW FULL PROCESSLIST; and B) SHOW ENGINE INNODB STATUS; and C) SHOW PLUGINS; and D) STATUS; 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 and Slow Query Log for the complete day's activities.
If we are trying to verify the 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 connecting, processing requests, the close function should be paired by the time you are done with your client's activities.
Make the Subject of your email INVOICE/ORDER #(assigned at purchase), please so we know which INVOICE/ORDER # your data is to be associated with for analysis, please.
Attach all text data, images, and your day's Error Log and day's Slow Query Log to be considered in your email(s) to email@example.com, please.