… add binary log filters; this ensures that the top-level master and its binary logs are fully intact, and then the binary log filters are executed on the intermediate server, thus resulting in less binary log data… the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL server’s…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…recipe for a /dev/null email filter. Avoid ratios and thresholds as much…administration mistake to delete one of MySQL‘s log or data files from disk…mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in the processlist. The pmp-check-mysql-processlist plugin checks SHOW…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
… MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in…work with data in SQL as it easy to filter all queries which happened within certain time interval (… * FROM slow_log ORDER BY start_time DESC LIMIT 100) l ORDER BY start_time which shows last queries …
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… slow log live, but that is a bit ugly solution. That is where this patch can be very useful. With simple MySQL SHOW…: 254 Other_commands: 85 Commit_transactions: 0 Rollback_transactions: 0 mysql> SHOW TABLE_STATISTICS LIKE ‘hosting2%’; +——————————–+———–+————–+————————-+ | Table | Rows_read | Rows_changed | Rows… and better filtering for the statistics Also combining these new commands with our msl patch, which introduces the advanced query logging, would…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…so that it can print stack traces that show where memory is consumed. Without debug symbols …Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql… down a memory leak bug on a filtered slave (read more in the actual bug report…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
…show up in reports as “/* No query */“. Fixed bug 1078838: pt-query-digest doesn’t parse general log…-only. When using –replicate-check-only, filter options like –databases and –tables were … inconsistently. Previously, pt-heartbeat respected the MySQL time zone, but this caused false readings…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…the application by aggregating query log with mk-query-digest. When I filtered out only queries of …unacceptable. If we look at the gain system shows from performance at 1 thread to the …do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_…
Post: Finding what Created_tmp_disk_tables with log_slow_filter
September 22, 2008 By 3 Comments
… a large number of temporary tables being created on disk. show global status like ‘Created_tmp%’ | Created_tmp_disk_tables | 91970… version of MySQL. The microslow patch adds a very useful feature, the ability to log queries by execution plan. log_slow_filter=name Log only… minutes and then set the filter to an empty string to stop collection. SET GLOBAL log_slow_filter:=”"; Then it was just a…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…filter to only check queries from replication thread: mk-query-digest slow-log –filter…of connections mysql> show processlist; +——–+————-+———–+——+———+——+———————————————————————–+——————+ | Id | User | Host | …
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
…the master non deterministic queries bad use of replication filters rollback of transactions mixing transactional and non-transactional …Log_File and Exec_Master_Log_Pos from SHOW SLAVE STATUS slave1 [localhost] {msandbox} ((none)) > change master to master_log_file=’mysql-bin.000001′, master_log…
