On Wed, Aug 30, 2000 at 06:34:54PM +0200, Arno Vije wrote:
snip
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
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".
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
[...]
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
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:
VirtualHost www.virtualhosta.com
ServerAdmin [EMAIL PROTECTED]
DocumentRoot /var/WWW
ServerName www.virtualhosta.com
Alias /stats/
On Thu, Aug 24, 2000 at 10:05:46PM +0100, Jonathan McDowell wrote:
I had a machine with a 2940 lock up after a fair few SCSI bus resets. I
compiled up the latest 2.2.17 pre release which has the latest driver in
it and turned off tagged command queuing and haven't seen a problem
since.
I
Has anyone had any luck getting the lvm stuff to work?
Tim
--
Tim Sailer (at home) Coastal Internet, Inc.
Network and Systems Operations PO Box 671
http://www.buoy.comRidge, NY 11961
[EMAIL
Maybe I missed it, but what's the deal with the new kernels (2.4.0xxx)
and shared memory? From top:
CPU states: 5.2% user, 1.8% system, 0.0% nice, 93.0% idle
Mem: 78592K av, 75848K used, 2744K free, 0K shrd, 1932K buff
Swap: 185464K av, 11520K used, 173944K free
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
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 that
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 like a
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,
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.
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,
:::
On Wed, Aug 30, 2000 at 06:34:54PM +0200, Arno Vije wrote:
snip
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
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.
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.
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
[...]
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
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:
VirtualHost www.virtualhosta.com
ServerAdmin [EMAIL PROTECTED]
DocumentRoot /var/WWW
ServerName www.virtualhosta.com
Alias /stats/
For example:
VirtualHost www.virtualhosta.com
ServerAdmin [EMAIL PROTECTED]
DocumentRoot /var/WWW
ServerName www.virtualhosta.com
Alias /stats/ /var/stats/virtualhosta.com
/VirtualHost
I think he ment mass_vhost from mod_vhost_alias or sth.
Maybe mod_rewrite could help you in this case?
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
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
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
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,
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
SNIP
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
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
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
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
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 actually
31 matches
Mail list logo