Sample explanation and code to create data cubes in MySQL using a Gearman UDF and a perl worker. No need to know Perl. This method allows anyone to create crosstabs in SQL, regardless of the programming language used to query the database.

Yesterday evening, a friend of mine had some issues with installing DBD::mysql, and asked if I had encountered the same issue. The problem, as the output from "make test" showed, was that certain symbols was missing:# Tried to use 'DBD::mysql'.# Error: Can't load '/Users/westerlund/src/perl/DBD-mysql-4.008/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/westerlund/src/perl/DBD-mysql-4.008/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _is_prefixFair enough, this is related to a 64-bit issue with MySQL---at least with my Perl version, which is now: Summary of my perl5 (revision 5 version 10 subversion 0) configuration: Platform: osname=darwin, osvers=9.5.0, archname=darwin-thread-multi-64int-2levelIf you try to link to a x86_64 version of MySQL, then you get the above mentioned error. So, I downloaded an x86 version of MySQL and tried again. The output from  []

If you work with databases long enough, you run into a certain problem. You have a mysqldump file* of a table or a database, and you need to import it into your new database. However, you need to change something in the file first. Maybe the "INSERT" statements need to be changed to "INSERT REPLACE". You fire up "vi "and load the file, but when you go to search and replace, "vi" runs out of memory and doesn't complete the operation. Or maybe the dump file is just so big it won't even load in the first place. What do you do in this situation?Well, one simple solution is to use the "sed" tool to modify the file. Sed actually stands for "stream editor". The "vi "editor would be considered a static editor in that it loads all of the file into memory at once. If you run out of memory, you are out of luck. With  []

MySQL users often dream about a more powerful yet stable database server. They want a server with more features, like expanding macros, customized logging, access to shell commands, access to live tables from other DBMS. Every feature, given enough development time, can be eventually implemented, but users want them now, with the current GA server. It can be done. Using a proxy server, some of those dreams come true. Today.

How to write MySQL test cases

How to write MySQL test cases

Perl stored procedures provide greater flexibility than the standard SQL stored procedures. For many users, they can provide performance and connectivity which is not available from the built in SQL implementation, where many users have to resort to writing UDFs.