If you're using Innodb tables MySQL has innodb_flush_log_at_trx_commit variable which defines how durable your transactions are. If you have high durability requirements you set it to 1 and log records are pushed directly to the disk on transaction commit. If you do not bother loosing come committed transactions you can set it to 0 and Innodb will only flush log approximately once per second. Finally you can set it to 2 which is flushes data to operation system cache (so if MySQL crashes transaction is not lost) but does not save from OS crashes or power failures.

So far so good. The only problem is many applications have different kind of transactions in the mix.

Indeed if you think about most Web applications different data (often updated in different transactions) have different durability requirements. For some of updates you really would hate to lose them, though they may be rare. For example if user …

To look a little bit more nice and because I do not want to spend to much time into my own blog/feed software I have decided to move all my writings here.

But the most interesting for me to is the readers feed back...

Sun engineers blog on the new multi-chip UltraSPARC T2 Plus systems

Today Sun is announcing new CMT-based systems, hard on the heels of the UltraSPARC T2 systems launched in October 2007 (the Sun SPARC Enterprise T5120 and T5220 systems). Whereas previous Sun CMT systems were based around a single-socket UltraSPARC T1 or T2 processor, the new systems incorporate two processors, doubling the number of cores and the number of hardware threads compared to UltraSPARC T2-based systems. Each UltraSPARC T2 Plus chip includes 8 hardware strands in each of 8 cores, so the Operating System sees a total of 128 CPUs. The new systems deliver an unprecedented amount of CPU capacity in a package this size, as evidenced by the very …

Sun engineers blog on the new multi-chip UltraSPARC T2 Plus systems

Today Sun is announcing new CMT-based systems, hard on the heels of the UltraSPARC T2 systems launched in October 2007 (the Sun SPARC Enterprise T5120 and T5220 systems). Whereas previous Sun CMT systems were based around a single-socket UltraSPARC T1 or T2 processor, the new systems incorporate two processors, doubling the number of cores and the number of hardware threads compared to UltraSPARC T2-based systems. Each UltraSPARC T2 Plus chip includes 8 hardware strands in each of 8 cores, so the Operating System sees a total of 128 CPUs. The new systems deliver an unprecedented amount of CPU capacity in a package this size, as evidenced by the very …

Later today around 5PM EST both me and my wife will be flying to San Jose to attend MySQL Conference happening next week. We will be staying the first two nights in Burlingame to meet family and friends.

Then on Friday evening we will be going to visit more family in Monterey. We will arrive at Hyatt Regency, Santa Clara, on Sunday afternoon.

Once at Hyatt, I will be happy to give a ride to anyone going to the Pre-Conference dinner.

After the conference, my plan is to spend time with a few …

More birds-of-a-feather evening sessions... this time a meeting about meetings: local MySQL user groups around the world. Please add yourself to http://forge.mysql.com/wiki/MySQL_Conference_and_Expo_2008#Local_MySQL_Groups if you run, want to start, or otherwise participate in a MySQL group where you live, and intend to attend this BoF session. We can exchange experiences and ideas, and I wrangled some books out of Apress which I'm happy to hand out for some of you to take back to your local groups!

(meanwhile, the Sunday community dinner event is coming along nicely with already nearly 30 people saying they'll come, including many community developers and MySQL alumni - looks like that's going to be a great gathering!)

I have a story for you. Don't fall asleep now - can't promise a happy ending though. There is no ending yet.

Once upon a time... there was OpenOffice.org. Version 2 of this product has a Base product, and the other components (Calc, etc) can also interface with databases through JDBC/ODBC, but the native db interface is something called SDBC which is kinda like a C++ version of JDBC.

A few years back, Georg Richter spent hundreds of hours of his spare time writing a native SDBC driver to connect OpenOffice.org to MySQL, so that it can interface without going through JDBC or ODBC layers. Cool, huh?

Now, what needs to happen is that this code goes into the main OpenOffice.org codebase. That in itself is not a problem, but there's a catch: OpenOffice.org is LGPL licensed. The licensing of the SDBC driver is not an issue, rights can or already have been signed through the Sun contributor license thing. But …

Time was invented so everything doesn't happen at once -- S. Wright

Next week is the MySQL Users Conference and getting ready to deliver six plus sessions of exams is quite an exercise in logistics. There are six scheduled sessions. We have only so many seats and so much time for the tests so those of you planning to take an exam need to plan accordingly.

You will find us in the Magnolia Room in the Hyatt Hotel, which is not exactly right next to all the action. Look for signs and ask for directions if you need help.

In the place of computers you would find at your local Pearson VUE test center, we are using pencil and paper (I wonder if paper was ever marketed as Papyrus 2.0 or Cuneiform Tablets++). This is one of the reasons the …