Showing entries 1 to 10 of 42328
10 Older Entries »
OpenLampTech issue #10

I keep rolling in with new issues of OpenLampTech, the newsletter for PHP/MySQL developers and you keep reading them. Sounds like a fair trade to me! I have another fantastic, huge issue for all of your reading enjoyment in the PHP/MySQL world…

Get tailored articles with Refind delivered each day in your inbox. Refind is part of my daily reading habit. Make it part of yours by using my referral link. At no additional cost to you, I will be eligible for a premium subscription with more sign-ups from my link. The essence of the web, every morning in your inbox. Subscribe for free

The Newsletter for PHP and MySQL Developers

Let’s get right to …

[Read more]
Absolute Trophy Champion -dbForge Studio for MySQL Got Nine Awards

The festive season has come to an end, but Devart is still receiving presents. We have great news that we would like to share. dbForge Studio for MySQL gained nine awards from G2. The collection of dbForge Studio for MySQL counts nine new badges: According to G2 users reviews, dbForge Studio for MySQL attracts by […]

The post Absolute Trophy Champion -dbForge Studio for MySQL Got Nine Awards appeared first on Devart Blog.

Glimpse of MySQL 8.0.28 Release

 MySQL 8.0.28 version is GA!!! , ready to use in production.Below is high level overview , more can be viewed from the weblink.

[1] Disabling Audit Logging for all connecting and connected sessions
SET GLOBAL audit_log_disable = true;
Setting audit_log_disable to true disables the audit log plugin. The plugin is re-enabled when audit_log_disable is set back to false, which is the default setting.

[2]- [Under Performance …

[Read more]
MySQL 8.0.28 Release Note Commentary

 MySQL Server version  8.0.28 was launched a few days ago and without a lot a fanfare. Which is a shame and I wish we had more of a splash for every release.  The release notes are available here

I would like to highlight some of the changes.

There are over a hundred bug fixes and big thanks to Hope Lee, Casa Zhang, Øystein Grøvlen, Song Zhibai, Facebook, Hobert Lu, Brian Yue, Zhai Weixiang, Murakami Kohei,  Venkatesh Prasad Venugopal, and the Tencent team.

The Highlights

This release does not have a lot of 'wow' new features but shows a lot of solid work in evolving the product. 

  • The new audit_log_disable system variable …
[Read more]
MySQL Performance Tuning: Top 10 Easy Tips

MySQL is a proven, reliable database that is quick to set up easy to maintain, and has outstanding performance. However, that performance can usually be improved with the judicious use of the following tips that are all easy to implement...

MySQL Query Optimization: Top 3 Tips

MySQL Query Optimization is usually simple engineering. But seeking information about how to tune queries is treated on many web reference sites like some Harry Potter-ish spell casting. There are simple tips you need to be aware of to get the best of your queries...

Tips to Optimize MySQL Applications Query Performance

Performance issues are often stubborn things to cure. Suddenly a query or operation seems slow, or slower-ish. Sadly, the database is often pointed at as the culprit by developers who are either positive their code cannot be at fault or those who see databases as a mysterious box that does odd things ...

Percona XtraBackup Changing to Strict by Default

Backups are a key part of a disaster recovery strategy, making sure you can continue or restore your business in case of an unwanted event with your data.

We always work on trying to improve Percona XtraBackup reliability, always favoring consistency, attempting to make unwanted outcomes be noticed as earlier as possible in the process.

Enabling –strict by Default

As of the upcoming release of 8.0.27, XtraBackup will no longer accept invalid parameters. Since the beginning of the times, validation of parameters has been a difficult task for XtraBackup as it mixes server-side and XtraBackup only parameters.

Starting at Percona XtraBackup 8.0.7 we implemented …

[Read more]
How to Upgrade MySQL on Ubuntu

In this tutorial, we’ll show you how to upgrade/update MySQL to a newer version. This tutorial was written and tested for Ubuntu. Recommended reading: How to install MySQL on Ubuntu Before we begin Before we begin with our actual tutorial, this is what you need (to know): As of writing, the latest MySQL release is […]

Source

Fill in missing Date ranges using MySQL

I’m always trying different programming exercises in order to learn and grow as a Developer. One of my favorite learning exercises is porting over from one SQL dialect to another, as they all have their own individual features. Having to hack together or mirror non-existent functionality really challenges my thinking, therefore enabling growth and improvement in my query skills. In this post, I share reproducing the same query results using MySQL for queries I first learned of/discovered that were covered using Oracle SQL and specific implementation features…

Image by José Augusto …

[Read more]
Showing entries 1 to 10 of 42328
10 Older Entries »