I know that this is well documented in many places on the web, but one of the comments that I saw to an earlier blog post was around installing MySQL via OpenSolaris.  David Comay provided some answers in the comments, which I thought that I would reiterate here.  This works for OpenSolaris 2008.05.

With a one line command, you can install MySQL:

pfexec pkg install SUNWmysql5

If you are looking for the entire AMP stack, you can install Apache, MySQL, and PHP using the command:

pfexec pkg install amp

And, if you are looking for the entire AMP stack with developer tools, use the following command:

pfexec pkg install amp-dev

Note that pfexec will allows you to run a privileged command as a non-root user provided that you have the authorization to do so.


The software that is installed with the commands above is placed in …

My colleague, Tom Daly, just submitted results for SPECj that showcases a compelling price / performance story with Glassfish, MySQL 5.0, and OpenSolaris on commodity Sun Intel hardware.  See the full details here.

Recently, a bug that caused excessive memory usage and slowness (specially in large models) in Workbench has been fixed in its canvas. From the testing I’ve done, the speed for displaying diagrams seems to scale much better and dragging around tables in large models is doable in an acceptable speed. This fix is in the upcoming releases of the 5.0 and 5.1 alpha versions of Workbench.

Apart from that, we’ve been doing some work on reintroducing OpenGL support to the Workbench canvas. Unlike the initial implementation, this time OpenGL is used directly instead of going through Cairo’s experimental (and not quite reliable) support through the Glitz layer. This means that in machines with a recent graphics card, hardware acceleration will be used and working with large diagrams will be a lot smoother and faster. Of course, software rendering backends (GDI+, Quartz and Xlib) will still be supported and used in case OpenGL is not the best …

Dear Italian MySQLlers,

join us for two new webinars on High Availability and Scalability and on the upcoming MySQL Enterprise Fall Release. All details here: http://www-it.mysql.com/news-and-events/web-seminars/

In the first one on November the 13th we will explore various MySQL high availability technologies and architectures. We will explore the uses cases for when to implement MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD) and other high-availability technologies.

Join us on December the 9th to see how the MySQL Query Analyzer, a new feature to the MySQL Enterprise Monitor, helps keep your key MySQL systems up and running at the highest levels of scalability and performance by helping you analyze your most expensive application and user queries by total executions, total run time, total data …

Dear Italian MySQLlers,

join us for two new webinars on High Availability and Scalability and on the upcoming MySQL Enterprise Fall Release. All details here: http://www-it.mysql.com/news-and-events/web-seminars/

In the first one on November the 13th we will explore various MySQL high availability technologies and architectures. We will explore the uses cases for when to implement MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD) and other high-availability technologies.

Join us on December the 9th to see how the MySQL Query Analyzer, a new feature to the MySQL Enterprise Monitor, helps keep your key MySQL systems up and running at the highest levels of scalability and performance by helping you analyze your most expensive application and user queries by total executions, total run time, total data …

Everyone does backups. Usually it’s some nightly batch job that just dumps all MySQL tables into a text file or ordinarily copies the binary files from the data directory to a safe location. Obviously both ways involve much more complex operations than it would seem by my last sentence, but it is not important right now. Either way the data is out and ready to save someone’s life (or job at least). Unfortunately taking backup does not come free of any cost. On the contrary, it’s more like doing very heavy queries against each table in the database when mysqldump is used or reading a lot of data when copying physical files, so the price may actually be rather high. And the more effectively the server resources are utilized, the more that becomes a problem.

What happens when you try to get all the data?

The most obvious answer is that it needs to be read, through I/O requests, from a storage that it resides on. The storage is …

Starting with version 5.1.28, there is a new table INFORMATION_SCHEMA.PROFILING and a new statement SHOW PROFILE(S). Basic information is in the reference manual and in an introductory article. But I don’t think that’s adequate for everyone. I’ll try here to give some non-basic information. I’ll assume that you read the manual, think of this as a supplement.

A bit of a caveat: I was totally against adding this feature, and some of my bias might show. But I’m not trying to argue about it. I do believe that once we add a feature we should explain it, and all I’m trying to do is explain here.

How it works

The data-gathering code, or “instrumentation”, goes approximately like this:
statement_begin:
…

Sun Microsystems always seems to be forced to defend itself, whether it is the company’s ongoing strategy amid dimmed revenue and earnings or its participation in open source. As one who recently considered the fate of a somewhat weakened Sun, I’d also like to highlight a recent series of promising technologies and efforts — dominated by open source — from the venerable technology giant.

Despite continued doubts, Sun continues to focus its strategy on open source software, which is finding its way into the company’s Solaris OS, storage technology with ZFS file system and MySQL database and elsewhere. The company recently launched a new Web site where it is figuratively letting its open source ponytail down and more succinctly staking out its place and …

As part of the MySQL on Sun hardware launch, Allan Packer put together 3 short technical videos on MySQL. 

• Introduction to MySQL Architecture and Typical Deployments (approximately 8 minutes)
  

This video give an introduction to MySQL architecture including storage engines, a release status update, and typical deployment scenarios, which includes horizontal scaling via replication and shards.  It also gives some advice on how to deploy MySQL on Sun systems today.

• Tuning and Monitoring MySQL (approximately 10 minutes)

This video highlights how to tune MySQL for optimal performance and includes details on which binaries are the right …

So I was bored earlier and decided to add a headline section to RelationalNews.com - the news site I’ve been working on for relational database management news feeds. It updates automatically based on the number of times an article has been clicked, very simple statistics tracking, and it gets the job done. Also, I increased the number of front page articles to 50.  Enjoy: http://relationalnews.com