Caught in a Web

Looking at my favorite rss feeds today, I found this post on great MySQL Performance Blog:

…if you press CTRL-C MySQL Command Line Client will not exit but will terminate query being executed.

In other words, in previous versions of MySQL client program, if you issue a query and try to interrupt it by hitting CTRL-C, CTRL-C would actually kill MySQL client itself, but query still continue running in background! In this case the only solution to really kill that query is to find it’s ID on process list (by issuing “show full processlist” query), and then to kill it with a query like “kill 12345″, where 12345 is ID of query that you want to be killed. In other words, something like this:

mysql> select * from odm_result_keywords where keyword like '%foo%joe%';
^CAborted
bash-2.05b$ mysql -A --enable-local-infile -udinke -ppass mydb
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1512 to server version: 4.1.18-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show full processlist;
+------+-------+----------------------------+-------------------+---------+------+--------------+--------------------------------------------------------------------+
| Id   | User  | Host                       | db                | Command | Time | State        | Info                                                               |
+------+-------+----------------------------+-------------------+---------+------+--------------+--------------------------------------------------------------------+
| 1486 | dinke | localhost                  | mydb | Query   |    3 | Sending data | select * from odm_result_keywords where keyword like '%foo%joe.cl' |
+------+-------+----------------------------+-------------------+---------+------+--------------+--------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> kill 1486;
mysql>

Thanks to changes in MySQL client program, all you have to do now is to hit CTRL-C, and query will be stopped immediately:

mysql> select domain from odm_result_keywords_de where whois_status is null and domain like '%.%.%';
Query aborted by Ctrl+C
ERROR 1317 (70100): Query execution was interrupted
mysql>

For more information about this feature (as well as other changes in MySQL 5.0.25) please follow this link.

Comments(0)

New release of PHP 5.2.0 is available for download.

Along with plenty of bugfixes, new release bring us some interesting features, the most interesting among them are hooks for tracking file upload progress , as well as new ZIP extension for creating and editing zip files.

More informations about this release can be found in the release announcement 5.2.0.

Comments(1)

Almost one year after launch of version 1.5, and just a few days after very buggy RC 3, final version of Firefox 2.0 is finally available.

According to release notes, new Firefox contains usability improvements, built-in phishing protection, spell checking, improved tabbed browsing and new JavaScript 1.7 under the hood.

After download (windows installation is 5.6MB) it install smoothly, without any problem with extensions etc.

However, my first impressions are not very good. I simple don’t like new default theme, something simmilar as “Go” button is added next to location bar and search bar, there is no longer close button to the far right side of tab bar, now you have close button added for each tab (like in Opera).

About new features, now firefox is able to remember your session (reopen all tabs you had before you’ve closed it). On my machine it is not enabled by default, but it can be easily turned on in ff options. Also, there is a new spell checker which is enabled by default with english dictionary. Very annoying if you mostly write in non english language, and don’t have dictionary support. Search bar is now able to list you suggestions soon after you star typing your keyword (simmilar as Google Suggest tool).

Regarding new options in menu, I haven’t noticed many changes. In History part there is a “Recently closed tabs” option, very usefull especially if you’ve closed some tab by mistake. Also themes and extensions are now reorganized under “Add-ons” menu, which is part of Tools menu. In Options menu there is a “feeds” tab where you can define how would you like to handle rss feeds, and in case you don’t have any feed reader installed, you can pick some of online readers (like Bloglines, Google Reader etc.).

All in all, I really liked ff 1.5 look and feel much more, but FF 2.0 have some interesting new features. Will give it a chance for a few days and see if I am going to keep it, or revert to goof old FF 1.5.x.x :)

Comments(1)

My favorite Web 2.0 application Netvibes just came to second big revision with code name “Cinnamon”.

At first I was disappointed with changes. Although they announced tons of new features, I saw only small changes in user interface and few new modules. However, more changes are about to come, because Cinnamon is actually “a three-month release cycle, where you will see new features and upgrades throughout that time”.

So far I’ve noticed new splash screen, slightly changed interface, and couple of new modules like “Blog Search”, Video Search etc.

Blog Search

Netvibes in Action

Comments(0)

Few weeks ago I found a way to install Webalizer on DreamHost. Webalizer is a little bit of an obsolete utility (comparing to Google Analytics Webalizer stats look rude), but still has some advantages. One of the biggest is that it is still used by many hosting solutions, so you don’t have to change all of your site(blog) pages just to make sure Google will track your stats.
(more…)

Comments(0)