Re: Another question

2000-08-30 Thread Nathan
Check the Readme's with the Kernel source - there is actualy a device you have to mount in your fstab file (you know, for bootup;) that enables shared memory. It uses a "imaginary" mount point like /proc does. However, as far as I know, "free" and friends don't show the shared memory in use corre

Re: reiserfs & databases.

2000-08-30 Thread Russell Coker
On Wed, 30 Aug 2000, Nathan E Norman wrote: >On Tue, Aug 29, 2000 at 04:36:23PM +0200, Dariush Pietrzak wrote: >> but, there are some commercial databases which keep their data directly >> on partitions ( this should be much better then any *fs including >> reiserfs) and the weird part is that tha

Re: what is sufficient free memory?

2000-08-30 Thread Dariush Pietrzak
> 70 processes: 69 sleeping, 1 running, 0 zombie, 0 stopped > CPU states: 0.1% user, 0.7% system, 0.0% nice, 99.0% idle > Mem: 63124K av, 61296K used, 1828K free, 36880K shrd, 7712K buff > Swap: 104380K av, 3128K used, 101252K free 35860K > cached This doesen't look li

Re: what is sufficient free memory?

2000-08-30 Thread Dariush Pietrzak
sorry for my last post, I haven't noticed that you people told everything already. > To paint a better picture, here's an entire top screen: just a little hint - don't sort your processes by cpu usage when you want to check memory usage ( just press big 'M' and it'll all clear up ) regards,

Re: reiserfs & databases.

2000-08-30 Thread Dariush Pietrzak
to sum things up - my idea to use reiserfs as database placeholder ain't that stupid. - modern fs's do better job that commercial database designers well, actually I'm using postgresql which can't use raw partitions anyway. thanks for the response.

MySQL vs. Postgres

2000-08-30 Thread Arno Vije
Hi, where setting up some servers for a small ISP, they want to have a SQL database, but i`m in doubt. Which one would you recommend, mysql or postgres? The SQL database will be used in combination with PHP3 (or 4) to generate dynamic websites. greets, :::

Re: MySQL vs. Postgres

2000-08-30 Thread Art Sackett
On Wed, Aug 30, 2000 at 06:34:54PM +0200, Arno Vije wrote: > where setting up some servers for a small ISP, > they want to have a SQL database, but i`m in > doubt. Which one would you recommend, mysql or postgres? > The SQL database will be used in combination with PHP3 (or 4) > to generate dyn

Apache vhosts dinamically alias

2000-08-30 Thread Jaume Teixi
I have each virtual host under /var/www I want to enable a virtualhostA.com/stats URL that points to /var/stats/virtualhostA.com same for virtualhostB, etc I've tried Alias /%1/stats/var/stasts/%1 with no success any Ideas? thanks, jaume.

Proftpd 226 message

2000-08-30 Thread Jaume Teixi
After upgrading proftp to 1.2.0pre10-2 now when an user connect to ftp site, for each directory that browsers on gets stupid message: 226-Transfer complete. 226 Quotas off how to disable this ?¿ thanks, jaume.

Re: MySQL vs. Postgres

2000-08-30 Thread Dariush Pietrzak
> If you don't need record-level locking, rollbacks, etc. then I would > recommend MySQL, simply because it's very fast. Hmm, if you need fast why use sql server? you could use databases in files. they're fast, simple etc. If you need to create apps based on SQL you will need transactions, and rec

RE: MySQL vs. Postgres

2000-08-30 Thread Scott Thompson
We run mySQL here and created an application with PHP3/4 to interface with the SQL engine. I will tell you now, that we re-wrote all the php pages into ANSI C as the performance was PATHETIC. (p2 350 with 256 megs of ram) The performance was 10 times faster than php. Another thing that I notice abo

Re: reiserfs & databases.

2000-08-30 Thread Bulent Murtezaoglu
[...] RC> The idea is that the database vendor knows their data storage RC> better than the OS can guess it, and that knowledge allows RC> them to implement better caching algorithms than the OS can RC> use. The fact that benchmark results show that raw partition RC> access is

RE: Apache vhosts dinamically alias

