Planet MySql
InnoDB Page Compression - MySQL 8 Compression  18h55 22 octobre
InnoDB Page Compression Explained We have several customers with multi-terabyte database infrastructure on SSDs, The SSDs are great investment for performance but they are also expensive with shorter lifespans so storage efficiency management is something we are very cautious about on SSDs, At...
Setting up MySQL Cluster on local machine using AutoInstaller  15h42 22 octobre
Mikael Ronström
We have a new version of the MySQL Cluster Auto Installer. I have prepared 3Youtube videos that shows how to make use of the Auto Installer to install andset up a cluster on your local machine.This is my first attempt at making Youtube videos to explain things aroundMySQL Cluster.The Auto Installer...
NoSQL SQL MySQL 8; Keynote OSI2019  09h28 22 octobre
Sanjay Manwani
NoSQL SQL Mysql 8 Open Source India 2019 keynote from Sanjay Manwani Slides from the keynote presented at Open Source India 2019 at Nimhans convention center Bangalore. As usual lots of interesting folks. Lots of focus on Open Source. Met people from the SODA foundation who are trying to...
MySQL & InnoDB Disk Space  09h21 22 octobre
Frederic Descamps
Yesterday, Bhuvanesh published an article about how to verify the difference between allocated diskspace for a tablespace and the the data in it. I commented with an old post explaining how to get some similar info only using SQL in case you don’t have filesystem access. And finally, my...
MySQL for Visual Studio 1.2.9 has been released  16h48 21 octobre
Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Visual Studio 1.2.9. This is a maintenance release for 1.2.x. It can be used for production environments. MySQL for Visual Studio is a product that includes all of the Visual Studio integration...
dbForge Studio for MySQL is a DBTA 2019 Finalist  13h54 21 octobre
Alena Subotina
DBTA (Database Trends and Applications) is a magazine delivering news and analysis on data science, big data, information management, and analytics. Every year, they conduct surveys among readers about various database-related software solutions to choose the best offers in a variety of categories...
MySQL Keyring now speaks Hashicorp Vault  06h37 21 octobre
MySQL Server Dev Team
As an intro to his performance act, an old school entertainer Victor Borge once famously asked the audience: Do you care for piano music? , which was greeted by a crowd, only to be immediately followed by a self-ironic punch line - Too bad. Security topics share a similar notion - namely,...
MySQL Calculate How Much Disk Space You Wasted  05h13 21 octobre
Bhuvanesh R
Its not the new term for DBAs. MySQL has an awesome parameter innodb-file-per-tables allows MySQL to create separate files for each tables. This helped a lot to manage the disk space in more efficient way. But when we perform a large batch job for delete or update the data in MySQL tables, you may...
MySQL Server 8.0.18: Thanks for the Contributions  06h18 20 octobre
Jesper Krogh
Tweet In my blog series about external contributions to MySQL 8 we have reached version 8.0.18 which was released Monday 14 October 2019. Again the community has contributed to make MySQL better. Thank you. The contributions to MySQL 8.0.18 includes several patches from Facebook as well as...
Just put the cold data over there  16h37 18 octobre
Mark Callaghan
There are several ways to use less SSD for an OLTP workload: choose a database engine has less space amplification, store less data, move the cold data elsewhere. The first approach is a plan while the others are goals. A plan is something you can implement. A goal requires a plan to get done.This...
Group Replication delivery message service  14h00 18 octobre
MySQL High Availability
In the process of enhancing MySQL replication with new features for our users, we also improve the internals. A lot of work goes also to modernize the codebase and make it easier to maintain and obviously extend as well. In MySQL 8.0.18, we have extended the set of internal services with a group...
Setting up a High Availability for PMM  21h18 17 octobre
We have been working with PMM for quite a long time, we do most of the performance analysis with PMM for most of our clients. It also provides the flexibility that we have built our own custom dashboard. PMM has many advantages Easy to deploy (docker based) Flexible Customizable Query Analytics...
Automatic member fencing with OFFLINE MODE in Group Replication  13h00 17 octobre
Nuno Carvalho
Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.... Tweet Google Plus ...
Dirty reads in High Availability solution  08h28 17 octobre
Marco Tusa
Understand dirty reads when using ProxySQL Recently I had been asked to dig a bit about WHY some user where getting dirty reads when using PXC and ProxySQL. While the immediate answer was easy, I had taken that opportunity to dig a bit more and buildup a comparison between different HA...
MySQL EXPLAIN ANALYZE  06h26 17 octobre
MySQL Server Dev Team
MySQL 8.0.18 was just released, and it contains a brand new feature to analyze and understand how queries are executed: EXPLAIN ANALYZE. What is it? EXPLAIN ANALYZE is a profiling tool for your queries that will show you where MySQL spends time on your query and why.... Facebook Twitter ...