Close
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Artificial Intelligence
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • Database

    Preview of MySQL Ready for Download

    By
    Lisa Vaas
    -
    December 29, 2003
    Share
    Facebook
    Twitter
    Linkedin

      eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More.

      MySQL AB last week released an alpha preview of the latest version of its flagship open-source database, MySQL 5.0.

      The company will announce pricing and release dates when MySQL 5.0 is formally announced in early January, a spokeswoman said. MySQLs site lists potential new features, including stored procedures based on the SQL-99 framework, which is similar to Oracle PL/SQL. According to documentation on the site, the SQL-99 framework accommodates external languages and provides compatibility with PL/SQL and T-SQL, for example.

      Other planned features include elementary cursor support, the ability to specify explicitly that an RTREE index be created for MyISAM tables and dynamic length rows for HEAP tables.

      In a move that promises to enhance standards compliance, improve portability and ease migration, the new release may include true VARCHAR support. This enhancement will support columns longer than 255 characters with no stripping of trailing whitespace.

      If planned enhancements are implemented, MySQL 5.0 should also be speedier than previous releases. One enhancement will affect the SHOW COLUMNS FROM table_name command, which is used by the MySQL client to enable expanded column names. A targeted enhancement for 5.0 is that the command opens only the definition file as opposed to the whole table. In addition, DELETE on MYISAM tables should be able to use record cache. Better in-memory (HEAP) tables will also resize rows dynamically and handle rows faster with less copying.

      Based on the planned enhancements list, MySQL 5.0 will gain better internationalization features as well. When using the SET CHARACTER SET command, the software will translate the whole query instead of translating only strings. Such translated characters can be used in database, table and column names.

      Finally, Version 5.0 is slated to resolve an issue with the RENAME TABLE command. In the current version of the database, using this command in an active MERGE table renders the table vulnerable to corruption.

      Although Version 5.0 is still in alpha, Uppsala, Sweden-based MySQL does recommend the products Standard binaries for most users. MySQL has incorporated the InnoDB storage engine—an open-source transactional storage engine from Innobase Oy Inc., of Helsinki, Finland—into those binaries. A Max version also includes features such as the Berkeley DB storage engine and other features that havent yet undergone thorough testing, including OpenSSL support, user-defined functions and BIG_TABLE support. Future versions of Standard binaries will include those features after they have matured and are stable, according to MySQLs site.

      The MySQL site warns that Debug binaries now include extra debug information that is not intended for general consumption, because the extra code may slow down database instances.

      Editors note: This story was updated to reflect the fact that new features are based on plans detailed on MySQLs site and have not as yet been verified by the company.

      Lisa Vaas
      Lisa Vaas is News Editor/Operations for eWEEK.com and also serves as editor of the Database topic center. Since 1995, she has also been a Webcast news show anchorperson and a reporter covering the IT industry. She has focused on customer relationship management technology, IT salaries and careers, effects of the H1-B visa on the technology workforce, wireless technology, security, and, most recently, databases and the technologies that touch upon them. Her articles have appeared in eWEEK's print edition, on eWEEK.com, and in the startup IT magazine PC Connection. Prior to becoming a journalist, Vaas experienced an array of eye-opening careers, including driving a cab in Boston, photographing cranky babies in shopping malls, selling cameras, typography and computer training. She stopped a hair short of finishing an M.A. in English at the University of Massachusetts in Boston. She earned a B.S. in Communications from Emerson College. She runs two open-mic reading series in Boston and currently keeps bees in her home in Mashpee, Mass.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.
      Get the Free Newsletter!
      Subscribe to Daily Tech Insider for top news, trends & analysis
      This email address is invalid.

      MOST POPULAR ARTICLES

      Latest News

      Zeus Kerravala on Networking: Multicloud, 5G, and...

      James Maguire - December 16, 2022 0
      I spoke with Zeus Kerravala, industry analyst at ZK Research, about the rapid changes in enterprise networking, as tech advances and digital transformation prompt...
      Read more
      Applications

      Datadog President Amit Agarwal on Trends in...

      James Maguire - November 11, 2022 0
      I spoke with Amit Agarwal, President of Datadog, about infrastructure observability, from current trends to key challenges to the future of this rapidly growing...
      Read more
      Cloud

      IGEL CEO Jed Ayres on Edge and...

      James Maguire - June 14, 2022 0
      I spoke with Jed Ayres, CEO of IGEL, about the endpoint sector, and an open source OS for the cloud; we also spoke about...
      Read more
      Applications

      Kyndryl’s Nicolas Sekkaki on Handling AI and...

      James Maguire - November 9, 2022 0
      I spoke with Nicolas Sekkaki, Group Practice Leader for Applications, Data and AI at Kyndryl, about how companies can boost both their AI and...
      Read more
      IT Management

      Intuit’s Nhung Ho on AI for the...

      James Maguire - May 13, 2022 0
      I spoke with Nhung Ho, Vice President of AI at Intuit, about adoption of AI in the small and medium-sized business market, and how...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×