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 300 seconds (5 minutes) 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 300 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 mydatalinks@mysqlservertuning.com, please.
-----------------------------------
This GLA-DWN-BEF.bat script may work for you, if you connect to your instance with root login.
# If Linux OS, adjust the folder/directory path for your tee output destination.
# Change the ccyymmdd-hh-mm to your current
# century,year,month,day,hour,minute such as 20220320-0921
tee c:/temp/ccyymmdd-hhmm-GLA-BEF-tee.txt;
SELECT NOW();
SHOW FULL PROCESSLIST;
SHOW ENGINE INNODB STATUS;
SELECT NOW();
notee;
end of script example.
--------------------
This GLA-DWN-AFT.bat script may work for you, if you connect to your instance with root login.
# If Linux OS, adjust the folder/directory path for your tee output destination.
# Change the ccyymmdd-hh-mm to your current
# century,year,month,day,hour,minute such as 20220320-0926
tee c:/temp/ccyymmdd-hhmm-GLA-AFT-tee.txt;
SELECT NOW();
SHOW FULL PROCESSLIST;
SHOW ENGINE INNODB STATUS;
SHOW PLUGINS;
STATUS;
SELECT COUNT(*) FROM information_schema.tables;
SELECT NOW();
notee;
end of script example.
--------------------------
2023 Nov 16 added
Global Variable formula/algorithm is ordered as two (2) four-hour blocks for each GV, paid when ordered.
Information required includes:
SELECT @@global_variable; __________________________ such as innodb_buffer_pool_size or max_connections and the
__________________________ current value displayed.
Server RAM available ______,
CPU/Core count _____,
Data Storage type HDD, SSD or NVME ______,
SELECT @@version; ____________________,
SELECT @@version_comment; ____________________,
--------------------------
