• common_schema & openark-kit in the media: #DBHangOps, OurSQL

    June 26, 2013

    #DBHangOps I had the pleasure of joining into @DBHangOps today, and speak about common_schema and openark-kit. What was meant to be a 15 minute session turned to be 50 -- sorry, people, I don't talk as much at home, but when it comes to my pet projects... I also realized I was missing on a […]

  • Working at Outbrain

    June 21, 2013

    I'm starting my new position as Senior Software Engineer at Outbrain. While I'm still to fully grasp the scope of my work, I will be handling data on all things MySQL, Hadoop, Cassandra, Kafka, more, more and more, at very large volumes. I find Outbrain a great supporter of community and open source: Open source […]

  • Easy SELECT COUNT(*) with split()

    June 8, 2013

    The two conservative ways of getting the number of rows in an InnoDB table are: SELECT COUNT(*) FROM my_table: provides with an accurate number, but makes for a long running transaction which take ages on large tables. Long transactions make for locks SELECT TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='my_schema' AND TABLE_NAME='my_table', or get same info via […]

  • Converting compressed InnoDB tables to TokuDB 7.0.1

    June 5, 2013

    Or: how to make it work in TokuDB version 7.0.1. This is a follow up on a discussion on the tokudb-user group. Background I wanted to test TokuDB's compression. I took a staging machine of mine, with production data, and migrated it from Percona Server 5.5 To MariaDB 5.5+TokuDB 7.0.1. Migration went well, no problems. […]

Powered by Wordpress and MySQL. Theme by openark.org