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 …

A friend emailed me a message he had received when attempting to login to Facebook:

The message reads, Warning: Facebook detected a potential scam to steam your account!
To prevent future problems, please reset your password.

Also, I was hearing in news today that a significant percentage of scams are now targeted towards social networking sites.

Of course, it goes without saying that one should not use their "important" passwords with social networking sites.

If you haven’t already signed up to attend the MySQL Conference & Expo 2008, you know you’re clearly missing out. Most tutorials in the conference have sold out, so I suggest getting to it as soon as possible. Remember, that all speakers have access to a 20% discount code, so email me if you’d like one.

Igor Babaev, is speaking on Wednesday, 16/04/2008, at 2pm, on Batched Key Access: a Significant Speed-up for Join Queries. To whet your appetite, there are also Batched Key Access Software Previews available now!

So what is Batched Key Access (BKA)? Its a new advanced technique to execute queries with multi-way join operations. The idea behind it is to accumulate several keys in a buffer, then …

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 to blogspot.com.
But the most interesting for me to is the readers feed back...

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 …