Shulou(Shulou.com)06/01 Report--

Editor to share with you what are the differences between mysql and oracle, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The differences between mysql and oracle are as follows: mysql is an open source project without charge, but oracle needs to charge for it. Mysql defaults to automatic submission while oracle does not, mysql syntax is more flexible and oracle syntax is strict, and so on.

For many small projects, MySQL database can basically achieve a variety of functional requirements, but with the increase of the amount of data, MySQL will gradually become overwhelmed, and then need to use Oracle database.

The difference between mysql and oracle

(1) Nature of the project

MySQL is an open source project, free of charge, while Oracle is a mature database product that is closed and charged at the same time.

(2) commit of transaction

MySQL defaults to auto-submission, while Oracle defaults to not auto-submission, which requires manual submission by users. You need to write commit instructions or click the commit button.

(3) SQL syntax is different.

MySQL's SQL syntax is more flexible, while Oracle's syntax is more strict.

(4) pagination query

MySQL writes "select... from... where...limit x, y" directly in the SQL statement, and paging can be achieved with limit, while Oracle requires pseudo-column ROWNUM and nested queries.

(5) support for transactions

MySQL supports transactions only in the case of row-level locks of the innodb storage engine, while Oracle fully supports transactions

(6) persistence of data preservation

MySQL will lose data after database update or restart, while Oracle writes the submitted sql operation line to the online log file, which is kept on disk and can be recovered at any time.

(7) differences in threads

MySQL belongs to single-process multithreading, while Oracle belongs to multiple processes (also single-process under Windows). Similar to the difference between Windows and Linux, Windows can only use one user, or you can switch between different users, while Linux is multi-user or the same user can connect to the operating system at the same time.

(8) permissions and security

The user of MySQL is related to the host, and it is easy to be impersonated by the host and ip, while the permissions and security concepts of Oracle are more traditional and formal.

(9) Partition tables and partition indexes

MySQL's partition table is not mature and stable, while Oracle's partition table and partition index functions are very mature, which can improve the user's experience of accessing db.

(10) concurrency

MySQL is mainly table-level locking, and the granularity of resource locking is very large. If a session locks a table for too long, it will prevent other session from updating the data in this table.

Oracle uses row-level locks, locking resources with much smaller granularity, only locking resources needed by sql, and locking on data rows in the database, independent of and index. So Oracle's support for concurrency is much better.

These are all the differences between mysql and oracle. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.