… PDT. Topics will include: Backups from the cluster Avoiding SST Flow Control What and How to Monitor Tuning best practices This…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…: [ percona2 ] Slaves: [ percona3 percona1 ] [root@percona1 ~]# cat /etc/redhat-release CentOS release 6.3 (Final) [root@percona1 ~]# rpm -q pacemaker pacemaker…-mode=false You can also check your cluster using cman_tool or clustat (if you have installed rgmanager) [root@percona3 ~]# cman…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… Percona Toolkit development team, will survey Percona Toolkit Command Line Tools – as well as go into more detail about using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share…
Comment: Impact of logging on MySQL’s performance
June 11, 2013 By 8 Comments
… large (but not necessarily slow) queries. It’s a good tool but it should only be used when needed, and that…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… of using Percona server over MySQL? 3. I am using CentOS for my servers but i develop apps in windows, do…
Comment: Percona Playback 0.6 for MySQL now available
June 10, 2013 By 1 Comment
I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.
Comment: Implementing SchemaSpy in your MySQL environment
June 5, 2013 By 2 Comments
…’t cope? * Is this a concern regarding crashes of the tool, or certain features don’t work past N number of…
Comment: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
The ERD tools I use are MySQL Workbench and SchemaSpy. The anomalies tab of SchemaSpy has been quite helpful. However both tools can’t really cope with really large schemas.
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… which has given me time to explore new tools using their environments. One tool that I am finding very helpful is called SchemaSpy. SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of… the impression that this is the only component of the tool. There are additional tabs: Tables – Names, number of children, parents…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… the creation of the duplicate index. Does it mean that tools like pt-duplicate-key-checker will not be necessary for… or a foreign key. This is the output of our tool when run on the same table, correctly identifying the redundancy…
