近期,MySQL Conference and Expo会议上SUN曾表示要关闭部分Mysql的源代码,此举立即激起了开源社区的愤怒.随后,SUN前CEO Marten Mickos出面澄清,MySQL永远都是开源软件。 而在2008年4月末,MySQL在北京与SUN公司合并之后的首次中国亮相中,Sun大中华区软件部
近期,MySQL Conference and Expo会议上SUN曾表示要关闭部分Mysql的源代码,此举立即激起了开源社区的愤怒.随后,SUN前CEO Marten Mickos出面澄清,MySQL永远都是开源软件。
而在2008年4月末,MySQL在北京与SUN公司合并之后的首次中国亮相中,Sun大中华区软件部总监赵晓亮再次强调了Sun要继续开源MySQL的决心。在这次的Sun&MySQL全球巡展中国站活动中,MySQL与中国开发者和合作伙伴进行了广泛交流,并对Sun与MySQL产品进行了全面推广与新特性的讲解,包括MySQL架构说明、性能演示、在Solaris之上的表现,以及Sun X64 Powerhouse等内容。
SUN与MySQL的合并,对于全球范围内那些希望部署MySQL的客户和开发商来讲,SUN目前可以提供全栈式的简单且安全的选择,并帮助企业使开源软件更快速的进入市场,使客户通过开源的全线方案,来开创网络经济全新时代。
就MySQL与SUN合并的意义,Sun大中华区软件部总监赵晓亮先生说道:Sun与MySQL的合并,帮助Sun坚定地进入价值150亿美元的数据库市场,强化了Sun在开源软件领域的领导地位,并确立了公司在网络经济中企业平台提供商的领先优势;对企业客户而言,这是有史以来的第一次,全球的企业和机构能统一到一个获得市场支持的标准开源平台上,并满足他们在规模上、质量上和全球服务方面的各种需求,实现自我对IT基础设施的自由掌握;对开源事业而言和互联网而言,迄今为止,尚没有平台供应商针对互联网将完整的开源操作系统所需的全部核心要素整合在一起,尚无任何公司可提供能够替代主流专属操作系统的综合备选方案,通过此次收购,我们将能做到,为全球免费软件社区,为世界各地的合作伙伴与客户创造巨大潜能。
就MySQL网络服务平台的构建,MySQL APAC高级副总裁Larry Stefornic先生说道:MySQL是最受当代开发人员青睐的网络服务构建平台。从Facebook、Google、Sina.com网站到银行和 电信公司,注重性能、效率和创新的架构师们都把目光转向了MySQL。但由于公司规模的原因,MySQL无法得到更多传统CIO的信任,而与Sun的合并 使MySQL能够全面改变这一切,MySQL公司将获得额外的资源和支持,以提高其在全球范围内的销售和支持团队,开放源代码软件的价值将继续增加,是一 个向世界证明开源价值的机会。
过去的几年里,SUN公司一直对NetBeans、OpenOffice.org、OpenSolaris等开发者社区提供有力的支持,在MySQL加入SUN之后,完善了SUN公司的软件产品线,并且为SUN的软件解决方案提供了有力的支撑,在Web 2.0、SaaS、企业IT、电信,以及嵌入式OEM市场方面,成为Sun的重要补充。
全球最流行的开源数据库MySQL目前是SUN公司软件机构的子业务,同时也是创建Web 2.0应用中的开源数据库最佳选择方案之一。随着MySQL企业级性能的完善,MySQL逐步在满足更大规模企业应用的方向上做出新的尝试。目前Sun公司正在着手扩大MySQL使用者与开发者社区,并通过商业服务来吸引企业用户,以加速本行业由专属技术阶段向开放式网络平台阶段转化的进程。
客户对于开源软件价值的进一步认识为开源社区不断注入着新的活力,在会议现场,来自Sun和MySQL的技术专家就加入SUN公司之后的MySQL开源策略表示:SUN公司将坚持开源的策略不会变化,并且在MySQL后续新功能添加之后也维持开放源代码的策略。在合并之后,Sun和MySQL将结合双方的优势,将软件产品线进行拓展和融合,为网络经济时代添加新的动力。
Sun无形之手左右新版MySQL背叛开源?
几个月前著名的开源数据库MySQL被Sun公司以10亿美元的天价拿下,当时就引起了开源业界相关人士的热评,这一收购行为将会对这一开源数据库以及开源业界带来怎样的影响,一时让人感到扑朔迷离。近日随着MySQL新版的发布,Sun的无形之手将如何左右MySQL被收购后的发展方向,再次引起了开源各界对这一交易所带来的影响的分析……
Sun出面澄清:MySQL永远是开源软件
上周MySQL Conference and Expo会议上SUN曾表示要关闭部分Mysql源代码,此举立即激起了开源社区的愤怒.目前,SUN前CEO Marten Mickos出面澄清,MySQL永远都是开源软件.
赵晓亮:MySQL坚持开源始终如一
就在上周,Sun的MySQL分部预告了MySQL 5.1的发布计划。值得注意的是,其中,新版MySQL最引人瞩目的特性是数据库的在线备份。但是,在线备份特性的一部分功能将不会在MySQL社区版本中出现,而只会提供给付费的MySQL企业版。
Sun&MySQL全球巡展中国站正式启动
2008年4月23日,北京,Sun MySQL全球巡展中国站活动在北京展开。这是Sun与MySQL合并之后,在中国的首次全面亮相,与中国客户、员工、社团开发者和合作伙伴广泛进行交流,全面推广Sun与MySQL合并所取得的成功。
Sun坚持开源策略拉拢各Linux发行版
Sun公司正在和多个Linux发行版项目进行接洽,目的是让这些发行版中能加入Sun的开源软件从而保证他的开源软件能够到达更多的开发者的手中。Sun公司目前正在和Debian项目以及OpenSuSe项目打得火热,同时也已经开始了与Ubuntu和Fedora项目关于在发行版中捆绑Sun软件事宜的洽谈。
-
08第3周回顾:Sun成开源梦幻企业 甲骨文结束并购长征
-
Sun开源Java 提升到Web 2.0

