Sometimes it needs to exactly mimic Oracle's ROWNUM where is no possibility to initiate a counter in previous statement by SET @rownum:=0;.
It is still possible in a single SQL.

SELECT @rownum:=@rownum+1 rownum, t.*
FROM (SELECT @rownum:=0) r, mytable t;

check process mongrel_0 with pidfile <SOME-DIR>/shared/log/mongrel.4000.pid
    start program = "mongrel_rake.sh start_0"
    stop program  = "mongrel_rake.sh stop_0"

    if totalmem is greater than 100.0 MB for 5 cycles then restart       # eating up memory?
    if cpu is greater than 50% for 2 cycles then alert                  # s an email to admin
    if cpu is greater than 80% for 3 cycles then restart                # hung process?
    if loadavg(5min) greater than 10 for 8 cycles then restart          # bad, bad, bad
    if 3 restarts within 5 cycles then timeout                         # something is wrong, call the sys-admin

    if failed port 4000 protocol http                   # check for response
        with timeout 10 seconds
        then restart
    group mongrel

set daemon 60
set logfile monit.log
set pidfile monit.pid 
set statefile monit.state

set httpd port 9999
    use address localhost
    allow username:password

Mongrel이 말을 듣지 않으면 Kill -9

Posted by deepblue 22 days ago

mongrel_rails  stop  [options]

mongrel_rails -f -w 5

 def stop(i)
  pid = "#{APP_HOME}/shared/log/mongrel.400#{i}.pid"
  system "mongrel_rails stop -P #{pid} -c #{APP_HOME}/current"

  if File.exists?(pid)
    system "mongrel_rails stop -P #{pid} -c #{APP_HOME}/current -w 5 -f"
    system "rm #{pid}"
  end
end 

Modal Windows

Creating a popup window is reasonably easy if you just want another browser window of a specified size and you don't care if your visitors swap back and forward between the various browser windows. Where it becomes difficult (if not impossible) is where you want the new window to stay in front of the original window and not allow your visitor to interact with the original window until the new window has closed. We call a window that insists on retaining the focus like this a modal window.

The difficulty is that Javascript does not have a standard way of creating a modal popup window the way it has a standard way to create an ordinary (modeless) window by using window.open().

A number of browsers (for example Netscape 4 or any version of Opera up to and including version 9) do not allow you to make a popup window modal at all. There is simply no command that you can use that will make a window modal in those browsers.

There are two groups of browsers that do allow you to create modal windows and each uses a different method to do so.

Internet Explorer adds an entirely new method to the window object to open a modal window - window.showModalDialog(). If you use that to try to open a modal window then if your visitor is running Internet Explorer then a modal window will be opened. If they are running some other browser then all they will get is a Javascript error.

The Mozilla based browsers (Netscape 6+, Firefox, etc) use a completely different method to declare that the window that is opened should stay in front . They use the normal window.open and just add an extra attribute modal=yes to the list of atributes that define the appearance of the window (unfortunately it still doesn't actually make it modal it just forces it to stay in front which is the best that you can do with these browsers). If you try to use this to try to open a modal window then the window will open in any browser (provided that it hasn't been blocked by a popup blocker) but it will only stay in front if the browser is one of the Mozilla based family. If your visitor is running Netscape 4, any version of Opera, or Internet Explorer etc. then the window will still open it just wont stay in front.

The best that we can do to set up a window that is as modal as we can make it is to combine these two together to create code that will open a modal window in Internet Explorer, keep the window in front in Mozilla based browsers, and which will just open a non-modal window in those browsers that don't support modal windows. Of course we don't want to test which browser that the browser itself claims to be since most Opera browsers are set to report that they are Internet Explorer. Instead we test for support for the showModalDialog method itself to identify those versions of Internet Explorer that support it. Combining the code together gives us the following (with the amendments from an ordinary non-modal window shown in bold).

