6/26
In the "Write MySQL Queries Using HeidiSQL 4" article, we learned how to connect to a MySQL database and execute queries against it using the free HeidiSQL GUI client. Today, we'll learn how to create a stored procedure using HeidiSQL's Stored Procedure Editor. 6/12
In this article, Sean Hull looks at the first five out of ten dials that you can turn to get an initial MySQL vanilla install working for your specific application requirements.
5/29
HeidiSQL is a free GUI client for MySQL, favored by many Web developers and database administrators of small to medium-sized businesses to manage persistent storage of data. This article will familiarize you with HeidiSQL’s Query editor by using it to write a query that will join four tables together to perform searches against a help library.
5/08
MySQL's unique architecture allows for plugin storage engines. There is the MyISAM storage engine, the ARCHIVE storage engine and the InnoDB storage engine; so it makes sense then that MySQL's clustering solution involves a storage engine as well, namely the NDB (Network DataBase) storage engine.
4/06
Query optimization is an often overlooked part of applications. Sean Hull encourages at least some attention to query optimization up front and helps you identify some of the more common optimizations you may run across.
3/12
MySQL's query cache is an impressive piece of engineering if sometimes misunderstood. Keeping it optimized and used efficiently can make a big difference in the overall throughput of your application, so it's worth taking a look under the hood, understanding it, and then keeping it tuned optimally.
2/12
MySQL Replication can be made quite reliable and robust if the right tools are used to keep it running smoothly--but what if enormous loads on the primary server are overloading the slave server. Are there ways to speed up performance, so the slave can keep up?
1/15
It's no surprise that the concept of a proxy has made its way into the database arena. The MySQL Proxy sits between your application and your MySQL database. Future articles will discuss the myriad of uses for this technology.
12/01
Continuing last months article on "MySQL Replication Pitfalls," Sean Hull discusses what to do to make your replication setup more resilient.
11/24
This week you'll find out how to access the Book-O-Rama database
from the Web using PHP. A sampling of key topics covered
include: how Web database architectures work, choosing a
database to use, querying the database, using other PHP-database
interfaces and more.
11/20
MySQL Enterprise gets new Query Tool -- but it'll cost you if you want it.
11/19
Sun Microsystems, Inc. today announced a major new version of its MySQL Enterprise subscription service to help corporate users dramatically improve the speed and uptime of their MySQL database applications.
11/13
Sean Hull examines some of the issues and problems with MySQL replication, offering examples to show why they are issues.
11/05
Ernest Bonat shows you how to 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.
10/09
With smart tech and business folks realizing the absolute must-have nature of data warehouses and BI support, it’s a great time to check out a MySQL-Infobright solution.
