MySQL

Hi Everyone,

I am giving the step by step instructions to install Drupal 6 on linux machine. I am giving this steps for Ubuntu 9.10. For any other linux forks you need some small changes.

Apache Installation:

Step 1: Install apache 2 by entering this command in linux terminal.

~$> sudo apt-get install apache2

Step 2: Now apache is installed and running in your system. You can verify this by typing this url on your bowser.

Tip 1: Enable the query cache in MySQL
How ??
* You can setup them in /etc/my.cnf (Red Hat) or /etc/mysql/my.cnf (Debian) file:
* # vi /etc/my.cnf
Append config directives as follows:
query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576

I came through a very strange problem. That is using DISTINCT on multiple columns at the same time using ORDER BY condition. When i don't use DISTINCT it returns correct order but on DISTINCT condition ORDER BY effect is lost. My query is some thing like this.

SELECT c.title, a.nid, b.filepath FROM content_type_x as a
LEFT JOIN files as b ON a.field_show_image_fid = b.fid
ORDER BY a.nid