12-29-2004
The biggest resource hog in my experience is MySQL or any other database program. If you're just serving html and php then 1.x ghz is a fast enough processor. DBase queries can produce a lot of overhead in which case you'd do best to use two or more cpu's and at the very least, a gig of RAM. But that's just my experience, your mileage may vary.
-Seg
edit: optimally it is best to run your DBase on a seperate server.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
This is my first post here, so I thought Id make it good. I am building a webserver that will be up in a month or so, so I am starting now. I was wondering, since I am on the fence here, should I go with Red hat or BSD? I am comfortable with both, I can run apache on either one, but I am wondering... (4 Replies)
Discussion started by: advok8
4 Replies
2. UNIX for Dummies Questions & Answers
i am installing FREEBSD and I would like to know which hardware specific network card that works and help with this would be great I am very new to this (UNIX) (1 Reply)
Discussion started by: BSD_NEWUSER
1 Replies
3. UNIX for Dummies Questions & Answers
I'm very new to UNIX and just istalled FreeBSD on my computer. I using the KDE desktop and the resolution is horrible. How do I adjust this. (3 Replies)
Discussion started by: mbrouder
3 Replies
4. UNIX for Dummies Questions & Answers
Hello folks, I'm very new to Unix so please bear with me.
I have a FreeBSD 5.1 box on IP address 192.168.1.4 and I want to tell it to use my broadband router (192.168.1.1) as it's default gateway. Could someone tell me how to do this?
I did search these forums first but could not find... (1 Reply)
Discussion started by: SRP
1 Replies
5. BSD
so, i have a video card SIS s315 AGP and i can't cofigure X Free on free BSD to run X window.
Anybody can help me solve this problem?? (2 Replies)
Discussion started by: Dmitri-br
2 Replies
6. BSD
Can anyone help me ?
I have installed Free BSD several times and I can't get the X window to work . I have installed the ports Gnome and others but for some reason when I type start x doesn't work.
I downloaded the 3 i386 disks but I get to install the first one wich complete the setup and... (3 Replies)
Discussion started by: skyhawkfly
3 Replies
7. BSD
for all you unix/linux interested heres an online book for free that covers the basics of BSD SysV Unix commands and applications . giving the average linux user a perspective on the differences in context of the two operating systems and for BSD users covers material as a refernce guide.
... (0 Replies)
Discussion started by: moxxx68
0 Replies
8. BSD
Now, I had installed free bsd at my office. Unfortunitely, Email server have been using Local PoP3 and SMTP to our ISP with outlook. but my unix firewall sever ( free bsd ) didn't allow these port ( 110 & 25 ).
How can i create the IP table to pass at server. If u have any experience about obvious... (4 Replies)
Discussion started by: Ashraff Ali
4 Replies
9. BSD
Hello friends. I am new to Unix although i am very flexible to any programming language. i was a window user. Now, no more. I have decided myself to switch to unix.
Here is my problem:
I burned the free BSD into my new RW CD's. I inserted the bootable manager first then, it was scanning and... (5 Replies)
Discussion started by: bonjour2006
5 Replies
10. BSD
Hello all
When I insert my USB , its says : umass0 detected . I want to ls files present in the USB.
I tried
mount -t msdosfs /dev/da0s1 /mnt
Whats is dev/da0s1 ?????
How can I mount it to use it ?
Regards (3 Replies)
Discussion started by: Junaid Subhani
3 Replies
LEARN ABOUT DEBIAN
grass-mesql
grass-mesql(1grass) Grass User's Manual grass-mesql(1grass)
NAME
grass-mesql - MySQL embedded driver
MySQL embedded driver MySQL embedded driver in GRASS MySQL database driver in GRASS enables GRASS to store vector attributes in MySQL
embedded database without necessity to run MySQL server.
Driver and database name
GRASS modules require 2 parameters to connect to a database. Those parameters are 'driver' and 'database'. For MySQL embedded driver the
parameter 'driver' should be set to value 'mesql'. The parameter 'database' is a full path to the directory where database tables are
stored. The best place is a directory in the mapset. The directory must be created before use of the driver. In the name of database it is
possible to use 3 variables:
$GISDBASE - path to current GISBASE
$LOCATION_NAME - name of current location
$MAPSET - name of current mapset
Examples of connection parameters:
db.connect driver=mesql database='$GISDBASE/$LOCATION_NAME/$MAPSET/mysql'
db.connect driver=mesql database=/home/user1/db
Data types, indexes
For more informations about supported data types and indexes see the documentation for MySQL (mysql) driver
Database type
Because database closing was found very slow if InnoDB was used, the InnoDB storage is disabled by default (hardcoded '--skip-innodb'
server option).
Note
The embedded server is started with hardcoded '--bootstrap' option to avoid warning about missing mysql.time_zone_leap_second table. This
can be fixed in future.
SEE ALSO
db.connect, SQL support in GRASS GIS
Credits
Development of the driver was sponsored by Faunalia (Italy) as part of a project for ATAC.
AUTHOR
Radim Blazek
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-mesql(1grass)