June 19, 2013

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

…Innodb tables): mysql> optimize table test; +———–+———-+———-+———————————-+ | Table | Op | Msg_type | Msg_text | +———–+———-+———-+———————————-+ | test.test | optimize | error…per page so not a big surprise 30 rows was not …

Filed Under: Insight for DBAs Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… very big fan of MyISAM; I would argue …optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | +—————————+———+ 10 rows in set (0.02 sec) mysql> optimize table dir_test_innodb; +———————-+———-+———-+———-+ | Table…

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

Post: Heikki Tuuri answers to Innodb questions, Part II

November 4, 2007 By 13 Comments

…faster than Flash. SSD Drives would be big win for TableSpace files but these …have a fairly large Innodb table (150GB) that is showing poor performance for full table scans. using O_…any table / index fragmentation, without having to run the OPTIMIZE? HT: Since OPTIMIZE rebuilds the whole table, it…

Filed Under: Insight for Developers Tagged With:

Post: Should you move from MyISAM to Innodb ?

January 12, 2009 By 59 Comments

… cases this is deliberate choice with system being optimized to deal with MyISAM limits, for example …very large number of tables, slow data load and ALTER TABLE and others. Another big one is COUNT(*) …be as much as 10-50 times for Innodb tables in particular for write intensive workloads. Check here…

Filed Under: Insight for DBAs Tagged With: , ,

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

…Innodb user when I found out ALTERing Innodb tables may take a lot of time. Fast Index creation will allow Innodb…case of ALTER TABLE (the big Gotcha for MyISAM tables). Are there …Innodb IO scheduling more aggressive which is important for serious IO subsystems. Many Innodb IO settings were optimized…

Filed Under: Events and Announcements Tagged With:

Post: Choosing innodb_buffer_pool_size

November 3, 2007 By 39 Comments

… about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I…boxes to 5% of memory size on the big boxes, though it can be even less than …cache for your Innodb tables but there are other things you need OS cache for – MyISAM tables (mysql database,…

Filed Under: Insight for DBAs Tagged With:

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

… carefully, especially with InnoDB tables — don’t use GUIDs.  Which brings me to my next point: Use InnoDB Assuming that you will…-only tables when things get big.  And even if it’s read-only, there’s still another reason to use InnoDB/XtraDB tables… Optimize… on big joins; the query optimizer can sometimes pick bad plans when you have a lot of joins between fact and dimension tables…

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

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb…

Filed Under: Insight for DBAs, MySQL

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…. You might find that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (The INFORMATION_SCHEMA… can be fixed and bring big gains. Schema, query, and index optimization Analyzing and optimizing a server’s table and index structures, and the…

Filed Under: Insight for Developers Tagged With:

Post: Heikki Tuuri Innodb answers - Part I

October 26, 2007 By 19 Comments

… how it plays when we can see more benchmarks. The big problems I see so far with this feature are ease… tables, everything can reside within a single extent. For big tables, a secondary index reserves different extents from the clustered index. Q4: Does Innodb…. Though full table scan is only one of replacement policy optimizations possible. Q8: How do you assess current state of Innodb scalability with…

Filed Under: Insight for Developers Tagged With: ,
« Older Posts