MySQL Tracking for Kernl Analytics

Starting today MySQL tracking (+MariaDB & Percona) is available to all Kernl Analytics customers. Using this information you can tailor your plugin/theme to use more powerful features available in later MySQL/MariaDB versions such as the JSON datatype. To enable this feature you need to upgrade to latest version of the Kernl Update Checker (>= 2.5.0)… Continue reading MySQL Tracking for Kernl Analytics

Migrating Kernl Analytics from Batch-Driven to Realtime

When we first started capturing realtime analytics data for Kernl it was a simple affair: 1 table N columns (id, date, product_uuid, domain, product_version, php_version,….) This worked well for the first few weeks, but eventually we started to see serious performance degradation as the table size grew. The first step we took was to normalize… Continue reading Migrating Kernl Analytics from Batch-Driven to Realtime