…ID=741; +———-+——+———————+———-+——+——-+———+ | TABLE_ID | ID | NAME | N_FIELDS | TYPE | SPACE | PAGE_NO | +———-+——+———————+———-+——+——-+———+ | 741 | 1679 | PRIMARY | 1 | 3 | 738 | 3 | | 741 | 1680 | idx_actor_last…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…07:56 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 44 seconds Make sure …which are different in different versions), you get no information what this object is …LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 16403 n bits 72 index …
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
… files. A well known innodb_file_per_table option brings the second one. … you’ll get an error in the log: InnoDB: Error: tablespace id is 10 …PAGE_NO: 3 *************************** 2. row *************************** TABLE_ID: 13 ID: 16 NAME: idx_actor_last_name N_FIELDS: 1 TYPE: 0 SPACE: 15 PAGE…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…per number of “Questions” or “Com_select” to get amount of IO per query or per… 12ms 238ms 0 # pages distin 17….Per-query information from mk-query digest (I omit queries text for client privacy) # Query 1: 0 QPS, 0x concurrency, ID… (1/0%)… 1753695 more # Last errno 0 # Users user # Query_time …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…: msandbox[msandbox] @ localhost [] # Thread_id: 1 Schema: test Last_errno: 0 Killed: 0 # …InnoDB_queue_wait: 0.000000 # InnoDB_pages_distinct: 973 SET timestamp=1325146286; …has to examine 1012 rows (per every query), interesting here is…, I can make out is “Get yourself Percona Server, turn on…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…_running’, we start to get information in the …id | | sakila | city | idx_fk_country_id | | sakila | customer | idx_fk_address_id | | sakila | customer | idx_fk_store_id | | sakila | customer | idx_last… rental_date,inventory_id,customer_id index_total_pages: 27 index… use innodb_file_per_table, then …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…normally posts about 64 page read requests per a readahead. The InnoDB buffer is 256 page read requests … cause data corruption, crashes, or wrong query results get the highest priority. We are slowly working …’last‘ serious bug in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
… a great extent but does not get rid of it completely. In the … when you are using innodb_file_per_table. Implementation Before going into showing …_space_was_deleted(space_id), here space_id is the id of the tablespace corresponding … (which is a list of pages ordered by their last access time) and a …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…get an even distribution, the test data was hashed over the values in the date_id…was discussed in the comments of the last post. ICE does not have any … innodb-file-format=barracuda innodb-file-per-table innodb-flush-log-at-trx…-on-metadata=0 innodb-stats-sample-pages=256 innodb-stats-update-need-lock…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… there would be fewer pages spanning multiple disks so … heads and 63 sectors per track: db2# fdisk -l Disk …0×00091218 Device Boot Start End Blocks Id System /dev/sda1 * 63 19535039 … element without a reminder. Lastly, if this is not …-bytes internally. This however gets more complicated with SSD …
