As pointed out by Schlomi Noach on my last blog, MySAR was already taken by a project related to Squid reports with MySQL. I decided then to look for a new name, and as I posted initially, I want to keep the sar prefix to describe the script’s purpose by association with the OS utility of the same name. I brainstormed many names. I liked Dave Edwards’s suggestion: SARkila, but it sounds too close to tequila, so I settled with Sheeri Cabral’s suggestion: sar-sql.

The title of the Launchpad page already reflects the change. What remains to be done is: a) change the name of the Perl script and documentation; and b) change the Launchpad URL. It is likely that I will change the name of the script when I release version 1.x (see below). I’m not sure of all the implications in Bazaar …

If you are running Kontrollbase on or against a MySQL 5.1 server please be aware that the alert for “table_cache” will alert incorrectly. This is because table_cache has been removed as a variable in MySQL 5.1 – so don’t worry when you see this alert. We are in the process of removing alert error this [...]

Just a quick note to let you know that Part 2 of my Intro to InfiniDB article is now live on the MySQL dev zone... Let me know if you have any questions or comments.

Just a quick note to let you know that Part 2 of my Intro to InfiniDB article is now live on the MySQL dev zone... Let me know if you have any questions or comments.

In the article ‘An alternative way of EAV modelling’, I discussed how to do EAV modelling by casting all values (except text) to integers. I’ll continue on that and talk about more advanced topics like multi-value fields.

As binary set
Not all questions have only a single option. Some fields we want to represent by radio-buttons, allow the user to select any number of options. For this we can mimic the behaviour of the SET field type of MySQL. A SET is almost similar to an ENUM, except that each bit represents an option. The value can have multiple bits enabled to represent multiple options.

Example: field options for field ‘programming language’

+-------+-------------+
| value | description |
+-------+-------------+
| 1     | C/C++       |
| 2     | PHP         |
| 4     | Java        |
| 8 …

On Thursday, November 29th (tomorrow) Padraig O'Sullivan, a graduate student and Drizzle team member extraordinaire and amazing developer who has worked on a number of projects both for Drizzle and libmemcached-- and who also helped me get the memcached functions for Drizzle off the ground is giving a webinar on the C++ API to libmemcached. As the site mentions, this webinar will explain the the functionality of memcached and how it can be used to scale applications, providing a "technical deep dive" into libmemcached's C++ interface. Also, presented will be the current status of the memcached (as well as libmemcached) project, future development goals and how to participate in the memcached community, something Dustin has recently posted about.

SilverStripe is a open source content management system(CMS) to create and
maintain website, it is currently published to the OpenSolaris /contib repository.

Installation of SilverStripe on OpenSolaris is straightforward by simply clicking
the installation button on the silverstrip's 'install.php' page,
however, the installation didn't work complaining with mysql query
execution failed:

"[User Error]  Couldn't run query: SELECT `SiteTree_Live`.\*,
`GhostPage_Live`.\*, `ErrorPage_Live`.\*, `RedirectorPage_Live`.\*,
`VirtualPage_Live`.\*, `SiteTree_Live`.ID,
if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS
RecordClassName FROM `SiteTree_Live` LEFT JOIN …

SilverStripe is a open source content management system(CMS) to create and
maintain website, it is currently published to the OpenSolaris /contib repository.

Installation of SilverStripe on OpenSolaris is straightforward by simply clicking
the installation button on the silverstrip's 'install.php' page,
however, the installation didn't work complaining with mysql query
execution failed:

"[User Error]  Couldn't run query: SELECT `SiteTree_Live`.\*,
`GhostPage_Live`.\*, `ErrorPage_Live`.\*, `RedirectorPage_Live`.\*,
`VirtualPage_Live`.\*, `SiteTree_Live`.ID,
if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS
RecordClassName FROM `SiteTree_Live` LEFT JOIN …

I would like to welcome everyone to the new InfiniDB CE home at InfiniDB.org!

We have been working hard on creating this community to be both informative, easy to navigate and built with functionality to let all of the users have and give their feedback. If there is any sugestions you may have please stop by the forum and make a post in the "Suggestion Box".

To get to the forums, just go to the dropdown menu under "Community" and it is the first link you will see - "Forums".

Read More...

I would like to welcome everyone to the new InfiniDB CE home at InfiniDB.org!

We have been working hard on creating this community to be both informative, easy to navigate and built with functionality to let all of the users have and give their feedback. If there is any sugestions you may have please stop by the forum and make a post in the "Suggestion Box".

To get to the forums, just go to the dropdown menu under "Community" and it is the first link you will see - "Forums".

Read More...