Showing entries 25591 to 25600 of 44958
« 10 Newer Entries | 10 Older Entries »
MySQL Workbench 5.2 – Code Statistics

A community member recently noted, that it takes quite a long time to compile MySQL Workbench. So he started wondering about how big the project actually is and asked for the Lines Of Code we have in our MySQL Workbench 5.2 repository.

We did not have this information at hand and therefore Alfredo ran some scripts during the weekend and generated this nice breakdown.

As you can see, we almost have 700k lines of code to maintain. Given that the MySQL Server itself has about 900k lines of code this is a pretty decent number I think, especially for a small team of 7.

Oracle-Sun: Statements and observations

I’ve been trying to dig a bit deeper into the European Commission’s investigation of Oracle’s proposed acquisition of Sun Microsystems, to look beyond the received wisdom about the EC’s concerns about the deal.

We know they revolve around the open source MySQL database, the European Commission has said that much. But the Statement of Objections weighs in at 155 pages, and even those that have read it admit to being confused by it. Meanwhile some of the most vocal parties in the public debate have vested interests in encouraging opinions for or against the deal.

Without knowing precisely what the European Commission wants to achieve it is impossible to come to any conclusions about the investigation. However, here are a few statements and observations:

[Read more]
Commercialization of PHP Software

I’ve just published an article that explains how a PHP-based product can gain a good position in the market and be made appealing to customers by using marketing communication. The focus is on products licensed under an Open Source license. Yet, most of the recommendations also apply to proprietary offerings.

The article has initially been published in German by PHPmagazin. It has now been translated to English and is available on the Initmarketing website: Commercialization of PHP Software.

ZFS on SAN - multiple slices from the same raid group?

I have never had much to do with Solaris, until recently. I have heard a lot about ZFS, and it's many advantages, but when I read about the upcoming deduplication in ZFS, I had to try it out. I talked to some people here more familiar with ZFS than me, but the indication from them was that they were getting away from ZFS. High I/O rates were bringing it to it's knees. We are using an EMC SAN here, and while reading about ZFS it occurred to me that what may be happening is that no one planned out the raid groups so that each slice of the SAN came from separate raid groups. I decided to test this out.

I did not have a spare system to run OpenSolaris on, and I needed a system with more SATA ports so I could have more hard disk drives. Here is what I came up with:

Gigabyte MA790FXT-UD5P Motherboard
AMD Phenom II 955 Quad Core 3.2GHz
4 x Mushkin Silverline PC3-10666 9-9-9-24 1333 2GB Ram
Gigabyte …

[Read more]
MONyog 3.6 introduces real-time query monitoring and sniping, better server management, improved alerting and major new features

Hi,

We are pleased to announce MONyog 3.6 – a major new release. Listed below are the major features included in this release.

Real-time query monitoring and sniping

MONyog provides a whole bunch of tools for finding problem SQL (Slow Query Log, SHOW PROCESSLIST snapshots, MySQL Proxy, etc). These tools are great if you want to find problem SQL in an application and tune those queries. However, using these tools to find problem is almost always a post-mortem exercise. In certain situations you may want real-time notifications for long running queries. MONyog 3.6 gives you exactly that. MONyog can continuosly monitor queries in real-time and send notifications (on Mail or SNMP) for queries that take more than a specified amount of time to execute. You can also specify an option to kill such queries.

Better server management

Several of MONyog’s customers monitor …

[Read more]
Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 11.2 (LAMP)

Installing Apache2 With PHP5 And MySQL Support On OpenSUSE 11.2 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an OpenSUSE 11.2 server with PHP5 support (mod_php) and MySQL support.

Poor man's schema comparison



Comparing database schemas is one of those DBA tasks that occur all the time.
If you can afford the luxury of having a GUI, then MySQL Workbench is the tool for you. It will help you compare structures and eventually synchronizing the differences.
If the only thing at your disposal is a command line interface, without the possibility of installing anything (a common occurrence when you are consulting), then this Poor man's schema comparison tool may come handy.


It's a Perl script that doesn't require module installations beyond the most common ones, and produces a simple …

[Read more]
InfiniDB test scripts updated to include UNION tests

With the release of the InfiniDB 0.9.5.1 that includes UNION functionality, the test scripts have been updated to include UNION tests as well.  You may download these new 0.9.5.1 test scripts here.

InfiniDB test scripts updated to include UNION tests

With the release of the InfiniDB 0.9.5.1 that includes UNION functionality, the test scripts have been updated to include UNION tests as well.  You may download these new 0.9.5.1 test scripts here.

Codebits 2009, coders conference and competition in Lisbon

Codebits is approaching. Form December 3rd to 5th, this gathering of 600 developers for a conference, which is also and foremost a competition, will occupy the mind of the best coders in Europe.
I will be a speaker, with two sessions:

[Read more]
Showing entries 25591 to 25600 of 44958
« 10 Newer Entries | 10 Older Entries »