LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Enterprise Linux Forums > Linux - Enterprise
User Name
Password
Linux - Enterprise This forum is for all items relating to using Linux in the Enterprise.

Notices

Reply
 
Search this Thread
Old 10-27-2005, 01:02 PM   #1
Thakowbbery
Member
 
Registered: Mar 2005
Posts: 135

Rep: Reputation: 17
Linux + Apache + PHP + ??MySQL/PostgreSQL??


Good afternoon

We have a system that is accessed through the local intranet will add some entries at a SQL database and also will have a search system.
For that, Linux + Apache + PHP + MySQL would do the job just fine.

But also, in that same db, will have two other systems, and those two combined will sum more than 2000 records a day (which means, adding and deleting from the db).

Now I want to know if MySQL will be able to handle such load. I heard that for things like that PostgreSQL would fit way better.

Can someone help me out with that?
 
Old 10-28-2005, 08:21 AM   #2
apolinsky
Member
 
Registered: Oct 2004
Location: Brooklyn
Distribution: Slackware 13.1,12.1,12.2; Debian Sqeeze; Centos 5,6
Posts: 253

Rep: Reputation: 34
2000 rows a day seems to be very minor. You should have no problems with Mysql.
 
Old 10-28-2005, 10:27 AM   #3
Thakowbbery
Member
 
Registered: Mar 2005
Posts: 135

Original Poster
Rep: Reputation: 17
Hum
How many info traffic do u think MySQL can handle daily?
 
Old 10-28-2005, 12:03 PM   #4
apolinsky
Member
 
Registered: Oct 2004
Location: Brooklyn
Distribution: Slackware 13.1,12.1,12.2; Debian Sqeeze; Centos 5,6
Posts: 253

Rep: Reputation: 34
Easily 100 users at a time doing significant processing, depending upon the size of the server. Assuming a reasonably sized server, I would think 100 times your estimate could be handled.
 
Old 10-28-2005, 03:18 PM   #5
climbingmerlin
Member
 
Registered: Mar 2004
Location: UK
Distribution: Fedora, OpenSuse
Posts: 91

Rep: Reputation: 15
Both MySQL and Postgresql would be fine... At work we have a Mysql database that is creating 20,000 rows a day when processing a job (very high DB load) and MySQL hardly notices...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP with MySQL and PostgreSQL ? Boby Linux - Software 2 05-25-2005 05:11 AM
Apache,PHP and PostgreSQL in a package Boby Linux - Software 1 03-29-2005 06:21 PM
Apache+Postgresql+PHP. reconfigure? vickr1z Linux - Newbie 2 08-23-2004 02:58 AM
Apache-php-postgresql-phppgadmin koswo Linux - Software 0 02-05-2004 06:05 AM
how to link apache+php+postgresql Sridhar Guntur Linux - General 3 01-09-2003 01:22 AM


All times are GMT -5. The time now is 11:41 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration