A recent survey found that the most used BI tool isn’t what you might think (e.g. Business Objects, Pentaho, Cognos, Jaspersoft, etc.) – it’s Microsoft Excel. And I suppose that’s not so surprising given spreadsheets are the main communication medium for financial and general business analysis.
If you use Excel in this manner, you should know that you can use Excel’s data import capabilities to directly query (via the MySQL ODBC driver) and pull data from Read More...
Before I write an actual introductionary blog-post about Embedded PBXT's (or just "EPBXT"), I'd like to drop some lines to teach you how to get started with Embedded PBXT today. Currently, there is no binary version of EPBXT available, so you will have to build it from bzr directly.
Your system has to meet the following requirements for doing so:
In general, if you can successfully build drizzled and mysql on your box, compiling epbxt should work fine, too.
To kick-start the compilation process, there is a special makefile which automates the building process.
# wget …[Read more]
Looking around on Google for a webpage test script returns a lot of results. Some of them are useful, some are not. In particular, for Python, the scripts on the first page of results are minimal and lacking a useful copy and paste / ready to go script that will answer the question “is my webpage available?”. So I decided to write a quick one that will give you the return code and email you as an alert if the page does not return with a 200 code (successful). You can find the script here. Update: the webserver was trying to execute the script as a .py file so I just changed it to .txt – for it to work you will want to change the .txt extension to a .py extension after you download it.
If you are familiar with Python scripting, this script could easily be modified to post to a form so that you can test a MySQL transaction (or other transactional DB) …
[Read more]For those of you on the O’Reilly MySQL conference list you will no doubt see this email, but for readers here is the important bits.
Oracle Executive Will Speak at O’Reilly MySQL Conference &
Expo
Edward Screven to Answer Questions re: Future of MySQL
Sebastopol, CA, February 24, 2010—Wonder about the future of MySQL? Curious about what Oracle plans for the open source database software? Expect answers when Edward Screven, Oracle’s chief corporate architect and leader of the MySQL business, speaks at the O’Reilly MySQL Conference & Expo, scheduled for April 12-15, at the Santa Clara Convention Center and the Hyatt Regency Santa Clara.
Edward Screven reports to CEO Larry Ellison, and he drives technology and architecture decisions across all Oracle products to ensure that product directions are consistent with Oracle’s overall strategy. He’ll discuss the current and future state of …
[Read more]It is a pleasure to announce that Kontrollbase – the MySQL analytics and performance monitoring webapp for MySQL servers – has a new sponsor. Network Redux is located in Portland, Oregon and offers enterprise quality dedicated and managed hosting as well as cloud services. Thomas Brenneke contacted me to discuss his interest in utilizing the [...]
In MySQL significant performance improvements can be achieved by the correct use of indexes. It is important to understand different MySQL index implementations and one key improvement on indexes defined on single columns is to use multiple column or more commonly known concatenated indexes.
However it’s also possible to define ineffective indexes. This example shows you how to identify a concatenated index that is ineffective.
CREATE TABLE example ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, a INT UNSIGNED NOT NULL, b INT UNSIGNED NOT NULL, c INT UNSIGNED NOT NULL, d INT UNSIGNED NOT NULL, x VARCHAR(10), y VARCHAR(10), z VARCHAR(10), PRIMARY KEY (id), UNIQUE INDEX (a,b,c,d) ) ENGINE=InnoDB; INSERT INTO example(a,b,c,d) VALUES (1,0,1,1),(1,0,1,2), (1,0,2,3), (1,0,4,5), (2,0,2,1),(2,0,2,2), …[Read more]
In a time when many tradeshows are experiencing lower then normal attendance the 8th Annual Southern California Linux Expo (SCaLE 8x) had record attendance this past weekend in Los Angeles. I was there exhibiting and conducting a community training day for Zenoss and was very impressed by not only the quality of the program but the enthusiasm of the attendees.
Here are some of the highlights:
The Mini Conferences
On the Friday before the main SCaLE expo and speaking program starts many people hold …
[Read more]We’re pleased to announce that Blue Gecko is providing hosting and some technical support for Drizzle! Drizzle is a community-driven project based on the popular MySQL DBMS that is focused on MySQL’s original goals of ease-of-use, reliability and performance. For more information go to http://drizzle.org.
Related posts:
With the motivation from today’s public news on Twitter’s move from MySQL to Cassandra, my own skills desire following in-depth discussions at last November’s Open SQL Camp to consider Cassandra and yesterday’s discussion with a new client on persistent key-value store products, today I download installed and configured for the first time. Not that today’s news was unexpected, if you follow the Twitter Engineering Open Source projects you would have seen Cassandra as well as other products being used or evaluated by Twitter.
So I went from nothing to a …
[Read more]I’ll be helping Morgan Tocker deliver the second half of his training course for MySQL Developers/DBAs in New York City in a few days (more Percona training). It was a snap decision at the last minute, but I’m hoping I’ll still get to meet some folks there. If we’ve corresponded over email or blog comments and you would like to get together, ping me in the comments here!
If you’re in the New York City area and you use MySQL, you should consider attending this course, too. Morgan knows his stuff and has written a good curriculum. Attendees give his courses excellent feedback, and the price is very reasonable. Oh, and I’ll be there too, did I mention that? You can pick my …
[Read more]