Showing entries 28026 to 28035 of 44044
« 10 Newer Entries | 10 Older Entries »
A beginners look at Drizzle - Datatypes and Tables

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
[Read more]
Libdrizzle Benchmarks - Massive Performance Increases

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]
MySQL Sandbox even more sandboxed



In the late evening of March 31st I had a good coding session with MySQL Sandbox. I implemented a feature that has been in the wish list for long time. Checking the port before installing, and providing a non used port that positively avoids conflicts is a great step forward.


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, …

[Read more]
Visit HeidiSQL at the MySQL Conference in Santa Clara, CA Ap

HeidiSQL and jHeidi will be present at the upcoming MySQL conference in Santa Clara, CA April 21-22, 2009. Please come visit us in the DotOrg Pavilion booth TT19! We'd love to meet users of HeidiSQL and talk about the latest features and upcoming releases.

DBA 5.1 Exam Contents, Part 3 of 3

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


  1. Copy a database
  2. Create a fulltext search
  3. Create a view to select certain data from a table
  4. Alter a table
  5. Update a compressed table
  6. Create a recurring event
  7. Update a global variable
  8. Use the INFORMATION_SCHEMA …
[Read more]
Globalization tasks (Part 1 of 3)

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 …

[Read more]
SSDs for Performance Engineers

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]
SSDs for Performance Engineers

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]
Upcoming Gearman Events

Good news! If you want to learn more about Gearman, you’ll have plenty of opportunities in the coming months:

[Read more]
MySQL Workbench on Mac OS X

MySQL Workbench Mac support has been requested from our community for a very long time. We got several emails and comments on the web and IRC channel that Workbench is the only tool why a lot of people are still running a VMware Fusion or Parallels session with Windows.

Therefore we are very happy about the recent release of WB 5.1 Beta1 which is the first release that is available on our three main platforms, Windows, Mac & Linux.

Those who have been giving MySQL Workbench 5.1 Beta1 on Mac OS X a try may have noticed the huge speed gain, compared to the Windows version, especially when working with bigger models. We even got complaints why we have “slowed down” the Windows version but this is simply due to the GUI hardware acceleration support available on the Mac, as well as on Linux systems.

So for the moment (until we finally get to re-enable full OpenGL support) using the Mac version is the new benchmark of model …

[Read more]
Showing entries 28026 to 28035 of 44044
« 10 Newer Entries | 10 Older Entries »