New Page 1

MySQL is one of the world's most popular open source databases, and it is widely used and becoming the database-of-choice for many leading Web 2.0 sites. Like most database servers, the most common bottleneck in the enterprise environment encountered by MySQL is disk I/O. To maximize the performance of MySQL for disk I/O bound workloads on the Solaris operating system on CMT servers (e.g. the Sun Fire T2000 Server), configuration and tuning of MySQL server variables is critical and can make a big difference to performance,  as does the optimization of the Solaris filesystem for MySQL, and the configuration of storage arrays.

Configuration Issues

MySQL server's performance can be optimized using various configuration settings. The first step is to read the configuration and system variables by running the command:

mysql> show variables;

…

New Page 1

MySQL is one of the world's most popular open source databases, and it is widely used and becoming the database-of-choice for many leading Web 2.0 sites. Like most database servers, the most common bottleneck in the enterprise environment encountered by MySQL is disk I/O. To maximize the performance of MySQL for disk I/O bound workloads on the Solaris operating system on CMT servers (e.g. the Sun Fire T2000 Server), configuration and tuning of MySQL server variables is critical and can make a big difference to performance,  as does the optimization of the Solaris filesystem for MySQL, and the configuration of storage arrays.

Configuration Issues

MySQL server's performance can be optimized using various configuration settings. The first step is to read the configuration and system variables by running the command:

mysql> show variables;

…

New Page 1

MySQL is one of the world's most popular open source databases, and it is widely used and becoming the database-of-choice for many leading Web 2.0 sites. Like most database servers, the most common bottleneck in the enterprise environment encountered by MySQL is disk I/O. To maximize the performance of MySQL for disk I/O bound workloads on the Solaris operating system on CMT servers (e.g. the Sun Fire T2000 Server), configuration and tuning of MySQL server variables is critical and can make a big difference to performance,  as does the optimization of the Solaris filesystem for MySQL, and the configuration of storage arrays.

Configuration Issues

MySQL server's performance can be optimized using various configuration settings. The first step is to read the configuration and system variables by running the command:

mysql> show variables;

…

Well, it’s better late than never! Frank Wiles has published the 65th edition of Log Buffer the weekly review of database blogs, on the Revolution Systems Blog. For the record Frank published it right on time on Friday - it’s just us that’s late. Sorry about that. Log Buffer #65.

MySQL AB today announced that NET-A-PORTER.COM, the world's premier luxury online fashion retailer, has standardised on MySQL Enterprise to support its continued growth, scalability and quality requirements.

Net-a-Porter will be showcasing their MySQL based architecture at MySQL's upcoming Northern Europe Customer Conference in London on 16th Oct at the Cavendish Conference Centre. Further information can be found at http://www.mysql.com/news-and-events/events/emea-conference-2007/.

I read a lot about MySQL backups using LVM Snapshots on Linux, WAFL Snapshots on NetApp and more recently ZFS Snapshots. But did you know you can do the same under FreeBSD?

FreeBSD has had snapshot capability since around 2001 allowing administrators to take a frozen image of a filesystem at a given instant in time with minimal impact on the server / filesystem. So how does …

Steve Ballmer apparently likes open source. Well, so long as it drives Windows revenue. And doesn't replace any. Ever. In fact, as he said at an event in Microsoft last week in London that he hopes to see all open-source innovation going to Windows, rather than Linux (more below).

His Q&A session is fascinating (you can watch it here), if for no other reason than to watch him slap around a strawman open-source competitor. I hardly recognized the open-source strawman he constructed, but he delighted in swatting its anti-commercial tendencies. I guess he has neglected to consider Red Hat, MySQL, SugarCRM, etc. etc. etc.

Among many others, Ballmer stated one absolutely dubious thing: "Our battle is not business model to business model, but rather product to product." If this were true (and if he actually believed it, …

after eight releases, we have gone from over 150 open bugs to under 70 bugs.

one of the really old bugs we are still looking at is how identifiers that are reserved words (or have non-alphanumeric characters) are handled from ado. as far as we can tell, the driver is doing everything correctly, and it is ado that is failing to properly quote the identifiers, but we have gotten some developers at microsoft involved in tracking the problem from that end.

just today there was a new bug filed about using the driver with visual basic 6, which was itself released in 1998. i am going to have to build a vm image with that installed so i can do some testing.

the next release of the new 5.1 branch should be out later this week. we will probably …