Reading Barons post about Kickfire Appliance and of course talking to them directly I learned a lot in their product is about beating data processing limitations of current systems.

This raises valid question how fast can MySQL process (filter) data using it current architecture ?
I decided to test the most simple case - what if we take the in memory table with very narrow row and run simple query which needs to do simple filtering - how many rows per second it will be able to do?

PLAIN TEXT SQL:

1. CREATE TABLE `m` (
2.   `i` int(11) NOT NULL
3. ) ENGINE=MEMORY DEFAULT CHARSET=latin1
4.  
5. mysql> SELECT count(*) FROM m;
6. +----------+
7. | count(*) |
8. +----------+
9. |  1047684 |
…

Are you interested in how to integrate the Zend Framework, Smarty and the Yahoo! UI Library into an infrastructure that makes it comfortable to develop professional web applications? Do you want to know how this infrastrucure is going to form a solid foundation for the MySQL website? And see what the future basement of db4free.net is going to look like?

And are you going to attend the MySQL Users Conference next week?

Then this is a presentation that you don't want to miss:

…

Just a quick note: Kickfire is not based on SSD (solid-state device) hard drives. Their old website says “SQL goes solid state” but that just means SQL in hardware, not SSD.

When I was a child, we had a Sears Lady Kenmore clothes washing machine that boasted “solid-state circuits” on the panel, in flowery script writing. It was not based on SSD, either.

Finally, I am not on the Kickfire payroll. I’m not getting anything from working with them, except perhaps the fun of being in their labs while they’re still in stealth mode. It’s a harder balance than you might think, writing about a product that I don’t know about and am excited to learn about, and sounding objective. If I’m sounding like a fanboy, I don’t mean to. Trust me, if it’s vaporware you’ll hear it here first.

…

It's just a matter of time before Ubuntu is crowned "enterprise ready" by one of the major ISVs. Will it be able to maintain its popularity once it is popular with enterprise buyers?

Ubuntu plays an increasingly important role within the larger Linux market. According to a new white paper from IDC [PDF], Linux is big business and is ready for prime time, with IDC forecasting overall spending on hardware, software, and services for Linux to increase 25.2 percent annually through 2011, particularly at the expense of Unix:

Increasingly, deployments of the Linux server operating system are expanding from infrastructure-oriented workloads to more commercially-oriented workloads such as database, enterprise resource planning (ERP) software and other general business processing, workloads that historically have been the domain of Microsoft …

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 …