June 19, 2013

Post: Choosing innodb_buffer_pool_size

November 3, 2007 By 39 Comments

…to readjust it later. This is also valid approach as if it is Dedicated MySQL Server you may not have a…tables). I could tell…MyISAM tables (mysql database, temporary etc) will need it, .frm file, binary logs, or relay logs, Innodb Transactional Logs also like to…

Filed Under: Insight for DBAs Tagged With:

Post: What exactly is read_rnd_buffer_size

July 24, 2007 By 4 Comments

…to – SQL or storage engine. Honestly as it had name very similar to read_buffer_size which is currently only used by MyISAM tables…to see how it really impacts performance both for MyISAM and Innodb…

Filed Under: Insight for DBAs Tagged With:

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

March 4, 2013 By 7 Comments

…MyISAM list. What happens if we take the MyISAM stopwords, insert them into a table, and configure that table to be our stopword list for InnoDB? This is the table…

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

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…to convert MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe the client is…to the query or the table. We explain how to interpret what we’re showing, and why the proposed modifications are better. If…

Filed Under: Insight for Developers Tagged With:

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

February 26, 2013 By 1 Comment

…to find out how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works compared to traditional MyISAM FTS. We’ll get to…

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

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

…to consume more than one page thus reducing performance. This is especially the problem as you have to specify single page size for Innodb table…or static record format ? (static record format for sort used by MyISAM may cause sort files to be much larger than table…

Filed Under: Events and Announcements Tagged With:

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 Comments

…a percent). Given that information, which server is badly tuned? If you said “I still can’t tell…InnoDB, some MyISAM, which is more important to you, etc) and choose an amount of memory based on how important those tables are to you, how…

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

Post: The tool I've been waiting for years

March 18, 2008 By 10 Comments

…table for MyISAM and Archive tables to INFORMATION_SCHEMA (or other system tables) which would be really cool Of course than one would need to…Innodb, Falcon, Maria. Having information about how large portion of table is cached would allow optimizer to…

Filed Under: Insight for DBAs Tagged With:

Post: Implementing efficient counters with MySQL

July 1, 2007 By 16 Comments

…to deal with is log flushes. If you have innodb_flush_log_at_trx_commit=0 or 2 or if you use MyISAM tables…is a passive cache, meaning it just caches stuff and you can’t easily tell it to perform certain action (ie write back to… MyISAM or HEAP tables for this purpose, how do you deal with Table Locks…

Filed Under: Insight for Developers Tagged With: ,

Post: Test Drive of Solid

September 22, 2006 By 5 Comments

…INNODB STATUS (at least) – so it is hard to tell what is really happening. Test 3: Phantom rows: Table before test: select * from test2; +—-+——–+ | id | names | +—-+——–+ | 1 | Mysql | | 2 | Solid | | 3 | MyISAM…

Filed Under: Uncategorized Tagged With: ,
« Older Posts