… through SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL… 0, not started, process no 3396, OS thread id 1152440672 MySQL thread id 8080, query id 728900 localhost root show innodb status —TRANSACTION…” will show the undo log record number which purge is currently processing, if it is active otherwise it will be zero. History list…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
… `j` (`j`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 mysql> show table status like “sample” \G; *************************** 1. row …02 sec) Looking at SHOW INNODB STATUS we can see: History list length 5 Total…: —TRANSACTION 0 42306982, ACTIVE 89 sec, process no 10099, OS thread id 1878960…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…instance, and I tried to show the minimal installation required for XtraDB…replication, galera and built-in mysql replication are independent from each other… want to partition your large history tables, so it can keep…somehow restarts because of this automatic process, it gets bootstrapped because of …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… more efficiently, by examining a history of the rows which … must wait for FlexCDC to process changes from that transaction. In… <-- too high +------------------+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_customer_…. The complete method examples show how to create a …
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By 1 Comment
…But first, some history. When I wrote a set of high-quality Cacti templates for MySQL a few years ago… isn’t retrieved from MySQL repeatedly cuts a lot of latency out of the process. In fact, I … just said, they actually aren’t. Graphs that show slightly different data, or greatly different data in …
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… process MySQL slow query logs using pt-query-digest you can…historical values for review trend analysis into query_review_history table. But it could be difficult to easily … seen date; * custom reports, choosing which columns to show; * filtering queries by hosts; * filtering reports by different …
Post: Innodb undo segment size and transaction isolation
January 12, 2011 By 3 Comments
… transaction looks: —TRANSACTION 17402D749, ACTIVE 15867 sec, process no 19349, OS thread id 1630148928 MySQL thread id 188790, query id 14796224615 host… in this case. If not you can check history size in SHOW INNODB STATUS: History list length 4000567 Mind however this size is…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
… for example MySQL CACTI Templates will have the graphs you need. If you’re looking at SHOW INNODB STATUS …. First it is re History list length 4000567 In this case the History Length is about 4 million … lot of rows. In many cases doing such processes in chunks, updating/deleting may be thousands of …
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…that load statement is: mysql -S /tmp/mysql-ib.sock -e “… group by YEAR which shows how many records per years +——+———+ | year | c1 | +——+———+ |…to edit query or check history), the documentation also needs … is not for online transactions processing. Compression in InfoBright is …
