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 PHP
mysql_drop_db
MYSQL_DROP_DB(3) 1 MYSQL_DROP_DB(3)
mysql_drop_db - Drop (delete) a MySQL database
SYNOPSIS
Warning
This function was deprecated in PHP 4.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more
information. Alternatives to this function include:
oExecute a
DROP DATABASE query
bool mysql_drop_db (string $database_name, [resource $link_identifier = NULL])
DESCRIPTION
mysql_drop_db(3) attempts to drop (remove) an entire database from the server associated with the specified link identifier. This function
is deprecated, it is preferable to use mysql_query(3) to issue an sql DROP DATABASE statement instead.
o $database_name
- The name of the database that will be deleted.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns TRUE on success or FALSE on failure.
Example #1
mysql_drop_db(3) alternative example
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
$sql = 'DROP DATABASE my_db';
if (mysql_query($sql, $link)) {
echo "Database my_db was successfully dropped
";
} else {
echo 'Error dropping database: ' . mysql_error() . "
";
}
?>
Warning
This function will not be available if the MySQL extension was built against a MySQL 4.x client library.
Note
For backward compatibility, the following deprecated alias may be used: mysql_dropdb(3)
mysql_query(3).
PHP Documentation Group MYSQL_DROP_DB(3)