function modalWin() {
if (window.showModalDialog) {
window.showModalDialog("xpopupex.htm","name",
"dialogWidth:255px;dialogHeight:250px");
} else {
window.open('xpopupex.htm','name',
'height=255,width=250,toolbar=no,directories=no,status=no,
menubar=no,scrollbars=no,resizable=no ,modal=yes');
}
}

All that remains is to set up the code to call our modal window function (and of course to allow those without Javascript to have the window open in a separate non-modal browser window as well.

If you want to see what effect that using all of the above code has in your particular browser then click here and if your browser supports modal windows then that is what will open and you will have to select the close link to close that window before being able to return to this page. If your browser doesn't support modal windows then the window will still open but it will not be modal.

라디오에서 오래간만에 들었는데 다시 듣고 시퍼서리...여기에 남김..

그리고 밑에는 가사...

==========================================================

눈의 꽃 가사...

어느새 길어진 그림자를 따라서
땅거미진 어둠속을 그대와 걷고 있네요.

손을 마주 잡고 그 언제까지라도
함께 있는것만으로 눈물이 나는 걸요.

바람이 차가워지는만큼 겨울은 가까워 오네요
조금씩 이 거리 그 위로 그대를 보내야 했던
계절이 오네요.

지금 올해의 첫눈꽃을 바라보며
함께 있는 이 순간을 내 모든걸 당신께 주고 싶어
이런 가슴에 그댈 안아요.

약하기만한 내가 아니에요 이렇게 그댈 사랑하는데
그저 내맘이 이럴뿐인거죠.

-간주중-

그대곁이라면 또 어떤일이라도
할 수 있을 것만 같아 그런 기분이 드네요.

오늘이 지나고 또 언제까지라도
우리 사랑 영원하길 기도하고 있어요.

바람이 나의 창을 흔들고 어두운 밤마저 깨우면
그대 아픈 기억 마저도 내가 다 지워줄께요.
환한 그 미소로

끝없이 내리는 새하얀 눈꽃들로
우리 걷던 이 거리가 어느새 변한것도 모르는체
환한 빛으로 물들어 가요.

누군갈 위해 난 살아 갔나요.
무엇이든 다 해주고 싶은
이런게 사랑인줄 배웠어요.

혹시 그대 있는곳 어딘지 알았다면
겨울밤 별이 되 그대를 비췄을텐데.

웃던 날도 눈물에 젖었던 슬픈 밤에도
언제나 그 언제나 곁에 있을께요.

지금 올해의 첫눈꽃을 바라보며
함께 있는 이 순간을 내 모든걸 당신께 주고 싶어
이런 가슴에 그댈 안아요.

울지말아요 나를 바라봐요.
그저 그대의 곁에서 함께이고 싶은 맘 뿐이라고
다신 그댈 놓지 않을까요.

끝없이 내리며 우릴 감싸요
거리 가득한 눈꽃 속에서
그대와 내 가슴에 조금씩 작은 추억을 그리네요.
영원히 내 곁에 그대 있어요.

MySQL: Get total number of rows when using LIMIT August 11, 2006

Every now and then you need to limit the number of rows MySQL returns, i.e. use the LIMIT clause. Result set pagination is by far the most often usage of LIMIT clause, since you usually want to select only rows you’ll be displaying on certain page.

The problem is that for pagination you also need total number of rows in a result set, so you know how many pages you’ll have. This usually means that you need to execute query two times. First query is for counting total number of rows without LIMIT. Second query is exactly the same as the first, just without LIMIT and it will actually retrieve required data. You would need two queries like these:

SELECT COUNT(*) FROM users WHERE name LIKE 'a%';

SELECT name, email FROM users WHERE name LIKE 'a%' LIMIT 10;

Now, this is not such a big problem when you have small result sets and/or simple queries. But if you have a complex query that joins several tables and takes a while to execute - well, you probably wouldn’t want to execute it twice and waste server resources.

Luckily since MySQL 4.0.0 you can use SQL_CALC_FOUND_ROWS option in your query which will tell MySQL to count total number of rows disregarding LIMIT clause. You still need to execute a second query in order to retrieve row count, but it’s a simple query and not as complex as your query which retrieved the data.

Usage is pretty simple. In you main query you need to add SQL_CALC_FOUND_ROWS option just after SELECT and in second query you need to use FOUND_ROWS() function to get total number of rows. Queries would look like this:

SELECT SQL_CALC_FOUND_ROWS name, email FROM users WHERE name LIKE 'a%' LIMIT 10;

SELECT FOUND_ROWS();

The only limitation is that you must call second query immediately after the first one because SQL_CALC_FOUND_ROWS does not save number of rows anywhere.

Although this solution also requires two queries it’s much more faster, as you execute the main query only once.

You can read more about SQL_CALC_FOUND_ROWS and FOUND_ROWS() in MySQL docs.