… (thank you ORM by joining all tables connected with foreign keys just in case) which would take 5 seconds even though… need to be executed during EXPLAIN phase yet making it unusable to check the optimizer performance. Solution for this problem was to…
Post: check-unused-keys: A tool to interact with INDEX_STATISTICS
June 26, 2009 By 10 Comments
…’ve created check-unused-keys, a Perl script to provide a nicer interface than directly querying the INFORMATION_SCHEMA database. check-unused-keys can be invoked and used as follows: %> check-unused-keys –help Usage: check-unused-keys [OPTIONS] Options: -d, –databases=
Comment: check-unused-keys: A tool to interact with INDEX_STATISTICS
April 23, 2010 By 10 Comments
thanks Ryan, i used perl check-unused-keys. with options and it worked like a charm, we use perl customized to our environment so. i had to use that instead of ./check-unused-keys . thanks
Comment: check-unused-keys: A tool to interact with INDEX_STATISTICS
June 28, 2009 By 10 Comments
it looks there is a typo # diff check-unused-keys-0.0.2 check-unused-keys-0.0.2.1 153c153 my @tbls = split(/,/, $OPTIONS{‘tables’});
Comment: How (not) to find unused indexes
October 16, 2009 By 2 Comments
Morgan, don’t forget that we have check-unused-keys … a perl script that uses Userstats to show unused keys. — Ryan Lowe
Comment: check-unused-keys: A tool to interact with INDEX_STATISTICS
April 23, 2010 By 10 Comments
tried to use the below check-ununsed-keys but failed. pls.help # ./check-unused-keys. -uusername -ppassword -Hhostname -iportname -ddbname Could not connect to MySQL i logged in with the same credentials using mysql -uusername -ppassword -hhostname -Pportname any help will be appreciated
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
…+—-+————-+——-+——+—————+——+———+——+——-+————-+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows |…am I supposed to find unused indexes then? You really…either use a proxy that checks EXPLAIN information (like QUAN) …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… key_buffer_sizeblogpercona.commanual key_cache_age_thresholdblogpercona.commanual key_cache_block_sizeblogpercona.commanual key_cache_division_limitblogpercona.commanual Key_read_requestsblogpercona.commanual Key_readsblogpercona.commanual Key_write_requestsblogpercona.commanual Key…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 4 Comments
…oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood….id INT, -> INDEX par_ind (parent_id), -> FOREIGN KEY (parent_id) REFERENCES parent(id) -> ON DELETE CASCADE -> … to one additional concurrency check (we actually care less about the concurrency check itself than the …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… ‘Key_blocks_not_flushed’, ’0′ ‘Key_blocks_unused‘, ’28987′ ‘Key_blocks_used’, ’1332′ ‘Key_read_requests’, ’1552507′ ‘Key_reads’, ’1654′ ‘Key_write_requests’, ’114303′ ‘Key_…full_range_join’, ’0′ ‘Select_range’, ’5683551′ ‘Select_range_check‘, ’0′ ‘Select_scan’, ’1104831′ ‘Slave_open_temp_tables’, ‘…
