Several pain points regarding MySQL on Ubuntu come to mind. First, its handling of large JSON documents was sometimes cumbersome. We stored structured financial data and occasionally had to denormalize or use workarounds for complex nested JSON queries. Native JSON indexing and better query performance on JSON fields would have helped us avoid some of those compromises. Second, the lack of native full-text search optimization meant we had to layer additional tools on top for searching financial document metadata and account descriptions efficiently. Third, horizontal scaling presented challenges, as MySQL's sharding is not as seamless as some newer databases. As our financial document volume grew, we had to be deliberate about partitioning strategies rather than it scaling automatically. Those are not deal-breakers, but addressing them would make MySQL even stronger for data-heavy AI workflows. Another consideration pertains to concurrency handling during peak processing windows. When we had multiple n8n workflows running simultaneously and all writing to MySQL, we occasionally encountered lock contention issues. Better built-in handling of high concurrency writes would have resolved that without requiring us to manually tune connection pooling and timeout settings. Additionally, the operational overhead on Ubuntu itself presented challenges. Monitoring and tuning MySQL performance require substantial DevOps knowledge. A more self-tuning approach to index optimization and query execution would reduce that burden, particularly for teams that focus more on application logic than database administration. These represented realistic friction points we managed, but nothing that made us want to abandon MySQL.
I have not noticed any specific improvements in my projects since starting with MySQL on Ubuntu, as I am using it at a beginner level, so I don't know what improvements are needed. However, I find that MySQL on Ubuntu provides an overall stable and flexible platform for learning and developing databases for applications. I appreciate that it has helped me learn some basic Linux commands, as at a beginner level, I don't know much about Linux, and Ubuntu is a Linux operating system that is reliable across all systems.
Performance improvements and security enhancements could be implemented for MySQL on Ubuntu. From a feature perspective, service management capabilities could be improved. While MySQL on Ubuntu runs as a managed service with auto-start on boot and auto-restart on failure capabilities, performance could be better, particularly in memory and thread handling on Linux. InnoDB buffer pool optimization should be enhanced. Automatic crash recovery should be considered an improvement, and write-ahead logging is another feature that could be advanced.
Erp Specialist at a tech vendor with 10,001+ employees
Real User
Top 10
Jan 11, 2026
I believe there could be improvements for MySQL on Ubuntu, particularly with AI integration in scripting tools such as GitHub Copilot, which provides examples and solutions for errors encountered during development. Overall, I would give MySQL on Ubuntu a nine out of ten because, despite some issues such as security concerns when changing passwords which compromised the database, it remains a very good database engine.
Chief Data Strategy and Governance Architect at a tech services company with 51-200 employees
Real User
Top 20
Dec 19, 2025
Integration is always important regarding operating systems and these types of products, so being able to integrate and export or import from JSON structures is very critical. Sometimes that is a little complicated because of the sometimes hierarchical nature of JSON or XML data formats, which do not always match to how you can structure MySQL on Ubuntu as a third normal form. There are those sorts of things that sometimes get inexperienced people; it does not seem to make sense. For denormalization, if you are trying to analyze it only, there is probably a shortcut that I have seen in some tools that once you define the third normal form type of data, it kind of automatically comes up with a way of analyzing it, turning it into an automated pivot table without you having to design the pivot table. Those things would be good to get the analysis. Some of the analysis that I had to code from scratch in Python were really simple binomial algorithmic comparisons. Some of that could turn into AI functions. Instead of coding it directly, I could use normal language saying I want to analyze this data based on whether this company has good financial viability to extend a million dollars of credit for buying fuel around the world or whatever the parameter is. That is what I can see coming in the future, that somebody that does not know how to code or does not really want to spend the time coding could actually ask in natural language AI to come up with that. To some extent, I have done that more recently with ChatGPT anyway to come up with a piece of code that at the moment does not work perfectly, but it is still Python and gives me the basic framework to then make it work elegantly.
I have not seen too much of a response in terms of issues. Sometimes, if the indexing is not done very well, I have noticed slowness, but largely, it has performed pretty well. The only area where I would say I have seen potential for improvement is occasional slowness, but I cannot really attribute it to the product; it could also be the design of the database and the queries. I have not encountered any other significant challenges. The slowness that occurs at times has not yet been established whether it is due to the design of the database, the queries, or the underlying software itself. I cannot comment on that right now.
Developer at a financial services firm with 11-50 employees
Real User
Top 10
Apr 17, 2025
More robust databases would enhance MySQL on Ubuntu. While fast, MySQL on Ubuntu may not handle complex applications as efficiently as alternatives, necessitating more robust database capabilities.
MySQL on Ubuntu offers a reliable, scalable, and high-performance database management environment. Known for its efficient installation and robust community support, it boosts application performance while securely handling data and reducing costs due to its open-source nature.MySQL on Ubuntu provides a powerful solution for database management needs, offering high availability and improved data management processes. It supports web and backend applications through strong security and...
Several pain points regarding MySQL on Ubuntu come to mind. First, its handling of large JSON documents was sometimes cumbersome. We stored structured financial data and occasionally had to denormalize or use workarounds for complex nested JSON queries. Native JSON indexing and better query performance on JSON fields would have helped us avoid some of those compromises. Second, the lack of native full-text search optimization meant we had to layer additional tools on top for searching financial document metadata and account descriptions efficiently. Third, horizontal scaling presented challenges, as MySQL's sharding is not as seamless as some newer databases. As our financial document volume grew, we had to be deliberate about partitioning strategies rather than it scaling automatically. Those are not deal-breakers, but addressing them would make MySQL even stronger for data-heavy AI workflows. Another consideration pertains to concurrency handling during peak processing windows. When we had multiple n8n workflows running simultaneously and all writing to MySQL, we occasionally encountered lock contention issues. Better built-in handling of high concurrency writes would have resolved that without requiring us to manually tune connection pooling and timeout settings. Additionally, the operational overhead on Ubuntu itself presented challenges. Monitoring and tuning MySQL performance require substantial DevOps knowledge. A more self-tuning approach to index optimization and query execution would reduce that burden, particularly for teams that focus more on application logic than database administration. These represented realistic friction points we managed, but nothing that made us want to abandon MySQL.
I have not noticed any specific improvements in my projects since starting with MySQL on Ubuntu, as I am using it at a beginner level, so I don't know what improvements are needed. However, I find that MySQL on Ubuntu provides an overall stable and flexible platform for learning and developing databases for applications. I appreciate that it has helped me learn some basic Linux commands, as at a beginner level, I don't know much about Linux, and Ubuntu is a Linux operating system that is reliable across all systems.
Performance improvements and security enhancements could be implemented for MySQL on Ubuntu. From a feature perspective, service management capabilities could be improved. While MySQL on Ubuntu runs as a managed service with auto-start on boot and auto-restart on failure capabilities, performance could be better, particularly in memory and thread handling on Linux. InnoDB buffer pool optimization should be enhanced. Automatic crash recovery should be considered an improvement, and write-ahead logging is another feature that could be advanced.
I believe there could be improvements for MySQL on Ubuntu, particularly with AI integration in scripting tools such as GitHub Copilot, which provides examples and solutions for errors encountered during development. Overall, I would give MySQL on Ubuntu a nine out of ten because, despite some issues such as security concerns when changing passwords which compromised the database, it remains a very good database engine.
Integration is always important regarding operating systems and these types of products, so being able to integrate and export or import from JSON structures is very critical. Sometimes that is a little complicated because of the sometimes hierarchical nature of JSON or XML data formats, which do not always match to how you can structure MySQL on Ubuntu as a third normal form. There are those sorts of things that sometimes get inexperienced people; it does not seem to make sense. For denormalization, if you are trying to analyze it only, there is probably a shortcut that I have seen in some tools that once you define the third normal form type of data, it kind of automatically comes up with a way of analyzing it, turning it into an automated pivot table without you having to design the pivot table. Those things would be good to get the analysis. Some of the analysis that I had to code from scratch in Python were really simple binomial algorithmic comparisons. Some of that could turn into AI functions. Instead of coding it directly, I could use normal language saying I want to analyze this data based on whether this company has good financial viability to extend a million dollars of credit for buying fuel around the world or whatever the parameter is. That is what I can see coming in the future, that somebody that does not know how to code or does not really want to spend the time coding could actually ask in natural language AI to come up with that. To some extent, I have done that more recently with ChatGPT anyway to come up with a piece of code that at the moment does not work perfectly, but it is still Python and gives me the basic framework to then make it work elegantly.
I have not seen too much of a response in terms of issues. Sometimes, if the indexing is not done very well, I have noticed slowness, but largely, it has performed pretty well. The only area where I would say I have seen potential for improvement is occasional slowness, but I cannot really attribute it to the product; it could also be the design of the database and the queries. I have not encountered any other significant challenges. The slowness that occurs at times has not yet been established whether it is due to the design of the database, the queries, or the underlying software itself. I cannot comment on that right now.
More robust databases would enhance MySQL on Ubuntu. While fast, MySQL on Ubuntu may not handle complex applications as efficiently as alternatives, necessitating more robust database capabilities.