Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 17945 10 Older Entries

Displaying posts with tag: mysql (reset)

The wish list for secure and effective monitoring of MySQL servers
+0 Vote Up -0Vote Down

All you need for monitoring MySQL servers. Data security is paramount for individuals and corporations alike. Today, it is inevitable not to notice the importance levied on hosted MySQL like RDS, Aurora, etc. Managing MySQL servers is becoming a daunting task, given the exponential growth in data and the number of users with each working days.

Below are the key aspects that need to be part of your wishlist.

1) Leveraging Performance Schema(P_S) and SYS Schema

Performance Schema was introduced in MySQL 5.5.3 and further upgraded through version 5.7. It has its own storage engine, provides access to low-level server …

  [Read more...]
Troubleshooting hardware resource usage webinar: Q & A
+0 Vote Up -0Vote Down

In this blog, I provide answers to the Q & A for the Troubleshooting hardware resource usage webinar.

First, I want to thank everybody who attended the May 26 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t …

  [Read more...]
MySQL Workbench & Performance_Schema
Employee +0 Vote Up -0Vote Down

Last week during the Oracle Users Group Leaders Summit in Bucharest I had the pleasure the meet the leaders for the MySQL Users Group from Azerbaijan,  Finland, Madrid and the Netherlands.

During some discussions, it appeared that some users are not aware of the Performance_Schema integration in MySQL Workbench. Indeed with WB you can enable PFS, add sys table if not present by default (<5.7).

You can use a default configuration or customize it and enable all the instruments and consumers you need.

When enabled, you can generate some useful reports

 

 

In case you are also not yet …

  [Read more...]
Utilizing OpenStack Trove DBaaS for deployment management
+0 Vote Up -0Vote Down

Trove is used for self service provisioning and lifecycle management for relational and non-relational databases in an OpenStack cloud. Trove provides a RESTful API interface that is same regardless of the type of database. CLI tools and a web UI via Horizon are also provided wrapping Trove API requests.

…  [Read more...]
Scaling Percona XtraDB Cluster with ProxySQL in Docker Swarm
+1 Vote Up -0Vote Down

In this post, we’ll look at scaling Percona XtraDB Cluster with ProxySQL in Docker Swarm.

In my previous post, I showed how to employ Percona XtraDB Cluster on multiple nodes in a Docker network.

The intention is to be able to start/stop nodes and increase/decrease the cluster size dynamically. This means that we should track running nodes, but also to have an …

  [Read more...]
sync_binlog = 1 in MySQL 5.7
Employee +1 Vote Up -0Vote Down

As Morgan announced it his blog post related to new defaults in 5.7, in 5.7.7 and newer the default value of sync_binlog is now 1.

This of course has an impact on performance especially if you don’t have fast storage like a RAID controller with a cache for example.

Already in O’reilly High Performance MySQL, is was written that the most important setting for binary logging on the master is sync_binlog = 1.

And …

  [Read more...]
MySQL Workbench 6.3.7 GA has been released
Employee +1 Vote Up -0Vote Down
The MySQL developer tools team announces 6.3.7 as our GA release for MySQL Workbench 6.3. 

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-3.html

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/list.php?152

Download MySQL Workbench 6.3.7 GA now, for Windows, Mac OS X 10.9+, 
Oracle Linux 6 and 7, Fedora 23 and Fedora 24, Ubuntu 16.04 or sources, from:








  [Read more...]
MySQL 5.7: New Audit Log Filtering Feature – Part 1
Employee_Team +3 Vote Up -0Vote Down

Security auditing plays important role in the process of securing a database system. Thanks to the MySQL Enterprise Audit extension, we can record all activities, such as client connections and execution of queries into a single log file, for later inspection.…

Restoring MySQL Database from xtrabackup – facepalm moments
+0 Vote Up -0Vote Down

Learning from facepalm moments of a MySQL database restore from Percona Xtrabackup.

Advanced MySQL Slow Query Logging Part 2: pt-query-digest report
+0 Vote Up -0Vote Down

Proper MySQL Query Optimization starts with a proper Slow Query Logging session. And MySQL Query Optimization is where I spend 70-80% of my time when doing MySQL performance optimization.

Here in part 2, we will go over the pt-query-digest report, that we have prepared in part 1.

The post Advanced MySQL Slow Query Logging Part 2: pt-query-digest report appeared first on Speedemy.

10 Newer Entries Showing entries 61 to 70 of 17945 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.