In my first article on partitioning, I demonstrated that you can get some pretty impressive performance benefits when you properly design partitioned tables to match the SQL queries that are routinely shot across the bow of your database server. Iâ??d now like to continue in that vein and show you how easy and efficient partitioning is in terms of managing how partitions are created and removed within tables.

Business intelligence is the key to fact-based decision making in the intelligent enterprise. Techniques and tools are designed to unlock knowledge from data.

XAMPP 1.5.3 BETA is now available for download. This beta release includes new versions of PHP 5.1.4, MySQL 5.0.21, Apache 2.2.2, phpMyAdmin 2.8.1 and OpenSSL 0.9.8b. The final versions are expect to be finished by mid-next week.

XAMPP BETA downloads

In connection to my previous post I was thinking how Web 2.0 with its massive use of Web Services affect LAMP Stack ? Well actually there are serious difference both for client and server application development which you might want to take into account.

If you're developing Web Service Server application you will most likely be dealing with two types of requests

• Real time requests. These are executed during web page generation on the client and add up to its response time. These are important to be answered as fast as possible. If you can't service them it time it might be better to return partial results or error code - not everyone is good at handling timeouts properly. One more nice feature you might consider is allowing to execute multiple operations with single request. This both allow you to service them in parallel and reduce number of round trips which are very expensive.
…

Welcome to my SQLbusRT blog!

My name is Bram Smulders. I recently started my final project for Imtech ICT Technical Systems in Amersfoort, the Netherlands, to finish my Masters degree at the University of Twente.

This blog will be used to keep all interested parties informed on the progress of this project.

So what is SQLbusRT?
SQLbusRT is a bus architecture with database connectivity which lets multiple publishers and subscribers exchange data meeting real time constraints. The benefit of having the database connectivity is that not only new data can be read by subscribers, also history data can be retrieved from the database, still meeting the real time constraints.
Currently the project is in a conceptual phase.

Information on this project
Besides this blog, there's …

On the morning of June 14th, I will be giving a tutorial entitled "Maximum Velocity MySQL" at this year's NYC PHP Conference. The tutorial is a three hour look at how to tune SQL queries, design efficient schemas and indexing strategies, and analyze your code base for the best performance of your PHP and MySQL applications.

Hope to see you all there!

Ok, in addition to programming, ice hocky and singing drinking songs, Finland is also quite famous for it's saunas.  I am told there are more than 1.5 million saunas in Finland, which is pretty remarkable for a population of around 5 million.  The sauna culture has existed here for thousands of years.  But leave it to the Finns to come up with something even more extreme: the negative sauna.  Whereas a normal Finnish sauna is hot (like 80C hot) a negative sauna is cold.  How cold?  -110 C cold (which converts to the even more impressive sounding -166 F).

So on the weekend, a few of us MySQLers working at Monty's went to experience a negative sauna.  You start in the room at -30C, then you go into the next …

I won an iPod at php|tek. Since Apple does not support Vorbis Ogg my options were either to install some third party firmware or to sell the iPod. I went with option #3 and gave it to a friend of mine who is moving to South Africa for an internship that will have him traveling a fair bit. Since he is still using mp3 he got it as a farewell present. Now other friends have noted an interest in iPods as well. Since apparently outside of IT iPods giveaways are less common I will try to get each of them an iPod with my awesome computing skills (Ok, I won the first one with drinking alcohol, but I still have not really acquired the taste for drinking so ..).

Anyways the purpose of this post is to highlight some issues in MySQL that will hopefully get fixed in …

Hey all. Please comment on this entry. I’m trying to get an idea of who’s listening to what I say.

Why do you read this blog? Are you interested in community wireless networks? OpenGL development on Linux? Family? Business Intelligence? Synchronizaton Manager news? Freecycle™ development? Random Perl bits? Something else I’ve forgotten about?

I’m finding myself over-extended and I need to cut back on some of the things I focus on. Please let me know what is important to you so I know how best to re-organize my time, energy and other resources.

© cjcollier for C.J.'s WordPress of studlyness, 2006. | Permalink | No comment

Filed under ewn, …

So MySQL 5.0 + debian sarge == how's ubuntu doing these days?

Been spending a few minutes here and there reading about large system ruby/rails installations over a couple days. Mongrel looks like fun.

I've seen no less than 12 different articles talking about "Scaling Rails". They talk about code distribution, load balancing your fastcgi/mongrel instances, running memcached everywhere, etc. Then they *all* end in the wonderful single database instance.

Would someone remind the ruby community that scaling out webnodes is easy, and only the tip of the iceburg? If you believe a single DB is all you will ever need, I have some datasets to show you ;)

Otherwise I'm still totally sick of PHP's inane behavior. Won't be rid of it for a long time...