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 …

After a slight delay (travel and catching up with “real work”), I’ve now uploaded the talks that I gave at MySQL Connect and Oracle Open World.

They are available on my Presentations Page, and inline below for convenience. The “Introduction to MySQL Enterprise Monitor” talk was actually a full demo, but there are some screenshots of MEM 3.0 in there if you’re interested in seeing a high level picture of what it looks like now.

Thanks to all that attended my talks, I got a lot of good questions and feedback!

Performance Schema and ps_helper MySQL Administration and Monitoring …

Recently Oracle announced several new features for the latest available development version of MySQL that is 5.7.2 at the time of writing this article. Most of them are performance and replication related that show us how incredible the new release will be.

In this post I’m going to try to explain in some easy steps how the new multi-source replication works and how we can configure it for our own tests. It is important to mention that this is a development release, so it is not production ready. Therefore this post is intend to people that want to test the new feature and see how it works with their application, always in a staging environment.

What is multi-source replication?

First, we need to have clear that multi-master and multi-source replication are not the same. Multi-Master replication is the usual circular replication where you can write on any server and data gets replicated …