June 19, 2013

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

…them are Innodb specific and it well can affect your workload. So benchmark to be sure. In Innodb … us greatly to spot scalability problems and find fixes for them. The work continues. I … reorganize which locks and reorganizes small portions of table online. Q38: Seems that adaptive hash indexes are …

Filed Under: Insight for Developers Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… locate this record but InnoDB cannot find it at all? I suspect that the “B” is causing problems for InnoDB, because it’s… of what we’ve learned so far: There are parts of InnoDB FTS configuration which are both letter-case and character-set sensitive. Watch out! When you add your first FULLTEXT KEY to an InnoDB table…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

… checksum failing CHECK TABLE says table is OK. This means You Can’t Trust CHECK TABLE in Innodb to be sure your tables are good. In this simple corruption was only in the data portion of pages so once you started Innodb with innodb_force… in the table and we need to somehow skip over it. To do it we would need to find max PK which could…

Filed Under: Insight for DBAs Tagged With:

Post: Find unused indexes

June 30, 2012 By Leave a Comment

…INNODB_INDEX_STATS.TABLE_NAME, INNODB_INDEX_STATS.INDEX_NAME from INNODB_INDEX_STATS WHERE CONCAT(INNODB_INDEX_STATS.index_name, INNODB_INDEX_STATS.table… We’ve learnt how to find unused indexes using different approaches…which of them you should evaluate. Good tools to help us on that evaluation are…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software

Post: Innodb Recovery Update - The tricks what failed.

May 24, 2007 By 3 Comments

….0.33 are not frequently used True many distributions still have versions before this one which could have some impact. Innodb tables rarely become corrupt Indeed even if you leave out crashes in my experience Innodb tables become… probably report half of the bugs I find, the once I find most annoying or find easy to provide repeatable example for so…

Filed Under: Insight for DBAs Tagged With:

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

… stuff happened at Users Conference but I’m just starting find bits of time from processing accumulated backlog. The Theme of… separately. Improved Auto Increment handling Yet another known Innodb problem is table locks which are taken for statement duration for Inserts with auto-increment…

Filed Under: Events and Announcements Tagged With:

Post: ANALYZE: MyISAM vs Innodb

September 3, 2008 By 9 Comments

… TABLE after initial table population and when there are significant changes makes sense. For Innodb as index stats are computed first time table…find number of exact values in the table. Now let us populate antest_innodb table which is same but uses Innodb format: mysql> insert into antest_innodb…

Filed Under: Insight for DBAs Tagged With: ,

Post: INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine

May 24, 2008 By Leave a Comment

… I could not get from InnoDB at the time was visibility into which transactions are blocking others when there are lock waits. It appears… to find out more information on InnoDB locks even in the older versions of InnoDB, but it’s not really easy.) These tables are fully documented in the InnoDB plugin manual, along with extensive examples of how to use them to find out what…

Filed Under: Insight for DBAs Tagged With: ,

Post: Can MySQL temporary tables be made safe for statement-based replication?

May 26, 2008 By 8 Comments

…which is interesting.) But does that mean it’s safe for replication? There is one good way to find… even when temporary tables are open.) Then I created a temporary table on the master, …, which this time will insert data from the temporary table into a non-temporary InnoDB table: master > delimiter …

Filed Under: Insight for DBAs Tagged With:

Post: Performance problem with Innodb and DROP TABLE

February 3, 2011 By 23 Comments

… working with an application which does a lot of CREATE and DROP table for Innodb tables and we’ve discovered DROP TABLE can take a… function which did not sound right. The great thing with oprofile output you can usually Google couple of top functions and find… you’re running innodb_file_per_table you will have a microstalls when tables are dropped and dropping a lot of tables in a batch…

Filed Under: Insight for DBAs, MySQL Tagged With:
« Older Posts
Newer Posts »