For those who don’t know the Obfuscator is for reporting bugs and support requests where the schema,data and queries are not allowed to be disclosed.

At the moment it requires PHP5+ and MySQL5+, the only requirement at the moment is the mysqli extension. It’s being written so that a simple command line interface will be added later as well as a way of interfacing with it directly in PHP. Because of the pluggable style infrastructure the possibilities are left wide open.

Features:

• Multiple Query Obfuscation Multiple queries in a single obfuscation
  procedure, so that tables are obfuscated consistently over a few related
  queries.
• Query Reformating the tokeniser will be able to pretty print queries no
  mater how ugly your query is.
• Pluggable Schema Obfuscation Obfuscation of schema will be …

In addition to having the Malaysia University Days, there’s something brewing in Singapore too.

First up, there is the Singapore MySQL Meetup Group, having a meeting in July, at a new location (Sun Solutions Centre, Central Mall). Confirm your attendance for a meetup at 7pm on Monday, July 14 2008.

And the other reason to be in Singapore, is the Sun Developer Days 2008 Singapore, happening on Tuesday, July 15, 2008. This is an all-day long event, held at the Hilton Hotel - register …

As of July 1 all Canadian MySQLers are employees of Sun Microsystems. I was expecting that we would be the rear guard, I was going to greet the great day singing “a broken man on an Edmonton pier / the last of Monty’s engineers” (with thanks to the writer of “Barrett’s privateers”), or perhaps “And I, the last, go forth companionless … Among new men, strange faces, other minds.” (with thanks to Mr Tennyson). But as things turned out, the Ukrainians and the French were delayed. So Trudy Pelzer and I were the last Canadian engineers to come on board, but not quite last of all.

And it’s been wonderful. A free lunch, a tour of Sun’s Edmonton office, a SafeWord security doohickey, a carrying case, and an alternative address = peter.gulutzan@sun.com. More seriously, I’ve …

I didn't have a chance yet to write about this due to some recent travel, but better late than never. About 10 days ago, Nokia acquired the remaining 52% of Symbian that they didn't already own for a cool $410 million. Nokia also announced that they would open source all of the Symbian code. This follows on Nokia's earlier acquisition this year of Trolltech, the open source GUI toolkit developer, for $153 million. For those not familiar with it, Symbian is a platform created jointly between Nokia, Ericsson, Motorola and Psion ten years ago. (Symbian evolved from the EPOC platform... READ MORE

I've made a few fixes to the SVN version of Flexviews:
flexviews.enable() would return an error when trying to create an incremental refresh materialized view without an AVG() aggregate expression in the select clause.

Performance of DML is now improved substantially. Flexviews is designed to work in an environment with serialized DML (such as a MySQL slave). I removed extra serialization enforcement overhead. Previously two tables were involved in coordinating the 'uow_id' generation to ensure serialization in the logs. Now only one table is utilized. I need to add a procedure to auto-cleanup this new table.


There and there are a lot more to make. On my list of things to do:
1) code cleanup
flexviews went through several iterations and there are still 'mview' references all over the
place

some of the code is encased in comments because it was extracted by …

Project: MySQL Forge RSS/Atom feeds

KEY ACCOMPLISHMENTS LAST WEEK

* Updated local branch to the new code setup of the Forge
* Installed PHPUnit
* Read documentation from PHPUnit
* Read some documentation from SeleniumRC

KEY TASKS THAT STALLED LAST WEEK

* None

KEY CONCERNS

* None

TASKS IN THE UPCOMING WEEK

* Merging feeds with the BZR branch.
* Writing first PHPUnit tests.
* Extending existing PHPUnit testsuite to make it more suitable for use in the BZR branch.
* Installing SeleniumRC and exercise with its functionality.

The Daily WTF: Hastening an Inevitable

Keeping hundreds of millions of sheets of paper on file isn't easy, so the IRS had an application built to computerize their records. It'd scan paper tax returns into a WORM (Write Once, Read Many) drive system and record lookup data in a database. That way they could filter by any fields they recorded in the database and access a scanned image of the tax return for any further information using a simple app, which sure beat the old method of data retrieval - digging through boxes, incurring huge wait times.

The nice thing about the old method, though, was that it generally worked. The new system was full of bugs, in addition to several other irritating issues. On Bobby's first day he was put in front of the application, and right off the bat it looked amateurish. Form elements …

Baron recently wrote about very helpful but often forgotten about “Pager” feature of command line client. There is another one which falls into the same list - the –tee option.

Specifying –tee=/path/to/file.log you can get all session content (everything typed in and printed out) stored in the log file. Quite handy for example to keep track of changes done on production.

Moreover you can put tee=/logs/mysql.log in “mysql” section in my.cnf to have logging enabled automatically when you start the client.

If you’re looking to log session beyond MySQL command line client you can check out “script” tool.

Entry posted by peter | …

I’ve now published slides from my talk at Velocity conference on Percona web site. Enjoy.

Entry posted by peter | No comment

Add to: | …