• TokuDB configuration variables of interest

    October 23, 2013

    During our experiments I came upon a few TokuDB variables of interest; if you are using TokuDB you might want to look into these: tokudb_analyze_time This is a boundary on the number of seconds an ANALYZE TABLE will operate on each index on each partition on a TokuDB table. That is, if tokudb_analyze_time = 5, […]

  • 5 years of blogging

    October 22, 2013

    openark.org blog is now five years old. Hurrah! Throughout these five years I posted almost exclusively MySQL oriented blogs, though I had every intention of writing on various engineering topics. I still see blogging as one of the most important forms of knowledge sharing, and indeed for me the blogs aggregated at Planet MySQL are […]

  • Converting an OLAP database to TokuDB, part 3: operational stuff

    October 14, 2013

    This is the third post in a series of posts describing our experience in migrating a large DWH server to TokuDB (see 1st and 2nd parts). This post discusses operations; namely ALTER TABLE operations in TokuDB. We ran into quite a few use cases by this time that we can shed light on. Quick recap: […]

  • On MySQL plugin configuration

    October 1, 2013

    MySQL offers plugin API, with which you can add different types of plugins to the server. The API is roughly the same for all plugin types: you implement an init() function, a deinit(); you declare status variables and global variables associated with your plugin, and of course you implement the particular implementation of plugin call. […]

 
Powered by Wordpress and MySQL. Theme by openark.org