Archive for the ‘analytics’ Category

Kontrollbase – new version available with improved analytics

Август 23rd, 2010
A new version of Kontrollbase – the enterprise monitoring, analytics, reporting, and historical analysis webapp for MySQL database administrators and advanced users of MySQL databases – is available for download. There are several upgrades to the reporting code with improved alert algorithms as well as a new script for auto-archiving of the statistics table based [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

InfiniDB Subquery Performance Profile – New with 1.1.1 Alpha

Апрель 30th, 2010

Let's take quick look at the performance of the new InfiniDB Subquery processing available with the 1.1.1 Alpha.  The arrow was added to be sure our timings weren't confused with the axis.



This was against a relatively small dataset, the Star Schema Benchmark with 6 million rows in the fact table.  A base query was run where the outer queryRead More...
PlanetMySQL Voting: Vote UP / Vote DOWN

Kontrollbase – revision 297 fixes Reporter-CLI “alert_22″ sub-routine

Апрель 13th, 2010
Quick note to let our users know that there was an XML tag closure error on the “alert_22″ subroutine in the “bin/kontroll-reporter-cli.pl” script. This does not affect the webapp portion of Kontrollbase – only reports generated via the command line reporter script. It is not a fatal error but will cause the XML file to [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Kontrollbase – graph “no data to display” on new install has been fixed

Март 25th, 2010
If you have been wondering why the overview and graphs pages say “no data to display” on the graphs when you first install Kontrollbase, it’s because there’s no data in the database being returned from the queries that generate the graphs – this is because a new install has no data to graph. This has [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Having an issue with a Kontrollbase upgrade?

Март 23rd, 2010
If you’ve noticed that your recent upgrade did not go as planned and now the application does not load – please check this page: http://wiki.kontrollsoft.com/wiki/UpgradingReleases for notes on upgrades between versions. Typically you need to execute a SQL file against the current schema to bring it up to date. If you have any questions please [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Kontrollbase rev292 gets important UI layout fixes

Март 19th, 2010
This is a small revision and will only be available through SVN. However, it is an important one to speak about as it solves a former issue when running the application on a screen smaller than 1024px wide. While most users may not have noticed this since they have larger monitors it has been noticed [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Kontrollbase wiki being migrated to Trac

Март 17th, 2010
Just a quick bit of news to let you all know that additions to the standard Kontrollbase and Kontrollkit userguides are being halted while we migrate the documentation to a new wiki system run by the very nice Trac software. You will be able to access the Kontrollbase and Kontrollkit documentation at http://wiki.kontrollsoft.com when it [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Kontrollbase – queries to update your max_connections alert

Февраль 26th, 2010
If you have been reading the Kontrollbase performance reports and noticed that one alert says your connection usage vs max connections ration is too high but then recommends you to decrease the max_connections variable, then you will find this fix handy. Its two simple queries that execute on the Kontrollbase schema to update the max_connections [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Kontrollbase – scripts being rewritten in Python, request improvements now!

Февраль 4th, 2010
The time has come for major performance improvements to the reporter, stats-gather, alerter, and client scripts. This means that I will be rewriting the scripts in Python. A couple of reasons for this; to cut down on the number of modules that are required for the installation process (which also makes distributing the client script [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Kontrollbase user’s group on Brijj.com

Февраль 2nd, 2010
We have a new users’s group on Brijj for anyone that wants to keep up to date with discussions and wants to increase their network profile on the site. Join now: http://www.brijj.com/group/kontrollbase-users
PlanetMySQL Voting: Vote UP / Vote DOWN