据ldquo;Java之父rdquo; James Gosling透露,Sun公司将不会为MySQL数据库引入一种新的API(应用编程接口),而是很有可能对M
据“Java之父” James Gosling透露,Sun公司将不会为MySQL数据库引入一种新的API(应用编程接口),而是很有可能对MySQL做更多的调整工作。
在悉尼的Sun公司的科技日上,Gosling说现在很多工具都是使用JDBC来连接数据库,使用API让SQL语句得以执行,这些使用方式很常用,因此,Sun将不会为MySQL开发一种特殊的API。
他还说:“许多人喜欢MySQL,但是他们同样喜欢数据库具备通用性……如果哪一天,你所在的IT部门突然说,‘No,你必须使用Oracle数据库’,那时你该如何是好呢?”。
因此,Gosling说Sun将会为MySQL的JDBC驱动做更多的调整,同样对MySQL做一些改变,能够让它运行在不同的体系结构中。Sun将会集中精力调整的一种体系结构就是Niagara 2 处理器(Niagara 2处理器维持八个核心,但每个核心可跑八条线程)。
Gosling称数据库如果跑在这些共享内存多处理器的机子上,会有令人吃惊的性能。
Sun对Mysql究竟会做哪些改进工作,业界一直猜疑不断。因为Mysql数据库相比很多商业数据库,还缺乏很多开发者和数据库管理员喜欢的功能。看来Sun首先希望做的就是,让MySQL能够更好地跑在自己的服务器和架构上,使得Mysql能够更好地跻身核心和关键应用。
资料:
MySQL,出自瑞典小公司MySQL公司的开源的数据库软件,,目前对数据库老牌厂商Oracle, IBM, Microsoft 以及 Sybase等公司产生威胁。
2004年7月,MySQL公司在成立8年后首次召开全球用户大会。该公司的合作创办者之一大卫?米科斯(David Axmark)称,目前MySQL软件的官方日下载数量已经达到29000份,而其全球总用户数量已经达到了惊人的400万,该公司直到现在,全职兼职人员的总和不过65人。
目前MySQL实行的是双重的用户许可证制度。对于那些下载免费版本的用户,必需将自己所进行的任何代码修改公布于众;或者通过付费的方式来使得这些更改成为私有产权。公司的利润来源也很清晰:产品技术服务,认证课程以及付费用户。
MySQL产品尚有一些不稳定等因素,但是,因为其开放性,被人形容是总值高达120亿美元的数据库市场上的“通配符”,它几乎可以运用在任何需要数据库的地方。
MySQL公司目前在同时开发两个版本的软件,4.1版以及5.0版。4.1版本的代码已经发布并有望在8个月后公布最终代码。而5.0版本的最后产品将在6个月后发布。
MySQL4.1版本中增加了不少新的性能,包括对主键的更高速度的缓存,对子查询的更好的支持,以及应网络约会网站所要求的,基于地理信息的查询。
而其同步开发的5.0版本则把目标对准了企业用户,对于4.1版本中的所有新特性,5.0版本悉数收入囊中,并且独具以下特点:对外键的良好支持;系统自动报错机制以及对存储过程的充分支持。
MySQL是一整套低成本的,基于SQL的客户/服务器(C/S)模式的关系数据库管理系统。它是一个开放源代码项目,可以在绝大多数的情况下免费使用,这使得它在开源社区中被广泛的使用。
之所以说可以在绝大多数情况下免费使用,MySQL可以说是一个半商业的数据库。 MySQL是可运行在大多数的Linux平台(i386,Sparc,etc),以及少许非Linux甚至非Unix平台。
1、许可费用phpma
MySQL的普及很大程度上源于它的宽松,除了略显不寻常的许可费用。MySQL的价格随平台和安装方式变化。MySQL的Windows版本(NT和9X)在任何情况下都不免费,而任何Unix变种(包括Linux)的MySQL如果由用户自己或系统管理员而不是第三方安装则是免费的,第三方案庄则必须付许可费。
2、价格phpma
平台 安装方式 价格
Windows NT,9X 任何 200美元
Unix或Linux 自行安装 免费
Unix或Linux 第三方安装 200美元
需要一个应用组件 200美元
可以得到多种支持合同,内容太多不再罗列,最新报价可咨询MySQL站点。
3、安装phpma
可以在MySQL站点上获得大多数主要的软件包格式(RPM、DBE、TGZ),客户端库和各种语言“包装”(Wrapper)可以分开的RPM格式获得。RPM格式的安装没有多*烦,并且无需初始配置。在rc3.d(以RedHat RPM为例)生成一个初始脚本,故MySQL守护进程在多用户模式下重启时被启动运行。MySQL的守护进程(mysqld)消耗很少的内存(在运行RedHat 5.1的奔腾133上,每个守护进程使用500K内存和另外4M共享内存的开销)并在只有在执行真正的查询时才装载到处理器上,这意味着对小型数据库来说,MySQL可以相当轻松地使用而不会对其他系统功能有太大的影响。

