...is that truth is stranger than fiction. Reality does not
appear any more plausible than plain nonsense.
We were discussing this yesterday on #ourdelta (Freenode
IRC) in the context of How MySQL really executes a query by Baron.
Antony
Curtis noted that if he'd write a truthful post on that
topic, people would think it was made-up regardless of the day of
the year!
Another proof of the premise: Baron has now put a giant banner
above/below his post, explaining that it was a joke. Apparently
that's necessary?
I tend to come up with neat ideas for April Fools throughout the
year, neglect to write them down, and come the day I have a
blank. But, given the above, there's another option: you just
write a truthful story, still leaving people …
…is that truth is stranger than fiction. Reality does not appear any more plausible than plain nonsense.
We were discussing this yesterday on #ourdelta (Freenode IRC) in the context of How MySQL really executes a query by Baron. Antony Curtis noted that if he’d write a truthful post on that topic, people would think it was made-up regardless of the day of the year!
Another proof of the premise: Baron has now put a giant banner above/below his post, explaining that it was a joke. Apparently that’s necessary?
I tend to come up with neat ideas for April Fools throughout the year, neglect to write them down, and come the day I have a blank. But, given the above, there’s another option: you just write a truthful story, still leaving people wondering …
[Read more]The Drizzle database, while similar to MySQL includes a number of significant differences. In this post we will look at data types and table syntax that is valid in Drizzle. For more background information you can also review A beginners look at Drizzle - Getting around with SHOW.
Data Types
This comparison is with Drizzle 2009.03.970 and MySQL 5.1.32 GA. More information at MySQL 5.1 Data Types.
The following data types are not valid in Drizzle.
- TINYINT
- SMALLINT
- MEDIUMINT
- BIT
- TIME
- YEAR
- BINARY
- SET …
Last night and today, I ran a series of benchmarks against Drizzle. These benchmarks were designed to isolate the performance improvement or regression from one change: using Eric Day's new libdrizzle client library instead of the legacy libdrizzleclient library from MySQL. The results are in, and they are stunning.
Here is a graph showing the difference between Drizzle sysbench on a readonly workload with the only difference being sysbench using the libdrizzle driver versus using the libdrizzleclient (libmysql) driver for sysbench:
As you can see, with libdrizzle, the throughput is dramatically increased, with Drizzle scaling to 8x the number of cores on the benchmark machine before a …
[Read more]
Now you can do things like this:
$ make_sandbox 5.1.33 --check_port --no_confirm
$ make_sandbox 5.1.33 --check_port --no_confirm
$ make_sandbox 5.1.33 --check_port --no_confirm
$ make_sandbox 5.1.33 --check_port --no_confirm
$ make_sandbox 5.1.33 --check_port --no_confirm
And you will get no errors!
The Sandbox will create msb_5_1_33_a, msb_5_1_33_b and so on,
using ports 5133, 5134, …
The optional section of the MySQL 5.1 DBA exam is a series of ten
tasks and the candidate has to complete at least five of them.
The five mandatory tasks are tests of core MySQL skills and the
optional section is a test of other skills a candidate may have
acquired.
All of these tasks can be completed in many different ways. For
instance the first mandatory task includes removing three
accounts. This can be done in one or more SQL statements. The
candidate is graded on IF they accomplished the task and not the
method used to accomplish the task.The Optional Tasks
-
- Copy a database
- Create a fulltext search
- Create a view to select certain data from a table
- Alter a table
- Update a compressed table
- Create a recurring event
- Update a global variable
- Use the INFORMATION_SCHEMA …
For today and tomorrow and the day after tomorrow, I (Peter Gulutzan) will say what the status is for “Globalization” tasks. These tasks meet Sun requirements for software; you could say that they’re moving forward due to Sun’s acquisition. I’ll give examples where the code is already working; for other cases I’ll just say what’s in the description in the worklog task.
WL#751 Error message construction
Current status: architecture review done
Version = 6.1
We’ll produce error messages taking into account the current
character set and the user’s choice of language. Expect changes
in errmsg.sys, errmsg.txt, internals documentation, string
formatting, and @@character_set_results.
WL#897 Accept SQL statements written with UCS2, UTF16,
UTF32
Status: not passed architecture review
Version = 6.x
Currently clients pass messages in UTF8, which can be converted
to UCS2 or UTF16 or …
Why should a performance engineer care about SSDs
There has a been lot of buzz regarding SSDs lately. SSDs change the dynamics of the IO subsystem. You are no longer limited by rotational latency and vibration effects. For a performance engineer this has many implications. Since performance engineers care mostly about performance, the first thought that comes to mind is "Are we going to see a big impact in benchmarks?".
The answer is really easy for IO bound benchmarks. How about CPU bound benchmarks? Many database benchmarks are CPU limited. Does a faster disk really change anything?
So what does an SSD really give you?
- Faster IOPS
- Decreased Latency for an IO
Faster IOPS
SSD's have a huge random IO capability. During a recent experiment with a SSD, I got around 12,000 random IO operations per second! I have seen SSDs where you can get more. If you have ever …
[Read more]Why should a performance engineer care about SSDs
There has a been lot of buzz regarding SSDs lately. SSDs change the dynamics of the IO subsystem. You are no longer limited by rotational latency and vibration effects. For a performance engineer this has many implications. Since performance engineers care mostly about performance, the first thought that comes to mind is "Are we going to see a big impact in benchmarks?".
The answer is really easy for IO bound benchmarks. How about CPU bound benchmarks? Many database benchmarks are CPU limited. Does a faster disk really change anything?
So what does an SSD really give you?
- Faster IOPS
- Decreased Latency for an IO
Faster IOPS
SSD's have a huge random IO capability. During a recent experiment with a SSD, I got around 12,000 random IO operations per second! I have seen SSDs where you can get more. If you have ever …
[Read more]