No more typing reviews! Try our Samantha, our new voice AI agent.

Faiss vs MySQL comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 23, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Faiss
Ranking in Open Source Databases
12th
Average Rating
8.0
Reviews Sentiment
3.3
Number of Reviews
3
Ranking in other categories
Vector Databases (13th)
MySQL
Ranking in Open Source Databases
1st
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
152
Ranking in other categories
Relational Databases Tools (4th)
 

Mindshare comparison

As of June 2026, in the Open Source Databases category, the mindshare of Faiss is 3.3%, down from 3.9% compared to the previous year. The mindshare of MySQL is 11.4%, up from 10.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Open Source Databases Mindshare Distribution
ProductMindshare (%)
MySQL11.4%
Faiss3.3%
Other85.3%
Open Source Databases
 

Featured Reviews

Kalindu Sekarage - PeerSpot reviewer
Senior Software Engineer
Integration improves accuracy and supports token-level embedding
The best features FAISS offers for my team include seamless integration with Colbert and the ability to use FAISS via the Ragatouille framework, which is tailor-made for using the Colbert model. Feature-wise, FAISS allows for more accurate result retrieval, and retrieval speed is also good when comparing the index size. Regarding features, I also emphasize that the usability of FAISS is very seamless, particularly its integration with Colbert and Ragatouille. FAISS has positively impacted my organization by helping us increase the accuracy of retrieval documents; when we store documents in token-level embedding, the accuracy will be high. Additionally, we do not need any external server to host FAISS, allowing us to integrate it with our backend framework, making it a very flexible framework.
Varuns Ug - PeerSpot reviewer
Senior Software Developer at NIT
Reliable transactions have supported secure payments, refunds, and bookings at high volumes
Regarding MySQL improvements, a pain point is horizontal scalability. MySQL scales very well vertically and can support read replicas, but as a system grows significantly, sharding and distributed data management can become complex compared to databases that are designed to scale horizontally from the beginning. This is one of the areas where I think MySQL should work more. Another area is handling very large analytic workloads. MySQL is excellent for transactional systems, but for large-scale analytics or reporting, specialized analytic databases may sometimes be a better fit. Apart from that, one area is performance troubleshooting. As the database grows, diagnosing things such as slow queries, lock contention, and deadlocks becomes complex.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The product has better performance and stability compared to one of its competitors."
"I used Faiss as a basic database."
"My use of MySQL has primarily been from a data integration point of view, a data architecture point of view, and reviewing the database itself, and the data structure, data types."
"MySQL is an open-source product and has good community support. If you encounter any problem, you can easily ask other members of the community to help. They help you a lot. On top of being free, MySQL is a cross-platform database, meaning it can work on both Windows and Linux. It is very good for us."
"It is a stable solution."
"MySQL is a scalable tool. Scalability-wise, I rate the solution a nine out of ten...The solution's technical support is good. I rate the technical support a nine out of ten."
"It has been perfectly stable for us."
"For anyone who wants to learn SQL, MySQL is free on Linux, Windows, or Mac Operating Systems."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"Mysql is free : it's an open source project, so you can use it with no cost."
 

Cons

"It could be more accessible for handling larger data sets."
"It would be beneficial if I could set a parameter and see different query mechanisms being run."
"One of the drawbacks of Faiss is that it works only in-memory. If it could provide separate persistent storage without relying on in-memory, it would reduce the overhead."
"The backup methods need improvement."
"It is a community driven project, which means that support is sometimes scarce and hard to find."
"I'd like to see Oracle provide more certification for it."
"When working with a cluster wide, I have to use the MySQL cluster version."
"I think that the stored procedures and the development tools to write and debug large queries could be improved."
"We switched to a different solution because of data access issues, speed, and consistency."
"Documentation is definitely required when running multiple databases on a cluster system."
"In MySQL, we need to define every table beforehand."
 

Pricing and Cost Advice

"Faiss is an open-source solution."
"It is an open-source tool."
"I use a free version at present."
"For the on-premise version, no license is required."
"We are using the free community edition of MySQL."
"I use the open-source free community version."
"There is not a license required for this solution."
"There is a license needed for this solution."
"We've never bought a commercial license. We just use the open-source community edition."
"I don't pay for a license."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
900,644 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
15%
Manufacturing Company
9%
Comms Service Provider
9%
Computer Software Company
9%
Financial Services Firm
10%
Manufacturing Company
9%
Construction Company
8%
Comms Service Provider
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business74
Midsize Enterprise34
Large Enterprise63
 

Questions from the Community

What is your experience regarding pricing and costs for Faiss?
I did not purchase FAISS through the AWS Marketplace because FAISS is an open-source product. My experience with pricing, setup cost, and licensing is straightforward, as there is no cost for acqui...
What needs improvement with Faiss?
I currently do not think there is anything to be improved based on our experience, as Faiss performs as we expected for our workflow. I would like to see improvement in the fact that FAISS currentl...
What is your primary use case for Faiss?
My main use case for FAISS is in a retrieval-augmented generation project using it with OpenAI, where we use FAISS to store our embeddings created by the Colbert model and for retrieval as well. In...
Why are MySQL connections encrypted and what is the biggest benefit of this?
MySQL encrypts connections to protect your data and the biggest benefit from this is that nobody can corrupt it. If you move information over a network without encryption, you are endangering it, m...
Considering that there is a free version of MySQL, would you invest in one of the paid editions?
I may be considered a MySQL veteran since I have been using it since before Oracle bought it and created paid versions. So back in my day, it was all free, it was open-source and the best among sim...
What is one thing you would improve with MySQL?
One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when it was free, everyone was on their own, seeking tutorials and how-to videos onli...
 

Comparisons

 

Overview

 

Sample Customers

1. Facebook 2. Airbnb 3. Pinterest 4. Twitter 5. Microsoft 6. Uber 7. LinkedIn 8. Netflix 9. Spotify 10. Adobe 11. eBay 12. Dropbox 13. Yelp 14. Salesforce 15. IBM 16. Intel 17. Nvidia 18. Qualcomm 19. Samsung 20. Sony 21. Tencent 22. Alibaba 23. Baidu 24. JD.com 25. Rakuten 26. Zillow 27. Booking.com 28. Expedia 29. TripAdvisor 30. Rakuten 31. Rakuten Viber 32. Rakuten Ichiba
Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Find out what your peers are saying about Faiss vs. MySQL and other solutions. Updated: June 2026.
900,644 professionals have used our research since 2012.