Meet the long-awaited release of dbForge tools for MySQL. We have enhanced them with a few new features that will surely come in handy. However, the foremost thing in this update is that our tools now can run on Linux and macOS through CrossOver, a solution that helps launch Windows applications on different operating systems. […]
The post The Enhanced dbForge Tools for MySQL v9.1 Are Out! appeared first on Devart Blog.
We are happy to announce the new release of our flagship solution for MySQL – dbForge Studio for MySQL – which is now available on Linux and macOS! Check out the updated features and improvements. Getting Started and Video Tutorials When you need to learn how the product or its specific feature works, you as […]
The post Meet dbForge Studio 2022 for MySQL – Now Available on Linux and macOS appeared first on Devart Blog.
Percona XtraDB Cluster (PXC) is a database clustering solution for MySQL. It ensures high availability, prevents downtime and data loss, and provides linear scalability for a growing environment.
Lately, the number of questions about how to build Percona software has increased. More and more people try to add their own patches, add some modifications, and build software by themselves. But this raises the question of how to do this in the same way as Percona does, as sometimes the compiler flag can make a drastic impact on the final binary. This is a really essential question and let’s look at how we build Percona XtraDB Cluster here at Percona.
At the first glance, the building process is not something
difficult. Everyone knows that magic make install
all command and suppose that as a result everything will
be …
In Percona Server for MySQL 8.0.29-21, we added one more patch that helps us to build server code on macOS. To be precise here, we still could do this even before this patch but only partially. Now it is possible to build RocksDB Storage Engine as well.
A word of disclaimer here, at the moment, by macOS we still understand macOS for Intel x86_64 architecture (the most recent ARM versions with Apple M1 / M2 processors are out of the scope of this blog post). Moreover, Percona does not provide …
[Read more]This blog post will discuss the newest feature available in MySQL 8.0.30: dynamic redo log sizing. After the InnoDB buffer pool size, we can say that having a proper size for the redo logs is crucial for MySQL performance. There are numerous blog posts about how to calculate a good redo log size. One of our classic blog posts is this one from Baron: How to calculate a good InnoDB log file size (That blog post is from 2008 and is still a valid formula to use.)
Now, which problem is this feature trying to solve?
In MySQL, the buffer pool and redo log size are settings that do not change frequently. Usually, these settings are set during database installation; after that, they are forgotten until an issue arises. The problem is that they used to be static, which means that you had to restart MySQL so the changes …
[Read more]Introduction In this article, we are going to see how MySQL rewriteBatchedStatements works when using JDBC, JPA, or Hibernate. I first researched this MySQL configuration property when I was writing the batching chapter of my High-Performance Java Persistence book, and, back then, I discovered that this setting allows batching plain Statement by rewriting the SQL string that is sent to the database. However, the MySQL 6 Connector/J documentation mentioned that: for prepared statements, server-side prepared statements can not currently take advantage of this rewrite option So, for a long time, I wrongly... Read More
The post MySQL rewriteBatchedStatements configuration property appeared first on Vlad Mihalcea. …
[Read more]We have another massive newsletter for you this week. And OpenLampTech is growing! Thank you for making it a success!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
This week in OpenLampTech issue #38, we have content covering:
Get your brand, product, or service the attention it needs with affordable classified ad placement in …
[Read more]Machine learning explainability in Oracle MySQL HeatWave ML
Connect a Python app to MySQL database with mysqlclient, mysql-connector-python, PyMySQL, and aiomysql.
MySQL Summit at Oracle CloudWorld in Las Vegas, OCT 17-20, is the biggest MySQL event. It includes 80+ sessions, from MySQL sessions, hands-labs, tutorials, birds-of-a-feather, and more. The event represents a unique opportunity to boost your MySQL knowledge and skills, learn what's new with MySQL, meet leading community experts, experts from companies who rely on MySQL, as well as the MySQL Engineering Team. Register now to save $200!
