June 19, 2013

Comment: table_cache negative scalability

April 14, 2010 By 23 Comments

… between MyISAM and InnoDB and the difference in how the OS handles opened files? 3) Would converting the MyISAM tables to InnoDB fix or help the os ulimit max open tables issue? Thanks for your help… = 100M default_table_type = MYISAM log_long_format # Innodb innodb_status_file = 1 innodb_file_per_table = 1 innodb_data_home_dir = /db2/innodb innodb_log_group_home…

Filed Under: Benchmarks Tagged With:

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

March 4, 2013 By 7 Comments

… a table, and configure that table to be our stopword list for InnoDB? This is the table that we’re trying to emulate: mysql: SHOW CREATE TABLE information_schema.innodb_ft… may be possible to take the MyISAM full-text parser code, convert it to a plugin, and use it for InnoDB FT indexes where…

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

Post: Innodb Table Locks

July 31, 2012 By 4 Comments

… Innodb. Unless table is being locked explicitly Innodb “converts” table lock to “no lock” hence eliminating conflicts on MySQL level table locks for most queries. Summary: MySQL Table level locks and Innodb Table Level…

Filed Under: Insight for DBAs, MySQL

Post: Recovering Innodb table Corruption

July 4, 2008 By 22 Comments

… data in MyISAM table so all you have to do is to drop old table and convert new table back to Innodb after restarting without innodb_force_recovery option. You can also rename the old table…

Filed Under: Insight for DBAs Tagged With:

Post: A recovery trivia or how to recover from a lost ibdata1 file

June 3, 2011 By 8 Comments

… Innodb tables Once the Innodb tablespace id is minus one of a customer table alter the table definition from MyISAM to Innodb Discard the tablespace Replace the table… modified schema, the recovery completed. The customer was able to download the tables in MyISAM format and then he just convert them back to InnoDB.

Filed Under: MySQL

Post: MyISAM Scalability and Innodb, Falcon Benchmarks

October 12, 2007 By 10 Comments

We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several…, while lock is still held when key block is copied to processing thread local storage on Key Read Request. This lock… case was converting table t1 into InnoDB, and results: Threads Queries/sec 1 296 2 341 4 544 8 493 16 498 InnoDB both…

Filed Under: Uncategorized Tagged With: , , , ,

Post: MySQL Error control changes

February 19, 2007 By 4 Comments

… will not query all tables are accessible not catching such errors. If MySQL is started with Innodb tables disabled accesses to Innodb tables will simply result… seen people thinking they have converted things to Innodb while they really did not because it was substituted back to MyISAM. I do not…

Filed Under: Insight for Developers Tagged With:

Post: Using VIEW to reduce number of tables used

September 28, 2007 By 12 Comments

… of tables per server which can become really inefficient. It is especially inefficient with Innodb tables both in terms of space (some tables would… are one table per user so we have post123 table which keeps posts for user number 123 etc. Converting it to the views we can have “post” table which has…

Filed Under: Insight for Developers Tagged With: ,

Post: Stored Function to generate Sequences

April 2, 2008 By 17 Comments

Today a customer asked me to help them to convert their sequence generation process to the stored procedure and even though I have already… to use them instead of auto_increment with Innodb tables to avoid short term “table level locks” which innodb sets when Insert is happening in the table…

Filed Under: Insight for Developers Tagged With: ,

Comment: Unexpected problem with triggers and mysqldump

February 25, 2013 By 8 Comments

Another approach would be to use “–compatible=no_table_options” while dumping data. Make sure that InnoDB is the default engine. The catch… also remove the character set declaration from create table statement. Since you are converting MyISAM table to InnoDB I guess this will not be an…

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