…. How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc… 0 # Users user # Query_time distribution # 1us # 10us # # 100us ################################################################ # 1ms ############# # 10ms ###### # 100ms # # 1s # 10s+ We can see this query takes 2ms to respond… needs an increase. The query time distribution histogram is also very interesting here we can see this query which analyzes no more than…

… MySQL version, unless you have very detailed automated QA. So what you can do is get the backup of the database and get query log (you can use mk-query-digest with tcpdump to sniff out queries if… will run SELECT queries on both new and old MySQL installations and check result set, explain plan and execution time, reporting you on…

… in MySQL. This is very helpful for measurement as otherwise we might not catch some long running connections. Now let’s get… this in the slow query log: # Time: 111229 3:02:26 # User@Host: msandbox[msandbox] @ localhost [] # Query_time: 2.365434 Lock_time: 0.000000 Rows… where this query was executed. Next the “Query_time distribution” section shows how this query times mostly, which you can see majority of the time lies…

… the table I get the following record in the slow query log: # Time: 120911 17:18:05 # User@Host: root[root] @ localhost [] # Thread_id: 65005 Schema: sbtest Last_errno: 0 Killed: 0 # Query_time… returned up to the top level MySQL part for processing are counted the …

…get query result which is up to 60 stable. We can also get query…queries, for which tracking exact rows used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache now stores queries…

… MySQL Indexing: Best Practices Webinar (both recording and slides are available now) We had lots of questions. I did not have time… traversed in both directions for different queries. This will use fast primary key for some queries and use key K as covering… data in index order MySQL gets data in already sorted order and looks at “one group at the time“, computing aggregate functions as…

… frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out… cause is some batch jobs, reports and other non response time critical activities are overloading the system causing user experience to… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing…