Some people are reporting slowness problems with MySQL Workbench 5.0 and after chatting with a few of these persons, I’ve gotten an idea of the causes.Although the sluggishness has generally been blamed to the graphics rendering, there are a couple other issues that affect performance.  If you follow these steps, you might get a more comfortable working experience:

1. Upgrade to the latest version. Workbench 5.0 is still being continually maintained and some performance related bugs are fixed from time to time. There might be other important bugs that are fixed too, so it’s worth upgrading anyway.
2. Limit the number of steps to save in the Undo History. Depending on the operations performed, having infinite undo history can use a lot of memory after a few hours of work.  In Tools -> Options -> General, enter some number around 10 ~ 20 in the option …

Background Knowledge

I have Windows Vista Ultimate with Service Pack 1 with the following optical media drives. The system is approximately one year old.

• Manufacture: LG
• Model: HL-DT-STDVD-ROM_GDRH20N
• Firmware version: 0D04

• Manufacture: LG
• Model: HL-DT-ST DVD+-RW GSA-H73N
• Firmware version: B103

Problem

There are two issues I’m experiencing all resulting in the fact that windows explorer is not refreshing the drive contents and/or drive volume label. Both issues occur on CD/DVD reader and CD/DVD writer drives. As well I’ve tried multiple discs from ones I’ve burnt to discs that were commercial produced and these discs all work fine on other computer systems.

1. My Computer/Windows Explorer is not refreshing the CD/DVD drive contents.
2. My Computer/Windows Explorer is not refreshing the CD/DVD …

One question that comes up relatively commonly in support is how much memory can MySQL use on my system. As you may know, MySQL runs in a single process with many threads. So the memory limit it has is based upon the operating system limits for a single process. Different operating systems have different limits, but the one I want to discuss is Windows 32-bit (such as 2000, XP, 2003, vista).

The short answer is that your mysqld-nt.exe can use up to ~1.8G of RAM. The question is why is that so. Since we have a 32-bit address space, in theory there is 2^32 mapping for the address space (4G). However, Windows uses what is called a 2G/2G split in that addressable space. 2G are allowed for the actual application to use and 2G is for the kernel mappings.

This 2G is then the address space of points, which normally ends up with around 1.8G of memory really being usable. If you try to use more than this, then you end up getting …

Microsoft released Windows 7 Beta 1 - the next major version of Vista, download here. There are tons of improvments mostly centered around making the content easily & intuitively accessible. But hey, Mac OSX already serves that purpose well for quite some time ;-)

But I still want to make sure that our Rails stack (NetBeans, GlassFish, and MySQL) work fine on it. And it very well do, without any issues, as you'll realize at the end of this blog :)

Lets first get started with installing Windows 7 Beta as a Virtual Box image. Few points to note here:

• Only IE can be used for downloading …

Background Knowledge

With the use of Samba we are able to share files through a local network and make it appear as if the files are on the Mac OS X locally. The instructions below will step you through step by step on how to access files from the Mac OS X to a Windows XP/Vista™ system through the network.

NOTE: Instructions to unblock network traffic through a software/hardware firewall are not provided. Refer to your software/network manual or support web site for details.

NOTE: These instructions will not allow for sharing via the Internet.

Solution

Setting up a file share in Windows XP

1. Open Windows Explorer/My Computer (press Windows Key+E) or go to the Windows Start Menu -> Programs -> Accessories -> Windows Explorer.
2. Browse to a folder you wish to share and right mouse click on it and left mouse click on “Properties”. …

One of the first things we had to do here at OlinData is set up a testing environment. Many customers have many different OS environments and we want to be able to accomodate all of them. With the setup described here, we will be able to easily set up many different OS’s, regardless of the [...]

If you ever used svn command line, you know it is not optimal to type in your password every time you do checkout, checkin, info, etc.  In linux world, it is very easy to setup keys to get around this.  Of course in the world of Windows it is not as easy.  Here are the steps you need to follow to get private/public keys working with your SVN under Windows using ssh tunneling.

Assumptions:  you will be connecting as user “root” to svn server located at “10.0.0.1”.  All your files will be saved at c:\ including your svn command line utility

First we will have to generate a key.  We can accomplish this by using a free utility called …

Previously on Log Buffer: Log Buffer #119.

And now.

Welcome to Log Buffer #120. My name is Warner, and I’m a SQL Server DBA at The Pythian Group. This is my first time on Log Buffer duties ever, so here’s hoping I can give everyone a fair and unbiased look at this week in the database blogging world (and related).

I admit I had no idea of the community or state of the PostgreSQL RDBMS, and so I definitely learned some new stuff this week. First off, over on “The Scale-out Blog” Robert Hodges invites us all to get our …

This is a short post that might save someone some valuable time, if Google decides to rank it high enough.

I've tried to install a newer version of the MySQL Connector .NET, namely 5.2.3 instead of the old 5.1.3 I had installed.
When trying to install 5.2.3, I got this error message:


Apparently the connector does not support upgrades from 5.1.x to 5.2.x. We should just remove the old one.

Here lies the problem: when I tried removing the old 5.1.3, I got a weird error of which I took no screenshot. It consisted of a blank error message showing a computer screen with a icon of a moon on it. Something resembling a "sleep mode" icon. Huh?

…

We use valgrind to find memory leaks in MySQL on Linux. The tool is a convenient, and often enlightening way of finding out where the real and potential problems are location.

On Windows, you dont have valgrind, but Microsoft do provide a free native debugging tool, called the user-mode dump heap (UMDH) tool. This performs a similar function to valgrind to determine memory leaks.

Vladislav Vaintroub, who works on the Falcon team and is one of our resident Windows experts provides the following how-to for using UMDH:

1. Download and install debugging tools for Windows from here
   MS Debugging Tools
   Install 64 bit version if you’re on 64 bit Windows and 32 bit version
   otherwise.

2. …