Hi all,

Today I'd like to continue a blog series in which I highlight Web application tutorials for NetBeans 6.5. A few changes have been made to tutorials, among which is the featuring of MySQL as the database of choice.

This third entry in the series will cover the tutorial, "Developing a Visual Web JSF Application".

In this tutorial, you use the NetBeans IDE and JSF 1.2 (Woodstock) components to create and run a simple web application, Hello Web. The example application asks you to input a name and then displays a message that uses that name. At first, you implement this page with an input field. Then you replace the input field with a drop-down list from which the user can choose a name. The drop-down list is populated with names from a database table.

MySQL is the database used in this version of the …

Many people know me as a nginx web server evangelist. But as (IMHO) any professional I think that it is really rewarding to know as much as possible about all the tools available on the market so every time you need to make a decision on some technical issue, you’d consider all pros and cons based on my own knowledge.

This is why when I received an email from Packt company asking if I’d like to read and review their book on Lighttpd I decided to give it a shot (I usually do not review any books because I do not always have enough time to read a book thoroughly to be able to write a review). So, here are my impressions from this book.

First, when I received the book, I was in doubt: how such a small book could cover so flexible and multi-purpose piece of software like …

Preparing for the Open Source Developers' Conference in Sydney next week. Of course I'm curious how it'll develop further this year, since I was the lead organiser last year... in any case it should be a great event, with an interesting bunch of people gathering, and a good program.

Somehow I got cajoled into doing three talks:
- Architecting for Success - Just in Case (30m)
- Optimisation by Design (30m)
- Scaling your Business: Approach Defines Outcome (2h)
The first one is not MySQL specific, and the last one is about business and development strategy.

Open Query's PHP expert trainer Sebastian Bergmann has been scheduled in parallel with my last session - pity, I would've liked to listen to that one.
…

Notes of one week with MySQL community in US and France

Background

I wanted to attend the first edition of the Open SQL Camp in Charlottesville, from November 14 to 16. For some mysterious reason, a four days plane ticket to any place in the US costs EUR 2,500, but if I stay 8 days, it costs EUR 800. Considering that I was in Frankfurt until November 8, the most sensible thing to do was flying to the US as early as possible and meet as many communities as I could. Among the ones I asked, Boston and New York answered enthusiastically, and then, serendipitously, I found an unexpected group in Baltimore, just before the last leg to Charlottesville.
I sent all groups a list of ten topics to choose from:
* MySQL 5.1 features
* Using MySQL partitions in practice
* testing with MySQL Sandbox
* MySQL Community How To
* Recent community additions to MySQL code
* Creative cross-language …

There are all sorts of different interfaces to memcached, but you don't need any of them to make requests from the command line, because its protocol is so simple. Try this, assuming it's running on the usual port on the local machine:

PLAIN TEXT CODE:

1. echo stats | nc 127.0.0.1 11211
2. STAT pid 22020
3. STAT uptime 3689364
4. STAT time 1227753109
5. STAT version 1.2.5
6. STAT pointer_size 64
7. STAT rusage_user 4543.071348
8. STAT rusage_system 8568.293421
9. STAT curr_items 139897
10. STAT total_items 51710845
11. STAT bytes 360147055
12. STAT curr_connections 40
13. STAT total_connections 66762
14. STAT connection_structures 327
15. STAT cmd_get 319992973
16. STAT cmd_set …

This works when you have access to the connected machine -- I've done this on Redhat/CentOs, but don't know about other linux distros.

• In the mysql processlist, you'll see the host/port connected:

192.168.10.100:60786

• Connect to the machine shown and run:
  

> socklist | grep 60786
tcp   60786   51371094       0  17518   27  httpd

> find /proc/ -lname "*51371094*" -ls

• this will give you the pid of the process that has the socket open to mysql by searching the file descriptor symlinks for the inode that coresponds to the socket on that port.

Happy Thanksgiving and little holiday challenge for you.
Say you have a trigger on the slave which you would like to work differently, depending on whenever update is executed via replication thread vs updating table locally ? This can be helpful for example for auditing updates which were done directly instead of coming from the master and some other cases.
Suggest how you would do it by commenting

Entry posted by peter | 12 comments

Add to: | …

If you were to measure MySQL’s “loadavg,” how would you do it?

The following metric (in pseudocode) is borrowed from Trevor Price at Aggregate Knowledge. It’s a way to calculate average query response time. What do you think of it?

$start = microtime(); $status1 = SHOW GLOBAL STATUS LIKE Questions; for ( 1 .. 100 ) { [...]