… Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a… small but handy improvements – changes and bug corrections – in MySQL 5.6 that can make our lives easier and have passed almost… index. Does it mean that tools like pt-duplicate-key-checker will not be necessary for MySQL 5.6? Let’s have a…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
…, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick Peterson, a member of Percona’s RemoteDBA team… with MySQL and Shard Query” Daniel Nichter, lead of the Percona Toolkit development team, will survey Percona Toolkit Command Line Tools – as… using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch will share with how MySQL can be used to…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…/Slave Set: ms_MySQL [p_mysql] Masters: [ percona2 ] Slaves: [ percona3 percona1 ] [root@percona1 ~]# cat /etc/redhat-release CentOS release 6.3 (Final) [root...:mysql): Master percona2 (unmanaged) p_mysql:1 (ocf::percona:mysql): Started percona3 (unmanaged) Stopped: [ p_mysql:2 ] Now we can upgrade all servers to 6…-mode=false You can also check your cluster using cman_tool or clustat (if you have installed rgmanager) [root@percona3 ~]# cman…
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… your database — I’m using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required… 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… Percona Toolkit supported platforms and versions. When you upgrade to MySQL 5.6, be sure to upgrade to Percona Toolkit 2.2… service from Percona that advises when certain programs (Percona Toolkit tools, MySQL, Perl, etc.) are either out of date or are known… 2.2 and pt-mysql-summary 2.2 have all the standard MySQL options built-in, like other tools: –user, –host, –port, –password…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… is glad to announce the release of Percona Playback 0.6 for MySQL on April 9, 2013. Downloads are available from our download site and Percona Software Repositories. Percona Playback for MySQL is a tool for replaying the load of one database server to another. Currently it can read queries from MySQL query…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer Guide… are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel replication but… 1 and the same tool is not possible. Want to talk more about performance? Come to Percona Live MySQL Conference and Expo…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… in the form of templates, plugins, and scripts. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to… Utilities. Also the following Cacti graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network Traffic”. A new tarball is available from… of Percona’s Remote DBA installation and setup of these tools are included with our services. You can find links to…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…. To manage this process, we use a tool co-developed with Percona. “Warm standby server”? …slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –… use case. You will need version 0.6 or later to get these features. Be …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…mysql> select * from SYS_COLUMNS WHERE TABLE_ID=741; +———-+—–+————-+——-+———+——+——+ | TABLE_ID | POS | NAME | MTYPE | PRTYPE | LEN | PREC | +———-+—–+————-+——-+———+——+——+ | 741 | 0 | actor_id | 6…
