# Other Tools **URL:** https://forums.percona.com/c/polyglot-projects/other-tools/11.md?page=2 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 3 --- ## [mk/pt-query-digest](https://forums.percona.com/t/mk-pt-query-digest/2405)
**Author:** [@robs](https://forums.percona.com/u/robs)\ **Replies:** 1\ **Last updated:** [June 20, 2012, 9:46pm UTC](https://forums.percona.com/t/mk-pt-query-digest/2405 "2012-06-20T21:46:27Z")
Hi All, I’m using the query-digest tool to gather some statistics on a number of busy servers. Currently the problem I have is that pt-query-digest’s memory usage continuously grows, heres how I’m using it. /usr/sbin/t… --- ## [pt-table-checksum, replication filters](https://forums.percona.com/t/pt-table-checksum-replication-filters/2404)
**Author:** [@hullsean](https://forums.percona.com/u/hullsean)\ **Replies:** 2\ **Last updated:** [April 4, 2012, 1:08pm UTC](https://forums.percona.com/t/pt-table-checksum-replication-filters/2404 "2012-04-04T13:08:55Z")
Hi all, I’m getting an error with pt-table-checksum. Cannot checksum with --replicate because replication filters are set on these hosts: P=3306,S=/var/lib/mysql/mysql.sock,h=localhost,p=…,u=root replicate\_ignore\_tab… --- ## [PhpMyadmin](https://forums.percona.com/t/phpmyadmin/2402)
**Author:** [@robsouthern](https://forums.percona.com/u/robsouthern)\ **Replies:** 2\ **Last updated:** [March 16, 2012, 8:15am UTC](https://forums.percona.com/t/phpmyadmin/2402 "2012-03-16T08:15:37Z")
Hi, I am looking at switching to Percona Server, would there be any problems with using phpmyadmin? Best, Rob --- ## [Installing RPM dependency problems with DBD::mysql and Term::ReadKey](https://forums.percona.com/t/installing-rpm-dependency-problems-with-dbd-mysql-and-term-readkey/2401)
**Author:** [@iberkner](https://forums.percona.com/u/iberkner)\ **Replies:** 2\ **Last updated:** [February 18, 2012, 10:15am UTC](https://forums.percona.com/t/installing-rpm-dependency-problems-with-dbd-mysql-and-term-readkey/2401 "2012-02-18T10:15:46Z")
Hi, Trying to install the Percona toolkit RPM and getting dependency errors: rpm -isv percona-toolkit-2.0.3-1.noarch.rpm error: Failed dependencies: perl(DBD::mysql) \>= 1.0 is needed by percona-toolkit-2.0.3-1.noarch … --- ## [Query Advisor Results](https://forums.percona.com/t/query-advisor-results/2400)
**Author:** [@gms8994](https://forums.percona.com/u/gms8994)\ **Replies:** 2\ **Last updated:** [February 17, 2012, 1:40pm UTC](https://forums.percona.com/t/query-advisor-results/2400 "2012-02-17T13:40:40Z")
Per Baron, I’m pasting this here: \[URL\]http://tools.percona.com/query/PLUQcFBa/advice\[/URL\] specifically, I can’t seem to find any information on CLA.003 (Paginating a result set with LIMIT and OFFSET is O(n^2) complex… --- ## [Use of pt-table-checksum in master-master environments](https://forums.percona.com/t/use-of-pt-table-checksum-in-master-master-environments/2399)
**Author:** [@Volans](https://forums.percona.com/u/Volans)\ **Replies:** 2\ **Last updated:** [February 8, 2012, 12:58pm UTC](https://forums.percona.com/t/use-of-pt-table-checksum-in-master-master-environments/2399 "2012-02-08T12:58:04Z")
This topic follows this question on Launchpad The original question was: I would like to know if it is safe (from the replication point of view) to run pt-table-checksum toolkit in environments with a master-master M… --- ## [mk(pt)-archiver and handling Duplicate entry errors](https://forums.percona.com/t/mk-pt-archiver-and-handling-duplicate-entry-errors/2396)
**Author:** [@massoo](https://forums.percona.com/u/massoo)\ **Replies:** 2\ **Last updated:** [January 17, 2012, 12:38pm UTC](https://forums.percona.com/t/mk-pt-archiver-and-handling-duplicate-entry-errors/2396 "2012-01-17T12:38:02Z")
Hi, I am using mk(pt)-archiver to archive data from the on-line database server to an off-line archive server. The script used is as follows: mk-archiver --statistics --source h=localhost,F=archive.conf,D=DB-NAME,t=TAB… --- ## [Percona toolkit installation issue related to perl-DBD-MySQL](https://forums.percona.com/t/percona-toolkit-installation-issue-related-to-perl-dbd-mysql/2397)
**Author:** [@iberkner](https://forums.percona.com/u/iberkner)\ **Replies:** 1\ **Last updated:** [December 21, 2011, 11:57am UTC](https://forums.percona.com/t/percona-toolkit-installation-issue-related-to-perl-dbd-mysql/2397 "2011-12-21T11:57:27Z")
Trying to install the Percona Toolkit version 1.0.1 using the rpm package as follows: rpm -i percona-toolkit-1.0.1-1.noarch.rpm Running the above produces this error: error: Failed dependencies: perl(DBD::mysql) \>= 1… --- ## [what is the content inside the innodb redo log file](https://forums.percona.com/t/what-is-the-content-inside-the-innodb-redo-log-file/2395)
**Author:** [@seagen](https://forums.percona.com/u/seagen)\ **Replies:** 2\ **Last updated:** [December 14, 2011, 10:27pm UTC](https://forums.percona.com/t/what-is-the-content-inside-the-innodb-redo-log-file/2395 "2011-12-14T22:27:23Z")
Anybody knows if there is a tool which could read the innodb redo log file and show us the readable content? As we know the binlog is very useful for replication and recovery, but the performance is also affected very s… --- ## [pt-query-advisor file size limits](https://forums.percona.com/t/pt-query-advisor-file-size-limits/2394)
**Author:** [@dtest](https://forums.percona.com/u/dtest)\ **Replies:** 2\ **Last updated:** [November 17, 2011, 11:00am UTC](https://forums.percona.com/t/pt-query-advisor-file-size-limits/2394 "2011-11-17T11:00:56Z")
I was unfortunate enough to have run pt-query-advisor on a general query log of 75GB: pt-query-advisor --type genlog general.log This (probably expectingly) ate up all the memory on the server and required a hard reboo… --- ## [pt-show-grant](https://forums.percona.com/t/pt-show-grant/2393)
**Author:** [@none.enon](https://forums.percona.com/u/none.enon)\ **Replies:** 1\ **Last updated:** [October 3, 2011, 9:24am UTC](https://forums.percona.com/t/pt-show-grant/2393 "2011-10-03T09:24:49Z")
Good day, show-grant outputs incorrect Sql format when access to the table is on selected fields only. consider the ff. table CREATE TABLE IF NOT EXISTS table3 ( SOrNum mediumint(9) unsigned NOT NULL auto\_increment, S… --- ## [Help with MySQL Handler socket](https://forums.percona.com/t/help-with-mysql-handler-socket/2414)
**Author:** [@srinivasan](https://forums.percona.com/u/srinivasan)\ **Replies:** 0\ **Last updated:** [May 24, 2011, 2:05am UTC](https://forums.percona.com/t/help-with-mysql-handler-socket/2414 "2011-05-24T02:05:46Z")
Hi, I am trying out MySQL HandlerSocket. I believe we can go execute\_multi() with handlersocket’s perl APIs to speed up multiple queries instead of using execute\_single(). I have tried this and it works for me in per… --- ## [variance to mean ratio vs coefficient of dispersion](https://forums.percona.com/t/variance-to-mean-ratio-vs-coefficient-of-dispersion/2392)
**Author:** [@rguinot](https://forums.percona.com/u/rguinot)\ **Replies:** 1\ **Last updated:** [March 11, 2011, 9:49pm UTC](https://forums.percona.com/t/variance-to-mean-ratio-vs-coefficient-of-dispersion/2392 "2011-03-11T21:49:39Z")
Hi, I have a little statistics question about the variance to mean (V/M) value reported by mk-query digest. let’s consider this output : Attribute pct total min max avg 95% stddev median V/M# ============ === ======= … --- ## [mk\_table\_checksum Warning: WHERE clause too large for boundaries column](https://forums.percona.com/t/mk-table-checksum-warning-where-clause-too-large-for-boundaries-column/2391)
**Author:** [@biwombihotmailcom](https://forums.percona.com/u/biwombihotmailcom)\ **Replies:** 1\ **Last updated:** [February 24, 2011, 7:17am UTC](https://forums.percona.com/t/mk-table-checksum-warning-where-clause-too-large-for-boundaries-column/2391 "2011-02-24T07:17:42Z")
hi running mk\_table\_checksum is returning warnings while checking one of our large tables in a master-master (passive master) replication set up. Does anyone know what these mean and and what the implications are? are … --- ## [Problem with mk-show-grants](https://forums.percona.com/t/problem-with-mk-show-grants/2390)
**Author:** [@adamb4040](https://forums.percona.com/u/adamb4040)\ **Replies:** 1\ **Last updated:** [February 15, 2011, 5:35am UTC](https://forums.percona.com/t/problem-with-mk-show-grants/2390 "2011-02-15T05:35:29Z")
I am getting the following error … Use of uninitialized value in split at ./mk-show-grants line 1731 mk-show-grants Ver 1.0.23 Distrib 7207 Changeset 7105 Any suggestions on how to work around this ? --- ## [No Plugins (HandlerSocket plugin) in percona-server-5.1 LUCID deb package](https://forums.percona.com/t/no-plugins-handlersocket-plugin-in-percona-server-5-1-lucid-deb-package/2413)
**Author:** [@netandreus](https://forums.percona.com/u/netandreus)\ **Replies:** 0\ **Last updated:** [December 17, 2010, 2:29am UTC](https://forums.percona.com/t/no-plugins-handlersocket-plugin-in-percona-server-5-1-lucid-deb-package/2413 "2010-12-17T02:29:08Z")
In tha package percona-server-server-5.1 for LUCID (ubuntu 10.04) amd64 there is no plugins and also HandlerSocket.so plugin, but for maverick (ubuntu 10.10) it does. How I can install plugins in Ubuntu 10.04 (lucid)? --- ## [mk-table-checksum issue with mysql log tables](https://forums.percona.com/t/mk-table-checksum-issue-with-mysql-log-tables/2389)
**Author:** [@iberkner](https://forums.percona.com/u/iberkner)\ **Replies:** 3\ **Last updated:** [October 27, 2010, 3:50pm UTC](https://forums.percona.com/t/mk-table-checksum-issue-with-mysql-log-tables/2389 "2010-10-27T15:50:05Z")
Running the checksum script and it says that the general\_log and slow\_log files are different even though they are not used and contain no records. Any suggestions? I just ran “flush logs” maybe that will help. Differe… --- ## [mk-table-checksum error](https://forums.percona.com/t/mk-table-checksum-error/2388)
**Author:** [@iberkner](https://forums.percona.com/u/iberkner)\ **Replies:** 0\ **Last updated:** [October 26, 2010, 3:23pm UTC](https://forums.percona.com/t/mk-table-checksum-error/2388 "2010-10-26T15:23:07Z")
Got this error while running mk-table-checksum: $VAR1 = {Code =\> ‘1592’,Level =\> ‘Note’,Message =\> ‘Statement may not be safe to log in statement format.’}; at /root/bin/mk-table-checksum line 5066. while doing mysql.ge… --- ## [mk-table-checksum fails due to "on update CURRENT\_TIMESTAMP"](https://forums.percona.com/t/mk-table-checksum-fails-due-to-on-update-current-timestamp/2387)
**Author:** [@iberkner](https://forums.percona.com/u/iberkner)\ **Replies:** 2\ **Last updated:** [October 10, 2010, 7:15am UTC](https://forums.percona.com/t/mk-table-checksum-fails-due-to-on-update-current-timestamp/2387 "2010-10-10T07:15:44Z")
I did a sqldump from a slave to another slave. On the master, we’re running mk-table-checksum. The new slave is showing as replicating correctly and from what I can tell it has to do with some tables having timestamp fie… --- ## [mk-parallel-restore](https://forums.percona.com/t/mk-parallel-restore/2386)
**Author:** [@posner](https://forums.percona.com/u/posner)\ **Replies:** 1\ **Last updated:** [August 4, 2010, 2:07pm UTC](https://forums.percona.com/t/mk-parallel-restore/2386 "2010-08-04T14:07:31Z")
[Previous page](https://forums.percona.com/c/polyglot-projects/other-tools/11.md?page=1)