Home Database Mysql Tutorial MySQL 5.4预览版发布 性能提高90%

MySQL 5.4预览版发布 性能提高90%

Jun 07, 2016 pm 04:09 PM
mysql release performance improve Preview

【51CTO编译】自4月20日甲骨文将收购Sun的消息传出之后,很多开发者和业内人士都对Java,开源以及MySQL的前景议论纷纷。MySQL一年前被Sun收购,做为甲骨文招牌数据库产品的主要竞争对手之一,很多人担心MySQL将会遭到排挤并消失(欲了解更多详情,请光顾专题

【51CTO编译】自4月20日甲骨文将收购Sun的消息传出之后,很多开发者和业内人士都对Java,开源以及MySQL的前景议论纷纷。MySQL一年前被Sun收购,做为甲骨文招牌数据库产品的主要竞争对手之一,很多人担心MySQL将会遭到排挤并消失(欲了解更多详情,请光顾专题:Oracle收购Sun)。不过这些并不影响最近的MySQL Conference & Expo上MySQL发布的MySQL更新。

周二,Sun的开源数据库部门发布了更加快速的更新MySQL的计划。

首先是MySQL 5.4的发布(官方下载地址)。根据声明,这个版本在某些指令运行上比MySQL 5.1提高了高达90%的效率。

这个更加快速的MySQL数据库来自收购MySQL一年多,又随即将被甲骨文收购的Sun。

MySQL的首席执行官对于甲骨文对待MySQL的态度充满乐观。他认为甲骨文会认识到MySQL的价值,并支持其加速更新发布的计划。

MySQL和软件基础设施部门的副总裁Karen Tegan Padir这样说到:“MySQL无处不在,所以它自身的影响力不会被谁收购它所影响。我们看待甲骨文收购Sun和看待Sun收购MySQL并无不同。甲骨文将会是一个好的接管人,因为他们必须这样做。只要他们不打算把MySQL排挤扼杀掉,MySQL将会持续加速发展。”

MySQL 5.4

MySQL部门产品经理Robin Schumacher解释说,MySQL的目标在于每三个月到半年就有一个新的里程碑。第一个就是MySQL 5.4。这次的发布算是一个预览版,今年晚些时候会发布完整版本。

MySQL 5.4的主要提升在于其性能。数据库中增添了不少创意的更新,其中最值得关注的就是MySQL优化器的改进。这个优化器是个规定数据库实现查询期间路径的工具。Schumacher表示MySQL优化器在subquery优化方面,如嵌套查询等查询上的效率提升了90%。

MySQL 6及之后

MySQL在过去几年间一直在谈论关于MySQL的开发。Shumacher表示,按照现在的计划,6.0版将在2010年推出。6.0版的重要功能之一将是Falcon引擎。这是MySQL在2006年公布的引擎,是InnoDB引擎的一个替代选项。

另外,Drizzle项目也是MySQL发展中十分重要的一部分。Padir对这个项目有着很高的评价。


Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to use MySQL backup and restore in PHP? How to use MySQL backup and restore in PHP? Jun 03, 2024 pm 12:19 PM

Backing up and restoring a MySQL database in PHP can be achieved by following these steps: Back up the database: Use the mysqldump command to dump the database into a SQL file. Restore database: Use the mysql command to restore the database from SQL files.

How to optimize MySQL query performance in PHP? How to optimize MySQL query performance in PHP? Jun 03, 2024 pm 08:11 PM

MySQL query performance can be optimized by building indexes that reduce lookup time from linear complexity to logarithmic complexity. Use PreparedStatements to prevent SQL injection and improve query performance. Limit query results and reduce the amount of data processed by the server. Optimize join queries, including using appropriate join types, creating indexes, and considering using subqueries. Analyze queries to identify bottlenecks; use caching to reduce database load; optimize PHP code to minimize overhead.

How to create a MySQL table using PHP? How to create a MySQL table using PHP? Jun 04, 2024 pm 01:57 PM

Creating a MySQL table using PHP requires the following steps: Connect to the database. Create the database if it does not exist. Select a database. Create table. Execute the query. Close the connection.

Performance comparison of different Java frameworks Performance comparison of different Java frameworks Jun 05, 2024 pm 07:14 PM

Performance comparison of different Java frameworks: REST API request processing: Vert.x is the best, with a request rate of 2 times SpringBoot and 3 times Dropwizard. Database query: SpringBoot's HibernateORM is better than Vert.x and Dropwizard's ORM. Caching operations: Vert.x's Hazelcast client is superior to SpringBoot and Dropwizard's caching mechanisms. Suitable framework: Choose according to application requirements. Vert.x is suitable for high-performance web services, SpringBoot is suitable for data-intensive applications, and Dropwizard is suitable for microservice architecture.

How to fix mysql_native_password not loaded errors on MySQL 8.4 How to fix mysql_native_password not loaded errors on MySQL 8.4 Dec 09, 2024 am 11:42 AM

One of the major changes introduced in MySQL 8.4 (the latest LTS release as of 2024) is that the "MySQL Native Password" plugin is no longer enabled by default. Further, MySQL 9.0 removes this plugin completely. This change affects PHP and other app

How to optimize the performance of multi-threaded programs in C++? How to optimize the performance of multi-threaded programs in C++? Jun 05, 2024 pm 02:04 PM

Effective techniques for optimizing C++ multi-threaded performance include limiting the number of threads to avoid resource contention. Use lightweight mutex locks to reduce contention. Optimize the scope of the lock and minimize the waiting time. Use lock-free data structures to improve concurrency. Avoid busy waiting and notify threads of resource availability through events.

Performance comparison of Java frameworks Performance comparison of Java frameworks Jun 04, 2024 pm 03:56 PM

According to benchmarks, for small, high-performance applications, Quarkus (fast startup, low memory) or Micronaut (TechEmpower excellent) are ideal choices. SpringBoot is suitable for large, full-stack applications, but has slightly slower startup times and memory usage.

How to set up MySQL connection pool using PHP? How to set up MySQL connection pool using PHP? Jun 04, 2024 pm 03:28 PM

Setting up a MySQL connection pool using PHP can improve performance and scalability. The steps include: 1. Install the MySQLi extension; 2. Create a connection pool class; 3. Set the connection pool configuration; 4. Create a connection pool instance; 5. Obtain and release connections. With connection pooling, applications can avoid creating a new database connection for each request, thereby improving performance.

See all articles