Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 151 to 160 of 36276 10 Older Entries
I am now a member of team MariaDB
+0 Vote Up -0Vote Down

Monday I started at MariaDB working on ColumnStore. My interest in column store technology extends way back to the days as the MySQL evangelist at Kickfire, which was a compressing column store and "SQL CHIP" appliance. My initial tasks are documentation related, but I'll be helping with development, and of course testing it with Shard-Query, which is a great stress testing system.

Planets9s - Download the new ClusterControl 1.3 for MySQL, MongoDB & PostgreSQL
+0 Vote Up -0Vote Down

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

Download the new ClusterControl 1.3 for MySQL, MongoDB & PostgreSQL

This week we were excited to announce the release of ClusterControl 1.3. This release contains key new features, such as Key Management for …

  [Read more...]
AWS Aurora Benchmark - Choose the right tool for the job
+1 Vote Up -0Vote Down


Some time ago, I published the article “AWS Aurora Benchmarking - Blast or Splash?”. In which I was analyzing the behavior of different solutions using synchronous replication in AWS environment.

After I published it, I received a lot of comments and feedback, from the community and from Amazon engineers.

Given that I had decide to perform another round of tests, keeping into account the comments received and the suggestions.

I had presented some …

  [Read more...]
Log Buffer #474: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This Log Buffer Edition covers Oracle, SQL Server and MySQL blogs from across the planet.


You might be thinking “Nothing is more frustrating that encountering a string column that is full of dates”. But there is something worse than that.

Unique constraint WWV_FLOW_WORKSHEET_RPTS_UK violated.

Understanding query slowness after …

  [Read more...]
Where is the MySQL 5.7 root password?
+0 Vote Up -0Vote Down

In this blog, we’ll discuss how to find the MySQL 5.7 root password.

While new MySQL software security features are always welcome, they can impact use and performance. Now by default, MySQL 5.7 creates a password for the root user (among other changes) so the installation itself can be considered secure. It’s a necessary change, but it has confused some customers and users. I see a lot of people on social networks (like Twitter) asking about this change.

Where is my root password?

The answer depends …

  [Read more...]
Webinar Thursday May 19, 2016: MongoDB administration for MySQL DBA
+0 Vote Up -0Vote Down

Please join Alexander Rubin, Percona Principal Consultant, for his webinar MongoDB administration for MySQL DBA on Thursday, May 19 at 10 am PDT (UTC-7).

If you are a MySQL DBA and want to learn MongoDB quickly – this webinar is for you. MySQL and MongoDB share similar concepts so it will not be hard to get up to speed with MongoDB.

In this talk I will explain the following …

  [Read more...]
Planning for default changes in MariaDB Server 10.2
+0 Vote Up -0Vote Down

Wed, 2016-05-18 14:13Colin Charles

MariaDB Server 10.2 has been a long time coming, as planning goes. We met in Amsterdam in October 2015 to start fleshing things out (and also managed a 10.1 GA then), and made a first alpha release in April 2016. If all goes well, 2016 will definitely see the GA release of MariaDB Server 10.2.

But this also means that it may be time to make changes in the …

  [Read more...]
Comment on Significant performance boost with new MariaDB page compression on FusionIO by alexandre
+0 Vote Up -0Vote Down

I see
Im currently using innodb_use_fallocate=ON, but NOT innodb_use_trim=ON

so, innodb_use_trim=ON is meant for trim and punch_hole.

gives impression that innodb_use_fallocate=ON is enough to enable punch hole with

fallocate(file_handle, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, file_offset, remainder_len)

cant see trim involved…

maybe a bug of fallocate?

found some info on

  [Read more...]
We’re hiring - again! Looking for our new QA Automation Engineer! Apply within!
+0 Vote Up -0Vote Down

We’ve just announced the latest version of our flagship product, ClusterControl, this week and as our product grows, so does our team.

As a result, we’re now looking for a QA automation wizard, someone who’ll help us take our product development to where we want it to be: short, well-tested release cycles.

This role involves extensive programming, test execution, reporting, and setting technical direction for testing Severalnines software.

And it involves being part of a great (if we say so), distributed team of highly skilled and motivated colleagues building the next generation database cluster …

  [Read more...]
Comment on Significant performance boost with new MariaDB page compression on FusionIO by Jan Lindstrom
+0 Vote Up -0Vote Down

Remember that by default innodb_use_trim = 0, meaning that full 16K is always written even when compressed payload is e.g. 4K. This is because innodb_use_trim = 1 requires punch hole support from OS and file system and this is only way to leave holes to file system currently.

10 Newer Entries Showing entries 151 to 160 of 36276 10 Older Entries

Planet MySQL © 1995, 2016, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.