Tag: MySQL

Feed: Planet MySQL; Author: Alena Subotina; January 24th, 2022 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 many features, among which are: data and schema compare functionality, advanced code completion and refactoring tools, visual query builder, robust database administration utilities and much more. You can check all reviews on dbForge Studio for MySQL ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Today we are already at the post number ten of the series of articles related to extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published: Today we will keep improving our component by adding some status variables. What I have in mind is to add the following status variables: clamav_signatures (integer): the amount of signatures loadedclamav_engine_version (varchar): the ClamAV Engine Versionvirus_found (integer): counter of detected viruses Once again, we will use a MySQL Component Service to handle our status variables: the Status Variable Registration service. In ... Read More

Feed: Planet MySQL; Author: Chandan Kumar;  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 sessionsSET 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 Schema] A new statement metric, CPU_TIME, is now available, enabling you to measure the CPU time spent on a query.This is helpful to troubleshoot performance of SQL statements specially hardware resource utilize by the SQL statement , below is the there table ... Read More

Feed: Planet MySQL; Author: Dave Stokes;  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 HighlightsThis 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 ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; 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 ... Read More

Feed: Planet MySQL; Author: Nick; 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 MySQL 8. The default version of MySQL is the 8th version on Ubuntu 20.04, 22.04, etc. If you’re using Ubuntu 18.04, the default version is MySQL 5.7, so you’ll need to upgrade. This tutorial will work for later releases too, ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; MySQL Database Service with HeatWave is now available globally in 30 regions Oracle Cloud Infrastructure commercial regions. The most recent addition is Johannesburg in South Africa.  ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; 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 ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; 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 ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; A year ago, I blogged about An Unprivileged User can crash your MySQL Server.  At the time, I explained how to protect yourself against this problem.  A few weeks ago, I revisited this vulnerability in a follow-up post in which I explained the fix, claimed that the MySQL 5.7 default configuration for Group Replication is still problematic, and explained a tuning to avoid the vulnerability.  In this last post in the series, I explain how to exploit this vulnerability to crash older version of MySQL (or untuned Group Replication in 5.7), but this needs a ... Read More