MySQL Optimization

    optimizdba mysql database tutorial join and view

    My SQL Database Tutorial: Views and Joins

    Posted November 12, 2018

    Introduction In this MySQL database tutorial, we will learn more about Views and how to perform joins efficiently. Database View Database Views are essentially SQL (Structured Query Language) query with an associated name. Views can frequently be used in the queries by selecting the desired rows or the columns of a table. They can instantly

    Read More
    optimizdba mysql performance

    Optimizing the process of MySQL Performance Tuning

    Posted October 11, 2018

    Released 23 years ago in 1995, MySQL, is still among the most popular relational database management systems. An open-source RDBMS, it uses Structured Query Language. And with the increasing amount of data, database management systems are a must-have for any organization. Now, as these databases expand, the data affects the processing speed negatively. To prevent

    Read More
    MySQL v/s MariaDB

    MySQL v/s MariaDB: Is There A Winner?

    Posted August 20, 2018

    Database revolution took a new turn in 2010 when Oracle Corporation acquired MySQL. According to Michael Widenius, one of the original developers of MySQL, Oracle had a conflict of interest with their original Oracle database. Hence, his response to this situation was forking the MySQL project and creating MariaDB. The first version of MySQL was

    Read More
    MySQL Performance Expert

    MySQL Optimization Experts

    Posted August 1, 2018

      A user waits for approximately 3 seconds for a web-page to load. If it doesn’t, the user chooses an alternative. Most applications make hundreds of requests to the servers many of which are DB requests. MySQL Optimization Experts can help you identify the bottlenecks and optimize the MySQL queries to improve the performance of

    Read More