Skip navigation links

MySQL Server Community Edition

Stay Connected

Resources

New! Take MySQL Virtual Courses from Anywhere

NetBeans IDE 6.1 with Glassfish and MySQL NetBeans IDE 6.1 is a free open-source Integrated Development Environment. It includes tools to create professional desktop, enterprise, and web applications. This installer is bundled with the Glassfish V2 application server and the MySQL Community server.

Developer Articles

Bound and Unbound DataGridView Control for MySQL 5.0/VB.NET 2008 Windows Applications

By Ernest Bonat, Ph.D. | November 5, 2008

Understanding and programming MySQL data load into the DataGridView control is a must for Windows Application Developers today. Many times, in real production environment the end-users need to see a result set of data to make daily business decisions. The main question is about how many records they need to see when the control gets loaded. The answer of the question is defined by the client's business rules. At this point application performance is a critical issue for Application Developers. In this paper I'll show you how load MySQL data into the DataGridView control using VB.NET bound and unbound programming modes. A timer class named Stopwatch for VB.NET will be used to measure the execution time between theses two programming modes.

Using Partitioning to Manage Satellite Networks

By Guy Adams, Chief Technical Officer at Parallel Ltd. | October 17, 2008

Our product historically used an Oracle backend, and after implementing simple date based range partitioning we got a 20-30 time performance increase in our queries. We had used MySQL in other more minor products we had developed, but we couldn’t move to it until partitioning was implemented. In Dec 05 we started to test MySQL partitioning, where partitioning syntax was supported but the optimizations were not in place. As soon as the optimizations were put in, we were able to run a side by side comparison against unpartitioned tables and Oracle partitions. Not only did we get in MySQL a 30+ times performance increase, but the MySQL version ran nearly twice as fast as the same Oracle configuration in a like for like test.

Advanced Bazaar for MySQL developers

By Guilhem Bichot | September 16, 2008

The MySQL project switched from Bitkeeper to another revision control system, Bazaar, in June 2008. My colleague Daniel Fischer wrote an excellent article describing how to get MySQL's code by using Bazaar, and how to compile a MySQL server binary from this. Here I am going to build on this knowledge and take it further, to show you how to modify MySQL's code for your needs, and share your modifications.

Data Warehousing with MySQL and Infobright

By Robin Schumacher | September 15, 2008

Unless you’ve been on a desert island lately, you probably know that the area of data warehousing/analytics/business intelligence (BI) is going gangbusters these days. Not many years ago, when industry analyst groups polled CIO’s on their top priorities, BI was #10. Then it jumped to #2 in 2006, and today it’s #1 according to Gartner group. It’s no mystery as to why this is: it’s a cut-throat economy out there in all industries and smart businesses need to tap their internal data to make critical business decisions, both tactically and strategically, to stay ahead of the pack.

FC Inter Milan Using MySQL 5.1 Partitioning and Event Scheduler

By Corrado Pandiani | September 10, 2008

If you are a football (soccer) fan, then F.C. Internazionale may mean something to you. Or perhaps its more common name, Inter Milan sounds familiar? Next in our Use Case Competition articles, here's Corrado Pandiani's experience, about using MySQL to power inter.it, one of the most popular soccer sites in Europe. Not only that, but inter.it is using the latest MySQL 5.1 technology.

More Developer Articles »