Emulate A More Granular MySQL Slow Query Log With Maatkit
Loading...
Loading...
1,265
Loading...
56:47
mk-query-digestby tcation1,377 views- 9:54
InnoDB Data Recovery 1of3by PerconaPerformance2,422 views
- 1:25:17
MySQL 5.4: Performance at your Fingertipsby tcation1,821 views
- 9:10
Rewriting SQL queries for Performance in 9 minutesby roughsealtd17,559 views
- 5:03
Larry Holmes vs Mike Tyson Holmesby sweetfights2,112,296 views
- 7:49
Devel module - query log enhancementsby moweitzman733 views
- 0:28
FotB 2006 - Hoss Gifford, Orgasmatron Part 1by codeeater2,524 views
- 8:40
Como usar o phpMyAdmin com MySQLby gxinternet21,989 views
- 43:37
InnoDB Database Recovery Techniquesby tcation2,523 views
- 1:32:34
New in MySQL 5.1: The Presentation, Including a checklist for how to upgradeby tcation965 views
- 24:38
(no audio from 4:56 to 21:31) Intro to XtraDB, a Scalable InnoDB-based Storage Engineby tcation799 views
- 57:00
O'Reilly Webcast: MySQL Replication - Audit, Test & Verifyby OreillyMedia3,901 views
- 43:33
Performance Tuning Best Practices for MySQLby GoogleTechTalks37,726 views
- 6:02
Miss California Press Conferenceby LisaNova1,459,285 views
- 10:10
DBA - השליטה חוזרת ל - Resouce Governor - חלק 2by JohnBryceTraining83 views
- 2:08
Microsoft Excel, SQL & Internet Tips : Using Microsoft SQL Credentialsby eHow2,337 views
- 4:49
skruntskrunt - granularity 001by abramh66675 views
- 3:20
Fetch Table Rows using mysql and phpby easyphptutorials825 views
- 1:24:43
How InnoDB works: Exploring SHOW ENGINE INNODB STATUSby tcation2,572 views
- 57:32
High-throughput MySQLby tcation1,162 views
This video is simply dynamite. I have implemented this over 4 months ago for a client at my employer's web hosting company.
The method presented in the video was crontab'd every 20 minutes and helped my client find the troublesome queries they had. They have since placed the query output into memcached.
Anytime a bad query rears its ugly head, the top 20 worst performing queries show up and my client responses to it. GOOD JOB, PERCONA !!!
rolandomysqldba 2 months ago
It don't working for me
I checked on the 3 servers
perl mk-query-digest --processlist localhost --interval 0.01
Pipeline process 2 (Processlist) caused an error: Use of uninitialized value in anonymous hash ({}) at mk-query-digest line 2259.
Pipeline process 2 (Processlist) caused an error: Use of uninitialized value in anonymous hash ({}) at mk-query-digest line 2259.
# Caught SIGINT.
qwertydzen1 9 months ago
Why not just configure mySQL to dump all the queries strings it receives to a log?
RobertMOdell 1 year ago