Tag: MySQL 5.7

Feed: Planet MySQL; Author: Peter Gulutzan; MySQL has thrown away the mysql.proc table for version 8.0 Development Releases. The best explanation that I've seen is the one that Dmitry Lenev gave at a conference last October. To summarize it: mysql.proc and its ilk are non-transactional, redundancy is bad, and MySQL can fix some known bugs by moving over to information_schema tables backed by InnoDB. Of course I approve for a separate reason: mysql.proc is non-standard and therefore it is a mistake. On the other hand, programmers that have invested some time in using mysql.proc will have some trouble changing them ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I do not care much about MySQL 8.0.x at the moment, as it's far from being GA and is work in progress. It is not yet used by customers whom I have to support. But I know about many interesting changes and improvements there that, eventually, are going to influence all main forks and kinds of MySQL. So, it would not be wise to ignore MySQL 8.0.c entirely even for me.For this post I decided to briefly check what community reported bugs were fixed in the recent release, 8.0.2, based on release notes. For ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; It's our pleasure to announce that MySQL Community team is supporting multiple shows around the world. Please find a list of conferences & events where you can find us in August & September below: NA&LAD UbuCon LA,Lima, Peru, Aug 18-19, 2017 MySQL Community team is supporting this small Ubuntu conference in LAD as Platinum sponsor.   Pacific Northwest PHP, Seattle, US, Sep 9-11, 2017 You can find our team at the MySQL Community booth in the expo area. Madison PHP, Madison, US, Sep 22-23, 2017 MySQL Community team is supporting this PHP conference ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; TL;DR: unless you know what you are doing, you should always have a primary key on your tables when replicating in RBR (and maybe even all the time). TL;DR2: MariaDB 10.1 has an interesting way to protect against missing a primary key (innodb_force_primary_key) but it could be improved.A few weeks ago, I was called off hours because replication delay on all the slaves from a replication chain was high and growing.  It was not the first time this happened on that chain, so I thought right away that this was probably an UPDATE or DELETE of many ... Read More

Feed: Planet MySQL; Author: Severalnines; Replication in MySQL has been around for a long time, and has been steadily improving over the years. It has been more like evolution rather than revolution. This is perfectly understandable, as replication is an important feature that many depend on - it has to work. In the last MySQL versions, we’ve seen improvements in replication performance through support for applying transactions in parallel. In MySQL 5.6, parallelization was done on schema level - all transactions which have been executed in separate schemas could be executed at once. This was a nice improvement for those ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; I have to get back to the topic of checking user variables in gdb to clarify few more details. In his commentShane Bester kindly noted that calling functions defined in MySQL code is not going to work when core dump is studied. So, I ended up with a need to check what does the my_hash_element() function I've used really do, to be ready to repeat that step by step manually. Surely I could skip that and use Python and Shane himself did, but structures of HASH type are widely used in MySQL, so I'd ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Jervin Real  | August 11, 2017 |  Posted In: MySQL PREVIOUS POST In this post I’ll answer questions I received in my Wednesday, July 19, 2017, webinar Learning MySQL 5.7! First, thank you all who attended the webinar. The link to the slides and the webinar recording can be found here. I received a number of interesting questions in the webinar that I’ve followed up with below. Would there be a big difference on passing from 5.1 to 5.6 before going to 5.7 or, at this point, would it be roughly the same? The biggest ... Read More

Feed: Planet MySQL; Author: HowToForge; MySQL is a free and open source relational management system. It stores data in tabular format. It is the most popular way of storing the data into the database. phpMyAdmin is also a free and open source application used to administrate a MySQL server instance through a rich graphical user interface. phpMyAdmin is written in PHP. To install phpMyAdmin, we will also need to install a web server with PHP on FreeBSD. In this tutorial, we will install MySQL with phpMyAdmin along with Apache web server with PHP 5.6. Prerequisite Minimal FreeBSD 11 server. Root ... Read More

Feed: Planet MySQL; Author: Jean-François Gagné; In my last post about big MySQL deployments, I am quickly mentioning that InnoDB compression is allowing dividing disk usage by about 4.3 on a 200+ TiB dataset.  In this post, I will give more information about this specific use case of InnoDB table compression and I will share some statistics and learnings on this system and subject.  Note that I am not covering InnoDB page compression which is a new feature of MySQL 5.7 (also known as hole punching). Before talking about the results, I will describe the system where I have implemented ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; MySQL Group Replication: read your own write across the group – lefred's blog: tribulations of a MySQL Evangelist Today is my last day in Asia (China and Taiwan), and between the sessions I had the time to code a small proof-of-concept for people that are asking how they could read their writes on all nodes and ensure the read consistency with their last write ? The usual (and easier) answer to this particular question is to read on the same host you just wrote. But currently MySQL provides you all the elements to force ... Read More