1
vote
0answers
35 views

MongoDB Performance Troubleshooting

I have a small MongoDB replica set (2.4.6) and it seems about once a week, the primary gets bogged and the load average spikes up. This app doesn't see a huge amount of traffic. It resides in EC2 ...
0
votes
1answer
15 views

OpenBase server database connection troubleshoot?

I am troubleshooting a workstation/server instance in which an application hangs while interacting with our Windows 2003 Server OpenBase-hosted database. In short, the application will go into "Not ...
3
votes
1answer
977 views

Maintenance of tables: do I need to REINDEX a table after truncating and repopulating?

I have a table with about 2 million rows in it of transactional data that we use for analytics. Every week we reload this with new data, so we've been using TRUNCATE to clear it out and then inserting ...
0
votes
2answers
118 views

Postgresql performance enhancement

I have my setup like this: Two separate instances of the database on a clustered environment. Both instances are on dedicated servers each carries up to the standard configurations. Instance one ...
1
vote
2answers
1k views

How to install Sphinx on CentOS 6 where the DB and App server are separate servers

First what is the best way to install Sphinx on a centOs server rpm -ivh http://sphinxsearch.com/downloads/accept.php?file=sphinx-2.0.6-1.rhel6.x86_64.rpm yum install sphinx didn't seem to work. ...
1
vote
1answer
1k views

How to calculate max_connections for PostgreSQL and default_pool_size for pgbouncer?

Is there a rule or something I can use to calculate a good number for max_connections, default_pool_size and max_client_conn? The defaults are odd. PostgreSQL defaults to max_connections=100 while ...
-1
votes
3answers
455 views

Redirect MySQL queries to another server [closed]

In order to lower system usage I'm planning to use another server to store my databases. so how can I redirect MySQL queries to another server or make MySQL to store databases on another server?
0
votes
1answer
95 views

ft_stopword_file not picked up

I have a VPS server with a company called Webfusion. I want to remove some or all of the FULLTEXT stopwords because some specific words needs to be searchable with my DB content. I opened ...
1
vote
1answer
197 views

How does MySQL 5.5 and InnoDB on Linux use RAM?

Does MySQL 5.5 InnoDB keep indexes in memory and tables on disk? Does it ever do it's own in-memory caching of part or whole tables? Or does it completely rely on the OS page cache (I'm guessing that ...
1
vote
1answer
301 views

Database Server Hardware components (order of importance), CPU speed VS CPU cache vs RAM vs DISK

