…TABLE `parent` ( `parent_id` int(10) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE…tables should look like this: Final Thoughts While I find the Relationships tab the most useful component of SchemaSpy, I don’t want to…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…how easy it is? ;-) Generative grammars like SQL can produce an infinite variety of… of “>” and be guaranteed to find exactly one match. But the tradeoff of…table, and making lookups to the `kind_types` table by primary key, the result was a query that took half the time. An important conclusion of…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…of a series of articles focused on the implications of enabling GTIDs on a production setup. The manual describes very nicely how to switch to… time? To find an answer to these questions…table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…primary key of the table is one field actor_id. Now we have all necessary information to generate CREATE TABLE statement. 0. Download the latest revision of…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
…I explained how to repair MySQL 5.6 GTID replication using… because of an error: Last_SQL_Error: Error ‘Duplicate entry ’4′ for key ‘PRIMARY” on query…. GTID we need to find a way to ignore that transaction. The way to do it… between Master and Slave servers. pt-table-checksum can help you here, which…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
…to find slow queries or queries which cause the large portion of the load on the system but how…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
…of these Larger pages means slower index lookup as you need to scan half the page in average to find the key value So how…to my tests it looks there is something special in how integer primary key…
Post: Find and remove duplicate indexes
June 20, 2012 By 9 Comments
…post I’m going to explain the different types of duplicate indexes and how to find and remove them. Duplicate keys on the same…find the three different types of keys explained before. Lets try it: mysql> show create table t; [...] PRIMARY KEY (`i`), KEY `name` (`name`,`i`), KEY `name_2` (`name`), KEY…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…to identify which of those two indexes is the Primary Key. This is our next step. 2- Identifying the Primary Key There are different methods to find…primary key. After identifying the Primary Key don’t forget to remove the innodb_table_monitor. C) Check the size on disk of…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
…how to find duplicate indexes. This time we’ll learn how to find unused indexes to…
