Installing Apache2 With PHP5 And MySQL Support On Ubuntu 10.04 (LAMP)

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

Wednesday night of the MySQL track of ODTUG Kaleidoscope will include an evening with Last Comic Standing comedian, John Heffron. It should be great way to unwind after day 3 of the conference. Black vodka anybody.

Check out the MySQL Schedule for more information of presentations for the 4 days. More details is also available here.

Improvements for Flexviews, materialized view for MySQL 5.1+

1. 
   
2. There is up-to-date documentation available as manual.html, a robodoc generated version of the manual for the SQL_API interface. The manual is generated from RoboDOC comments embedded in the source code. This makes it easy to maintain the documentation if the interface changes.
   
3. Flexviews has a new easier to read, and hopefully easier to understand website. You can find a copy of the manual on the web site as well.
   
4. There is a SQL converter on the website than will automatically generate Flexviews SQL_API calls from a SELECT statement. The next step will be to turn this into a MySQL proxy script that …

Glyn Moody has an interesting piece on Why Patents are Like Black Holes where he looks at the situation when a large patent holder goes bankrupt - or is about to. His point is that even if a company otherwise can go out of business cleanly, the patents often remain as a piece of "IPR" that can come back and haunt us like a zombie.

Also Matt Asay recently weighed in on the subject:

read more

my last day with oracle (formerly sun, formerly mysql), today, came a little over eight years after my first.

on to the next thing.

Welcome to Log Buffer, the weekly roundup of database blogs.

Kicking off this week in Log Buffer #191 are posts from Alisher Yuldashev:

Randolf Geist blogs on an Advanced Oracle Troubleshooting Session – PGA/UGA memory fragmentation for when a batch process takes significantly longer than expected.

…

We’re Open Sourcing some command line tools for accessing some modern system calls on Linux.

The project is named linux-ftools and is over on Google Code.

You’ll have to checkout the hg repo locally and build yourself for now.

Specifically fallocate, fadvise, and fincore (and a few other smaller tools).

They need a bit more cleanup , specifically error handling (and maybe a few more features).

I’d like to try to get these into Debian.

These were designed for use with MySQL but you might be able to use them in your setup as well.

…

The MySQL Enterprise Spring 2010 Release includes key improvements designed to help you proactively optimize MySQL performance and identify potential issues before they can become costly outages or slowdowns. In this webinar we will explore the new features of the MySQL Enterprise Monitor 2.2 that are designed to save DBAs and Developers time and effort in keeping MySQL systems running at the highest levels of security, performance and availability. Join us and learn about:

• How the MySQL Connectors can now be used to collect, aggregate and monitor MySQL query performance data
• How to quickly identify which queries are performing full table scans
• How to isolate your worst performing queries based on total execution counts, time, data returned, date/time, query content, query type, and more
• How to identify and drill down into line-level source code for specific query executions
• New …

A useful feature of statistical systems in social networking backend's is the analysis of when members are mostly, or better said, in average online. Imagine, that we have a database table to store DATETIME-timestamps of when users logged in, which could look like this:

Read the rest »

I may or may not be interviewed on the Swedish language Radio Vega. The background to this confusing statement is that the Finnish government today publishes a report on the use of open source in Finnish companies and associated risks related to that. I was a contributor to the report since Monty Program is a Finnish open source company. I guess since I speak Swedish, the reporter had scheduled a telephone interview with me after the press conference.

read more