The latest version of Kontrollbase – the opensource enterprise MySQL analytics and performance tuning application –  is available for download. Since the previous one, version 225, there have been a lot of great changes. The most significant being the development and inclusion of the Reporter CLI script – which is a combination of the client, [...]

It’s about time to add a new major feature to Kontrollbase. I’ve had some great feedback from the user community regarding features and options for improvement. Here’s your chance to get a vote in on the next addition. Vote now!

More stats for your consumption! Here are the latest additions to the environment overview reporting features. On the overview page, as of revision 238, you will find the following data for your servers. Update your revision now using ’svn update’ to get the new features or wait until the next formal release if you are [...]

I’ve been messing around with the Kontrollbase schema for the last couple of days, writing various queries for the daily reporting scripts that will eventually be an automated pdf report. I’ll give you examples of two of the queries, the first being overall environment stats, and the second being single-host growth over time.

Overall environment stats
select ((((MAX(os_mem_used)) / 1024 ) / 1024) / 1024) max_os_mem_used, ((((MIN(os_mem_used)) / 1024 ) / 1024) / 1024) min_os_mem_used, ((((AVG(os_mem_used)) / 1024 ) / 1024) / 1024) avg_os_mem_used, ((((STDDEV_POP(os_mem_used)) / 1024 ) / 1024) / 1024) stdev_os_mem_used, ((((MAX(length_data + length_index)) / 1024 ) / 1024) / 1024) max_size, ((((MIN(length_data + length_index)) / 1024 ) / 1024) / 1024) min_size, ((((AVG(length_data + length_index)) / 1024 ) / 1024) / 1024) avg_size, ((((STDDEV_POP(length_data + length_index)) / 1024 ) / 1024) / 1024) …

Just a reminder to all of those users that are enjoying Kontrollbase – if you get a minute in your day please go to the MySQL Forge site and put your vote in on Kontrollbase. It’s a simple star based vote on the right side of the page located here: http://forge.mysql.com/projects/project.php?id=318

If you are having an issue with adding hosts/clients/users on revision 162 it’s because of the INSERT DELAYED sql command being used. Before I release a new version, please change the following lines in the file “system/application/models/mode_app.php” Incorrect code line 70: $sql0="INSERT DELAYED INTO server_list ( line 139: $sql0="INSERT DELAYED INTO `server_client` ( line 177: $sql0="INSERT DELAYED INTO `system_users` [...]

This comes rather quickly as the last revision – 150 was just uploaded a few days ago. This is because there was a new method of checking config options in the bin/ scripts that utilizes the codeigniter config files instead of config.cfg in the base directory, the problem was the all of the required bin/ [...]

There have been a lot of changes to the UI since the original screenshots were uploaded so it was about time that the page should reflect the current look on the application. Check them out here to see the new theme and features: http://kontrollsoft.com/screenshots

This should be an interesting advance for Kontrollbase. I recently acquired a older dual 2ghz G5 PPC Power Mac running 10.5.8 and have just finished the installation of MySQL Community 5.0.85 (mysql-5.0.85-osx10.5-powerpc-64bit). I should note that the installation process is actually easier than it is on RHEL with RPMs. Quite nice. So, given this [...]

The latest version is available for download. Big changes include a debug log file view tab, redesigned system management screen, authentication ACL fixes, host state fixes for server-loop, AJAX’d user/host/client pages, data grids for all pertinent tables, and a fix for the slate theme submit button. If you are running an older version of Kontrollbase I would highly recommend upgrading. I’ll be adding an “upgrade” page to the documentation today for just that purpose. Download the new release here: http://kontrollsoft.com/software-downloads