June 19, 2013

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

November 24, 2011 By 2 Comments

…_innodb.cc:2284) ==9090==    by 0x712F17: ha_initialize_handlerton(st_plugin_int*) (handler.cc:435) ==9090==    by 0x7A212A: plugin_initialize(st_plugin_int*) (sql_plugin… code against future changes that might make the issues not-so-minor. Additionally, I’d consider backporting and using MySQL 5…

Filed Under: MySQL

Post: How to Monitor MySQL with Percona's Nagios Plugins

February 22, 2012 By 11 Comments

…, and it won’t be deleted until the server restarts, so the problem remains undetected while it becomes more and more… its data directory. InnoDB is getting stuck, has long-running transactions, or other problems. The pmp-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage

January 13, 2010 By 13 Comments

… for InnoDB-plugin. Here we observe innodb_adaptive_flushing in action (which is ON by default), and I think innodb_adaptive_flushing in InnoDB-plugin is… are: So I guess buffer_pool improvements play here for XtraDB, and looking on summary result: InnoDB 9439.316 NOTPM InnoDB-plugin-1.0…

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency

December 3, 2008 By 15 Comments

… did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used… regression from plugin increases with number of cores. If you would not only run MySQL plugin but also use new “Barracuda” Innodb format… execution path. Another thing to note – if you’re using Innodb Plugin consider using new Barracuda format, though do this only after…

Filed Under: Benchmarks Tagged With:

Post: Real-Life Use Case for "Barracuda" InnoDB File Format

April 23, 2008 By 11 Comments

… new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could… convert customer’s data to Barracuda file format using new InnoDB plugin recently released by Oracle. First thing I’ve tried was… 16kb pages down to 8kb) new innodb plugin performs TEXT/BLOB/VARCHAR fields compression off-page so every large TEXT field could become…

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

Post: Blob Storage in Innodb

February 9, 2010 By 13 Comments

… (used in before Innodb plugin and named “Antelope” in Innodb Plugin and XtraDB) Innodb would try to fit the whole row onto Innodb page. At least… have its own 16K allocated. This can be pretty inefficient so I’d recommend avoiding multiple large blobs per row when… and the fix comes with Innodb Plugin in “Barracuda” format and ROW_FORMAT=DYNAMIC. In this format Innodb stores either whole blob on…

Filed Under: Insight for DBAs, MySQL Tagged With:

Comment: Great work Innodb Team

December 1, 2009 By 8 Comments

… Innodb with plugin can compromise stability and surely introduce number of behavior changes which are not intended to happen in “Stable” release. So giving the Option of easily enabling Innodb plugin in MySQL 5.1 is a great… to stay using BuiltIn Innodb and people who like Features and Performance to use Innodb Plugin. I would expect if Innodb plugin goes to “GA…

Filed Under: Events and Announcements Tagged With:

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

March 4, 2013 By 7 Comments

… | Bamish James Peterson | 1 | +——–+——————————+——————–+ With 5.6, we’re not so fortunate. mysql: SELECT id, full_name, MATCH(full_name, details… full-text parser code, convert it to a plugin, and use it for InnoDB FT indexes where you’re expecting MyISAM-style…

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

Post: Interested to learn about New Innodb Plugin Performance ?

April 15, 2008 By 2 Comments

As you probably have already heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see Heikki and the… this Plugin you’re welcome to come to presentation by Heikki and Ken which will be followed by my presentation on Innodb Scalability Limits. I will not go a lot into this plugin performance because I did not…

Filed Under: Uncategorized Tagged With: ,

Comment: InnoDB in self-compiled MySQL 5.1

July 19, 2010 By 9 Comments

… and trying –with-innodb, –with-plugin-innodb, etc. I trawled the configure script and found –with-plugins= and innobase / innodb_plugin. I assumed innodb_plugin, but I have no idea whether innobase is required, so I included that for…

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