HappyDeveloper's questions

All my tables use InnoDB, and I have set sphinx sql_range_step to the minimum, which is 128. This improved the performance a lot, but it is still very slow if you make a request right after a new step begins.

I'm sure it would work just fine if I could reduce the range step to 10 or something, but someone found that the min value is hardcoded and there is no way to change it (other than editing the source).

So I was wondering if there was a way to deal with this directly from MySQL. When I am indexing a database, the other databases aren't affected, so it's not the whole server which has been slowed down, but only the database I am indexing.

Is there a way to give less priority to a user or query, or something?

I have been told to chgrp and chmod (770 and g+s) the directory I need to be shared between the user 'apache' and the user that owns the website files.

When the owner creates new files in there, they have by default this permissions: 664, which isn't perfect, but it's ok.

The problem is that when apache (with a php script) creates new files in there, they have this permissions: 644.

Then the files created by apache are not writtable by the group. How do I fix that? I want it to be 664 by default, or 770.

I have used chgrp for the 'logs' and 'cache' directories, and chmod 770, so both the linux user asigned to that site (used to execute scripts from the command-line), and the user 'apache' can read/write log and cache files (because both users belong to the group of that site).

The problem is that when one of them creates a file, the other one is not able to write or delete it. The file is being created as owned by its creator, but not belonging to the group. I thought using chgrp in the parent directory was the solution.

Any ideas?

PS: I'm on Centos 5.5, and PHP 5.3

I have been told that my dedicated server (which I use for hosting my websites) has RAID 1 (software), which makes my two disks of 750gb each, act as one, which is good for both speed and instant backup (in case one of them explodes or something)

But I'm not serving any critical application, and I would prefer to be able to use the second disk for daily or semanal backups.

So how do I remove the RAID 1 thing so I can use all the disk space as I wish?

Here's the result for $ df -h, in case you need it:

Filesystem            Size  Used Avail Use% Mounted on
/dev/md1              9.7G  1.7G  7.6G  18% /
/dev/md2              683G  290M  649G   1% /home
tmpfs                 4.0K     0  4.0K   0% /dev/shm

I'm on Centos 5.5

I did $ df -h and it threw this:

Filesystem            Size  Used Avail Use% Mounted on
/dev/md1              9.7G  1.7G  7.6G  18% /
/dev/md2              683G  211M  649G   1% /home
tmpfs                 4.0K     0  4.0K   0% /dev/shm

The problem is that my websites are located in /var/www, which I guess belongs to /, and they won't be able to use the disk space for things like images, that need to be placed inside the webroot, eg: /var/www/my_site/public_html/

What can I do about it? Should I move disk space from /home to / ? How? Or move the sites to /home ? Any thoughts?

Im using centos 5.5 and apache 2

I want to prevent my php scripts from sending mails through the MTA in localhost 25, without authentication.

I have been told that the server, by default, trusts itself, and that's why I need no auth in this case. So I have to disable the 'unauthenticated local relay'. How can I achieve that in postfix?

I have set up a postfix mailserver, and now I can send emails connecting to the smtp server through 'localhost', port 25.

But I don't know how to check as which user the mail has been sent. I can send without authenticating myself, though it's not an open relay: it seems to work only for localhost.

I would like to be forced to authenticate, or at least know which user is sending the mail, so I can set a quota for him, and a permitted 'from' (right now I can pick any of the available domains as the sender, when sending through a php script)

I couldn't find anything other than the mail 'from' and 'to' in /var/log/maillog.

Any ideas?

Hey everyone, I'm new to server administration, so I'm just trying to find a good hosting controller that let me do/have these things in my new dedicated server: - Create hosting accounts, each one with its own bandwidth/storage limits. - PHP 5.3 - MySQL

Someone told me to install CentOS and Klox, but from what I read, klox does not support PHP 5.3. Any thoughts?