Category: MySql Toolbox
-
How to improve mysql performance using CACHING
A deep analisys of a performance bottleneck could be long and is based on different kind of data (OS metrics, IO performance tests, DB wait stats and so on…). Before starting with this (or simply after a new delivery) some simple checks could help you to correct rapidly some of the common (and bigger) bottlenecks…
-
Queries to see rapidly what your MySql is doing NOW
Those queries are useful to admin MySQL instances using mysql client. 1) Check active processes/connections running mysql> show processlist; the previous statement doesn’t show all queries text running. To see the complete statements running use: mysql> show processlist; –or– mysql> show full processlist G; the running queries statements could bee quite long. Use the “G”…