The steps for upgrading MySQL database include: 1. Backup the database, 2. Stop the current MySQL service, 3. Install the new version of MySQL, 4. Start the new version of MySQL service, 5. Recover the database. Compatibility issues are required during the upgrade process, and advanced tools such as PerconaToolkit can be used for testing and optimization.

MySQL backup policies include logical backup, physical backup, incremental backup, replication-based backup, and cloud backup. 1. Logical backup uses mysqldump to export database structure and data, which is suitable for small databases and version migrations. 2. Physical backups are fast and comprehensive by copying data files, but require database consistency. 3. Incremental backup uses binary logging to record changes, which is suitable for large databases. 4. Replication-based backup reduces the impact on the production system by backing up from the server. 5. Cloud backups such as AmazonRDS provide automation solutions, but costs and control need to be considered. When selecting a policy, database size, downtime tolerance, recovery time, and recovery point goals should be considered.

MySQLclusteringenhancesdatabaserobustnessandscalabilitybydistributingdataacrossmultiplenodes.ItusestheNDBenginefordatareplicationandfaulttolerance,ensuringhighavailability.Setupinvolvesconfiguringmanagement,data,andSQLnodes,withcarefulmonitoringandpe

Optimizing database schema design in MySQL can improve performance through the following steps: 1. Index optimization: Create indexes on common query columns, balancing the overhead of query and inserting updates. 2. Table structure optimization: Reduce data redundancy through normalization or anti-normalization and improve access efficiency. 3. Data type selection: Use appropriate data types, such as INT instead of VARCHAR, to reduce storage space. 4. Partitioning and sub-table: For large data volumes, use partitioning and sub-table to disperse data to improve query and maintenance efficiency.

TooptimizeMySQLperformance,followthesesteps:1)Implementproperindexingtospeedupqueries,2)UseEXPLAINtoanalyzeandoptimizequeryperformance,3)Adjustserverconfigurationsettingslikeinnodb_buffer_pool_sizeandmax_connections,4)Usepartitioningforlargetablestoi

MySQL functions can be used for data processing and calculation. 1. Basic usage includes string processing, date calculation and mathematical operations. 2. Advanced usage involves combining multiple functions to implement complex operations. 3. Performance optimization requires avoiding the use of functions in the WHERE clause and using GROUPBY and temporary tables.

Efficient methods for batch inserting data in MySQL include: 1. Using INSERTINTO...VALUES syntax, 2. Using LOADDATAINFILE command, 3. Using transaction processing, 4. Adjust batch size, 5. Disable indexing, 6. Using INSERTIGNORE or INSERT...ONDUPLICATEKEYUPDATE, these methods can significantly improve database operation efficiency.

In MySQL, add fields using ALTERTABLEtable_nameADDCOLUMNnew_columnVARCHAR(255)AFTERexisting_column, delete fields using ALTERTABLEtable_nameDROPCOLUMNcolumn_to_drop. When adding fields, you need to specify a location to optimize query performance and data structure; before deleting fields, you need to confirm that the operation is irreversible; modifying table structure using online DDL, backup data, test environment, and low-load time periods is performance optimization and best practice.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

Notepad++7.3.1
Easy-to-use and free code editor

DVWA
Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software
