Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-performance]

185 questions
0
votes
4 answers

Trying to scale my dedicated server for high traffic

I have a quad core xeon, 8GB ram, and only 2 x 1TB SATA drives right now. I am trying to figure out how to scale my application to handle as much load and traffic per day as possible. I have an industry network site and it's currently bogging around…
Andrew Fashion
  • 1,635
  • 7
  • 22
  • 26
0
votes
1 answer

What db and storage are people using for SaaS OLTP and OLAP offerings

I work for a privately held SaaS company and we are reviewing some of our architectural decisions around database and storage. Knowing that others have gone before us, I am wondering if I might "stand on the shoulders of giants" by hearing what…
QWade
  • 877
  • 1
  • 11
  • 17
0
votes
1 answer

MySQL hosting: What are the recommended specs and w

I have two specific cases of MySQL hosting. 1) I have a case where I have 2000 plus concurrent users to a single MySQL Database. They are not simple web users, but actual business users who need to connect write and read constantly through about 8-9…
ramdaz
  • 675
  • 1
  • 8
  • 25
0
votes
3 answers

SQL Server Performance & Latching

I have a SQL server 2000 instance which runs several concurrent select statements on a group of 4 or 5 tables. Often the performance of the server during these queries becomes extremely diminished. The querys can take up to 10x as long as other runs…
Colin
  • 109
  • 4
0
votes
2 answers

Store product data in session variable or access db every time?

I have my database storing lots of information about products (year, name, release_date, volume, etc. etc.). I currently load all of the products once and store them in a session variable - right now there's only 8 products but the list will grow…
JakeTheSnake
  • 343
  • 1
  • 8
  • 19
0
votes
1 answer

What OS, hardware, and how to optimize server for high volume traffic

The framework I am using is called SocialEngine.net v4, and it's completely written in Zend, so it's insanely super CPU intensive. SocialEngine is in PHP and uses MySQL. I need to know what OS, what hardware you suggest (dual xeons, amd, how much…
Andrew Fashion
  • 1,635
  • 7
  • 22
  • 26
0
votes
1 answer

MySQL innodb has lots of processes hanging in "update" state once every minute

Description of problem I have a fairly large MySQL installation. There are at least 3 separate servers which run the innoDB storage engine. Once every minute, at the same time each minute, for about 3-4 seconds, each of my innodb machines suddenly…
Mike Sherov
  • 113
  • 1
  • 7
0
votes
3 answers

Development DB server with dedicated hardware

I'm planning to move one of my development database servers to its own machine. I'm currently running it on my laptop, which is not very convenient. DB Servel is PostgreSQL 9.0.1, OS is Gentoo. There is only one development server attached to the…
Attila O.
  • 226
  • 3
  • 12
0
votes
1 answer

MySQL connections - RAM or Processing?

I know the queries utilize more processing, but the connection itself, does it use more RAM than processing?
Ben
  • 3,630
  • 17
  • 62
  • 93
0
votes
1 answer

Performance lag for database replication

My company is really sensitive about keeping up the performance on our core system. Our users also have a requirement to replicate or mirror all data to another location (in another location within city limits) in case a disaster happens. A software…
Ludwi
  • 293
  • 1
  • 7
0
votes
2 answers

What to seek/avoid in a hosted server monitoring service?

I'm looking for hosted monitoring solution (CPU, memory, disk, loads, mysql, replication network etc..) for a group of servers on Amazon EC2 /Scalr (app, mysql, load balancer). So far I found http://scoutapp.com , http://www.serverdensity.com,…
Niro
  • 1,371
  • 3
  • 17
  • 35
0
votes
2 answers

Which database (DBMS) can best utilize multiple cores and more memory?

The databases that I am interested in are: SQL Server 2008, MySQL, and PostgreSQL 9.0. In general, I am wondering which of those would "scale-up" the best. I have read that PostgreSQL used to scale-up better than MySQL, but that the difference has…
JohnB
  • 497
  • 2
  • 6
  • 12
0
votes
3 answers

Optimal setup of files, filegroups and RAID types for a large Microsoft SQL Server Database

First - while I'd totally be down for advice; I'm also interested if there are any good ways of measuring/collecting data in advance that I could use to determine which 'rules of thumb' to follow and which to skip. I can't change the schema…
Rizwan Kassim
  • 529
  • 6
  • 20
0
votes
1 answer

Looking for a bottleneck in MySQL server

I have two Ubuntu servers with very similar, if not identical, configuration: both have 16 cores (4 E5540 Xeons), 16GB RAM, HP Smart Array P212 controllers with 2 HDDs in RAID1. I/O scheduler used is deadline. Both run the same versions of MySQL…
minaev
  • 1,549
  • 12
  • 13
0
votes
1 answer

Reccomendation for tuning 100's of SQL Databases

I'm running several SQL servers, each running a few hundred multi-gig databases for customers. They are all setup homogeneously as far as the schemas are concerned, however customer usages of the data differ quite a lot from database to…
wayne
1 2 3
…
12 13