…optimizer and see how easy it is? ;-) …engineer-years spent developing and testing the query optimizer. The developers have to…to be consecutive. Then you could choose a random value, look up the row with “=” instead of “>” and be guaranteed to find…, and making lookups to the `kind_types` table by …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…ENGINE=InnoDB DEFAULT CHARSET=latin1 So, `TABLE_ID` is our table_id. `ID` here is the index identifier. We need it to find…
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
… | id | select_type | table | type | possible_keys | key …`Population` (`Population`) ) ENGINE=MyISAM DEFAULT CHARSET…to index at about 34%. How am I supposed to find unused indexes then? You really have to…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… doesn’t work. How can I recover deleted rows? We’re going to follow the same …_SCHEMA that can help us to find the different indexes and types. mysql (information_schema) > select i.INDEX…their IDs) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE…
Post: Find and remove duplicate indexes
June 20, 2012 By 9 Comments
… the optimizer phase slower because MySQL needs to examine more query plans. The storage engine needs to maintain, calculate and update more index… slower In this post I’m going to explain the different types of duplicate indexes and how to find and remove them. Duplicate keys on…. This type of indexes are easy to find out and to avoid them. How? Just specify the index name and MySQL will avoid to create duplicate…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…it’s difficult or impossible to find the right threshold for …to those discussed within InnoDB, but it can find evidence of problems in the server as well as the storage engine… recently. It is surprising how often a server crashes, …will include more plugins to monitor more types of problems, but…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… implementation details of how it would compare to Innodb storage engine – old timer in this space. Does it add choice to the people ? Yes… functions which you’d find in Oracle, PostgreSQL and other databases. MEMORY storage engine is old timer of this type, ARCHIVE, CSV are other good examples. There are also storage engines out where to read sensor data, talk to memcache or external search engine…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
… you need to scan half the page in average to find the key value So how you control…type but not for numerical and other column types. Also according to my tests it looks there is something special in how… default ”, KEY `c` (`c`), KEY `id` (`id`) ) ENGINE=MyISAM Index size: PACK_KEYS=DEFAULT – 1550K…
Post: How Percona Develops Open-Source Software
January 9, 2009 By 4 Comments
… new high-performance transactional storage engine Maatkit, which is a …to learn a great deal about what your server is doing and how to optimize it. Customer demands. Customers come to…there were a built-in type in MySQL that could …great balancing act, and finding a balance that seems to make sense …
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… HA. For the others, let’s move on! How to determine which MySQL High-Availability solution is best? … might be replaced by another search engine like Sphinx in order to remove the restriction. There is no… way to get used to a technology and experiment with it in a test environment. The other type of…
