# MySQL 5.6 Reviews **Vendor:** Jetware **Category:** [AWS Marketplace Software](https://www.g2.com/categories/aws-marketplace) **Average Rating:** 4.3/5.0 **Total Reviews:** 12 ## About MySQL 5.6 MySQL 5.6 is a robust, open-source relational database management system designed to meet the demands of modern web, cloud, and embedded applications. Released in February 2013, it introduced significant enhancements in performance, scalability, reliability, and manageability, making it a preferred choice for developers and organizations seeking efficient data management solutions. Key Features and Functionality: - Improved Performance and Scalability: MySQL 5.6 offers up to a 230% improvement in transactional and read-only throughput. This is achieved through optimizations in the InnoDB storage engine, including reduced mutex contentions and enhanced concurrency on heavily loaded OLTP systems. - Enhanced Query Execution: The updated optimizer includes subquery optimizations, Index Condition Pushdown , and Batch Key Access , resulting in faster query execution times and improved diagnostics. - Advanced Replication Capabilities: Features like crash-safe replication, multi-threaded slaves, and global transaction identifiers enhance data integrity and availability, facilitating efficient scale-out architectures. - Flexible NoSQL Access: Integration with the Memcached API allows for simple key-value operations directly on InnoDB tables, combining the benefits of NoSQL and SQL within the same database system. - Online Data Definition Language Operations: DBAs can perform schema changes, such as adding indexes or altering tables, without downtime, ensuring continuous application availability. Primary Value and User Solutions: MySQL 5.6 addresses critical challenges in data management by providing a high-performance, scalable, and reliable database solution. Its enhanced features enable developers to build and deploy sophisticated applications efficiently, while DBAs benefit from improved manageability and reduced operational overhead. The integration of NoSQL capabilities and advanced replication ensures flexibility and data integrity, making MySQL 5.6 a comprehensive solution for diverse data management needs. ## MySQL 5.6 Pros & Cons **What users like:** - Users praise MySQL 5.6 for its **robust data analytics capabilities** , perfectly meeting their backend needs. (1 reviews) - Users praise MySQL 5.6 for its **robust performance** , excelling in both backend functionality and analytics. (1 reviews) **What users dislike:** - Users find MySQL 5.6 has **limited flexibility** , which may hinder scalability for future needs despite current satisfaction. (1 reviews) ## MySQL 5.6 Reviews ### 1. Simply the best **Rating:** 5.0/5.0 stars **Reviewed by:** Eugene V. | Head of Product, Small-Business (50 or fewer emp.) **Reviewed Date:** January 29, 2025 **What do you like best about MySQL 5.6?** Great DB that just works great - robust for the backend needs, great for analytics **What do you dislike about MySQL 5.6?** Might be not very scalable, but meets our for needs at the moment **What problems is MySQL 5.6 solving and how is that benefiting you?** Used as a main backend DB for our product ### 2. review for MYSQL 5.6 **Rating:** 3.5/5.0 stars **Reviewed by:** Khilan P. | Unity Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 11, 2023 **What do you like best about MySQL 5.6?** Multi-range read and scanning several index ranges is a query designed to speed up operations such as range index scans and join operations on indexed columns. Replication improvement Optimization replaced with row-based. Secure **What do you dislike about MySQL 5.6?** native JSON support InnoDB limitations, for example, it uses a shared buffer pool for caching data and indexes. It's challenging to debug sto Lack of certain features **What problems is MySQL 5.6 solving and how is that benefiting you?** Capability and ecosystem Cost effective Security: MySQL 5.6 offers various security features to protect sensitive data. Database management Problem optimization: MySQL 5.6 introduces several performance improvements and optimizations. ### 3. It's an excellent Relational Database Management System **Rating:** 5.0/5.0 stars **Reviewed by:** Andres H. | Development Team Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** December 12, 2022 **What do you like best about MySQL 5.6?** It is free and has InnoDB for foreign key constraints, triggers, custom functions, views, and many important things in the SQL world. It also has a large community, so you might find answers easier compared to Oracle and PostgreSQL. **What do you dislike about MySQL 5.6?** It does not have JSON data types, but it was included in version 5.7. I really dislike the fact that it does not have a real BOOLEAN data type, we need to use TINYINT and cast it in the application. **What problems is MySQL 5.6 solving and how is that benefiting you?** Storing and querying data, by having strict conditions to store them when they are related. Since this is the most common Relational Database Management System, I can use it almost in every server or container, with no extra installation. ### 4. Site Reliability Engineer **Rating:** 4.5/5.0 stars **Reviewed by:** Soumyadip C. | Information Technology Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2023 **What do you like best about MySQL 5.6?** Secure , High performance, Industry Standard , Opensource, Data Security, Scalability, Higher Efficiency **What do you dislike about MySQL 5.6?** It's not a huge Database size and challenge to debug stored procedures . It's not SQL complaint as syntax of SQL in MySQL **What problems is MySQL 5.6 solving and how is that benefiting you?** It"s solves database solutions in Three tier web app architecture as backend supporting the Frontend Apache Web server . Stores all incoming request and it's data from Application Load Balancer mostly . ### 5. "Unveiling the power of MYSQL 5.6" **Rating:** 4.5/5.0 stars **Reviewed by:** Siddharth P. | Unity 3d Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** June 06, 2023 **What do you like best about MySQL 5.6?** 1. Performance improvements. 2. Replication Enhancements. 3.InnoDb improvements. 4. Better Security. **What do you dislike about MySQL 5.6?** 1. Lack of JSON Support. 2. Limited Performance. 3. Inefficient Full-text Search. 4.Limited Online Schema Changes. **What problems is MySQL 5.6 solving and how is that benefiting you?** Replication Improvement: MYSQL 5.6 introduced features like Multi-Threaded Slave replication and Global Transaction identifiers.These enhancements improved the reliability. ### 6. Great Relational Database Provider **Rating:** 4.5/5.0 stars **Reviewed by:** Ishan M. | Enterprise (> 1000 emp.) **Reviewed Date:** April 05, 2023 **What do you like best about MySQL 5.6?** Limitless functionalities, can handle a vast number of tables, schemas, and databases at the same time. **What do you dislike about MySQL 5.6?** UI can be improved, looks a little old and too complex. **What problems is MySQL 5.6 solving and how is that benefiting you?** Storing relational tables into Database and querying over them for various business purposes. ### 7. A Generous goodbye to MySQL 5.6 [Deprecated Feb 2022] **Rating:** 4.5/5.0 stars **Reviewed by:** Jatin K. | Freelance, Small-Business (50 or fewer emp.) **Reviewed Date:** March 27, 2022 **What do you like best about MySQL 5.6?** Of course, MySQL is the most popular RDBMS in fact, the first database of many. It's a great tool, and I admired the newly added features in the 5.0+ versions. My favorite was all of them the COMMIT and stored procedures that were added, it made the job so easy and productive **What do you dislike about MySQL 5.6?** Scalability was an issue and is still sort of an issue with MySQL but for what it is supposed to do, it is perfect in that. MySQL is not really for big/large databases anyway. **What problems is MySQL 5.6 solving and how is that benefiting you?** MySQL 5.6 had the COMMIT functionality which I was hoping since upgrading from the lower versions and then it did improved on the security aspect so there's that too. ### 8. MySQL 5.6 has enhanced Performance Schema which is useful for our MySQL server monitoring executions **Rating:** 4.0/5.0 stars **Reviewed by:** Rithika G. | Cloud Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** March 31, 2022 **What do you like best about MySQL 5.6?** MySQL 5.6 is excellent when it comes to delivering multithreaded database servers with dual license policies (GNU & Commercial licenses) for our production systems. It includes various security improvements for storing authentication passwords which can be created from its config editor utility. It also includes password expiration columns which are useful in preventing subsequent server connection requests once it is set as Y. No additional configuration is required once we connect our client software with pipe connections for granting access control privileges to our users. **What do you dislike about MySQL 5.6?** Previously we had issues with its audit log due to compatibility problems with our Oracle audit vault. The file format obtained from the audit log was recently updated which effectively solved our compatibility issues. Now we are able to filter our audit events through its built-in plugin for our multi-user accounts & reporting its event status. **What problems is MySQL 5.6 solving and how is that benefiting you?** MySQL 5.6 provides our enterprise with brilliant firewall reliability from the application level standpoint so that we can have control over the permission or denial of SQL executions by our users. It offers a distinct selection of partition tables with a partition lock feature to enhance the performance of our DDL & DML executions. We are able to define custom performance schema based on our business use cases which are pivotal in monitoring all server events & updating our tables with Dynamic SQL statements. We install MySQL 5.6 in our Amazon EC2 instances since it's superb for managing all event collections and synchronizing requests. ### 9. MySQL review **Rating:** 5.0/5.0 stars **Reviewed by:** Muhammad N. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 13, 2021 **What do you like best about MySQL 5.6?** MySQL is easy to use and very popular database. This is free of cost. Server for MySQL is good. PHP MyAdmin Using Apache server(xampp), I used on localhost **What do you dislike about MySQL 5.6?** No, there is no faults with MySQL. There is nothing wrong with MySQL. Its work properly. **What problems is MySQL 5.6 solving and how is that benefiting you?** MySQL helped me to solved many SQL queries and it's advantage is that we can simply use it on localhost. MySQL workbench is my favorite. ### 10. Best for query optimization, High Transactional throughput in InnoDB engine **Rating:** 4.0/5.0 stars **Reviewed by:** Md. Siddikur R. | Database Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** January 14, 2022 **What do you like best about MySQL 5.6?** Fast performance and Improvement of InnoDB Engine. I appreciate the NoSQL interface via Memcached. I use MySQL workbench. I think its fast performance, scaleability will create a unique position in the competitive market. **What do you dislike about MySQL 5.6?** I was so upset when I saw the InnoDB flush method was not supported in Windows in this version. **What problems is MySQL 5.6 solving and how is that benefiting you?** I did not see such a thing. ### 11. Review about mysql **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Wholesale | Small-Business (50 or fewer emp.) **Reviewed Date:** December 15, 2021 **What do you like best about MySQL 5.6?** Can create word'user' table and can check if the param is null in query **What do you dislike about MySQL 5.6?** The only one thing I dislike is alias error occur in delete query and sometime (()) ‌‌are not working in subquery **What problems is MySQL 5.6 solving and how is that benefiting you?** I have used in my business for 4years . There is nothing special problem. But in version change , a little bit problem occur. ### 12. Classic, functional Database Tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Mid-Market (51-1000 emp.) **Reviewed Date:** December 16, 2021 **What do you like best about MySQL 5.6?** MySql 5.6 is a classic, easy-to-use database tool. Allows users to manage, organize, and manipulate data easily. **What do you dislike about MySQL 5.6?** This is an outdated version, there are now newer versions that can be utilized. **What problems is MySQL 5.6 solving and how is that benefiting you?** We are using this tool as a relational database for various projects. Storing, modifying, and organizing data that is populated by a UI. ## MySQL 5.6 Discussions - [What is MySQL 5.6 used for?](https://www.g2.com/discussions/what-is-mysql-5-6-used-for) - [View MySQL 5.6 pricing details and edition comparison](https://www.g2.com/products/mysql-5-6/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-22+23%3A31%3A30+-0500&secure%5Bsession_id%5D=e25873be-a6ce-4133-bc54-65ebca454c1f&secure%5Btoken%5D=b5ae92c531a5ea6f0b12953e681c5f9bbb3b8e11b1d34d62079fc5e3de848fc6&format=llm_user) ## MySQL 5.6 Features **Agentic AI - AWS Marketplace** - Autonomous Task Execution - Multi-step Planning - Cross-system Integration