… to me. Probably its due to a bug in how counter is calculated inside MariaDB? Other Observations Sometimes both for MariaDB 5… plans. a. Bad Plan id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE nation ALL PRIMARY NULL… where b. Good Plan id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE orders range PRIMARY,i…
Post: When EXPLAIN estimates can go wrong!
October 13, 2011 By 7 Comments
…_type: SIMPLE table: test_estimate type: ref possible_keys: type_created key: type_created key_len: 1 ref: const rows: 3135918 Extra: Using index…_type: SIMPLE table: test_estimate type: range possible_keys: type_created key: type_created key_len: 1 ref: NULL rows: 14313458 Extra: Using where… that there is a bug in MySQL 5.1 and how it calculates the row estimates. This bug was tracked down to…
Post: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
August 28, 2007 By 57 Comments
…now – we need too check how long our COUNT query would …| table | type | possible_keys | key | key_len | ref | rows | Extra | +—-+————-+————+——+—————+——+———+——-+——-+————-+ …MySQL accessed our table data when calculated result set size even when…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… OUTPUT ===================================== Per second averages calculated from the last… count” show how actively innodb uses internal sync array – how…len 6; hex 0000140c2d8f; asc – ;; 2: len 7; hex 80009c40050084; asc @ ;; Innodb will print statement which caused error. Definition of foreign key…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…LEN` int(10) unsigned default NULL, `CLUSTER_NAME` varchar(255) default NULL, `SPACE` int(10) unsigned default NULL, PRIMARY KEY… once than in every InnoDB page. How let’s connect actor.ibd from … new style checksum) page 11: new style: calculated = 0x E4189B9B; recorded = 0x C168689B fixing …
