Openark - openark.org - code.openark.org
General Information:
Latest News:
Trick: recovering from "no space left on device" issues with MySQL 23 Aug 2013 | 04:25 pm
Just read Ronald Bradford's post on an unnecessary 3am (emergency) call. I sympathize! Running out of disk space makes for some weird MySQL behaviour, and in fact whenever I encounter weird behaviour ...
common_schema 2.2: better QueryScript isolation & cleanup; TokuDB; table_rotate, split params 13 Aug 2013 | 08:39 am
common_schema 2.2 is released. This is shortly after the 2.1 release; it was only meant as bug fixes release but some interesting things came up, leading to new functionality. Highlights of the 2.2 r...
Tool of the day: q 8 Aug 2013 | 02:26 pm
If you work with command line and know your SQL, q a great tool to use: q allows you to query your text files or standard input with SQL. You can: And you can: And you can also combine with your fa...
common_schema roadmap thoughts 22 Jul 2013 | 05:36 pm
I'm happy with common_schema; it is in fact a tool I use myself on an almost daily basis. I'm also happy to see that it gains traction; which is why I'm exposing a little bit of my thoughts on general...
common_schema 2.1 released: advanced & improved split(), persistent script tables, more schema analysis, and (ahem) charts! 17 Jul 2013 | 11:57 pm
common_schema 2.1 is released! common_schema is your free & open source companion schema within your MySQL server, providing with a function library, scripting capabilities, powerful routines and read...
common_schema & openark-kit in the media: #DBHangOps, OurSQL 27 Jun 2013 | 12:46 am
#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 ...
Working at Outbrain 21 Jun 2013 | 09:55 pm
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, ...
Easy SELECT COUNT(*) with split() 8 Jun 2013 | 09:41 am
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 age...
Converting compressed InnoDB tables to TokuDB 7.0.1 5 Jun 2013 | 12:10 pm
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 ...
mycheckpoint revision 231 released 23 May 2013 | 05:21 pm
A new release for mycheckpoint: lightweight, SQL oriented MySQL monitoring solution. If you're unfamiliar with mycheckpoint, well, the one minute sales pitch is: it's a free and open source monitoring...
