Requirements

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Straterra
Forum Regular
Posts: 527
Joined: Mon Nov 24, 2003 8:46 am
Location: Indianapolis, Indiana
Contact:

Requirements

Post by Straterra »

I have a server with Apache, Windows 98SE, and a FTP client. The server is 150mhz with 16mb ram....Do you think I can run MySQL smoothly and atleast kind of quickly? I currently use SQLite, and I am wondering if it is time to switch from SQLite to MySQL, or stay with MySQL.
redmonkey
Forum Regular
Posts: 836
Joined: Thu Dec 18, 2003 3:58 pm

Post by redmonkey »

I have an old 200Mhz laptop with 16MB ram running win98, Apache 1.3, PHP4 and mySQL 3.23 and it actually works reasonably well.

I've never used SQLite so I couldn't offer any comparisons on that part.

I've also just put together a little automatic setup app which installs and configures Apache 1.3.20, PHP 4.3.4 and mySQL 3.23.58 with the option to install and configure phpMyAdmin 2.5.5-pl1 in a win32 enviroment. If this interests you give me a shout as I'm looking to test it on a few different boxes and I'm also looking for feedback as to ease of use. So far I have tested the app on win98 and win2K and seems to do exactly what it says on the tin.
microthick
Forum Regular
Posts: 543
Joined: Wed Sep 24, 2003 2:15 pm
Location: Vancouver, BC

Post by microthick »

With services like Apache and MySQL, the big requirement is RAM.

Currently, my system is running Apache and MySQL.

Apache is using: 33.4 MB of RAM
MySQL is using: 11.8 MB of RAM

I'd suggest upgrading your RAM if at all possible.
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

I run a database/web/ftp server, mySQL/Apache 1.x/Proftpd using Linux on a Pentium 75 with 24 megs of RAM. Runs great. I have about 30 tables, each with anywhere between 5,000 - 30,000 records. Data is updated hourly and daily.
User avatar
scorphus
Forum Regular
Posts: 589
Joined: Fri May 09, 2003 11:53 pm
Location: Belo Horizonte, Brazil
Contact:

Post by scorphus »

Straterra, don't wonder if it is time to switch... switch! To Linux. And don't waste processor and memory resources with the whole GUI.

Pyrite, that's great! I also have an ancient Pentium 95 with 16 megs powered by Debian 3.0 woody, running MySQL/PostgreSQL/Apache1.3.x/FTP/SSH/SAMBA very great. It is on the ground under my very foot with only power and lan cables pluged in.

The only thing that makes me a bit bored is the fact that Apache is killed every morning around 7:30. It seems to being killed because lack of RAM but I belive a new kernel should solve the problem. I compiled a new one but I'm getting kernel panic and still don't know what is the cause... Anyways, I kinda like it when things are not working smoothly :P 8)

Regards,
Scorphus.
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

Well if you like things not working smoothly, use Windows 95 :P
Straterra
Forum Regular
Posts: 527
Joined: Mon Nov 24, 2003 8:46 am
Location: Indianapolis, Indiana
Contact:

Post by Straterra »

Well..what distro do you think I should use of Linux then?
User avatar
scorphus
Forum Regular
Posts: 589
Joined: Fri May 09, 2003 11:53 pm
Location: Belo Horizonte, Brazil
Contact:

Post by scorphus »

IMHO, either Slackware or Debian. I think those are really good distros.
User avatar
Saethyr
Forum Contributor
Posts: 182
Joined: Thu Sep 25, 2003 9:21 am
Location: Wichita, Kansas USA
Contact:

Post by Saethyr »

*not trying to hijack this thread*

On this same note, I am reminded I have a 700mhz sitting at the hacienda and need to know what distro would be best for a complete and totalk Linux newbie to learn on? I downloaded and burned Fedora and I believe Debian but I would be willing to try anything.


Saethyr
User avatar
Pyrite
Forum Regular
Posts: 769
Joined: Tue Sep 23, 2003 11:07 pm
Location: The Republic of Texas
Contact:

Post by Pyrite »

Of course everyone knows I"m going to say Slackware...for the both of you.
Post Reply