(Valeriy Kravchuk) Some results in my initial post in this series led me to questions that I’ll try to answer here. First of all, I noted that SELECT from a single table ended up with just one metadata lock request:
Tag: Open Source
MySQL Performance Troubleshooting Crash Course. A Story Of One Sneaky MySQL Performance Bug
(Aurimas Mikalauskas) What better way to learn the basics of MySQL Performance Troubleshooting, than by observing a MySQL expert troubleshoot a nasty MySQL 5.7 performance bug, that a team of DBAs were chasing for weeks before giving up and calling in an external consultant for help.
Version Tokens in MySQL 5.7
(Prabeen Pradhan) In MySQL 5.7.8 we added support for version tokens. This is a new feature that enables you to prevent accessing incorrect or out-of-date data, and stray modifications executing on the wrong server.
MySQL 5.7 InnoDB Versus the Thread Sanitizer
(Rik Prohaska) InnoDB and the Thread Sanitizer do not work well together in MySQL 5.7. There are hundreds of possible data races reported by the Thread Sanitizer in the InnoDB code for the simplest case of initializing the MySQL server and shutting it down. Luckily, most of these data races are be
Secure by Default in MySQL 5.7
(Harin Vadodaria) MySQL 5.7 comes with enhancements which makes a deployment secure by default. These features try to minimize attack surface as much as possible without hampering usability aspect.
Is MySQL X faster than MySQL Y? – Ask queryprofiler
(Simon Mudd) When trying out new software there are many other questions you may ask and one of those is going to be the one above.
Use MySQL to store data from Amazon’s API via Perl scripts
(Tony Darnell) I really like Amazon.com and I have been a Prime member for several years. Along with millions of different items for sale, Amazon has an affiliate program, where you can earn money advertising products on your web site. When a visitor to your site clicks on a link and orders a produc
SSL/TLS Improvements in MySQL 5.7.10
(Todd Farmer) Secure communications is a core component of a robust security policy, and MySQL Server 5.7.10 – the first maintenance release of MySQL Server 5.7 – introduces needed improvements in this area.
Better high availability: MySQL and Percona XtraDB Cluster with good application design
(Przemys³aw Malkowski) Have you ever wondered if your application should be able to work in read-only mode? How important is that question?
MySQL 5.7 Performance Schema Versus the Thread Sanitizer
(Rik Prohaska) This blog continues the investigation into possible data races in the MySQL server reported by the Thread Sanitizer. The previous blog investigated several possible data races that were detected when the MySQL server is initialized.
