Menu
Is there a way/tool/technique to calculate the processor and memory cost of a specific MySQL query?
348
Mysql Server Memory Usage = Sum of Global Buffers + (number of Connection * Per thread memory variables). Global buffers include: key_buffer_size: key_buffer_size is the size of the buffer used for index blocks.
You can use Performance Insights to identify the exact queries that are running on the instance and causing high CPU usage. First, activate Performance Insights for MySQL. Then, you can use Performance Insights to optimize your workload. Be sure to consult with your DBA.
The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of RAM. You can improve MySQL performance by increasing the values of certain cache and buffer-related system variables.
Check this sample:
sample at mysql.com
85
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
