If you are a developer working in a MySQL environment, this blog post is for you. I share 3 MySQL commands or statements that you should know. That is a bold statement, I know. Turns out, once you do know (of) these commands, you will use them all the time. They minimize guesswork which leads to better productivity in other facets of your programming and querying workflow. I use them myself almost daily and am sure you will too once you see how simple they are to use. So why should you know them? Continue reading and find out…

Photo by hannah joshua on Unsplash

OS, Software, and DB used:

• OpenSuse Leap 15.1
…

In this post, I’ll cover examples of the MySQL TRIM() function. TRIM() removes specific characters – or spaces – from a given string, at either: the beginning, ending, or potentially in both locations depending on several factors. With an optional keyword argument that controls which character(s) – if any – are removed, TRIM() can be tricky so let’s gain understanding with several easy-to-digest examples…

Photo by Peter Beukema on Unsplash

OS, Software, and DB used:

• OpenSuse Leap 15.1
• MySQL 8.0.20

Self-Promotion:

If you enjoy …

If you write MySQL queries, at some point you are going to have to provide query results in a specific order. To impose any ordering in MySQL (this applies to SQL overall and is not directed only at MySQL), you have to use the ORDER BY clause. Without it, there is no guaranteed order. The database is free to send back query results in any order. As I learn PHP, I make it a point to explore both the MySQL side, along with the PHP side in regards to similar type tasks and the efficiency of each. So far in my PHP journey, I have found that arrays are used quite extensively. In this post, I’ll cover array_multisort() – one of many in-built PHP functions – used for sorting arrays. In the context of the example data for this post, the arrays are populated by an unordered MySQL query. Let’s see one example of how you can establish a sorting order in a PHP …

Join 9500 others and follow Sean Hull on twitter @hullsean.

1. Stand up and be heard

Years ago I was sitting on an online forum chatting with an Oracle buddy of mine. This was circa 1998. We were working on an open source tool to interface with Oracle. There were all these libraries, for PHP & Perl, and a lot of developers starting to build tools. We hatched this hair brained idea to write a book about all of this, and pitched it to O’Reilly. They loved it and thus was born the book Oracle & Open Source in 2001.

Writing a book was, is and always will be a lot of work. It was a great learning experience too. Editors critique your writing, and this teaches you to speak to a broader …

After last week’s post about bloggin trends, this week I will go through the most active bloggers over the years as well as particularly for 2010.

What is the range of time analysed here?

mysql >  select min(date_time), max(date_time) from blogs;
+---------------------+---------------------+
| min(date_time)      | max(date_time)      |
+---------------------+---------------------+
| 2004-03-04 19:47:00 | 2011-01-07 13:22:00 |
+---------------------+---------------------+
1 row in set (0.04 sec)

How many blog posts in the above period (almost 7years)?

mysql >  select count(*) from blogs;
+----------+
| count(*) |
+----------+
|    21698 |
+----------+
1 row in set (0.00 sec)

How many authors have contributed to planetmysql?

mysql >  select count(distinct(author)) from blogs; …

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 …

GoogleCL is an apparently simple application. If you install it on Mac using macports you realize how many dependencies it has and how much complexity it gives under the …

1. ZeroMQ -- bold claim of "Fastest. Messaging. Ever." LGPL, C++ with bindings for many languages, past version 2 already. (via edd on Twitter)
2. Prediction Market News (David Pennock) -- HSX is going to be a real marketplace with real $. The real HSX will of course say goodbye to the virtual specialist and the opening weekend adjust, two facets of the game that make it fun to play, but that create significant amounts of (virtual) wealth out of thin air. The Cantor Gaming group is engaged in other interesting initiatives. They are taking over a sportsbook in Las Vegas and turning it into more of a derivatives exchange with live in-game betting, a step toward my dream of a geek-friendly casino. …

Tokutek is pleased to announce the general availability of TokuDB for MySQL, version 2.2.0.  This version offers several improvements:

• 
  
• Better multi-core load balancing for concurrent workloads.
  
• Faster bulk loading performance.
  
• Enhanced diagnostics for easier tuning and troubleshooting.
  
• Fixed all known bugs.

About TokuDB

TokuDB for MySQL is a storage engine built with Tokutek’s Fractal Tree technology. TokuDB provides near seamless compatibility for MySQL applications. Tables can be individually defined to use TokuDB, MyISAM, InnoDB or other MySQL-compliant storage engines. Data is loaded, inserted, and queried using standard MySQL commands, with no restrictions or special requirements. Our Fractal Tree technology indexes up to 50 times faster than …

At Tokutek, Rich Prohaska used
Gearman to automate our nightly build and
test process for TokuDB for MySQL.  Rich is busy working on TokuDB, so I’m
writing up an overview of the build and test architecture on his behalf.

Build and Test Process

Rich created a script, nightly.bash, that gets kicked off every night as a cron
job.  Nightly.bash creates a separate Gearman job for each build target.
We have a separate build target (unique binary) for each combination of
operating system (e.g. Linux, Windows, etc.) and HW architecture (e.g.
i686, x86_64) supported by TokuDB.  As we support more operating
systems over time, the number of build targets grows quickly so we needed
a build and test architecture that scales, and Gearman makes …