Week 3(9th June – 16th June)

Key Accomplishments Last Week

1) Successfully went through the complete presentation on http://forge.mysql.com/wiki/How_to_Build_MySQL_on_Windows/Presentation

2) Successfully built mysql from source by following the instructions http://forge.mysql.com/wiki/MySQL_Internals_Guided_Tour.

3) Resolved all errors that arose from steps 1) and 2) on my system.In the process I gained plenty of insight into the internal working of mysql and ubuntu.

4) Mysqlslap is written in the C API. Hence I began to read about the C API for writing client programs to access the mysql database.

Key Tasks that stalled Last Week

None

…

Week 3(9th June – 16th June)

Key Accomplishments Last Week

1) Successfully went through the complete presentation on http://forge.mysql.com/wiki/How_to_Build_MySQL_on_Windows/Presentation

2) Successfully built mysql from source by following the instructions http://forge.mysql.com/wiki/MySQL_Internals_Guided_Tour.

3) Resolved all errors that arose from steps 1) and 2) on my system.In the process I gained plenty of insight into the internal working of mysql and ubuntu.

4) Mysqlslap is written in the C API. Hence I began to read about the C API for writing client programs to access the mysql database.

Key Tasks that stalled Last Week

None

…

So everybody and their dog hopefully knows about SQL injection attacks these days. Most people should have also heard someone telling them that using prepared statements is the magic super fix to all of these issues. People slightly more in the know will have read that prepared statements lead to all sorts of issues. Some of which can be fixed with hacks (or eventually at the source). Some of which can only be solved of the source also exist of course. Some others can only be fixed with certain assumptions (like using the first set of data for generating the …

One of our replication slave broke last night. This is another strange one. I have multiple slaves running under version 4.1.19 (yup, this is an old one, hehe). But for some strange reason, only one replication slave exhibited the following behavior: It would seem like it cannot create a temporary table while other replication slaves have no problem with it. See below for the example.

mysql> create temporary table abc (id int);
ERROR 1046 (3D000): No database selected

mysql> \u customer
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

mysql> create temporary table abc (id int);
ERROR 1049 (42000): Unknown database 'customer'

mysql> create table abc (id int);
Query OK, 0 rows affected (0.01 sec)

mysql> \u test
…

In this BLOG post I will concentrate on the achievements with data synchronization with SQLyog 7.0 (beta 1 released just before the weekend).

SQLyog 7 provides 2-8 times speed improvement (depending on data) with a ‘mixed-type’ of syc-job (involving both INSERTS, UPDATES and DELETES) as compared to SQLyog 6. A few comparison examples (SQLyog 6, SQLyog 7 and Maatkit) with 4 testcases:

a)
Source Rows: 3950400, Target Rows: 3950400, Inserted Rows: 49599, Updated Rows: 49500, Deleted Rows:49599. Primary Col(INT). InnoDB
SQLyog 6: 1120 sec
SQLyog 7: 267 sec
Maatkit : 530 sec

b)
Source Rows: 48025 , Target Rows: 48775, Inserted Rows: 1225 , Updated Rows:1225, Deleted Rows : 1975. Primary Col(INT), InnoDB.
SQLyog 6: 30 sec
SQLyog 7 : 8 sec
Maatkit : 19 sec

c)
Source Rows:150404 , Target Rows: 152864, Inserted Rows: 12136, Updated Rows: 16236, …

UPDATE - 2008-06-23 - A member of O’Reilly’s editing team commented that this privilege has *NOT* been discontinued, and all O’Reilly authors should receive a free Safari account. Thanks a bunch, Mary, for the clarification (see comments for more).

I learned from one of the authors of the recently released second (read: first, squared) edition of High Performance MySQL that O’Reilly apparently did away with the idea of giving O’Reilly book authors free Safari accounts. Lame.

I do not know why in the world they would discontinue this offering for authors. Perhaps they’re not aware, but a great many of the O’Reilly authors are also bloggers. Tech bloggers. Some of them write on the O’Reilly blogs themselves, but …

Neocleus obtains new round of funding. Novell releases OpenSUSE 11. Red Hat acquires open source identity code from Identyx. (and more)

Neocleus Raises Over $11M in Series B Financing, Neocleus (Press Release)
openSUSE Project Announces Availability of openSUSE 11.0, Novell (Press Release)

Red Hat Delivers on Linux Automation with Identity Management and Open Source Systems Management Solutions, Red Hat (Press Release)

Sun Microsystems Releases New Version of Open Source …

With the bulk of my classes over, I finally have time to read some hand-picked books (rather than those 1000 page dry volumes required for courses). This is perfect timing since the new “High Performance MySQL” book was just released. I got a little carried away with my order, but felt I should catch up on some books I’ve been eyeing for some time. Anyone else care to share their summer reading list?

By June 30th, I should have:

• High Performance MySQL: Optimization, Backups, Replication, and More
• The Art of Multiprocessor Programming
• The Definitive ANTLR Reference: Building Domain-Specific Languages
• Programming Erlang: Software for a Concurrent World
• The Joy of Vegan Baking: The Compassionate Cooks’ Traditional Treats and Sinful Sweets

(The last book is for both Wendy and me, it should help provide tasty treats while reading the others)

I …

After 4 good releases, Ubuntu let me down with 8.04. Maybe it was the timing - I upgraded my laptop as part of restoring it from a hard drive crash a few weeks ago - but isn't a brand new disk a good time to change your OS version? 

 On the upside, Hardy was the first OS I've installed where I opted to keep the default wallpaper (the bird is purty). And I'm pretty sure suspend (nVidia driver and all) was working better than previously, which is always good news. 

But I no longer had use of the VGA port for cloned or extended desktop, and I was unable to find a solution. That's a dealbreaker for anyone who needs to do frequent presentations (or, for that matter, uses their laptop as a primary workstation and has a > 15" monitor).

Worse, vpnc was, at best, squirrelly. I do quite a lot over VPN, and we still have two of them (Sun & MySQL). My sunray solves …

After 4 good releases, Ubuntu let me down with 8.04. Maybe it was the timing – I upgraded my laptop as part of restoring it from a hard drive crash a few weeks ago – but isn’t a brand new disk a good time to change your OS version? 

 On the upside, Hardy was the first OS I’ve installed where I opted to keep the default wallpaper (the bird is purty). And I’m pretty sure suspend (nVidia driver and all) was working better than previously, which is always good news. 

But I no longer had use of the VGA port for cloned or extended desktop, and I was unable to find a solution. That’s a dealbreaker for anyone who needs to do frequent presentations (or, for that matter, uses their laptop as a primary workstation and has a > 15" monitor).

Worse, vpnc was, at best, squirrelly. I do quite a lot over VPN, and we still have two of them (Sun & MySQL). My sunray solves half of that problem for me, but until …