“I believe that one should benchmark before making any technology decisions.” An interview with Pieter van Zyl creator of the OO7J benchmark. In August last year, I published an interesting resource in ODBMS.ORG, the dissertation of Pieter van Zyl, from the University of Pretoria:“Performance investigation into selected object persistence stores”. The dissertation presented the OO7J [...]

GreenSQL has just released a new document,

Microsoft SQL Server Security Best Practices :

http://www.greensql.com/content/sql-server-security-best-practices

SQL Server Security Best Practices

The binary version for MySQL Cluster 7.1.9 has now been made available at http://www.mysql.com/downloads/cluster/

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.9 (compared to 7.1.8) can be found in the official MySQL Cluster documentation. In addition, there is a great BLOG posting from Johan Anderson explaining how to use the new table added to ndbinfo to tune DiskPageBufferMemory when storing tables on disk.

Inspired by Stack Exchange’s Architecture in Bullet Points. I have to admit that I was happy to see that we stack up pretty well, being a Ruby on Rails site. There’s no denying that Ruby is slower than C#. …and we could talk about Microsoft SQL Server vs MySQL as well.

It’s a little bit of an apples to oranges comparison. We’re a members only site that is mostly not indexed in Google and we’ve got a low unique visitor count and a high average time on the site. Also, we’re very, very budget conscious.

Traffic

• 173 Million Page Views per Month (not including guests + sign in page views)
• 1600 350 Rails requests per second (at peak times, requests for static files not included) whoa huge error there, 1600 reqs/sec just hitting Rails would be impressive. There were some static files …

I’ve written some new Nagios checks for HandlerSocket. check_handlersocket is a part of http://code.google.com/p/check-mysql-all/, and is meant to be called locally on the HandlerSocket server (usually via NRPE), but the perl-Net-HandlerSocket module must be installed. Feedback is welcome, usage is as follows: Usage: check_handlersocket -K [options] Options: -K, --check= The check to run --columns= Comma-separated [...]

This month is a special month. It’s not because of Valentines day or even the exciting day where we see groundhogs. No, this month is special because I’m have a book contest where you, the reader, get to win something free for doing absolutely nothing more than posting a comment saying that you want one of the several books I have available in the contest.

So without getting into boring details I’ll keep this short. I’ve been reviewing a lot of books lately and I think it’s time to get some books into people’s hands to enjoy themselves. This month the giveaways are all Python oriented.

So, all you have to do is take a look at the following titles and post a comment here saying that you want one of them. At the end of the month two readers will be chosen via a random list sorting python script I’ve whipped up for just this purpose. You will then get an email from the publisher who will send a brand new e-copy of the …

Do you know MySQL? Can you talk to an audience of your peers? Then new opportunities are waiting for you.

There are many speaking opportunities for you to speak to folks who want to hear about MySQL! People want to hear what you have learned the hard way, serendipitously discovered, researched rigorously, or your best practice. You may have groups in your area that are looking for you to present. MySQL is a very popular subject at all sorts of conferences and you do not need to be guru-level to be a speaker.

If you live near the following cities or plan to visit them, please check out these calls for papers!

Baltimore? Railsconf Call for papers end Feb 17th.

Graz? Grazer Linuxtage Call for papers ends March 1st.

…

…with a bit of strategic thinking

They come back, every now and then. Subqueries are far from being perfect at MySQL and they can give you some serious headaches.

Skilled MySQL developers know it better. They avoid subqueries as much as they can. It is not that subqueries do not work, it is just that the optimizer sometimes is, well, “not that optimised”.

So you may stay away from subqueries with some good SQL review. But what happens when the subquery is automatically generated by a script or a tool? If you can change the statement, I’m afraid you need to find some serious workarounds that vary case by case.

Here is an example that I found few weeks ago when I visited one of our customers.

Our customer used Magento for its site. Magento used a couple of queries that I will report here as sales and sales_items, …

Phew, here we go, this blog post has been long time coming! A few months ago I started toying around with the idea of analyzing the PlanetMySQL public blog feed. It doesn’t take long to extract the data and prepare it for analysis but between lots of work and procrastination this blog post was left unfinished.

It was partly out of pure curiosity and partly the fact that it seemed to me there were less posts than previous years that I decided to trend out the number of posts over the past years and here we go.

The blue line shows the blog posts per month over the past six years and the black line is a polynomial trend line. There are a few points of interest which are visible and I’ll be listing here (to all their understanding):
1. The first thing which struck me negatively is …

I’m a big fan of NoSQL when it comes to remove useless work put on some over loaded SQL box , for solving  write scalability issues but i will try to demonstrate that in most case you can push a MySQL and MariaDB server at the same level in vertical scalability compare to NoSQL solution. 

I found some of the benchmarks not always taking into account the best practice of RDBMS usage,  no persistante connections  (shorten authentification , socket and thread stack allocation), not using prepared statement to cache plans and  limit network usage, using bad primary keys like varchar or big numeric data type.

[From varokism: Using MySQL as a NoSQL: a story for exceeding 450000 qps with MariaDB]

I think the biggest issue so far with HandlerSocket is that most of …