…a little known goodie from Percona Toolkit for MySQL called pt-query-digest. One customer was suffering from periods of…with these cases, we set up pt-stalk to trigger a capture if Threads_running went above a known …information to review even if we couldn’t be logged in to the server at the time the …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… enables backups without blocking user queries, making it ideal for companies…secondary indexes on innobackupex –apply-log –rebuild-indexes. This allows … DBD::MySQL package for server communication instead of spawning the MySQL command …file and position. This could trigger a bug if the server…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …log_binblogpercona.commanual log_binblogpercona.commanual log_bin_indexblogpercona.commanual log_bin_trust_function_creatorsblogpercona.commanual log_errorblogpercona.commanual log_isamblogpercona.commanual log_outputblogpercona.commanual log_queries…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… installations) or a system administration mistake to delete one of MySQL‘s log or data files from disk. The database server will… timeouts, applications often don’t handle or log this error appropriately. The pmp-check-mysql-status plugin can be configured to alert… and responds to a query. The pmp-check-mysql-status is also very flexible and can be used to trigger an alert on…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… how to avoid them. TRIGGERS When a statement activates a Trigger only the original query is logged not the subsequent triggered statements. If you want…(YEAR(CURDATE())); END;// mysql> CALL this_pyear(); Binary Log: #111213 23:33:41 server id 1 end_log_pos 2055 Query thread_id=6…. In this case neither the trigger, the CALL or the queries inside the procedure that modifies data are logged. So in this case…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… that it would trigger and log the query. Taking other Approach For our clients we often need to find a queries which impact application… to run with recent MySQL version. Now why do not we use general log instead ? Unfortunately general logs queries before queries are executed (and even…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…increase after executing a particular query. Or, maybe mysqld is seemingly…mysql client), you would execute whatever steps you think are necessary to increase memory usage/trigger…Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…triggers must be changed. The work in the trigger is immediate and affects every transaction. Finally, MySQL has limited trigger…_id: 999 master_log_file: binary_log.000001 master_log_size: 214652 exec_master_log_pos…Query OK, 0 rows affected (0.00 sec) mysql> insert into test.demo values (1,1); Query…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
…, however all we found was a spike in writes, many queries piled up and looking at the system process list it…-trigger -rw-r–r– 1 root root 91 Nov 3 08:36 2011_11_03_08_36_00-trigger … -rw-rw—- 1 mysql mysql 1073742171 Nov 2 15:15 /var/lib/mysqllogs/db1-bin-log.003229 -rw-rw—- 1 mysql mysql 1073742976…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… group commit would trigger in MySQL 4.0 and large number of transactions in total so serializing them would make MySQL unable to… see very strange behavior on 5.0 of MySQL being slow but few queries being “inside innodb” and potentially even empty queue… “commit” queries in the processlist for multiple statement transactions. Looking at SHOW INNODB STATUS you would notice large amount of log writes…