2000-08-30 Thread Brian Jones
Hmm... This might work... In your virtualhost declaration in httpd.conf place the Alias definition such as "Alias /stats/ /var/stats/virtualhosta.com" For example: ServerAdmin [EMAIL PROTECTED] DocumentRoot /var/WWW ServerName www.virtualhosta.com Alias /stats/ /var/stats/virtualhosta.com You

RE: Apache vhosts dinamically alias

2000-08-30 Thread Dariush Pietrzak
> For example: > > ServerAdmin [EMAIL PROTECTED] > DocumentRoot /var/WWW > ServerName www.virtualhosta.com > Alias /stats/ /var/stats/virtualhosta.com > I think he ment mass_vhost from mod_vhost_alias or sth. Maybe mod_rewrite could help you in this case?

Re: MySQL vs. Postgres

2000-08-30 Thread hendriks
hi, Sorry, not that familiar with sql servers. postgres is using record-level locking, what does mysql do, is it locking the whole table ? what are rollbacks? what other advantages are there in using postgres instead of mysql ? i maintain a small hosting server, that runs mysql (beside apache,

Apache mod_rewrite

2000-08-30 Thread Jaume Teixi
I need to do the following in order to access stats for each based virtual host when typing url www.virtualhost1.com/stats or www.virtualhost99.com/stats server page located under /var/reports/virtualhost1 or /var/reports/virtualhost99 I've tryed on my httpd.conf: RewriteEngine on Rewrit

Re: MySQL vs. Postgres

2000-08-30 Thread Dariush Pietrzak
> postgres is using record-level locking, what does mysql do, is it > locking the whole table ? what are rollbacks? what other advantages are AFAIK mysql locks whole table, rollback is term used with transaction - thing is, you put some sql statements inside transaction, and one of them fail, you

Re: MySQL vs. Postgres

2000-08-30 Thread Christian Hammers
On Wed, 30.08.00 18:02 +0200, Dariush Pietrzak wrote: > Hmm, if you need fast why use sql server? you could use databases > in files. they're fast, simple etc. Which file based database system is faster than mysql? I tried Berkeley db3 (although with transaction code) and it was horrible slow! bye

Re: MySQL vs. Postgres

2000-08-30 Thread Robert Davies
My workplace used php3 + mysql, then php3 + oracle, now looking at a combination of php3 + local mysql + master oracle db (the local mysql db's would act as caches for fast answers to most page queries). This is for scalability and availability reasons. php most commonly used with mysql, told by

RE: MySQL vs. Postgres

2000-08-30 Thread Scott Thompson
Some stats for you. Keep in mind that these are only for the webserver. Hits Bytes Visits PViews Month 8,891,404 58,798,965,869 211,007 1,528,073 Jun 2000 10,853,047 57,775,413,897 224,862 1,375,197 Jul 2000 9,121,259 53

RE: routing

2000-08-30 Thread Kevin
Alright I've run into another problem or maybe I'm just dumb. 208.3.69.1 is the main router connected to the internet. 208.3.69.2 (eth0) is the device connected via ethernet to the main router on the linux router/bridge. 208.3.69.4 (eth1) goes to the client (208.3.69.3). The main route

RE: routing

2000-08-30 Thread Bulent Murtezaoglu
You are setting 255.255.255.0 netmasks so the machines are expecting to find .1 .2 .3 machines on the local ethernet interfaces. I don't know why you are doing it like that, but what would fix your problem is getting the Linux router machine to do a proxy-arp. You can turn this on by echo'ing t

Re: MySQL vs. Postgres

2000-08-30 Thread R. W. Rodolico
> > > postgres is using record-level locking, what does mysql do, is it > > locking the whole table ? what are rollbacks? what other advantages are > AFAIK mysql locks whole table, > rollback is term used with transaction - thing is, you put some sql > statements inside transaction, and one of

Re: Another question

2000-08-30 Thread tps
On Tue, Aug 29, 2000 at 11:35:10PM -0600, Nathan wrote: > Check the Readme's with the Kernel source - there is actualy a device you > have to mount in your fstab file (you know, for bootup;) that enables > shared memory. It uses a "imaginary" mount point like /proc does. OK, I found it. It actual

Re: reiserfs & databases.

2000-08-30 Thread Russell Coker
On Wed, 30 Aug 2000, Nathan E Norman wrote: >On Tue, Aug 29, 2000 at 04:36:23PM +0200, Dariush Pietrzak wrote: >> but, there are some commercial databases which keep their data directly >> on partitions ( this should be much better then any *fs including >> reiserfs) and the weird part is that th

Re: what is sufficient free memory?

2000-08-30 Thread Dariush Pietrzak
> 70 processes: 69 sleeping, 1 running, 0 zombie, 0 stopped > CPU states: 0.1% user, 0.7% system, 0.0% nice, 99.0% idle > Mem: 63124K av, 61296K used, 1828K free, 36880K shrd, 7712K buff > Swap: 104380K av, 3128K used, 101252K free 35860K > cached This doesen't look l

Re: what is sufficient free memory?

2000-08-30 Thread Dariush Pietrzak
sorry for my last post, I haven't noticed that you people told everything already. > To paint a better picture, here's an entire top screen: just a little hint - don't sort your processes by cpu usage when you want to check memory usage ( just press big 'M' and it'll all clear up ) regards,

Re: reiserfs & databases.

2000-08-30 Thread Dariush Pietrzak
to sum things up - my idea to use reiserfs as database placeholder ain't that stupid. - modern fs's do better job that commercial database designers well, actually I'm using postgresql which can't use raw partitions anyway. thanks for the response. -- To UNSUBSCRIBE, email to [EMAIL PROTE

MySQL vs. Postgres

2000-08-30 Thread Arno Vije
Hi, where setting up some servers for a small ISP, they want to have a SQL database, but i`m in doubt. Which one would you recommend, mysql or postgres? The SQL database will be used in combination with PHP3 (or 4) to generate dynamic websites. greets, :::

Re: MySQL vs. Postgres

2000-08-30 Thread Art Sackett
On Wed, Aug 30, 2000 at 06:34:54PM +0200, Arno Vije wrote: > where setting up some servers for a small ISP, > they want to have a SQL database, but i`m in > doubt. Which one would you recommend, mysql or postgres? > The SQL database will be used in combination with PHP3 (or 4) > to generate dy

Apache vhosts dinamically alias

2000-08-30 Thread Jaume Teixi
I have each virtual host under /var/www I want to enable a virtualhostA.com/stats URL that points to /var/stats/virtualhostA.com same for virtualhostB, etc I've tried Alias /%1/stats/var/stasts/%1 with no success any Ideas? thanks, jaume. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED]

Proftpd 226 message

2000-08-30 Thread Jaume Teixi
After upgrading proftp to 1.2.0pre10-2 now when an user connect to ftp site, for each directory that browsers on gets stupid message: 226-Transfer complete. 226 Quotas off how to disable this ?¿ thanks, jaume. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Tr

Re: MySQL vs. Postgres

2000-08-30 Thread Dariush Pietrzak
> If you don't need record-level locking, rollbacks, etc. then I would > recommend MySQL, simply because it's very fast. Hmm, if you need fast why use sql server? you could use databases in files. they're fast, simple etc. If you need to create apps based on SQL you will need transactions, and re

RE: MySQL vs. Postgres

2000-08-30 Thread Scott Thompson
We run mySQL here and created an application with PHP3/4 to interface with the SQL engine. I will tell you now, that we re-wrote all the php pages into ANSI C as the performance was PATHETIC. (p2 350 with 256 megs of ram) The performance was 10 times faster than php. Another thing that I notice ab

Re: reiserfs & databases.

2000-08-30 Thread Bulent Murtezaoglu
[...] RC> The idea is that the database vendor knows their data storage RC> better than the OS can guess it, and that knowledge allows RC> them to implement better caching algorithms than the OS can RC> use. The fact that benchmark results show that raw partition RC> access is

RE: Apache vhosts dinamically alias

2000-08-30 Thread Brian Jones
Hmm... This might work... In your virtualhost declaration in httpd.conf place the Alias definition such as "Alias /stats/ /var/stats/virtualhosta.com" For example: ServerAdmin [EMAIL PROTECTED] DocumentRoot /var/WWW ServerName www.virtualhosta.com Alias /stats/ /var/stats/virtualhosta.com Yo

RE: Apache vhosts dinamically alias

2000-08-30 Thread Dariush Pietrzak
> For example: > > ServerAdmin [EMAIL PROTECTED] > DocumentRoot /var/WWW > ServerName www.virtualhosta.com > Alias /stats/ /var/stats/virtualhosta.com > I think he ment mass_vhost from mod_vhost_alias or sth. Maybe mod_rewrite could help you in this case? -- To UNSUBSCRIBE, email to [EMAI

Re: MySQL vs. Postgres

2000-08-30 Thread hendriks
hi, Sorry, not that familiar with sql servers. postgres is using record-level locking, what does mysql do, is it locking the whole table ? what are rollbacks? what other advantages are there in using postgres instead of mysql ? i maintain a small hosting server, that runs mysql (beside apache

Re: MySQL vs. Postgres

2000-08-30 Thread Dariush Pietrzak
> postgres is using record-level locking, what does mysql do, is it > locking the whole table ? what are rollbacks? what other advantages are AFAIK mysql locks whole table, rollback is term used with transaction - thing is, you put some sql statements inside transaction, and one of them fail, yo

Re: MySQL vs. Postgres

2000-08-30 Thread Christian Hammers
On Wed, 30.08.00 18:02 +0200, Dariush Pietrzak wrote: > Hmm, if you need fast why use sql server? you could use databases > in files. they're fast, simple etc. Which file based database system is faster than mysql? I tried Berkeley db3 (although with transaction code) and it was horrible slow! by

Re: MySQL vs. Postgres

2000-08-30 Thread Robert Davies
My workplace used php3 + mysql, then php3 + oracle, now looking at a combination of php3 + local mysql + master oracle db (the local mysql db's would act as caches for fast answers to most page queries). This is for scalability and availability reasons. php most commonly used with mysql, told b

RE: MySQL vs. Postgres

2000-08-30 Thread Scott Thompson
Some stats for you. Keep in mind that these are only for the webserver. Hits Bytes Visits PViews Month 8,891,404 58,798,965,869 211,007 1,528,073 Jun 2000 10,853,047 57,775,413,897 224,862 1,375,197 Jul 2000 9,121,259 5

RE: routing

2000-08-30 Thread Kevin
Alright I've run into another problem or maybe I'm just dumb. 208.3.69.1 is the main router connected to the internet. 208.3.69.2 (eth0) is the device connected via ethernet to the main router on the linux router/bridge. 208.3.69.4 (eth1) goes to the client (208.3.69.3). The main rout

RE: routing

2000-08-30 Thread Bulent Murtezaoglu
You are setting 255.255.255.0 netmasks so the machines are expecting to find .1 .2 .3 machines on the local ethernet interfaces. I don't know why you are doing it like that, but what would fix your problem is getting the Linux router machine to do a proxy-arp. You can turn this on by echo'ing

Re: MySQL vs. Postgres

2000-08-30 Thread R. W. Rodolico
> > > postgres is using record-level locking, what does mysql do, is it > > locking the whole table ? what are rollbacks? what other advantages are > AFAIK mysql locks whole table, > rollback is term used with transaction - thing is, you put some sql > statements inside transaction, and one of

Re: Another question

2000-08-30 Thread tps
On Tue, Aug 29, 2000 at 11:35:10PM -0600, Nathan wrote: > Check the Readme's with the Kernel source - there is actualy a device you > have to mount in your fstab file (you know, for bootup;) that enables > shared memory. It uses a "imaginary" mount point like /proc does. OK, I found it. It actua

Apache mod_rewrite

2000-08-30 Thread Jaume Teixi
I need to do the following in order to access stats for each based virtual host when typing url www.virtualhost1.com/stats or www.virtualhost99.com/stats server page located under /var/reports/virtualhost1 or /var/reports/virtualhost99 I've tryed on my httpd.conf: RewriteEngine on Rewri