… row table which would look as following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name: sbtest Engine: InnoDB Version: 10 Row_format: Compact Rows: 10000060 Avg_row_length: 224 Data…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… Record lock, heap no 5 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 80000002; asc ;; 1…, OS thread id 1150142816 fetching rows, thread declared inside InnoDB 166 mysql tables in use 1, locked 0 MySQL thread id 8078, query id…, OS thread id 1147980128 fetching rows, thread declared inside InnoDB 114 mysql tables in use 1, locked 0 MySQL thread id 8077, query id…
Comment: Finding out largest tables on MySQL Server
October 6, 2008 By 27 Comments
… 10 rows in set (0.15 sec) mysql> show table status like ‘table’ \G *************************** 1. row *************************** Name: table Engine: InnoDB Version: 10 Row_format: Compact Rows: 14898977 Avg_row….00 | +———————————————-+——–+——-+——-+————+———+ mysql> show table status like ‘table’ \G *************************** 1. row *************************** Name: table Engine: InnoDB Version: 10 Row_format: Compact Rows: 15120698 Avg_row_length: 147…
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
…, 1 row affected (0.02 sec) mysql> show table status like “comptest” \G *************************** 1. row *************************** Name: comptest Engine: InnoDB Version: 10 Row_format: Compact Rows: 1 Avg_row_length… Warnings: 0 mysql> show table status like “comptest” \G *************************** 1. row *************************** Name: comptest Engine: InnoDB Version: 10 Row_format: Compressed Rows: 1 Avg_row_length: 32768 Data…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
…Record lock, heap no 180 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 30; hex 306338386465646233353863643936633930363962373361353736383261; asc …4058032 fetching rows, thread declared inside InnoDB 3 mysql tables in use 1, locked 1 2539 lock struct(s), heap size 224576 MySQL thread…
Comment: COUNT(*) for Innodb Tables
July 19, 2012 By 32 Comments
you can get approximate number of rows as fast in Innodb as in myisam tables using “SHOW TABLE STATUS” command it … statistics on a page: mysql> show table status like ‘customers’ *************************** 1. row *************************** Name: customers Engine: InnoDB Version: 10 Row_format: Compact Rows: 11861 Avg_row_length: 222 Data…
Comment: Real-Life Use Case for "Barracuda" InnoDB File Format
April 24, 2008 By 11 Comments
…_id`) ) ENGINE=InnoDB mysql> show table status like ‘document_queries’\G *************************** 1. row *************************** Name: document_queries Engine: InnoDB Version: 10 Row_format: Compact Rows: 10027623 Avg_row_length: 4266…: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: InnoDB free: 120832 kB 1 row in set (0.24 sec)
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
… if these are already applied to the pages (Innodb log format has page numbers stored together with operation … have tables with short rows your log records will likely be more compact and so same log length…and undo phase – rolling back uncommitted transactions. As MySQL 5.0 these seems to be done in…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…implement InnoDB style “gap locking”. Gap locking effectively involves locking rows that do…engine. And, fortunately MySQL 5.1. supports row-based replication which …row-level lock for each row returned by the SELECT. These locks are all stored in RAM. The format is quite compact (especially when row…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
… from t; +——+ | i | +——+ | 21 | | 30 | | 26 | +——+ 3 rows in set (0.00 sec) root…INNODB STATUS information as follow: —TRANSACTION 0 27638, ACTIVE 1207 sec, process no 2909, OS thread id 1100101952 inserting mysql…no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; …
