This is the query that just got me to thinking that I should blog about mySQL hints, tips, and ramblings. So... thinking turned into action and now I have a blog! The next step is to be able to keep it going so that it becomes useful to mySQL database administrators that are concerned about performance of mySQL and also need make sure that queries are written well.
Now... onward and forward...
By Tim O'Reilly
Miguel de Icaza writes:
Today we are formalizing a collaboration between Microsoft and Novell with the explicit purpose of bringing Silverlight to Linux and do this in a fully supported way. The highlights of this collaboration include: ... Microsoft will give Novell access to the test suites for Silverlight to ensure that we have a compatible specification. The same test suite that Microsoft uses for Silverlight. Microsoft will give us access to the Silverlight specifications: details that might be necessary to implement 1.0, beyond what is currently published on the web; and specifications on the 1.1 version of Silverlight as it is updated. Microsoft will make the codecs for video and audio available to users of Moonlight from their web site. The codecs will be binary codecs, and they will only be licensed for use with Moonlight on a …
[Read more]A short note to let everyone know that I’ll be heading to Dubai later today to participate in Pythian’s exhibit in the Business Solutions Hall. For those of you who haven’t heard of it, GITEX is like COMDEX for the Middle-East - it’s literally the third largest tradeshow in the world where COMDEX is #1 - [...]
I've been very busy since OSCON, so my blog pipeline is full. Hopefully I can properly catch up on some topics I've been meaning to discuss in the next few weeks. If you've been busy like me, you might be wondering how to catch up and keep up with the things that are most important to you. I've found that having my own planet (blog aggregator) has helped tremendously. If your tastes are similar (PHP, web application security, etc.), you might like mine, cleverly (yeah, right) dubbed Planet Chris. Other planets you might find interesting are Planet PHP, Planet Web Security, and Planet MySQL, although I highly recommend creating your own. I haven't …
[Read more]MySQL Has API to run Multiple Queries at once. This feature was designed mainly with saving network round trip in mind and got a little traction due to associated security risks and not significant gains in most cases.
What would make MySQL Multiple Queries API more usable ?
Allow to run queries in parallel - The great benefit of knowning all queries at once is of course you can run them in parallel. Asynchrnous submission API would be even better but even multi query working this way would be much better. I know there is a work going on on breaking connection=thread=transaction mapping which may allow having multiple working threads for same transaction within same connection which could possibly allow to implement it.
Optimize query set The other thing you can do when you …
[Read more]MuleSource launches MuleForge. Talend integrates with SugarCRM. Microsoft issues press release on Open XML standards vote. (and more)
MuleSource Launches MuleForge.org to Accelerate Universal Integration of Data and Services, MuleSource (Press Release)
Talend Announces Data Integration for SugarCRM, Talend (Press Release)
Strong Global Support for Open XML as It Enters Final Phase of ISO Standards Process, Microsoft (Press Release)
Virtual Iron Integrates SLES 10 Kernel and Drivers in Latest Release, …
[Read more]
If you’re new to MySQL, you might not know that in the default configuration ‘a’='A’. Ie, string comparisons are by default case-insensitive. If this is a surprise to you, read up on Chapter 9 of the online manual, on character sets and collations.
The default character set is latin1 and the default collation is latin1_swedish_ci (’ci’ stands for ‘case-insensitive). If you don’t want ‘a’ to equal ‘A’, you can change this by setting the variables ‘character-set-server’ and ‘collation-server’ in your config file or your startup options. For example, we want to support unicode, so we use character-set-server=’utf8′ in our config file. We also added the following (in the [mysqld] section) so that clients will use the right character set and collation, too: init_connect=’set names utf8; set collation_connection=utf8_bin’.
On the other hand, by default in linux, …
[Read more]MySQL is not so heavily-instrumented as Oracle. (Back to tuning using ratios rather than the wait interface… sigh…) But it does offer (among other tools) the slow query log. Turn it on (put ‘log_slow_queries‘ in your config file), and all queries that take longer than long_query_time seconds (also set in your config file) will be logged to a slow query log file, along with the time they took to execute. Then you can use mysqldumpslow to analyze the output. You can see, for example, which slow queries are taking the most cumulative time on your server, or are being executed most frequently. (The manual doesn’t say much about it, and mysqldumpslow ––help doesn’t give too much help, but I think mysqldumpslow -s t and mysqldumpslow -s c do that.)
If you use InnoDB, though (as we do), be aware that the “lock time” logged in the slow query log only counts time for …
[Read more]
I usually get a feel for "what's hot" in the marketplace by the
number of books on the shelves at my favorite bookstore. A couple
years ago there was six shelves at my Borders store filled with
books on Oracle. Oracle for Dummies, PL/SQL, and scores of
Certification books. I was quite surprised to find only three
books on Oracle at the same store this past weekend.
MySQL still has some respect with about a 1/2 shelf. .Net clocked
in with about 5 or 6 shelves with a smattering here and there of
Java and the associated technologies. Good old Perl shared half a
shelf with PHP. But I feel left behind because I don't know Excel
Macros (about 12 shelves).
Maybe Oracle has really achieved a self-tuning, self-managing
database and we don't need books anymore.
Please excuse me while I apply four more patches to my
"up-to-date" 10.2.0.3 installation.
Dear data integration fans,
Once in a while, there are discussions on various blogs (usually with me smack in the middle of it) debating the differences between code generation and model based execution, how this impacts the way we approach databases, the open nature of it all, etc.
With this blog entry I want to push the notion that Pentaho Data Integration (Kettle) didn’t just evolve by chance into the state it is today as a streaming, metadata driven, model based engine. I made some careful design choices early on…
Open as possible
The goal of Kettle from the beginning was to be as open as possible. My definition of “as open as possible” included: