Showing entries 1 to 10 of 42681
10 Older Entries »
The Enhanced dbForge Tools for MySQL v9.1 Are Out!

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.

Meet dbForge Studio 2022 for MySQL – Now Available on Linux and macOS

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.

How to Build Percona XtraDB Cluster From Sources

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 …

[Read more]
Building Percona Server for MySQL 8.0 with RocksDB Storage Engine on macOS

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]
MySQL 8.0 Dynamic Redo Log Sizing

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]
MySQL rewriteBatchedStatements configuration property

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]
OpenLampTech issue #38 – Substack Repost

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:

  • MySQL Indexes
  • PHP boolean comparisons
  • Yoda Conditions
  • Installing WordPress on LAMP
  • And much more

Get your brand, product, or service the attention it needs with affordable classified ad placement in …

[Read more]
Explore Explainability in MySQL HeatWave ML

Machine learning explainability in Oracle MySQL HeatWave ML

Connect to a MySQL database in Python

Connect a Python app to MySQL database with mysqlclient, mysql-connector-python, PyMySQL, and aiomysql.

Read the full story

Register Now for MySQL Summit to Save $200

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!

Showing entries 1 to 10 of 42681
10 Older Entries »