One of our customers reported that ‘create table select from’ statements stall for a period of time equal to the TokuDB lock timeout.  This indicated a lock conflict between multiple transactions.  In addition, other MySQL clients that were opening unrelated tables were also stalled.  This indicated that some shared mutex is held too long.  We discuss details about this bug and how it was fixed.  The bug fix will be distributed in TokuDB 7.1.0.

Example
Suppose that we set the tokudb lock timeout to 60 seconds just to exaggerate the stall.

mysql> set global tokudb_lock_timeout=60000;
Query OK, 0 rows affected (0.00 sec)


We then create a simple table.

mysql> create table s (id int primary key);
Query OK, 0 rows affected (0.02 sec)


When we create new table (t) and populate it from some …

One of the major announcements made at the MySQL Connect conference just over a week ago was the labs release of MySQL Fabric, which supports management of MySQL Server farms in a sharded deployment.  It’s available on labs.mysql.com, which means it is just an early release with some rough edges.  One of those rough edges that I’d like to see resolved soon is that it’s difficult to install on Windows, as there is no installer package provided.  There is some documentation on how to install Fabric (you’ll find it in section 15.8.2 of the PDF that makes up the downloadable documentation), but it’s focused on Linux platforms, so I thought I would post the process that …

Sreekar,
Yes, in general you can specify multiple output threads.
And you can definitely play with that.
See what works and what does not.
There are sometimes worst performance numbers when you have multiple
write threads (even in non-raid disks).
Regards,
Sanjay

The cost of SSDs has been dropping rapidly, and at the time of this writing, 2.5-drives have reached the 1TB capacity mark.  You can actually get inexpensive drives for as little as 60 cents per GB. Even inexpensive SSDs can perform tens of thousands of IOPs and come with 1.5M – 2M hous MTBF and a 5-year warranty: check out the Intel SC S3500 specs as an example. There is however one important factor you need to take into account when considering  SSDs as opposed to conventional hard drives – Write Endurance.

Many of us have heard about SSDs having limits in terms of how many writes SSDs can handle, many however assume this is what is already accounted for in the warranty period and so if the hard drives claim to have sequential write speed of 450MB/sec and a warranty of 5 years we expect …

This release fixes tons of bugs, while the number of new features is not as high as in a major release.
Especially, we have a new libmysql.dll in place now, which fixes pluggable authentication, broken in
the 8.0 release.

Get it from the download page.

Here are the most noticable changes and new features:

* Make snippets directory customizable. Fixes issue #3276
* Provide a libmysql.dll from a MariaDB-5.3.12 server, to fix pluggable authentication. Also fixes "malformed packet" on LOAD DATA.
* Introduce Win7+ jump items on task button. See http://www.heidisql.com/forum.php?t=12385.
* Introduce the new data option "Local number format"
* …

This release fixes tons of bugs, while the number of new features is not as high as in a major release.
Especially, we have a new libmysql.dll in place now, which fixes pluggable authentication, broken in
the 8.0 release.

Get it from the download page.

Here are the most noticable changes and new features:

* Make snippets directory customizable. Fixes issue #3276
* Provide a libmysql.dll from a MariaDB-5.3.12 server, to fix pluggable authentication. Also fixes "malformed packet" on LOAD DATA.
* Introduce Win7+ jump items on task button. See http://www.heidisql.com/forum.php?t=12385.
* Introduce the new data option "Local number format"
* Remove "Run file" dialog, and use a standard …

This release fixes tons of bugs, while the number of new features is not as high as in a major release.
Especially, we have a new libmysql.dll in place now, which fixes pluggable authentication, broken in
the 8.0 release.

Get it from the download page.

Here are the most noticable changes and new features:

* Make snippets directory customizable. Fixes issue #3276
* Provide a libmysql.dll from a MariaDB-5.3.12 server, to fix pluggable authentication. Also fixes "malformed packet" on LOAD DATA.
* Introduce Win7+ jump items on task button. See http://www.heidisql.com/forum.php?t=12385.
* Introduce the new data option "Local number format"
* …

Quite some time ago, I published scripts to implement password policies for MySQL, and promised to show how to expose violations of that policy via MySQL Enterprise Monitor (MEM).  That stalled somewhat with other objectives, but I want to revisit it now that MEM 3.0 is GA.  If you haven’t tried MEM 3.0 yet, consider doing so – it’s quick and easy to set up.

Many people don’t realize that MEM can be extended to monitor things beyond MySQL Server health, including visibility into application state as observed from the database.  In part of the hands-on-lab I recently led at MySQL Connect, we …

Save Time & Money – Do It Right The First Time

SPEAKER: Gerry Narvaja, Tokutek
DATE: Tuesday, October 8th
TIME: 1pm ET

If you are thinking of using the leading open source database in a project, learn just how easy it is to get started with MySQL, and how important it is to do it right. A few simple decisions early in development, and knowing when and how to effectively use the TokuDB performance engine, can save significant time and money down the road. Key metrics for MySQL success include performance, scalability, database size, and agility. Register Now!

Attend this webinar to learn:

• The basics of installing and configuring MySQL and TokuDB
• How to maximize performance for long-term scalability
• How to configure compression for highest ROI
…

Reposted from Monty Says.

I recently read some comments that we at the MariaDB Foundation have not been very open about what we are doing.

We are very sorry about this. The problem is not that we are secret about what we are doing, the problem is that not many of us working at the MariaDB Foundation are very active bloggers.

I will try to address this concern by starting a monthly blog about the MariaDB development that MariaDB Foundation employees are doing. This together with Simon Phipps’ state of the sea lion blog, which is published here, should hopefully give everyone a better idea of what we are doing.

At the MariaDB Foundation we are now 4 people …