June 19, 2013

Post: Performance problem with Innodb and DROP TABLE

February 3, 2011 By 23 Comments

…this bug at this time. The problem is basically if you’re running innodb_file_per_…which were responsible for poor performance of SHOW STATUS and crash recovery performance over last couple of years…vary a lot depending on buffer pool size. MyISAM tables creating/dropping was several times faster …

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: MySQL Performance Blog now uses Sphinx for Site Search

February 15, 2008 By 52 Comments

… Google search if I wanted to find something on MySQL Performance Blog. Today we have published new search functionality for our… Sphinx query language to search phrases or Search MyISAM in post title. Besides basic search functionality we’ve implemented list of last… fun and for SEO. Hope this addition will make MySQL Performance Blog more useful for you. UPDATE: For those looking to…

Filed Under: Insight for Developers Tagged With: , ,

Post: Paul McCullagh answers your questions about PBXT

November 20, 2009 By 2 Comments

… log-based architecture makes performance characteristics different to both MyISAM and InnoDB/XtraDB. Tests show that PBXT’s performance is similar to InnoDB… actually out perform InnoDB with SELECTs under circumstances. The implementation of full-durability has changed the performance characteristics of PBXT from “MyISAM-like…. It’s job is to clean up after a transaction. Basically it recognizes which record versions are no longer needed and…

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

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

February 26, 2013 By 1 Comment

… sense of how it works compared to traditional MyISAM FTS. We’ll get to performance in the third installment. For now, the… the way, let’s get to it. Here is our basic table definition for the DIR dataset. The table for the… with AutoCommit enabled – remember, the focus here isn’t on performance just yet. Having loaded the data, the first thing we…

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

Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?

January 24, 2008 By 30 Comments

… – This is MyISAM table which is accessed via index, which means to retrieve each row MySQL will have to perform OS system…, which is unique,it is pre-read and query executed basically on single table querying state by ID. Next test was… As you can see, ENUM and VARCHAR show close performance, while join performance degraded dramatically. Here is why: mysql> explain select SQL…

Filed Under: Benchmarks Tagged With: , , , , , , ,

Post: MySQL File System Fragmentation Benchmarks

March 21, 2008 By 28 Comments

… basic things we can learn from these results – Concurrent growth of many tables causes data fragmentation and affects table scan performance nadly – MyISAM suffers worse than Innodb – Innodb extent allocation works (perhaps would be good option for MyISAM as well…

Filed Under: Benchmarks Tagged With: ,

Post: Test Drive of Solid

September 22, 2006 By 5 Comments

…far goal is the performance and scalability testing before I wanted to look at basic transactional properties such as … * from test2; +—-+———–+ | id | names | +—-+———–+ | 1 | Mysql | | 2 | Solid | | 3 | MyISAM | +—-+———–+ Session1: mysql> begin; Query OK, 0 rows affected (…

Filed Under: Uncategorized Tagged With: ,

Post: What exactly is read_rnd_buffer_size

July 24, 2007 By 4 Comments

… sort is performed it can be performed having only row pointers together with key value – which are offsets for MyISAM and primary key… which are being length can be converted to fixed size (basically everything but BLOB/TEXT) MySQL can use read_rnd_buffer… should do benchmarks sometime to see how it really impacts performance both for MyISAM and Innodb.

Filed Under: Insight for DBAs Tagged With:

Post: What to do with MySQL Full Text Search while migrating to Innodb ?

September 10, 2009 By 12 Comments

… queries. This approach is helpful if migration has to be performed very quickly and it takes a lot of time to… can just rebuild the table from Innodb source on regular basics. In case you can afford to have stale data in… lot especially if performance of full text search is an issue to. This eliminates the need to have MyISAM table anywhere. We…

Filed Under: Insight for Developers Tagged With: ,

Post: 10+ Ways to Crash or Overload MySQL

November 13, 2007 By 20 Comments

… a trivial way to crash MySQL to the user with basic privileges and asking me what to do. My answer to… tables ? This can be offset by keeping myisam_sort_buffer_size low, but then performance would suffer. Prepared Statements Number – Happily now… Both Innodb and MyISAM have hotspots and having few connections which use appropriate operations heavily you can reduce system performance beyond being…

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