Tag: InnoDB

Feed: Planet MySQL; Author: Yngve Svendsen; When MySQL 5.6 went GA back in 2013, it was a major milestone for MySQL, with a large number of improvements and new features in areas such as InnoDB, partitioning, performance schema, optimizer, and GIS. And not least, 5.6 came with much improved security features and characteristics. But all things eventually come to an end. The baton passed to MySQL 5.7 and then 8.0, and as of February 5 2021, 5.6 will in practice reach its end of life. You will still be able to access pre-existing update releases, documentation and  other support materials ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; In MySQL Server 8.0.23 an improvement was made to InnoDB that allows truncation and deletion of all tablespaces to be faster. In fact, making it almost instantaneous as long as AHI is disabled. This is done by allowing pages in the buffer pool to be freed lazily instead of immediately when a tablespace is deleted. This change generalizes the technique that was introduced in 8.0.21 that made UNDO tablespace truncation instant, described here. Similar to the UNDO-specific fix, this work makes any tablespace deletion or truncation process much faster and, what is ... Read More

Feed: Planet MySQL; Author: Dave Stokes; Adieu MySQL 5.6!When you arrived in 2013 you had a lot of cool new features.  There was the NoSQL Memchache plug-in that was blazingly fast, an improved Performance Shema, full texted searching for InnoDB, big improvements in the optimizer, and great enhancements to replication. You were a great replacement for 5.5!But in a few days you become history, a museum piece.  No more updates for big fixes for you.  You will become part of the 'back in the old MySQL 5.6' days stories senior DBAs and developers will tell.  You were a big improvement ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Although how range_optimizer_max_mem_size operates is explained in the official doc, it’s not a well-known variable and surely not a variable you need to modify under most circumstances. But from time to time we get some performance tickets related to this.What problem does this variable cause if it is not properly sized? Let’s find out with an example!Given the following table definition: CREATE TABLE `joinit` (   `i` int(11) NOT NULL AUTO_INCREMENT,   `s` varchar(64) DEFAULT NULL,   `t` time NOT NULL,   `g` int(11) NOT NULL,   PRIMARY KEY (`i`) ) ENGINE=InnoDB AUTO_INCREMENT=2490316 DEFAULT CHARSET=latin1CREATE TABLE `joinit` (  `i` ... Read More

Feed: Planet MySQL; Author: MySQL Server Dev Team; The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.23! In addition to several bug fixes and minor changes, some significant enhancements regarding monitoring/troubleshooting and performance were included. MySQL Shell AdminAPI Cluster diagnostics Checking how a Cluster is running and, whenever the cluster is not 100% healthy, perform troubleshooting tasks is certainly one of the main tasks of a DBA. The AdminAPI makes this operation very easy by centralizing the monitoring information in: <Cluster>.status([options]) In this release, we’ve extended the status() command to provide more ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; With the new MySQL 8.0.23, something very interesting has been released: Invisible Column. This is the first post dedicated to this new feature, I expect to write a series of 3. This one is the introduction. Prior to MySQL 8.0.23, all columns of a table were always visible (if you had the privilege to see it). Now, an invisible column can be specified and will be hidden to queries. It can always be accessed if explicitly referenced. Let’s see how it works: create table table1 ( id int auto_increment primary key, name varchar(20), age ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Large replication topologies are quite common nowadays, and this kind of architecture often requires a quick method to rebuild a replica from another server.The Clone Plugin, available since MySQL 8.0.17, is a great feature that allows cloning databases out of the box. It is easy to rebuild a replica or to add new nodes to a cluster using the plugin. Before the release of the plugin, the best open-source alternative was Percona XtraBackup for MySQL Databases.In this blog post, we compare both alternatives for cloning purposes. If you need to perform backups, Percona ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; The expected version 8.0.23 of MySQL has been released yesterday o/ For new features and resolved bugs, I recommend Geir‘s traditional blog post announcing the release. Of course, as usual, this release contains contributions from our great Community and let me thanks all the contributors on behalf of the MySQL Team. MySQL 8.0.23 includes contributions from Daniel Black, Vilnis Termanis, Venkatesh Prasad Venugopal, Daniël van Eeden, Cai Yibo, Kamil Holubick, Shaohua Wang, Krunal Bauskar, Tzachi Zidenberg, Cédric Luthi, Brian Yue, Hope Lee and Facebook. Thank you all for your great contributions. MySQL is an ... Read More

Feed: Planet MySQL; Author: Geir Hoydalsvik; The MySQL Development team is very happy to announce that MySQL 8.0.23 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.23 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories. The source code is available at GitHub. You can find the full list of changes and bug fixes in the 8.0.23 Release Notes. Here are the highlights. Enjoy! Invisible Columns Support for INVISIBLE columns  (WL#10905) This work by Praveenkumar Hulakund adds support for INVISIBLE columns. A ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users,MySQL Shell 8.0.23 is a maintenance release of MySQL Shell 8.0 Series (acomponent of the MySQL Server). The MySQL Shell is provided underOracle’s dual-license.MySQL Shell 8.0 is highly recommended for use with MySQL Server 8.0 and5.7. Please upgrade to MySQL Shell 8.0.23.MySQL Shell is an interactive JavaScript, Python and SQL consoleinterface, supporting development and administration for the MySQLServer. It provides APIs implemented in JavaScript and Python thatenable you to work with MySQL InnoDB cluster and use MySQL as a documentstore.The AdminAPI enables you to work with MySQL InnoDB cluster and InnoDBReplicaSet, providing integrated ... Read More