Want to know why MySQL?
October 24, 2018
Want to know why MySQL?
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with MySQL
MySQL was used by the IT department at the place I worked before. We used it mainly to add, access or manage any data in our student database. I worked at a center where students would come in and take their tests online. Whenever there were any issues with a student's test, it was always easy for us to use MySQL to retrieve his data from the database and resolve the issue.
Pros
- Quick processing. MySQL always ensure optimum speeds, and unique memory caches for enhanced performance.
- Reliability. It has features like consistent, isolated, durable transaction support. It also guarantees instant deadlock identification.
- Flexibility of use. It makes maintenance, debugging and updates fast and easy while also enhancing user experience.
Cons
- Does not really support larger databases as efficiently as smaller ones. When the data grows, only the simple and indexed query gets good performance, however, a complex query gets comparatively slow, even sometimes unable to fulfill the request.
- A few stability issues. There have been some cases when MySQL works perfectly fine for 1-2 weeks and then it just suddenly crashes.
- Poor performance scaling. SQL does not support auto sharding, so you may need to maintain your nodes manually.
- High scalability
- Lowers TCO
- Offers exceptional security
Cuts down seperate charges for additional databases as in Microsoft SQL Server. It is an open source software compared to other database management systems.
Comments
Please log in to join the conversation