Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 35703 10 Older Entries
VividCortex Adds Query Analysis Features
+0 Vote Up -0Vote Down

VividCortex is all about optimizing your queries. Many of our users asked us to analyse their queries, searching for common errors and mistakes.

It's true that there are some excellent tools out there to perform the same tasks, such as pt-query-advisor from the great Percona Toolkit. But having this information available right in our web application is something we always wanted to do, too. And today we released that!

Today we added Query Analysis to our …

  [Read more...]
RocksDB vs the world for loading Linkbench tables
+0 Vote Up -0Vote Down

I like RocksDB, MyRocks and MongoRocks because they are IO efficient thanks to excellent compression and low write-amplification. It is a bonus when I get better throughput with the RocksDB family. Here I show that RocksDB has excellent load performance and to avoid benchmarketing the context is loading Linkbench tables when all …

  [Read more...]
Measuring Docker IO overhead
+0 Vote Up -0Vote Down

This will be another post on using Percona Server via a Docker image. I want to follow up on my previous post regarding CPU/Network overhead in Docker “Measuring Percona Server Docker CPU/network overhead” by measuring  if there is any docker IO overhead on operations.

After running several tests, it appears (spoiler alert) that there is no Docker IO overhead. I still think it is useful to understand the …

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

This Log Buffer Edition covers blog posts from Oracle, SQL Server and MySQL for this week.

Oracle:

APEX shuttle item with one direction

Wondering about which tasks and work products are essential for your project?

Using Spark(Scala) and Oracle Big Data Lite VM for Barcode & QR Detection

Cloning 10.2.0.3 …

  [Read more...]
MariaDB 5.5.48 and Connector/J 1.3.5 now available
+0 Vote Up -0Vote Down

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.48 and MariaDB Connector/J 1.3.5. See the release notes and changelogs for details on these releases. Download MariaDB 5.5.48 Release Notes Changelog What is MariaDB 5.5? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/J 1.3.5 Release Notes Changelog About MariaDB Connector/J […]

The post MariaDB 5.5.48 and Connector/J 1.3.5 now available appeared first on MariaDB.org.

New in MySQL 5.7: Performance Schema scalable memory allocation
Employee_Team +1 Vote Up -0Vote Down

Performance Schema is a mechanism to collect and report run time statistics for running MySQL server. These statistics are stored-in and fetched-from internal memory buffers. In MySQL 5.6 GA, memory for these buffers is allocated during MySQL server startup with either user specified configuration values or with default values that autosize.…

Foundation report for 2015
+0 Vote Up -0Vote Down

This is a repost of Otto Kekäläinen's blog of the MariaDB foundations work in 2015.

The mariadb.org website had over one million page views in 2015, a growth of about 9% since 2014. Good growth has been visible all over the MariaDB ecosystem and we can conclude that 2015 was a successful year for MariaDB.
Increased adoptionMariaDB was included for the first time in an official Debian release (version 8.0 "Jessie") and …


  [Read more...]
Comment on Life at Pythian as a MySQL DBA by Natalia
+0 Vote Up -0Vote Down

Hi Derek, thanks for sharing with us this post, from my perspective it was really helpful.

I have worked as a Windows admin for several projects but the roles were very specific and sometimes you did not have the chance to do new things.
At the moment I work freelance but I am very interested in a job position for Pythian.

Do you know if there´s any job position for Windows Admin?

Thanks!

We need your feedback: please participate in our open source database management survey
+0 Vote Up -1Vote Down

As members of the wider open source database users community, we’d like you to participate in our open source database deployment and management survey.

Your input will help us make our resources and tools for deploying, monitoring, managing and scaling databases of even more use to the community. It will give us valuable insight into the challenges you face when operating databases.

Please take the survey today by providing your input below; this will take approx. 5 minutes of your time.

 

We’ll share the results of the survey once we have compiled your responses.

…  [Read more...]
EXPLAIN FORMAT=JSON: buffer_result is not hidden!
+0 Vote Up -0Vote Down

Time for another entry in the EXPLAIN FORMAT=JSON is cool! series. Today we’re going to look at how you can view the buffer result using JSON (instead of the regular

EXPLAIN

 command.

Regular

EXPLAIN

 does not identify if

SQL_BUFFER_RESULT

 was used at all. To demonstrate, let’s run this query:

mysql> explain …
  [Read more...]
Showing entries 1 to 10 of 35703 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.