MySQL has till the 18th to review all the student applications we’ve had for the Google Summer of Code 2008.

We’ve had 48 applications (it was 49 before one withdrew), up from the 35 that we had last year - growth! Currently, we also have 3 non-MySQL’ers being mentors (this is expected to grow), and we’ve also invited the phpMyAdmin team to mentor folk with their projects in mind, as its a very popular web-based UI.

What really is interesting is that out of the 48 applications, 13 already have owners wanting them! That’s 13 mentors, ready to go with the early applicants, and this can only mean good news (i.e. more to come).

Let’s hope that Google provides us more than our previous 10 slots, as in the early stages, we already have a 27% approval rating of students and their projects. Interesting times ahead.

Technorati Tags: …

In MySQL Proxy scripts you can define variables and modify them. No surprise here. If you define a variable with script wide scope, you can use such variable and modify it between queries. For example:

local how_many_queries = 0
function read_query(packet)
 how_many_queries=how_many_queries + 1
 print (how_many_queries)
end

However, when you have two clients connected to the same Proxy instance, each one will have a separated set of local variables. By default, MySQL Proxy protects the variables inside a session. If two clients connect to the Proxy running the above script, there will be a distinct count for each session, not the total of queries, as intended.
To share information among sessions, you must use a dedicated table inside the Proxy, called, aptly enough, proxy.global

proxy.global.how_many_queries = proxy.global.how_many_queries or 0 …

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!)