I am new to database world and would like to know what are crucial hardware specs when it comes to database performance. I have searched the internet and found this so far (In order of decreasing ...
0
votes
3answers
143 views

How do multiple servers work in terms of databases? [closed]

I don't know an awful lot about servers, but I do know that there are many ways you can improve the performance of running a web application, in terms of hardware. For example, starting with a single ...
0
votes
2answers
96 views

Server configurations for hosting MySQL database

I have a web application which uses a MySQL database hosted on a virtual server. I've been using this server when I started the application and when the database was really small. Now it has grown and ...
2
votes
1answer
85 views

How can I tell how my oracle databases configurations' differ?

I have two databases with the same data, running on the same physical server. They are performing differently (one is twice as fast as the other). I've compared the Initialization Parameters and ...
4
votes
1answer
107 views

Are there any performance differences between Oracle Entreprise and Oracle Standard editions?

Someone has asserted to me that the reason why one database is performing better than another (50-100%) is because one has Enterprise Edition and the other has Standard Edition. Given the same ...
0
votes
1answer
163 views

Measuring Performance through SHOW INNODB STATUS;

When looking at the output of SHOW INNODB STATUS on mysql what are the most important values to be looking at, and what would be an indicator of poor performance? Specifically under FILE I/O and ...
0
votes
0answers
487 views

Cannot enlarge MySQL Innodb_Buffer_Size, causes MySQL to crash

I currently have innodb_buffer_size set to 2GB - yet I have well over 5GB of innodb databases, and another 4 gigs of free ram on the server (Centos 5). I tried to increase the value to 3 gig, but ...
0
votes
1answer
112 views

Mysql slow query log issue…?

Analyzing the slow query log of my mysql database server, i found an interesting query taking more time and making issues in performance of my application.Please help me to find out the issue ? # ...
5
votes
4answers
4k views

MySQL, disk I/O and SSD drives

We have a LAMP box with 2x mirrored 1 TB WD Black Caviar disks running the whole OS and MySQL. 8 GB / RAM, 2x quad core CPUs. We're really taxed on disk I/O, and I've been thinking of ...
3
votes
2answers
1k views

extreme slowness with a remote database in Drupal

We're attempting to scale our Drupal installations up and have decided on some dedicated MySQL boxes. Unfortunately, we're running into extreme slowness when we attempt to use the remote DB - page ...
2
votes
3answers
156 views

Does the order of creating a columns for a table impact performance?

For purely asthetic reasons I've always had the first column(s) of a table as the primary key column(s). After that I've not taken any care to the order columns are added to the table. Is this wrong? ...
0
votes
3answers
84 views

Development DB server with dedicated hardware [duplicate]

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. ...
2
votes
3answers
165 views

What would be better solution a single database or multiple databases, one for each customer

I building a software that is going to have a lot of users (hopefully) I will have users that dont have much records or exceed normal data and I would also have the big users which will have millions ...
0
votes
1answer
608 views

SQL Server MDF Files Split guidelines

Are there any specific guidelines to split up a single MDF file into multiple files for a single database. An example of a scheme that I can think of is splitting it so that one NDF file contains just ...
2
votes
3answers
3k views

Need help with Access Database with Front End and Back End really slow with more than 1 user

We have had a consultant install a database for a client that is based on Access 2007 with a front end (on each workstation) and I guess the database back end (on the file server, it is a server 2003 ...
0
votes
2answers
1k views

Firebird database corruption causes

I am running several different Firebird versions (2.0, 2.1) on multiple entry level Windows-based servers with wildly varying hardware. The only matching thing between them is that they are running ...
3
votes
2answers
318 views

Very large database, very small portion most being retrieved in real time

I have an interesting database problem. I have a DB that is 150GB in size. My memory buffer is 8GB. Most of my data is rarely being retrieved, or mainly being retrieved by backend processes. I would ...
0
votes
1answer
322 views

Should I partition my main table with 2 millions rows?

I am a developer and would need some DBA-advices. We are starting to get performance problem with a MSSQL2005 database. The visible effects of the incidents is mainly CPU-hog on the server but ...
8
votes
3answers
8k views

postgreSQL vs Cassandra vs MongoDB vs Voldemart?

Which database to decide upon? Any comparisions? Existing: postgresql Issues Not easily scalable horizontal. Needs sharding etc Clustering does not solve the data growth problem ...
1
vote
2answers
2k views

Multiple columns in a single index versus multiple indexes

The short version of my question is what's the difference between three indexes each indexing a single column and one index indexing three columns. Background follows. I'm primarily a programmer but ...
2
votes
3answers
363 views

PostgreSQL lots of writes

I am using postgreSQL for a scientific application (unsupervised clustering). The python program is multi-threaded so that each thread manages its own postmaster process (one per core). Hence, their ...
0
votes
2answers
503 views

PostgreSQL lots of large Arrays and Writes

I am running a python program that spawns 8 threads and as each thread launch its own postmaster process via psycopg2. This is to maximize the use of my CPU-cores (8). Each thread call a series of SQL ...
1
vote
2answers
155 views

What kind of database server should I use for a 500k stored procedure calls per day database?

I have a database that gets about 500,000 stored procedure calls a day in addition to other stuff. It's running too slow for us and we're going to upgrade it when we get around to it. I'm looking at ...
1
vote
2answers
1k views

How does a SQL database handle simultaneous requests?

This may be a bit of a noob question, but I'm curious: How can a database handle multiple simultaneous requests, most notably reads? Is every request placed in a queue, so it really occurs one at a ...