Now for a little bit of a history lesson. We wanted some kind of
“forge” back in 2005, because sourceforge was all the rage then (today, you
can’t even find mariadb or mongodb listed there). We didn’t want to pay the
exorbitant fees associated with sourceforge, so we investigated
…

Just a reminder to all of those users that are enjoying
Kontrollbase – if you get a minute in your day please go to the
MySQL Forge site and put your vote in on Kontrollbase. It’s a
simple star based vote on the right side of the page located
here: http://forge.mysql.com/projects/project.php?id=318

In my old post there is a bug when run in MySQL 5.1.30 and old,
because the status variable Queries was added in MySQL 5.1.31. So
i change to choose between Queries and Questions status
variables, and I think the Queries represent more accurate
result.

http://forge.mysql.com/tools/tool.php?id=217

By the way:

# Queries The number of statements executed by the server. This
variable includes

Do you need to find qps for peak hours not avg qps through mysql
life.

The MySQL 5.1 offers new GLOBAL_STATUS information schema tables.
These can be used to report certain performance metrics, such as
the number of queries processed per certain seconds, NOT overall
avg queries per second, Its good to know how much qps in peak
hours.

Yesterday I had the honour of presenting my
mini-bi/datawarehousing tutorial "Starring Sakila" for MySQL
University. I did a modified version of the presentation I did together with Matt Casters at
the MySQL user's conference 2009. The structure of the
presentation is still largely the same, although I condensed
various bits, and I added practical examples of setting up the
ETL process and creating a Pentaho Analysis View (OLAP pivot
table) on top of a Mondrian Cube.

The slides, session recording, and materials such as SQL script,
pentaho data integration jobs and transformations, and Sakila
Rentals Cube for Mondrian are all available here on MySQL Forge.
Copyright Notice
Presentation slides, and …

One request I occasionally see is for a case insensitive version
of REPLACE() for MySQL. I wrote this a while back, but here it is
now for all of you to play around with. It uses a basic naïve
string search algorithm, so can be slow under some circumstances.

phpMyAdmin and MySQL Forge,
along with the MySQL Build Farm initiative were
the main MySQL related benefactors of Google Summer of Code 2008.
phpMyAdmin got BLOB Streaming support and a
simplified setup script, MySQL Forge got
RSS and Atom feeds and the MySQL Build Farm got
a test schedule.

Directly mentored by phpMyAdmin originator Marc Delisle,
GSoC student Raj Kissu Rajandran completed the
BLOB streaming support in phpMyAdmin. This is
how he describes his project goals (which are now achieved):

It is often common to come across a website, especially a blog,
that is built on a pairing of MySQL and PHP. Seeing as how most
of those who run such websites on the Internet do not have access
to a Shell account or have experience in managing applications
from the command-line, …

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.