Phoronix: MySQL 8.0 Released With Many Improvements, Faster Performance
It's a busy day in the software and hardware space today as well as a busy week for Oracle with several big releases this week. The latest is the general availability of the long-awaited MySQL 8.0 update...
http://www.phoronix.com/scan.php?pag...L-8.0-Released
Announcement
Collapse
No announcement yet.
MySQL 8.0 Released With Many Improvements, Faster Performance
Collapse
X
-
MySQL 8.0 Released With Many Improvements, Faster Performance
Tags: None
-
Originally posted by andrei_me View PostAbout json on relational database, it is really useful, you got almost the best of both worlds, at least in my use cases on Postgres
-
Originally posted by uid313 View PostFor a while it seemed like not much was happening to MySQL and people were migrating away from MySQL to MariaDB which was the "new" MySQL in the same way that LibreOffice became the new OpenOffice.org. Many people feared MySQL would starve under Oracle as happened to many other products under the management of Oracle but it seems that MySQL is alive and kicking.
How does MySQL compare with MariaDB these days?
Are the code bases pretty close or have they diverged significantly?
Which one is the preferred choice?
Leave a comment:
-
How these perf numbers compare to MariaDB?
About json on relational database, it is really useful, you got almost the best of both worlds, at least in my use cases on Postgres
Leave a comment:
-
Originally posted by randomizer View Post
We're closer to a post-NoSQL world, where most people has finished playing with their toys and gone back to work.
I call it CommentsDB coz it's only good for skript kiddy blog comments sections.
- 1 like
Leave a comment:
-
Originally posted by uid313 View PostIs JSON in relational databases truly useful or just a desperate attempt to stay relevant in a post-SQL / NoSQL world?
- 2 likes
Leave a comment:
-
Originally posted by uid313 View PostJSON is indeed important. But maybe in those cases a real document database such as MongoDB should be used?
- 2 likes
Leave a comment:
-
Originally posted by paulpach View Post
Back in the day, MySQL lacked some basic features such as foreign keys and triggers. PostgreSQL was years ahead in terms of functionality which gave MySQL a bit of a bad reputation.
Nowadays, MySQL has matured and it is a solid RDBMS. It is Ranked #2 according to DB-Engine and it is by far the most popular open source database available. It is used by some big names out there, definitely not a toy.
I've heard so many bad things about it, how it was behaving incorrectly.
I know MySQL is very popular, because it is an integral part of the LAMP stack and powers so many WordPress sites. But just because it is popular does not mean it is good.
Is it reliable, is it well-behaved these days?
Originally posted by bpetty View PostJSON storage is very important. The corporate world is going cloud / micro-services and everyone is working with JSON data. Storing and querying that data makes things so much easier.
I love JSON but is JSON in relational databases just a toy and a desperate attempt to stay relevant or is a real improvement that is really useful?
Originally posted by F.Ultra View PostDon't know if I missed something but I run the queries from the last post by "Pura Vida" on MariaDB (which is MySQL) and saw no deadlocks. Don't say that bugs like these does not exist (every SQL have full bugzillas) but this one I could not reproduce at least not on MariaDB v10.2.14
How does MySQL compare with MariaDB these days?
Are the code bases pretty close or have they diverged significantly?
Which one is the preferred choice?
Leave a comment:
-
Originally posted by bpetty View Post
In terms of being a great database to run a website off of, or for a product with relatively few tables and relationships, I agree. If you are talking about using it for enterprise software, leveraging explicit transactions, then no... it sucks. Case in point: https://bugs.mysql.com/bug.php?id=48652
JSON storage is very important. The corporate world is going cloud / micro-services and everyone is working with JSON data. Storing and querying that data makes things so much easier.
- 1 like
Leave a comment:
-
Is JSON in relational databases truly useful or just a desperate attempt to stay relevant in a post-SQL / NoSQL world?
Leave a comment:
Leave a comment: