… post I explained how to repair MySQL 5.6 GTID replication using two different methods…. entry ’4′ for key ‘PRIMARY” on query. Default database: ‘test’. Query: ‘insert into t VALUES(NULL,’salazar’)’ …different ways to find the failed transaction. You can examine the binary logs or you can also check …
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…Check out the Percona Toolkit supported platforms and versions. When you upgrade to MySQL 5.6, be sure to upgrade to…: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was…-time to limit how long they run. There are more changes in addition to those …
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the log stream across log…playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log…lines up with the blue part. Check back Thursday…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…how to setup and run this benchmark, can be found here. We decided to run this benchmark for MySQL… used this dataset to check server behavior …how to run benchmark: [mysqld] user=root port=3306 innodb_buffer_pool_size = 30G innodb_flush_method = O_DIRECT innodb_log…=1000 query_cache_size=0 query_cache…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…to deadlocks and timeouts, applications often don’t handle or log this error appropriately. The pmp-check-mysql-status plugin can be configured to…checking that the server is alive and responds to a query. The pmp-check-mysql-status is also very flexible and can be used to…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
…how much time MySQL spends in various phases of query…query consumed 0.18 seconds. Where did the time go? mysql> SHOW PROFILE FOR QUERY 1; +———————-+———-+ | Status | Duration | +———————-+———-+ | starting | 0.000032 | | checking…logging slow query…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…Query Log – Especially after the changes to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… to using mysql binary logs…to convert it. You can easily check that it parses by running the SELECT portion, adding LIMIT 0 to…to actually build the contents of the view, making it available for querying: mysql…how you can combine both types of views together. The complete method examples show how to…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… mk-query-digest output was obviously bogus when compared to the host’s slow-query-log (for example, none of the top 5 slow queries reported by mkqd appeared in the actual slow log… to capture tcpdump data in seconds (1200 = 20 min) TMP=’/tmp’ LOCKFILE=”$self.lockfile” TMPfile=”$self.temp” RESfile=”$self.result” # check lock…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…changed, starting MySQL 5.5.3. Let’s see how this works now. Metadata Locking behavior starting MySQL 5.5….| checking query cache for query | 0.000007 | | checking privileges on cached | 0.000003 | | checking permissions | 0.000005 | | sending cached result to clien | 0.000011 | | logging slow query …