MySQL is an open source relational database management system, mainly used to store and retrieve data quickly and reliably. Its working principle includes client requests, query resolution, execution of queries and return results. Examples of usage include creating tables, inserting and querying data, and advanced features such as JOIN operations. Common errors involve SQL syntax, data types, and permissions, and optimization suggestions include the use of indexes, optimized queries, and partitioning of tables.

MySQL is an open source relational database management system suitable for data storage, management, query and security. 1. It supports a variety of operating systems and is widely used in Web applications and other fields. 2. Through the client-server architecture and different storage engines, MySQL processes data efficiently. 3. Basic usage includes creating databases and tables, inserting, querying and updating data. 4. Advanced usage involves complex queries and stored procedures. 5. Common errors can be debugged through the EXPLAIN statement. 6. Performance optimization includes the rational use of indexes and optimized query statements.

MySQL is chosen for its performance, reliability, ease of use, and community support. 1.MySQL provides efficient data storage and retrieval functions, supporting multiple data types and advanced query operations. 2. Adopt client-server architecture and multiple storage engines to support transaction and query optimization. 3. Easy to use, supports a variety of operating systems and programming languages. 4. Have strong community support and provide rich resources and solutions.

InnoDB's lock mechanisms include shared locks, exclusive locks, intention locks, record locks, gap locks and next key locks. 1. Shared lock allows transactions to read data without preventing other transactions from reading. 2. Exclusive lock prevents other transactions from reading and modifying data. 3. Intention lock optimizes lock efficiency. 4. Record lock lock index record. 5. Gap lock locks index recording gap. 6. The next key lock is a combination of record lock and gap lock to ensure data consistency.

The main reasons for poor MySQL query performance include not using indexes, wrong execution plan selection by the query optimizer, unreasonable table design, excessive data volume and lock competition. 1. No index causes slow querying, and adding indexes can significantly improve performance. 2. Use the EXPLAIN command to analyze the query plan and find out the optimizer error. 3. Reconstructing the table structure and optimizing JOIN conditions can improve table design problems. 4. When the data volume is large, partitioning and table division strategies are adopted. 5. In a high concurrency environment, optimizing transactions and locking strategies can reduce lock competition.

In database optimization, indexing strategies should be selected according to query requirements: 1. When the query involves multiple columns and the order of conditions is fixed, use composite indexes; 2. When the query involves multiple columns but the order of conditions is not fixed, use multiple single-column indexes. Composite indexes are suitable for optimizing multi-column queries, while single-column indexes are suitable for single-column queries.

To optimize MySQL slow query, slowquerylog and performance_schema need to be used: 1. Enable slowquerylog and set thresholds to record slow query; 2. Use performance_schema to analyze query execution details, find out performance bottlenecks and optimize.

MySQL and SQL are essential skills for developers. 1.MySQL is an open source relational database management system, and SQL is the standard language used to manage and operate databases. 2.MySQL supports multiple storage engines through efficient data storage and retrieval functions, and SQL completes complex data operations through simple statements. 3. Examples of usage include basic queries and advanced queries, such as filtering and sorting by condition. 4. Common errors include syntax errors and performance issues, which can be optimized by checking SQL statements and using EXPLAIN commands. 5. Performance optimization techniques include using indexes, avoiding full table scanning, optimizing JOIN operations and improving code readability.


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

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

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

SublimeText3 Chinese version
Chinese version, very easy to use

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function