Ideas, releases, practical guides, and perspectives from the people building with MySQL.
My copy of High Performance MySQL arrived this week! It's also Independance Day here in the States, so I have a long weekend after all the fireworks to get through my stack of reading, plus get some hill rides in to prepare for a 200K brevet July 19th. Oh, tomorrow also starts the Tour de France! What a weekend!!
MySQL DBA & Programming Blog by Mark Schoonover …
[Read more]My copy of High Performance MySQL arrived this week! It's also Independance Day here in the States, so I have a long weekend after all the fireworks to get through my stack of reading, plus get some hill rides in to prepare for a 200K brevet July 19th. Oh, tomorrow also starts the Tour de France! What a weekend!!
MySQL DBA & Programming Blog by Mark Schoonover …
[Read more]Andrew Clarke has published to 104th edition of Log Buffer, the weekly review of database blogs, on Radio Free Tooting, marking LB’s second year. Happy Birthday, LB!
Log Buffer always needs editors, so if you you’d like to present your view of the week that was in DB blogs, contact me, the Log Buffer coordinator. You’ll be joining some of the best bloggers around, and making yourself and your blog a little better known to readers around the world.
And now, here’s Andrew Clarke’s …
[Read more]MySQL Proxy is very flexible and can be used for many different use-cases
What shall we implement first, where should our priority ?
Cast you vote at http://dev.mysql.com/tech-resources/quickpolls/
MySQLs multiple-queries feature makes it possible to run two or more SQL commands with one function call: SQL injections made easy. The PDO design is said to be optimized for security. For security reasons PDO has gone the stony road of prepared statements. If security matters, why does PDO_MYSQL explicitly enable multiple-queries? If portability matters, why do you use a MySQL specific feature?
Mighty multiple-queries feature: performance
Multi-statement is yet another example of how optimization works: trade in one feature (security) for another (performance). Sending several SQL command with one function call saves communication round-trips. You need only one round-trip for executing n > 1 SQL …
[Read more]MySQLs multiple-queries feature makes it possible to run two or more SQL commands with one function call: SQL injections made easy. The PDO design is said to be optimized for security. For security reasons PDO has gone the stony road of prepared statements. If security matters, why does PDO_MYSQL explicitly enable multiple-queries? If portability matters, why do you use a MySQL specific feature?
Mighty multiple-queries feature: performance
Multi-statement is yet another example of how optimization works: trade in one feature (security) for another (performance). Sending several SQL command with one function call saves communication round-trips. You need only one round-trip for executing n > 1 SQL …
[Read more]I missed Red Hat's fiscal 1Q09 release a few weeks ago, so I went back and read the transcript and dug into the numbers a little. As you can see in the table below, total revenue growth has averaged 31 percent/quarter since fiscal 1Q08. Surprisingly though, Sales & Marketing and R&D have grown 32 percent/quarter and 37 percent/quarter over the same period. More evidence to refute the myth that open source doesn't need sales, marketing or R&D investments. It is good to see that R&D is growing faster than Sales & Marketing. However, it's not sustainable for R&D and Sales... READ MORE
MySQLs multiple-queries feature makes it possible to run two or more SQL commands with one function call: SQL injections made easy. The PDO design is said to be optimized for security. For security reasons PDO has gone the stony road of prepared statements. If security matters, why does PDO_MYSQL explicitly enable multiple-queries? If portability matters, why do you use a MySQL specific feature?
Mighty multiple-queries feature: performance
Multi-statement is yet another example of how optimization works: trade in one feature (security) for another (performance). Sending several SQL command with one function call saves communication round-trips. You need only one round-trip for executing n > 1 SQL …
[Read more]
Yesterday, I was on the freenode ##pentaho irc channel when
Andres
Chaves asked me how to calculate the Nth percentile in MySQL. He saw a
solution somewhere using subqueries, but wasn't too happy about
it.
A while ago I wrote about calulating the median in MySQL, and it turns
out the Nth percentile can be calculated using a
similar, single-pass approach, not relying on subqueries, UDFs,
or user-defined variables.
The percentile....
So, what is a percentile exactly? Here's what the wikipedia
says:
A percentile is the value of a variable below which a certain
percent of observations fall. So the 20th percentile is the value
(or score) below which 20 …
I haven't received my copy of the book yet, but being unable to control my temptation I have started reading it over Safari while waiting for my own very personal copy. :)
Already a fan of the first edition, you can feel the same charisma being carried over in this book also. The best part of the book is the simplicity by which you are set sailing over MySQL.
Without doubt, it is one of the best books MySQL can ask for. Certainly, I would recommend this book to anyone who is associated with the word MySQL. Or otherwise if you answer yes to any of these questions below, then go and grab a copy.
.jpg){kind=link}