Timeline for CPU,Memory and disk I/O utilization for each query in mysql
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 12, 2018 at 6:26 | history | edited | Pankaj Kumar | CC BY-SA 3.0 |
added 301 characters in body
|
| Mar 12, 2018 at 5:51 | comment | added | Pankaj Kumar | Now set maximum profiling SET profiling = 100 Now you can find query ID and running sql query by SHOW PROFILES; If you want to check in detail for any query, run this query- SHOW PROFILE FOR QUERY QueryID; If you want to check CPU USAGE for any query, run this query- SHOW PROFILE CPU FOR QUERY QueryID; | |
| Mar 12, 2018 at 5:51 | comment | added | Pankaj Kumar | -- ALL displays all information -- BLOCK IO displays counts for block input and output operations -- CONTEXT SWITCHES displays counts for voluntary and involuntary context switches -- CPU displays user and system CPU usage times -- IPC displays counts for messages sent and received -- MEMORY is not currently implemented -- PAGE FAULTS displays counts for major and minor page faults -- SOURCE displays the names of functions from the source code, together with the name and line number of the file in which the function occurs -- SWAPS displays swap counts | |
| Mar 12, 2018 at 5:50 | comment | added | Pankaj Kumar | SHOW PROFILES displays a list of the most recent statements sent to the server. The size of the list is controlled by the profiling_history_size session variable, which has a default value of 15. The maximum value is 100. Setting the value to 0 has the practical effect of disabling profiling. Optional type values may be specified to display specific additional types of information: | |
| Mar 9, 2018 at 14:18 | comment | added | sreekanth | Thank for information pankaj kumar. My doubt is does mysql stores these information in any tables or views?? Lets take an example I have ran a query before two days. How can I get the details like how much memory been utilized for the query when I had executed it. | |
| Mar 9, 2018 at 9:32 | history | edited | Pankaj Kumar | CC BY-SA 3.0 |
How ever you may find more command
|
| Mar 9, 2018 at 7:53 | review | First posts | |||
| Mar 9, 2018 at 8:11 | |||||
| Mar 9, 2018 at 7:51 | history | answered | Pankaj Kumar | CC BY-SA 3.0 |