Author: MySQL Planet

Feed: Planet MySQL; Author: Michael McLaughlin; Six years ago I wrote a common lookup post to illustrate the effectiveness of things used throughout your applications. Now, I’m updating my student image with a more complete solution to show how to avoid update anomalies. In the prior post, I used a while loop in PHP, like the following: do { ... } while($stmt->next_result()); Using PHP Version 7.3.8 and MySQL 8.0.16, that now raises the following error message: Strict Standards: mysqli_stmt::next_result(): There is no next result set. Please, call mysqli_stmt_more_results()/mysqli_stmt::more_results() to check whether to call this function/method in /var/www/html/app/library.inc on line 81 ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; Somebody didn’t like the MySQLi Update Query example on the tutorialspoint.com website because it use the procedure mysqli_query style. Here’s a simple example of using the object-oriented method version. More or less, instead of query it uses the more intuitive execute() method. The update_member function contains the logic and below it is a call to the test the function. It relies on a MySQLCredentials.inc file that contains the hostname, user name, password, and database name. You can create create member table, like my example in MySQL 8, or any other table in your MySQL ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Percona announces the release of from the website or install PT-1696: the new pt-pg-summary tool supports PostgreSQL data collection in a way similar to other PT summary tools. The following is a fragment of the report that the tool produces:PT-1741: Migration to a new MongoDB driver was done.PT-1344: pt-online-schema-change failed to detect hostnames with a specified port numberPT-1630: pt-table-checksum had a regression which prevented it from working with Galera clusterPT-1709: pt-upgrade generated “Use of uninitialized value in concatenation (.) or string” error in case of invalid MySQL packetsPT-1728: pt-table-checksum failed to scan small tables that ... Read More

Feed: Planet MySQL; Author: Alena Subotina; .NET Core 3 .NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework. Since then .NET Core has been drastically improved. .NET Core 2.0 has a significant part of Full .NET Framework features and includes new functionality and significant performance optimizations.This year, a new .NET Core 3 is coming. It is currently available as .NET Core 3.0 Preview 9, and despite its preview status, Microsoft officially recommends it to full production use. Besides, Microsoft sends some signals that the development of Full ... Read More

Feed: Planet MySQL; Author: Krunal Lathiya; Laravel 6 CRUD Example | Laravel 6 Tutorial For Beginners is today’s topic. We can upgrade your Laravel’s 6 version by going to this link. Laravel 6 continues the improvements made in Laravel 5.8 by introducing the following features. Semantic versioning Compatibility with Laravel Vapor, Improved authorization responses, Job middleware, Lazy collections, Sub-query improvements, The extraction of frontend scaffolding to the laravel/ui Composer package Content Overview #Server Requirements For Laravel 6 See the following server requirements to run Laravel 6. PHP >= 7.2.0 BCMath PHP Extension Ctype PHP Extension JSON PHP Extension Mbstring PHP Extension ... Read More

Feed: Planet MySQL; Author: Ted Wennmark; Last week I posted a blog on how to setup multi-source for MySQL 5.7 using GTID based replication, in this blog we will do the same using MySQL 8.0.Most of the procedure are the same, there are only two things that we need to change are; 1) Procedure for creating the replication user. 2) Fetching the GTID value from the MySQL dumpfile.1) Create replication user for MySQL 8 MySQL 8 uses a new authentication plugin so to create the replication user will differ from MySQL 5.7. The procedure for 5.7 was with:mysql> CREATE USER ... Read More

Feed: Planet MySQL; Author: VividCortex; When you're trying to understand your systems and why they behave as they do, one of the most powerful questions is "what changed?" or "what's different?" We've offered this capability for years in VividCortex, and now we've added it to the more recent Explorer feature so you can interrogate your databases and discover what's new and different about them ... Read More

Feed: Planet MySQL; Author: Mark Callaghan; This is a review of Adapting TPC-C Benchmark to Measure Performance of Multi-Document Transactions in MongoDB which was published in VLDB 2019. I appreciate that MongoDB and Asya Kamsky took the time to get this published. That can be a weekend and nights project when in industry. I also appreciate that this not a benchmarketing effort. The purpose wasn't to overstate performance. The purpose was to show how to get good performance on a TPC-C like workload with MongoDB and realistic hardware and configurations. I hope for a similar effort on MongoDB with Linkbench.My ... Read More

Feed: Planet MySQL; Author: Severalnines; Microsoft Azure is known to many as an alternative public cloud platform to Amazon AWS. It's not easy to directly compare these two giant companies. Microsoft's cloud business -- dubbed commercial cloud -- includes everything from Azure to Office 365 enterprise subscriptions to Dynamics 365 to LinkedIn services. After LinkedIn was acquired by Microsoft it began moving its infrastructure to Azure. While moving LinkedIn to Azure could take some time, it demonstrates Microsoft Azure’s capabilities and ability to handle millions of transactions. Microsoft's strong enterprise heritage, software stack, and data center tools offer both familiarity ... Read More

Feed: Planet MySQL; Author: Dave Stokes; Oracle Code One starts September 16th and the MySQL Track is packed with interesting presentations. The session coded that start with 'DEV' are general talks. Hands on Labs start with 'HOL' and you will have a pre imaged laptop to use to do the lab work. And 'TUT' is for tutorials.  Use the mobile OOW/CodeOne app to reserve your space as space is limited and there is limited stand by space.I highly recommend the State of the Dolphin talk on Monday as that will provide the richest overview of what is going on within ... Read More