One of the most common sources of trouble for the beginning VB / MySQL developer seems to revolve around which cursor location to use. Related to the cursor location problem is the choice of cursor type and lock type. The purpose of this article is to assist the Visual Basic developer in choosing the proper cursor location, cursor type, and lock type to use when programming Visual Basic (or VB) applications that use MySQL as a back-end database through ADO and Connector/ODBC (MyODBC).(2004-01-22)

Mike Hillyer explains why he thinks Visual Basic and MySQL are an ideal combination for application development, and the motivation for his continuing series of articles on the subject.(2004-01-22)

The MySQL 5.1 offers new GLOBAL_STATUS information schema tables. These can be used to report certain performance metrics, such as the number of queries processed per certain seconds, NOT overall avg queries per second, Its good to know how much qps in peak hours.

MySQL replication is often positioned as a solution to provide extra throughput for your database (especially when dealing with high numbers of read operations). What tends to be overlooked is how it can be used to provide high availability (HA) – no matter how much redundancy you have at a local level, your system remains at risk from a single catastrophic failure – loss of power, earthquake, terrorist attack etc. By using MySQL asynchronous replication to maintain a geographically remote copy of that data, service can be maintained through any single site failure.

How to copy InnoDB table to different database.

inotify is a handy standard Linux kernel tool to track file access/writes under a live server.

Mysqlconf 2009 talk about Kickfire

How to simulate loads on MySQL servers using Proxy and MockLoad

We all love graphs. We all love SQL hacks. We all know the SQL hack which displays a character-based graph (example follows for those unfamiliar). But we all love horizontal graphs, not vertical ones. We are used to the X axis being horizontal, Y being vertical. Not vice versa. In this post I’ll present a SQL hack which rotates a vertical graph to horizontal. In fact, the technique shown will rotate any ‘textual image’; but graphs are a nice example.

Very insightful article about how MySQL Cluster achieves fault tolerance and high availability.

Presentation given at OSCON 2009 on Scaling a web application (mostly PHP/MySQL) and gives a framework for creating scaling profiles and capacity/scenario profiling for your web site. An overview of Application and Database scaling steps and considerations.

In one of the servers we have an issue that happens to one of the servers that some items that have the status of "freeing items" and "Sending data" are just stuck there, causing a lot of locks on the server, and the load of the server drops to almost 0. The server then wouldn't restart, and the only solution is to kill the mysqld process, and fix the crashed tables that result from the kill.

I’ve been working on various different MySQL related issues and maintenance procedures some of which have not gone according to plan. Here is a recipe that may help you avoid wasting a lot of time, especially if your database is large.

Lua script for Workbench to add relationships based on column names

A quick introduction into MapReduce.

There is a cool option for mysqlbinlog for disabling the binary log when doing recovery using binary logs, namely --disable-log-bin. There are various ways for doing this.

Keeping good database backups is crucial because unpredictable disastrous events always occurs. In web-based business – backup is a critical component. There exist different open-source scripts, that could help to organize the database backup process in a customized and easy way, avoiding use of mysqldump (default MySQL backup tool). This article describes various open-source scripts that can help a newbie sysadmin to organize MySQL backup process.

The MySQL server is not really in the phone. It's accessed through a ssh connection. But it is cool to see nonetheless.

The Librarian goes mobile!

The title says it all, and the explanation is very interesting. The consequences of disabling binlog due to lack of storage are catastrophic. Entertaining and worrying at the same time.