Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 41 to 50 of 36180 10 Older Entries
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.

Oracle:

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.
reading

https://mariadb.com/kb/en/mariadb/compression/

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.

MySQL 5.7 read-write benchmarks
+0 Vote Up -0Vote Down

In this post, we’ll look at the results from some MySQL 5.7 read-write benchmarks.

In my past blogs I’ve posted benchmarks on MySQL 5.5 / 5.6 / 5.7 in OLTP read-only workloads. For example:

  [Read more...]
ClusterControl 1.3 Released with New Features for MySQL, Percona Server, MariaDB, MongoDB & PostgreSQL
+0 Vote Up -0Vote Down

The Severalnines team is pleased to announce the release of ClusterControl 1.3.

This release contains key new features, such as Key Management for MySQL, MariaDB, Percona Server and PostgreSQL, improved security, additional Operational Reports, along with performance improvements and bug fixes.

Join us next week on Tuesday, May 24th, for a live demo!

Sign up for the webinar

Highlights

  • New for MySQL, MariaDB, Percona Server & PostgreSQL
    • Key Management
  [Read more...]
10 Newer Entries Showing entries 41 to 50 of 36180 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.